public void update_plan()
{
DataSet update_plan = new DataSet();
DateTime today = DateTime.Today;
try
{
if (ListRight.Items.Count > 0)
{
for (int c = 0; c < ListRight.Items.Count; c++)
{
DataSet get_bin = new DataSet();
get_bin = con.FN_ExecuteQuerySingle("select BinId,BinName,Latitude,Longitude,Priority,Type from Mst_Bin where BinId='" + ListRight.Items[c].Value + "' and StatusB='A'");
string b_id = get_bin.Tables[0].Rows[0]["BinId"].ToString();
string b_name = get_bin.Tables[0].Rows[0]["BinName"].ToString();
string b_lat = get_bin.Tables[0].Rows[0]["Latitude"].ToString();
string b_lon = get_bin.Tables[0].Rows[0]["Longitude"].ToString();
string b_priority = get_bin.Tables[0].Rows[0]["Priority"].ToString();
string b_type = get_bin.Tables[0].Rows[0]["Type"].ToString();
string b_Sequence = Convert.ToInt32(c + 1).ToString();
DataSet ins_bin = new DataSet();
ins_bin = ob.FN_insert_bins(b_id, b_name, b_lat, b_lon, b_type, b_priority, b_Sequence, today);
}
MessageBox.Show("Schedule Updated Successfully");
}
else
{
MessageBox.Show("LIST IS EMPTY");
}
}
catch { }
}
