private void BindDropdown()
{
SummaryRegisterDAL objsummary = new SummaryRegisterDAL();
BindDropdownDAL obj = new BindDropdownDAL();
var TruckNolst = obj.BindTruckNo();
// var ToCity = obj.BindToCity();
obj = null;
var driver = objsummary.selectHireDriverName();
objsummary = null;
if (driver != null && driver.Count > 0)
{
ddlDriver.DataSource = driver;
ddlDriver.DataTextField = "Driver_name";
ddlDriver.DataValueField = "Driver_Idno";
ddlDriver.DataBind();
ddlDriver.Items.Insert(0, new ListItem("--Select--", "0"));
}
drptruckno.DataSource = TruckNolst;
drptruckno.DataTextField = "Lorry_No";
drptruckno.DataValueField = "lorry_idno";
drptruckno.DataBind();
drptruckno.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
protected void ImgBtnTruckRefresh_Click(object sender, ImageClickEventArgs e)
{
BindDropdownDAL obj = new BindDropdownDAL();
var TruckNolst = obj.BindTruckNo();
ddlTruckNo.DataSource = TruckNolst;
ddlTruckNo.DataTextField = "Lorry_No";
ddlTruckNo.DataValueField = "lorry_idno";
ddlTruckNo.DataBind();
ddlTruckNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindTruckNo()
{
BindDropdownDAL obj = new BindDropdownDAL();
var TruckNolst = obj.BindTruckNo();
ddlTruckNo.DataSource = TruckNolst;
ddlTruckNo.DataTextField = "Lorry_No";
ddlTruckNo.DataValueField = "lorry_idno";
ddlTruckNo.DataBind();
ddlTruckNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindLorryNo()
{
BindDropdownDAL obj = new BindDropdownDAL();
var LorryNo = obj.BindTruckNo();
drpLorryNo.DataSource = LorryNo;
drpLorryNo.DataTextField = "Lorry_No";
drpLorryNo.DataValueField = "Lorry_Idno";
drpLorryNo.DataBind();
obj = null;
drpLorryNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindDropdown()
{
BindDropdownDAL obj = new BindDropdownDAL();
var senderLst = obj.BindSender();
var receiverLst = obj.BindSender();
var TruckNolst = obj.BindTruckNo();
var ToCity = obj.BindAllToCity();
var Agent = obj.BindAgent();
var bank = obj.BindBank();
var itemname = obj.BindItemName();
var UnitName = obj.BindUnitName();
var Transpoter = obj.BindTranspoter();
obj = null;
ddlSenderName.DataSource = senderLst;
ddlSenderName.DataTextField = "Acnt_Name";
ddlSenderName.DataValueField = "Acnt_Idno";
ddlSenderName.DataBind();
ddlSenderName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
ddlReciverName.DataSource = receiverLst;
ddlReciverName.DataTextField = "acnt_name";
ddlReciverName.DataValueField = "acnt_idno";
ddlReciverName.DataBind();
ddlReciverName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
ddlTruckNo.DataSource = TruckNolst;
ddlTruckNo.DataTextField = "Lorry_No";
ddlTruckNo.DataValueField = "lorry_idno";
ddlTruckNo.DataBind();
ddlTruckNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
ddltoCity.DataSource = ToCity;
ddltoCity.DataTextField = "city_name";
ddltoCity.DataValueField = "city_idno";
ddltoCity.DataBind();
ddltoCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
ddlfromCity.DataSource = ToCity;
ddlfromCity.DataTextField = "city_name";
ddlfromCity.DataValueField = "city_idno";
ddlfromCity.DataBind();
ddlfromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
ddlTranspoter.DataSource = Transpoter;
ddlTranspoter.DataTextField = "Acnt_Name";
ddlTranspoter.DataValueField = "Acnt_Idno";
ddlTranspoter.DataBind();
ddlTranspoter.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindTruckNo()
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindTruckNo();
obj = null;
if (lst.Count > 0)
{
ddlTruckNo.DataSource = lst;
ddlTruckNo.DataTextField = "Lorry_No";
ddlTruckNo.DataValueField = "Lorry_Idno";
ddlTruckNo.DataBind();
}
ddlTruckNo.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindDropdown()
{
BindDropdownDAL obj = new BindDropdownDAL();
TyreIssueDAL objTruck = new TyreIssueDAL();
var TruckNolst = obj.BindTruckNo();
var ToCity = obj.BindLocFrom();
var itemname = objTruck.BindItemName();
obj = null;
ddlTruckNo.DataSource = objTruck.BindTruckNo();
ddlTruckNo.DataTextField = "Lorry_No";
ddlTruckNo.DataValueField = "Lorry_Idno";
ddlTruckNo.DataBind();
ddlTruckNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
protected void ddlGrtype_SelectedIndexChanged(object sender, EventArgs e)
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindTruckNo();
if (ddlGrtype.SelectedValue == "GRR")
{
ddlTranstype.Enabled = true;
if (lst.Count > 0)
{
ddltruckNo.Visible = true;
ddlTranstype.Enabled = true;
txttruck.Visible = false;
//ddltruckNo.DataSource = lst;
//ddltruckNo.DataTextField = "Lorry_No";
//ddltruckNo.DataValueField = "Lorry_Idno";
//ddltruckNo.DataBind();
//ddltruckNo.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
else
{
ddlTranstype.SelectedIndex = 0;
ddlTranstype.Enabled = false;
obj = null;
if (lst.Count > 0)
{
txttruck.Visible = true;
ddltruckNo.Visible = false;
//ddltruckNo.DataSource = lst;
//ddltruckNo.DataTextField = "Lorry_No";
//ddltruckNo.DataValueField = "Lorry_Idno";
//ddltruckNo.DataBind();
//ddltruckNo.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
//lblTruckNo.Text = "Truck No.";
}