protected void ddlRoute_SelectedIndexChanged(object sender, EventArgs e)
{
ListBoxAllotment.Items.Clear();
if (ddlRoute.SelectedValue != "0")
{
ds = con.FN_ExecuteQuerySingle("select * from Mst_Drivers");
ListLeft.DataSource = ds;
ListLeft.DataValueField = "DriverID";
ListLeft.DataTextField = "DriverName";
ListLeft.DataBind();
ListLeft.Items.Add(new ListItem("", ""));
DataSet ds1 = new DataSet();
ds1 = con.FN_ExecuteQuerySingle("select * from Mst_Vehicles");
ListRight.DataSource = ds1;
ListRight.DataValueField = "vehicle_num";
ListRight.DataTextField = "vehicle_type";
ListRight.DataBind();
ListRight.Items.Add(new ListItem("", ""));
divlistbox.Visible = true;
dvgrvDetails.Visible = true;
}
else
{
dvgrvDetails.Visible = false;
}
}
public void edit_schedule()
{
DateTime today = DateTime.Today;
DataSet edit_s = new DataSet();
edit_s = con.FN_ExecuteQuerySingle("select BinId , BinName,Sequence from Mst_schedule_collecttion where Date='" + today + "'");
ListRight.DataSource = edit_s;
ListRight.DataTextField = "BinName";
ListRight.DataValueField = "BinId";
ListRight.DataBind();
ListLeft.Items.Clear();
btn_update.Visible = true;
sbt_plan.Visible = false;
btn_edit_schedule.Visible = false;
btnRight.Visible = false;
Remove.Visible = true;
}
