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));
}
}
}
}
