using (SqlConnection conn = new SqlConnection(Helpers.DatabaseConnect)) { SqlCommand cmd = new SqlCommand("SELECT DISTINCT transdetail_id FROM Tdata WHERE period_name='" + (reportingPeriod) + "' AND agent_shortname IS NULL", conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Models.FileUpload.Mapping mapping = new Models.FileUpload.Mapping(); mapping.TransactionDetailId = Convert.ToString(dr["transdetail_id"]); using (SqlConnection conn1 = new SqlConnection(Helpers.DatabaseConnect)) { SqlCommand cmd1 = new SqlCommand("SELECT company_code FROM TData WHERE transdetail_id='" + Convert.ToString(mapping.TransactionDetailId) + "'", conn1); conn1.Open(); SqlDataReader dr1 = cmd1.ExecuteReader(); if (dr1.Read() == true) { mapping.companycode = Convert.ToString(dr1["company_code"]); if (mapping.companycode == Harare) { using (SqlConnection connp = new SqlConnection(Helpers.DatabaseConnect)) { cmd.CommandText = @"INSERT INTO TData(agent_shortname) VALUES(@agentanalysiscode) WHERE transdetail_id='" + Convert.ToString(mapping.TransactionDetailId) + "'"; cmd.Parameters.AddWithValue("@agentanalysiscode", HreCode); try { connp.Open(); cmd.ExecuteNonQuery(); } catch (SqlException e) { ViewBag.ErrorMessage = "Processing error !"; return View(); } connp.Close(); } } //else if (mapping.companycode == Bulawayo) //insert different value based on company_code i.e Bulawayo } conn1.Close(); } } conn.Close(); }
SELECT transdetail_id FROM TData WHERE (agent_shortname IS NULL)
"SELECT DISTINCT transdetail_id FROM Tdata WHERE period_name='" + (reportingPeriod) + "' AND agent_shortname IS NULL"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)