private void BindCity()
{
BindDropdownDAL obj = new BindDropdownDAL();
var ToFrom = obj.BindLocFrom();
DdlfromcityHead.DataSource = ToFrom;
DdlfromcityHead.DataTextField = "City_Name";
DdlfromcityHead.DataValueField = "City_Idno";
DdlfromcityHead.DataBind();
obj = null;
DdlfromcityHead.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindCity(Int64 UserIdno)
{
BindDropdownDAL obj = new BindDropdownDAL();
var ToCity = obj.BindCityUserWise(UserIdno);
DdlfromcityHead.DataSource = ToCity;
DdlfromcityHead.DataTextField = "CityName";
DdlfromcityHead.DataValueField = "CityIdno";
DdlfromcityHead.DataBind();
obj = null;
DdlfromcityHead.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindCity(int stateIdno)
{
BindDropdownDAL obj = new BindDropdownDAL();
var FrmCity = obj.BindCity(stateIdno);
ddlCity.DataSource = FrmCity;
ddlCity.DataTextField = "City_Name";
ddlCity.DataValueField = "City_Idno";
ddlCity.DataBind();
obj = null;
ddlCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindCity()
{
BindDropdownDAL BindDropdownDAL = new BindDropdownDAL();
var lst = BindDropdownDAL.BindCity(Convert.ToInt64(ddlState.SelectedValue));
BindDropdownDAL = null;
ddlCity.DataSource = lst;
ddlCity.DataTextField = "City_Name";
ddlCity.DataValueField = "City_Idno";
ddlCity.DataBind();
ddlCity.Items.Insert(0, new ListItem("< Choose City >", "0"));
}
private void BindCity()
{
obj = new BindDropdownDAL();
var ToCity = obj.BindLocFrom();
obj = null;
ddlFromCity.DataSource = ToCity;
ddlFromCity.DataTextField = "city_name";
ddlFromCity.DataValueField = "city_idno";
ddlFromCity.DataBind();
ddlFromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Location...", "0"));
}
private void BindTyrePosition()
{
BindDropdownDAL objTyre = new BindDropdownDAL();
var LorrMast = objTyre.SelectTyrePostion();
ddlTyrePosition.DataSource = LorrMast;
ddlTyrePosition.DataTextField = "Position_name";
ddlTyrePosition.DataValueField = "Position_id";
ddlTyrePosition.DataBind();
ddlTyrePosition.Items.Insert(0, new ListItem("--Select Position--", "0"));
objTyre = null;
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
Count = 0;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
OpenTyreDAL obj = new OpenTyreDAL();
int ICount = obj.ICount(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "SerialNo")));
double amnt = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "OpenRate"));
dblNetAmnt = amnt + dblNetAmnt;
if (ICount > 0)
{
LinkButton lblDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
LinkButton lbledit = (LinkButton)e.Row.FindControl("lnkbtnEdit");
lblDelete.Enabled = false;
lblDelete.ToolTip = "Issued";
lbledit.Enabled = false;
lbledit.ToolTip = "Issued";
}
Count++;
// Used to hide Delete button if ItemgrpId exists in Rate Master,Goods Received, Quotation,GR Preparation,Commission Master
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
LinkButton lnkbtnEdit = (LinkButton)e.Row.FindControl("lnkbtnEdit");
string ItemIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "TyreIdno"));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "SerialNo"))) ? "0" : Convert.ToString(DataBinder.Eval(e.Row.DataItem, "SerialNo"));
if (ItemIdno != "")
{
BindDropdownDAL obj1 = new BindDropdownDAL();
var ItemExist = obj1.CheckItemExistInOtherMaster(SerialNo);
if (ItemExist != null && ItemExist.Count > 0)
{
lnkbtnDelete.Visible = false;
lnkbtnEdit.Visible = false;
}
else
{
lnkbtnEdit.Visible = true;
lnkbtnDelete.Visible = true;
}
}
// end----
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblQuantity = (Label)e.Row.FindControl("lblRecordCount");
Label lblAmntTot = (Label)e.Row.FindControl("lbltotAmount");
lblQuantity.Text = Convert.ToDouble(grdMain.Rows.Count).ToString("N2");
//lblAmntTot.Text = dblNetAmnt.ToString("N2");
}
}
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 BindCity()
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindLocFrom();
obj = null;
ddlLocation.DataSource = lst;
ddlLocation.DataTextField = "City_Name";
ddlLocation.DataValueField = "City_Idno";
ddlLocation.DataBind();
ddlLocation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindCityFrom()
{
BindDropdownDAL obj = new BindDropdownDAL();
var ToCity = obj.BindLocFrom();
obj = null;
drpCityFrom.DataSource = ToCity;
drpCityFrom.DataTextField = "City_Name";
drpCityFrom.DataValueField = "City_Idno";
drpCityFrom.DataBind();
drpCityFrom.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindParty()
{
obj = new BindDropdownDAL();
var PartyName = obj.BindParty();
obj = null;
ddlPartyName.DataSource = PartyName;
ddlPartyName.DataTextField = "Acnt_Name";
ddlPartyName.DataValueField = "Acnt_Idno";
ddlPartyName.DataBind();
ddlPartyName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Party...", "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 BindStateDDL()
{
BindDropdownDAL objClsBindDropDown = new BindDropdownDAL();
var lst = objClsBindDropDown.BindState();
ddlState.DataSource = lst;
ddlState.DataTextField = "State_Name";
ddlState.DataValueField = "State_Idno";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("--Select--", "0"));
ddlCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindFromCity(Int64 UserIdno)
{
BindDropdownDAL obj = new BindDropdownDAL();
var FrmCity = obj.BindCityUserWise(UserIdno);
drpCityDelivery.DataSource = FrmCity;
drpCityDelivery.DataTextField = "CityName";
drpCityDelivery.DataValueField = "CityIdno";
drpCityDelivery.DataBind();
obj = null;
drpCityDelivery.Items.Insert(0, new System.Web.UI.WebControls.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 BindSenderName()
{
//outsndngBillRepDAL obj = new outsndngBillRepDAL();
BindDropdownDAL obj = new BindDropdownDAL();
var SenderName = obj.BindSender();
drpSenderName.DataSource = SenderName;
drpSenderName.DataTextField = "Acnt_Name";
drpSenderName.DataValueField = "Acnt_Idno";
drpSenderName.DataBind();
objInvcDAL = null;
drpSenderName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
protected void lnkBtnLocation_Click(object sender, EventArgs e)
{
BindDropdownDAL obj = new BindDropdownDAL();
var to = obj.BindLocFrom();
ddlLocation.DataSource = to;
ddlLocation.DataTextField = "city_name";
ddlLocation.DataValueField = "city_idno";
ddlLocation.DataBind();
ddlLocation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
lnkBtnLocation.Focus();
}
private void BindPartyName()
{
obj = new BindDropdownDAL();
DataTable dtParty = new DataTable();
dtParty = obj.BindPartyForSale(ApplicationFunction.ConnectionString());
obj = null;
ddlPartyName.DataSource = dtParty;
ddlPartyName.DataTextField = "Acnt_Name";
ddlPartyName.DataValueField = "Acnt_Idno";
ddlPartyName.DataBind();
ddlPartyName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Party.......", "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"));
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
BindDropdownDAL objDropDal = new BindDropdownDAL();
Int64 StckDetlIdno = 0;
VechDetlClmPrtyDAL objDAL = new VechDetlClmPrtyDAL();
Int32 intYearIdno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 intLocIdno = string.IsNullOrEmpty(Convert.ToString(ddlLocation.SelectedValue)) ? 0 : Convert.ToInt64(ddlLocation.SelectedValue);
Int64 intItemIdno = string.IsNullOrEmpty(Convert.ToString(ddlItemName.SelectedValue)) ? 0 : Convert.ToInt64(ddlItemName.SelectedValue);
string strSerialNo = string.IsNullOrEmpty(Convert.ToString(txtSerialNo.Text)) ? "" : Convert.ToString(txtSerialNo.Text);
string strCompName = string.IsNullOrEmpty(Convert.ToString(txtCompName.Text)) ? "" : Convert.ToString(txtCompName.Text);
string strPurFrom = string.IsNullOrEmpty(Convert.ToString(txtPurchaseFrom.Text)) ? "" : Convert.ToString(txtPurchaseFrom.Text);
Int32 intTyreType = string.IsNullOrEmpty(Convert.ToString(ddltype.SelectedValue)) ? 0 : Convert.ToInt32(ddltype.SelectedValue);
Int64 intAcntIdno = string.IsNullOrEmpty(Convert.ToString(ddltype.SelectedValue)) ? 0 : Convert.ToInt64(ddltype.SelectedValue);
double ddlOpenRate = string.IsNullOrEmpty(Convert.ToString(txtOpenRate.Text.Trim())) ? 0 : Convert.ToDouble(txtOpenRate.Text.Trim());
//Check Conditions Before Save Peeyush Kasuhik
var lst1 = objDropDal.CheckSerialNo(strSerialNo);
if (lst1 != null && lst1 > 0)
{
ShowMessageErr("Serial No already Exists !"); return;
}
if (string.IsNullOrEmpty(hidstckidno.Value) == true)
{
StckDetlIdno = objDAL.Insert(strSerialNo, intLocIdno, intItemIdno, strCompName, intTyreType, strPurFrom, intYearIdno, ddlOpenRate, (string.IsNullOrEmpty(Convert.ToString(Request.QueryString["AcntIdno"])) ? 0 : Convert.ToInt64(Request.QueryString["AcntIdno"])));
}
else
{
StckDetlIdno = objDAL.Update((string.IsNullOrEmpty(Convert.ToString(hidstckidno.Value)) ? 0 : Convert.ToInt64(hidstckidno.Value)), strSerialNo, intLocIdno, intItemIdno, strCompName, intTyreType, strPurFrom, intYearIdno, ddlOpenRate, (string.IsNullOrEmpty(Convert.ToString(Request.QueryString["AcntIdno"])) ? 0 : Convert.ToInt64(Request.QueryString["AcntIdno"])));
}
if (StckDetlIdno == 0)
{
ShowMessageErr("Record Not Saved ");
}
else if (StckDetlIdno == -1)
{
ShowMessageErr("Record already exists.");
}
else if (StckDetlIdno > 0)
{
if (hidstckidno.Value == "")
{
ShowMessage("Record Saved Successfully");
}
else
{
ShowMessage("Record Updated Successfully.");
}
this.ClearControls();
this.BindGrid();
}
}
private void BindCity()
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.BindLocFrom();
if (lst.Count > 0)
{
ddlFromCity.DataSource = lst;
ddlFromCity.DataTextField = "City_Name";
ddlFromCity.DataValueField = "City_Idno";
ddlFromCity.DataBind();
ddlFromCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
private void BindState()
{
BindDropdownDAL BindDropdownDAL = new BindDropdownDAL();
var lst = BindDropdownDAL.BindState();
//.SelectState();
BindDropdownDAL = null;
ddlState.DataSource = lst;
//ddlState.DataTextField = "Name";
ddlState.DataTextField = "State_Name";
ddlState.DataValueField = "State_Idno";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("< Choose State >", "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 BindCity(Int64 UserIdno)
{
BindDropdownDAL obj = new BindDropdownDAL();
var FrmCity = obj.BindLocFromByUserId(UserIdno);
obj = null;
if (FrmCity.Count > 0)
{
ddlFromCity.DataSource = FrmCity;
ddlFromCity.DataTextField = "City_Name";
ddlFromCity.DataValueField = "City_Idno";
ddlFromCity.DataBind();
}
ddlFromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Location...", "0"));
}
//private void BindClaimParty()
//{
// BindDropdownDAL obj = new BindDropdownDAL();
// DataTable dtParty = new DataTable();
// dtParty = obj.BindPartyforClaim(ApplicationFunction.ConnectionString());
// obj = null;
// ddlDivPrtyName.DataSource = dtParty;
// ddlDivPrtyName.DataTextField = "Acnt_Name";
// ddlDivPrtyName.DataValueField = "Acnt_Idno";
// ddlDivPrtyName.DataBind();
// ddlDivPrtyName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Party.......", "0"));
// ddlParty.DataSource = dtParty;
// ddlParty.DataTextField = "Acnt_Name";
// ddlParty.DataValueField = "Acnt_Idno";
// ddlParty.DataBind();
// ddlParty.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Party.......", "0"));
//}
private void BindCompany()
{
BindDropdownDAL obj = new BindDropdownDAL();
var CompanyName = obj.SelectCompanyName();
obj = null;
if (CompanyName != null)
{
ddlCompanyName.DataSource = CompanyName;
ddlCompanyName.DataTextField = "Acnt_Name";
ddlCompanyName.DataValueField = "Acnt_Idno";
ddlCompanyName.DataBind();
}
ddlCompanyName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Choose Company.......", "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"));
}
private void BindTyreType()
{
BindDropdownDAL obj = new BindDropdownDAL();
var lst = obj.SelectTyreType();
obj = null;
if (lst != null && lst.Count > 0)
{
ddltype.DataSource = lst;
ddltype.DataTextField = "TyreType_Name";
ddltype.DataValueField = "TyreType_IdNo";
ddltype.DataBind();
}
ddltype.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindTyreName()
{
BindDropdownDAL obj = new BindDropdownDAL();
var itemname = obj.SelectOnlyTyre();
obj = null;
if (itemname != null && itemname.Count > 0)
{
ddlItemName.DataSource = itemname;
ddlItemName.DataTextField = "Item_Name";
ddlItemName.DataValueField = "Item_idno";
ddlItemName.DataBind();
}
ddlItemName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindItemGroup()
{
BindDropdownDAL obj = new BindDropdownDAL();
var objUserPref = obj.BindItemGroup();
obj = null;
if (objUserPref != null && objUserPref.Count > 0)
{
ddlItemGropForPopup.DataSource = objUserPref;
ddlItemGropForPopup.DataTextField = "ItemType_Name";
ddlItemGropForPopup.DataValueField = "ItemTpye_Idno";
ddlItemGropForPopup.DataBind();
}
ddlItemGropForPopup.Items.Insert(0, new ListItem("-- Select --", "0"));
}