private void populateCheckedCompanyProducts() { int selectedID = Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"]); List <CompanyProducts> CPC = CompanyProducts.GetProductCategories(selectedID); txtLocation.Text = ""; if (CPC.Count > 0) { txtLocation.Text = CPC[0].Location; int j = 0; for (int i = 0; i < cblProducts.Items.Count; i++) { if (Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID) { cblProducts.Items[i].Selected = true; if (j < CPC.Count - 1) { j++; } } } } }
protected void btnSaveData_Click(object sender, EventArgs e) { List <CompanyProducts> CPC = CompanyProducts.GetProductCategories(Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"])); int i; int j = 0; SqlConnection conn = ConnectionHelper.GetSQLConnection(); SqlCommand command = new SqlCommand("UPDATE Exporters SET Location= @Location WHERE ExporterID = @ExpID", conn); command.Parameters.AddWithValue("@Location", txtLocation.Text); command.Parameters.AddWithValue("@ExpID", Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"])); command.Connection.Open(); SqlDataReader rs = command.ExecuteReader(); rs.Read(); rs.Close(); if (CPC.Count > 0) { for (i = 0; i < cblProducts.Items.Count; i++) { if ((Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID) && (cblProducts.Items[i].Selected == false)) { CompanyProducts.Delete(CPC[j].ChildEquipID); if (j < CPC.Count - 1) { j++; } } else if ((Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID) && (cblProducts.Items[i].Selected == true)) { if (j < CPC.Count - 1) { j++; } } } j = 0; for (i = 0; i < cblProducts.Items.Count; i++) { if ((cblProducts.Items[i].Selected == true) && (Convert.ToInt32(cblProducts.Items[i].Value) != CPC[j].ChildEquipID)) { CompanyProducts.Insert(Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"]), Convert.ToInt32(cblProducts.Items[i].Value)); //ProductsPlaceHolder.Text += cblProducts.Items[i].Value + "<br />"; } else if ((cblProducts.Items[i].Selected == true) && (Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID)) { if (j < CPC.Count - 1) { j++; } } } } else { for (i = 0; i < cblProducts.Items.Count; i++) { if (cblProducts.Items[i].Selected == true) { CompanyProducts.Insert(Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"]), Convert.ToInt32(cblProducts.Items[i].Value)); } } } }