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