private void BindCityTo()
{
BindDropdownDAL obj = new BindDropdownDAL();
var ToCity = obj.BindAllToCity();
obj = null;
drpCityTo.DataSource = ToCity;
drpCityTo.DataTextField = "City_Name";
drpCityTo.DataValueField = "City_Idno";
drpCityTo.DataBind();
drpCityTo.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindDestination()
{
BindDropdownDAL obj = new BindDropdownDAL();
var DestiCity = obj.BindAllToCity();
ddlDestination.DataSource = DestiCity;
ddlDestination.DataTextField = "City_Name";
ddlDestination.DataValueField = "City_Idno";
ddlDestination.DataBind();
objGRDAL = null;
ddlDestination.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BidFromCity()
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindAllToCity();
obj = null;
ddlToCity.DataSource = lst;
ddlToCity.DataTextField = "City_Name";
ddlToCity.DataValueField = "City_Idno";
ddlToCity.DataBind();
ddlToCity.Items.Insert(0, new 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 BindDropdown()
{
BindDropdownDAL obj = new BindDropdownDAL();
var senderLst = obj.BindSender();
var receiverLst = obj.BindSender();
var TruckNolst = obj.BindTruckNowithLastDigit();
var ToCity = obj.BindAllToCity();
var Agent = obj.BindAgent();
var bank = obj.BindBank();
var UnitName = obj.BindUnitName();
var ToCityComp = obj.BindLocFrom();
obj = null;
ddlSender.DataSource = senderLst;
ddlSender.DataTextField = "Acnt_Name";
ddlSender.DataValueField = "Acnt_Idno";
ddlSender.DataBind();
ddlSender.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"));
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"));
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"));
ddlCompFromCity.DataSource = ToCity;
ddlCompFromCity.DataTextField = "city_name";
ddlCompFromCity.DataValueField = "city_idno";
ddlCompFromCity.DataBind();
ddlCompFromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
ddlCompFromCity.DataSource = ToCityComp;
ddlCompFromCity.DataTextField = "City_Name";
ddlCompFromCity.DataValueField = "City_Idno";
ddlCompFromCity.DataBind();
ddlCompFromCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindFromCity()
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindAllToCity();
obj = null;
if (lst.Count > 0)
{
drpCityDelivery.DataSource = lst;
drpCityDelivery.DataTextField = "City_Name";
drpCityDelivery.DataValueField = "City_Idno";
drpCityDelivery.DataBind();
drpCityDelivery.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
private void ToCity()
{
BindDropdownDAL obj = new BindDropdownDAL();
var ToCity = obj.BindAllToCity();
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"));
ddlViaCity.DataSource = ToCity;
ddlViaCity.DataTextField = "city_name";
ddlViaCity.DataValueField = "city_idno";
ddlViaCity.DataBind();
ddlViaCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
protected void imgSearch_Click(object sender, ImageClickEventArgs e)
{
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
// txtTdsAmnt.Text = "0.00";
ddlTruckNo.SelectedIndex = 0;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
lnkbtnokClick.Visible = false;
//if (Convert.ToInt32(hidWorkType.Value) > 1)
//{
// lblDelvSerch.Text = "Truck No.";
// DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
// var lst = obj.selectTruckNo();
// obj = null;
// if (lst.Count > 0)
// {
// ddldelvplace.DataSource = lst;
// ddldelvplace.DataTextField = "Lorry_No";
// ddldelvplace.DataValueField = "Lorry_Idno";
// ddldelvplace.DataBind();
// ddldelvplace.Items.Insert(0, new ListItem("--Select--", "0"));
// }
//}
//else
//{
//lblDelvSerch.Text = "Delv. Place";
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindAllToCity();
obj = null;
if (lst.Count > 0)
{
ddldelvplace.DataSource = lst;
ddldelvplace.DataTextField = "City_Name";
ddldelvplace.DataValueField = "City_Idno";
ddldelvplace.DataBind();
ddldelvplace.Items.Insert(0, new ListItem("--Select--", "0"));
}
//}
txtDateFrom.Focus();
}
private void BindCity()
{
try
{
CityMastDAL obj = new CityMastDAL();
var lst = obj.SelectCityCombo();
obj = null;
drpCityFrom.DataSource = lst;
drpCityFrom.DataTextField = "City_Name";
drpCityFrom.DataValueField = "City_Idno";
drpCityFrom.DataBind();
drpCityFrom.Items.Insert(0, new ListItem("--Select--", "0"));
BindDropdownDAL obj2 = new BindDropdownDAL();
var ToCity = obj2.BindAllToCity();
obj2 = null;
}
catch (Exception Ex)
{
}
}