private void funcFillRoute()
{
busAllocation = new BusAllocation();
busAllocation.OFlag = 5;
DataSet ds = pBus.funcBusRouteAllocation(busAllocation);
if (ds.Tables[0].Rows.Count > 0)
{
ddlRouteName.DataSource = ds.Tables[0];
ddlRouteName.DataTextField = "Route_Name";
ddlRouteName.DataValueField = "Routet_ID";
ddlRouteName.DataBind();
}
ddlRouteName.Items.Insert(0, "Select Route");
ddlBusName.Items.Clear();
ddlBusName.Items.Insert(0, "Select Bus");
}
private void funcFillBusName()
{
if (ddlRouteName.SelectedItem.Value == "Select Route")
{
ddlBusName.Items.Clear();
ddlBusName.Items.Insert(0, "Select Bus");
}
else
{
ddlBusName.Items.Clear();
busAllocation = new BusAllocation();
busAllocation.Route_ID = Convert.ToInt32(ddlRouteName.SelectedItem.Value);
busAllocation.OFlag = 6;
DataSet ds = pBus.funcBusRouteAllocation(busAllocation);
if (ds.Tables[0].Rows.Count > 0)
{
ddlBusName.DataSource = ds.Tables[0];
ddlBusName.DataTextField = "Bus_Name";
ddlBusName.DataValueField = "Bus_ID";
ddlBusName.DataBind();
}
ddlBusName.Items.Insert(0, "Select Bus");
}
trBtn.Visible = false;
trGrid.Visible = false;
tblTotal.Rows.Clear();
tblAlloted.Rows.Clear();
grdLocTotal.DataSource = null;
grdLocTotal.DataBind();
grdLocAlloted.DataSource = null;
grdLocAlloted.DataBind();
lbl_msg.Visible = false;
lbl_msg.Text = "";
}
private void funcFillBusLocation()
{
lbl_msg.Visible = false;
lbl_msg.Text = "";
if (ddlBusName.SelectedItem.Value == "Select Bus")
{
tblTotal.Rows.Clear();
tblAlloted.Rows.Clear();
grdLocTotal.DataSource = null;
grdLocTotal.DataBind();
grdLocAlloted.DataSource = null;
grdLocAlloted.DataBind();
trBtn.Visible = false;
trGrid.Visible = false;
}
else
{
trBtn.Visible = true;
trGrid.Visible = true;
tblTotal = (DataTable)ViewState["tblTotal"];
tblAlloted = (DataTable)ViewState["tblAlloted"];
busAllocation = new BusAllocation();
busAllocation.Bus_ID = Convert.ToInt32(ddlBusName.SelectedItem.Value);
busAllocation.Route_ID = Convert.ToInt32(ddlRouteName.SelectedItem.Value);
busAllocation.OFlag = 7;
DataSet ds = pBus.funcBusRouteAllocation(busAllocation);
tblTotal = ds.Tables[0];
tblAlloted = ds.Tables[1];
ViewState["tblTotal"] = tblTotal;
ViewState["tblAlloted"] = tblAlloted;
if (tblTotal.Rows.Count > 0)
{
grdLocTotal.DataSource = tblTotal;
grdLocTotal.DataBind();
}
else
{
grdLocTotal.DataSource = null;
grdLocTotal.DataBind();
}
if (tblAlloted.Rows.Count > 0)
{
grdLocAlloted.DataSource = tblAlloted;
grdLocAlloted.DataBind();
}
else
{
grdLocAlloted.DataSource = null;
grdLocAlloted.DataBind();
}
}
}
