private void BindDateRange()
{
FinYearDAL objDAL = new FinYearDAL();
ddlDateRange.DataSource = objDAL.FillYrwiseDateRange(ApplicationFunction.ConnectionString());
ddlDateRange.DataTextField = "DateRange";
ddlDateRange.DataValueField = "Id";
ddlDateRange.DataBind();
objDAL = null;
}
public void BindDateRange()
{
FinYearDAL obj = new FinYearDAL();
var lst = obj.FillYrwiseDateRange(ApplicationFunction.ConnectionString());
ddldateRange.DataSource = lst;
ddldateRange.DataTextField = "DateRange";
ddldateRange.DataValueField = "Id";
ddldateRange.DataBind();
}
private void PrintGRPrep(Int64 GRHeadIdno)
{
Repeater obj = new Repeater();
double dcmsn = 0, dblty = 0, dcrtge = 0, dsuchge = 0, dwges = 0, dPF = 0, dtax = 0, dtoll = 0, dqty = 0, damnt = 0, dweight = 0;
string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string TinNo = ""; string ServTaxNo = ""; string Through = ""; string FaxNo = ""; string Remark = ""; string DelNoteRef = "";
int iPrintOption, PrintRcptAmnt = 0; string strTermCond = ""; Int32 PriPrinted = 0; Int32 ReportTyp = 0; int compID = 0; string numbertoent = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
private void BindGridChallanNotConfirmed()
{
BindDropdownDAL obj = new BindDropdownDAL();
var ds = obj.GetGrChlnNotConfirm(ApplicationFunction.ConnectionString());
if (ds != null)
{
grdGrListChlnNotConfirm.DataSource = ds;
grdGrListChlnNotConfirm.DataBind();
}
}
private void PrintReport(Int64 Inv, Int64 date, Int64 city)
{
Repeater obj = new Repeater();
DataSet dsReport = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spInvGen] @ACTION='REPORT',@Id='" + Inv + "',@YearIdno='" + date + "',@FromCityIdno='" + city + "'");
if (dsReport != null && dsReport.Tables[0].Rows.Count > 0)
{
Repeater1.DataSource = dsReport.Tables[0];
Repeater1.DataBind();
}
}
private void GetOutstandingRepPartyWise()
{
BindDropdownDAL obj = new BindDropdownDAL();
var ds = obj.GetOutstandingRepPartyWise(ApplicationFunction.ConnectionString());
if (ds != null)
{
grdOutstandingRepPartyWise.DataSource = ds;
grdOutstandingRepPartyWise.DataBind();
}
}
private void bindsender()
{
PurchaseBillDAL objBill = new PurchaseBillDAL();
DataTable dt = objBill.BindSenderForPurchaseBill(ApplicationFunction.ConnectionString());
ddlPartyName.DataSource = dt;
ddlPartyName.DataTextField = "Acnt Name";
ddlPartyName.DataValueField = "Acnt Idno";
ddlPartyName.DataBind();
ddlPartyName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void PopulateMultpleFromCity(int UserIdno)
{
EmployeeMasterDAL obj = new EmployeeMasterDAL();
DataSet Ds = obj.PopulateFromCityMultiple(UserIdno, ApplicationFunction.ConnectionString());
chklistFromcity.DataSource = null;
chklistFromcity.DataSource = Ds.Tables[0];
chklistFromcity.DataTextField = "city_name";
chklistFromcity.DataValueField = "City_Idno";
chklistFromcity.DataBind();
}
private void BindSenderName()
{
PrtyDetlDAL obj = new PrtyDetlDAL();
DataTable SenderName = obj.BindPartynew("BindPartynew", ApplicationFunction.ConnectionString());
ddlParty.DataSource = SenderName;
ddlParty.DataTextField = "Acnt_Name";
ddlParty.DataValueField = "Acnt_Idno";
ddlParty.DataBind();
ddlParty.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindReceiptType()
{
PaymentToOwnDAL obj = new PaymentToOwnDAL();
var RcptType = obj.BindRcptType(ApplicationFunction.ConnectionString());
ddlRcptTyp.DataSource = RcptType;
ddlRcptTyp.DataTextField = "ACNT_NAME";
ddlRcptTyp.DataValueField = "Acnt_Idno";
ddlRcptTyp.DataBind();
ddlRcptTyp.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void Populate(Int64 HeadId)
{
imgSearch.Enabled = false;
ddlDelvryPlace.Enabled = false;
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
tblDelvChlnHead chlnhead = obj.selectHead(HeadId);
ddldateRange.SelectedValue = Convert.ToString(chlnhead.Year_Idno);
ddldateRange_SelectedIndexChanged(null, null);
ddldateRange.Enabled = false;
txtchallanNo.Text = Convert.ToString(chlnhead.DelvChln_No);
txtDate.Text = Convert.ToDateTime(chlnhead.DelvChln_Date).ToString("dd-MM-yyyy");
ddlDelvryPlace.SelectedValue = Convert.ToString(chlnhead.DelvryPlc_Idno);
ddlTransportName.SelectedValue = Convert.ToString(chlnhead.Transprtr_Idno);
ddlTruckNo.SelectedValue = Convert.ToString(chlnhead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
ddldriverName.SelectedValue = Convert.ToString(chlnhead.Driver_Idno);
txtDelvInstruction.Text = Convert.ToString(chlnhead.Delvry_Instrc);
txtkatt.Text = Convert.ToDouble(chlnhead.Katt_Amnt).ToString("N2");
txtNetAmnt.Text = Convert.ToDouble(chlnhead.Net_Amnt).ToString("N2");
txtOtherAmnt.Text = Convert.ToDouble(chlnhead.Other_Amnt).ToString("N2");
txtGrosstotal.Text = Convert.ToDouble(chlnhead.Gross_Amnt).ToString("N2");
//if (Convert.ToInt32(hidWorkType.Value) > 1)
//{
// ddlDelvryPlace.Visible = false;
// ddlTruckNo.Enabled = false;
//}
//else
//{
// ddlDelvryPlace.Visible = true;
// ddlTruckNo.Enabled = true;
// ddlDelvryPlace.Enabled = false;
//}
DtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId);
ViewState["dt"] = DtTemp;
this.BindGrid();
imgSearch.Enabled = false;
Int64 value = 0;
value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString());
if (value > 0)
{
lnkbtnSave.Enabled = false;
}
else
{
lnkbtnSave.Enabled = true;
}
PrintChallan(HeadId);
obj = null;
}
protected void lnkbtnsubmit_Click(object sender, EventArgs e)
{
try
{
if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0))
{
string strchkValue = string.Empty; string sAllItemIdnos = string.Empty;
string strchkDetlValue = string.Empty;
for (int count = 0; count < grdGrdetals.Rows.Count; count++)
{
CheckBox ChkGr = (CheckBox)grdGrdetals.Rows[count].FindControl("chkId");
if ((ChkGr != null) && (ChkGr.Checked == true))
{
HiddenField hidGrIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidGrIdno");
strchkDetlValue = strchkDetlValue + hidGrIdno.Value + ",";
}
}
if (strchkDetlValue != "")
{
strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1);
}
if (strchkDetlValue == "")
{
ShowMessageErr("Please check atleast one Gr.");
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
else
{
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
string strSbillNo = String.Empty;
DataTable dtRcptDetl = new DataTable(); DataRow Dr;
dtRcptDetl = obj.SelectGRDetail(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToString(strchkDetlValue));
ViewState["dt"] = dtRcptDetl;
BindGrid();
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
}
ddlRcptTyp.Focus();
}
else
{
ShowMessageErr("Gr Details not found.");
grdMain.DataSource = null;
grdMain.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
private void PrintMangrolGST(Int64 HeadIdno, Int64 PrintFormat)
{
Repeater obj = new Repeater();
string CompName = string.Empty; string Add1 = string.Empty, Add2 = string.Empty; string PhNo = string.Empty; string City = string.Empty; string State = string.Empty; string PanNo; string TinNo = string.Empty; string Serv_No = string.Empty; string FaxNo = string.Empty; string CodeNo = string.Empty; string ServTaxNo = string.Empty;
DataSet CompDetl = null;
CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details..
//GetCityDetails(((CompDetl.Tables[0].Rows[0]["City_Idno"] == null && CompDetl.Tables[0].Rows[0]["City_Idno"].ToString() == "") ? "" : CompDetl.Tables[0].Rows[0]["City_Idno"]).ToString());
if (CompDetl.Tables[0].Rows[0]["CompGSTIN_No"] != null && CompDetl.Tables[0].Rows[0]["CompGSTIN_No"].ToString() != "")
protected void ddlGroupType_SelectedIndexChanged(object sender, EventArgs e)
{
ItemMastPurDAL obj = new ItemMastPurDAL();
DataTable Dttemp = new DataTable();
Int64 Value = string.IsNullOrEmpty(Convert.ToString(ddlGroupType.SelectedValue)) ? 0 : Convert.ToInt64(ddlGroupType.SelectedValue);
Dttemp = obj.SelectType(ApplicationFunction.ConnectionString(), Value);
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
ddlAddType.SelectedValue = Dttemp.Rows[0]["IDNO"].ToString();
}
}
protected void lnkbtnSubmit_Click(object sender, EventArgs e)
{
try
{
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
if ((grdSearchRecords != null) && (grdSearchRecords.Rows.Count > 0))
{
string SerialIdDetlValue = string.Empty;
for (int count = 0; count < grdSearchRecords.Rows.Count; count++)
{
CheckBox ChkGr = (CheckBox)grdSearchRecords.Rows[count].FindControl("chkId");
if ((ChkGr != null) && (ChkGr.Checked == true))
{
HiddenField hidSerialIdno = (HiddenField)grdSearchRecords.Rows[count].FindControl("hidSerialIdno");
SerialIdDetlValue = SerialIdDetlValue + hidSerialIdno.Value + ",";
}
}
if (SerialIdDetlValue != "")
{
SerialIdDetlValue = SerialIdDetlValue.Substring(0, SerialIdDetlValue.Length - 1);
}
if (SerialIdDetlValue == "")
{
ShowMessageErr("Please select atleast one Serial No.");
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
else
{
string Result = String.Empty;
DataTable dt = new DataTable(); DataRow Dr;
if (RDbSaleBill.Checked == true)
{
dt = objClaimFrmDAL.Select(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(SerialIdDetlValue));
}
else
{
dt = objClaimFrmDAL.SelectClaimDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(SerialIdDetlValue));
}
if (dt != null && dt.Rows.Count > 0)
{
objClaimFrmDAL = null;
ViewState["dt"] = dt;
}
this.BindGridT();
}
}
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
private void Populate(Int64 ClaimHeadIdno)
{
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
tblClaimHead ObjHead = objClaimFrmDAL.Select_ClaimHead(ClaimHeadIdno);
if (ObjHead != null)
{
ViewState["ClaimHeadIdno"] = ClaimHeadIdno;
ddlDateRange.SelectedValue = Convert.ToString(ObjHead.Year_Idno);
txtPrefixNo.Text = ObjHead.Prefix_No.ToString();
txtClaimDate.Text = string.IsNullOrEmpty(ObjHead.ClaimHead_Date.ToString()) ? "" : Convert.ToDateTime(ObjHead.ClaimHead_Date).ToString("dd-MM-yyyy");
if ((string.IsNullOrEmpty(Convert.ToString(ObjHead.Claim_Against)) ? 0 : Convert.ToInt64(ObjHead.Claim_Against)) > 0)
{
RDbParty.Checked = true;
}
else
{
RDbSaleBill.Checked = true;
}
txtClaimNo.Text = string.IsNullOrEmpty(ObjHead.Claim_No.ToString()) ? "" : Convert.ToString(ObjHead.Claim_No);
ddlFromCity.SelectedValue = string.IsNullOrEmpty(ObjHead.FromLoc_Idno.ToString())? "0" : Convert.ToString(ObjHead.FromLoc_Idno);
ddlParty.SelectedValue = string.IsNullOrEmpty(ObjHead.Prty_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Prty_Idno);
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(ObjHead.Comp_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Comp_Idno);
RDbParty.Enabled = false; RDbSaleBill.Enabled = false;
ddlFromCity.Enabled = false; imgSearch.Visible = false;
dtTemp = CreateDt();
string Result = String.Empty;
var ClaimNo = objClaimFrmDAL.SelectSaleBillNo(Convert.ToInt64(ClaimHeadIdno)); if (ClaimNo != null && ClaimNo > 0)
{
lblSbillNo.Text = "Sale Bill No : " + ClaimNo.ToString();
}
DataTable dt = new DataTable();
if ((string.IsNullOrEmpty(Convert.ToString(ObjHead.Claim_Against)) ? 0 : Convert.ToInt64(ObjHead.Claim_Against)) > 0)
{
dt = objClaimFrmDAL.SelectClaimParty(ApplicationFunction.ConnectionString(), ClaimHeadIdno);
}
else
{
dt = objClaimFrmDAL.SelectClaimDetails(ApplicationFunction.ConnectionString(), ClaimHeadIdno);
}
if (dt != null && dt.Rows.Count > 0)
{
objClaimFrmDAL = null;
ViewState["dt"] = dt;
}
this.BindGridT();
ViewState["dt"] = dtTemp;
this.BindGridT();
}
}
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"));
}
public bool UpdateChallan(Int64 chlnidno, double commissionAmnt, double tdsAmnt)
{
ChlnBookingDAL objChallan = new ChlnBookingDAL();
if (chlnidno > 0)
{
if (objChallan.BulkUpdateChallan(ApplicationFunction.ConnectionString(), chlnidno, commissionAmnt, tdsAmnt))
{
return(true);
}
}
return(false);
}
protected void grdTruckPrevLoc_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
ViewState["Edit"] = true;
Int64 iTrackIdno = Convert.ToInt64((e.CommandArgument == null ? "0" : e.CommandArgument).ToString());
hidTrackIdno.Value = iTrackIdno.ToString();
ChlnBookingDAL obj = new ChlnBookingDAL();
var data = obj.SelectLorryTrackingLocByTrackIdno(ApplicationFunction.ConnectionString(), iTrackIdno);
if (data.Rows.Count > 0)
{
ddlCity.SelectedValue = data.Rows[0]["City_Idno"].ToString();
txtTruckCurrDate.Text = data.Rows[0]["Track_Date"].ToString();
txtTruckCurrTime.Text = data.Rows[0]["Track_Time"].ToString();
chkTrackingSMS.Checked = Convert.ToBoolean((data.Rows[0]["SMS_Sent"] == null ? "false" : data.Rows[0]["SMS_Sent"]).ToString());
}
}
else if (e.CommandName == "cmddelete")
{
Int64 iTrackIdno = Convert.ToInt64((e.CommandArgument == null ? "0" : e.CommandArgument).ToString());
hidTrackIdno.Value = iTrackIdno.ToString();
ChlnBookingDAL obj = new ChlnBookingDAL();
Int32 data = obj.DeleteLorryTrackingLocByTrackIdno(ApplicationFunction.ConnectionString(), iTrackIdno);
if (data < 0)
{
//MESSAAGE
this.ShowMessage("Tracking detail deleted.");
}
else
{
//MESSAAGE
this.ShowMessageErr("Error deleting tracking detail.");
}
}
else if (e.CommandName == "cmdSendSMS")
{
Int64 iTrackIdno = Convert.ToInt64((e.CommandArgument == null ? "0" : e.CommandArgument).ToString());
string strMobileNo = GetMobileNumbers(iTrackIdno);
if (SendSMS(strMobileNo, GetMsg(iTrackIdno)))
{
this.ShowMessage("Message sent to party.");
}
else
{
this.ShowMessageErr("Error sending message.");
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "PopUpTrackTruck()", true);
}
private void PrintInvoice(String HeadIdno)
{
ChallanConfirmationDAL obj = new ChallanConfirmationDAL();
String GRNo = HeadIdno;
string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string FaxNo = "";
string GSTIN = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
DataSet dsReport = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spInvGen] @ACTION='SelectPrint1',@Id='" + HeadIdno + "'");
CompName = Convert.ToString(CompDetl.Tables[0].Rows[0]["Comp_Name"]);
Add1 = Convert.ToString(CompDetl.Tables[0].Rows[0]["Adress1"]);
Add2 = Convert.ToString(CompDetl.Tables[0].Rows[0]["Adress2"]);
PhNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"]);
City = Convert.ToString(CompDetl.Tables[0].Rows[0]["City_Idno"]);
State = Convert.ToString(CompDetl.Tables[0].Rows[0]["State_Idno"]) + "(CODE :- " + Convert.ToString(dsReport.Tables[0].Rows[0]["GSTState_Code"]) + ")";
TinNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["TIN_NO"]);
FaxNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Fax_No"]);
PanNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Pan_No"]);
GSTIN = Convert.ToString(CompDetl.Tables[0].Rows[0]["CompGSTIN_No"]);
lblpin.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["Pin_No"]);
lblCompname.Text = CompName; //lblcomp.Text = "For - " + CompName;
lblCompAdd1.Text = Add1;
lbladd2.Text = Add2;
lblcity.Text = City;
lblstate.Text = State;
lblmobile.Text = PhNo;
lblgstin.Text = GSTIN;
lblpan.Text = PanNo.ToString();
if (dsReport != null && dsReport.Tables[1].Rows.Count > 0)
{
Repeater1.DataSource = dsReport.Tables[1];
Repeater1.DataBind();
Repeater2.DataSource = dsReport.Tables[1];
Repeater2.DataBind();
}
lblunit.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["unit"]);
lblbillno.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Inv_No"]);
lblbilldate.Text = Convert.ToDateTime(dsReport.Tables[0].Rows[0]["Inv_Date"]).ToString("dd-MM-yyyy");
lblcontname.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Party_Name"]);
lbladd1.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Address1"]);
lblcadd2.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Address2"]);
lblcity1.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["City_Name"]);
lblst.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["State_Name"]);
lblgst.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Party_GSTINNo"]);
Double T1 = Convert.ToDouble(lbltotal.Text);
Double T2 = Convert.ToDouble(lbltot.Text);
lblgrandtotal.Text = Convert.ToString((T1 + T2));
}
private void CallPrint()
{
try
{
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
lblAddress.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["Adress1"]);
//PhNo = "Phone No. (O) :" + Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"] + "," + CompDetl.Tables[0].Rows[0]["Phone_Res"]);
lblPhoneNo.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"]);
//ServTaxNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Serv_Tax"]);
lblPanNo.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["PAN_No"]);
lblEmail.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["Comp_Mail"]);
lblCompDescr.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["CompDescription"]);
lblTripNo.Text = Request.QueryString["TripNo"].ToString();
lblTripDate.Text = ((Request.QueryString["TripDate"] == null || Request.QueryString["TripDate"] == "") ? "" : Convert.ToDateTime(Request.QueryString["TripDate"]).ToString("dd-MM-yyyy")).ToString();
//lblCompFromCity.Text = Request.QueryString["CompFromCity"].ToString();
lblTruckNo.Text = GetTruckNo(Request.QueryString["TruckNo"].ToString());
lblSender.Text = GetUserName(Request.QueryString["Sender"].ToString());
lblFromCity.Text = GetCityName(Request.QueryString["FromCity"].ToString());
lblToCity.Text = GetCityName(Request.QueryString["ToCity"].ToString());
lblDriverName.Text = Request.QueryString["DriverName"].ToString();
lblStartKms.Text = Request.QueryString["StartKms"].ToString();
lblEndKms.Text = Request.QueryString["EndKms"].ToString();
//lblDateRange.Text = Request.QueryString["DateRange"].ToString();
lblItemName.Text = Request.QueryString["ItemName"].ToString();
lblItemSize.Text = Request.QueryString["ItemSize"].ToString();
//lblRateType.Text = Request.QueryString["RateType"].ToString();
lblQuantity.Text = Request.QueryString["Quantity"].ToString();
lblGweight.Text = Request.QueryString["Gweight"].ToString();
//lblAweight .Text = Request.QueryString["Aweight"].ToString();
lblrate.Text = Request.QueryString["rate"].ToString();
lblAdvance.Text = Request.QueryString["Advance"].ToString();
lblCommission.Text = Request.QueryString["Commission"].ToString();
lblTotalPartyAdv.Text = Request.QueryString["TotalPartyAdv"].ToString();
lblRTOChallan.Text = Request.QueryString["RTOChallan"].ToString();
lblDetention.Text = Request.QueryString["Detention"].ToString();
lblTotalAmount.Text = Request.QueryString["TotalAmount"].ToString();
lblTotalFreight.Text = Request.QueryString["TotalFreight"].ToString();
//lblReceived.Text = Request.QueryString["Received"].ToString();
//lblRecType .Text = Request.QueryString["RecType"].ToString();
lblTotalPartyBalance.Text = Request.QueryString["TotalPartyBalance"].ToString();
lblDriver.Text = Request.QueryString["Driver"].ToString();
lblDiesel.Text = Request.QueryString["Diesel"].ToString();
lblDriverAc.Text = Request.QueryString["DriverAc"].ToString();
lblTotalVehAdv.Text = Request.QueryString["TotalVehAdv"].ToString();
lblNetTripProfit.Text = Request.QueryString["NetTripProfit"].ToString();
}
catch (Exception ex)
{
}
}
private void BindPartName()
{
PaymentToOwnDAL obj = new PaymentToOwnDAL();
DataTable lst = obj.FetchChallanDetail(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToInt32(ddlFromCity.SelectedValue));
if (lst.Rows.Count > 0)
{
ddlChallan.DataSource = lst;
ddlChallan.DataTextField = "chln_Detl";
ddlChallan.DataValueField = "Chln_Idno";
ddlChallan.DataBind();
ddlChallan.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
}
private void PrintInvoice(string billno)
{
DataSet dsReport = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spAnnexure] @ACTION='BillINVOICE', @BillNo='" + billno + "', @AnexureNo='" + ddlAnnexure.SelectedValue + "'");
lblcontname.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Party_Name"]);
lbladd1.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Address1"]);
lblcadd2.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Address2"]);
lbldis.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["City_Name"]);
diccode.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Pin_Code"]);
lblst.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["State_Name"]) + "(CODE :- " + Convert.ToString(dsReport.Tables[0].Rows[0]["GSTState_Code"]) + ")";
lblgst.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Party_GSTINNo"]);
lblAnnexNo.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Annexure_No"]);
lblUnit.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["unit"]);
}
private void PrintInvoice(String HeadIdno)
{
InvoiceDAL obj = new InvoiceDAL();
String CityName = Session["fromcity"] as string;
dttemp = obj.city(ApplicationFunction.ConnectionString(), CityName);
String GRNo = HeadIdno;
string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string FaxNo = "";
string GSTIN = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast A Left JOIN tblCITYMASTER CM On CM.city_idno=A.city_idno Left join tblStateMaster SM ON SM.state_idno=A.state_idno");
DataSet dsReport = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spInvGen] @ACTION='PJLBillSummary',@Id='" + HeadIdno + "'");
CompName = Convert.ToString(CompDetl.Tables[0].Rows[0]["Comp_Name"]);
Add1 = Convert.ToString(CompDetl.Tables[0].Rows[0]["Adress1"]);
Add2 = Convert.ToString(dttemp.Rows[0]["Address1"]) + "," + Convert.ToString(dttemp.Rows[0]["Address2"]);
//PhNo = "Phone No. (O) :" + Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"] + " " + CompDetl.Tables[0].Rows[0]["Phone_Res"]);
PhNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"] + "," + CompDetl.Tables[0].Rows[0]["Mobile_1"]);
City = Convert.ToString(CompDetl.Tables[0].Rows[0]["City_Name"]);
State = Convert.ToString(CompDetl.Tables[0].Rows[0]["State_Name"]) + "(CODE :- " + Convert.ToString(dsReport.Tables[0].Rows[0]["GSTState_Code"]) + ")";
TinNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["TIN_NO"]);
FaxNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Fax_No"]);
PanNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Pan_No"]);
GSTIN = Convert.ToString(CompDetl.Tables[0].Rows[0]["CompGSTIN_No"]);
lblpin.Text = Convert.ToString(CompDetl.Tables[0].Rows[0]["Pin_No"]);
lblCompname.Text = CompName; lblcom.Text = "For - " + CompName;
lblCompAdd1.Text = Add1;
lblcity.Text = City;
lblstate.Text = State;
lblmobile.Text = PhNo;
lbgst.Text = GSTIN;
lblpan.Text = PanNo.ToString();
if (dsReport != null && dsReport.Tables[1].Rows.Count > 0)
{
Repeater1.DataSource = dsReport.Tables[1];
Repeater1.DataBind();
}
lblunit.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["unit"]);
lblbillno.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Inv_No"]);
lblcontname.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Party_Name"]);
lbladd1.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Address1"]);
lblcadd2.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Address2"]);
lbldis.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["City_Name"]);
diccode.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Pin_Code"]);
lblst.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["State_Name"]) + "(CODE :- " + Convert.ToString(dsReport.Tables[0].Rows[0]["GSTState_Code"]) + ")";
lblgst.Text = Convert.ToString(dsReport.Tables[0].Rows[0]["Party_GSTINNo"]);
}
private void BindPartyName()
{
CostLedgerDAL obj = new CostLedgerDAL();
DataSet ds = obj.FillLedger(ApplicationFunction.ConnectionString());
if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
{
ddlParty.DataSource = ds;
ddlParty.DataTextField = "Acnt_Name";
ddlParty.DataValueField = "ID";
ddlParty.DataBind();
objAccountBookDAL = null;
ddlParty.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
private void PopulateChallanHead(long iChlnId)
{
ChlnBookingDAL obj = new ChlnBookingDAL();
var data = obj.SelectChallanHeadById(ApplicationFunction.ConnectionString(), iChlnId);
if (data.Rows.Count > 0)
{
lblChlnNo.Text = data.Rows[0]["Chln_No"].ToString();
lblChlnDate.Text = data.Rows[0]["Chln_Date"].ToString();
lblLorryno.Text = data.Rows[0]["Lorry_No"].ToString();
lblPartyName.Text = data.Rows[0]["Acnt_Name"].ToString();
lblLocFrm.Text = data.Rows[0]["From_City"].ToString();
lblLocTo.Text = data.Rows[0]["To_City"].ToString();
}
}
private void PrintGRPrep(Int64 GRHeadIdno)
{
GRPrepDAL obj1 = new GRPrepDAL();
if (GRHeadIdno != 0)
{
//DataSet ds = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spGRPrep] @ACTION='SelectPrintOM',@Id='" + GRHeadIdno + "'");
DataSet ds = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spGRPrep] @ACTION='SelectPrint',@Id='" + GRHeadIdno + "'");
ds.Tables[0].TableName = "GRPrint";
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
lblTexInvoice.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Tax_InvNo"]);
lblExciceInvoice.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Exc_InvNo"]);
lblGRno.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Gr_No"]);
lblGrDate.Text = string.Format("{0:MMMM dd, yyyy}", Convert.ToDateTime(ds.Tables["GRPrint"].Rows[0]["Gr_Date"]));//.ToString("dd-MM-yyyy");
lblOrderNO.Text = ds.Tables["GRPrint"].Rows[0]["Ordr_No"].ToString();
lblConsignorName1.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Sender"]);// ds.Tables["GRPrint"].Rows[0]["ConsigName"].ToString();
lblConsigneeName1.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Receiver"]);
lblConsigneeAddress1.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Recriver Address"]);
lblDeliverCity.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["To_City"]);
lblDeliverPlace.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Delivery_Place"]);
lblDeliverDistrict.Text = "";
lblLorryNo.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Lorry No"].ToString());
lblQty.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Qty"]); //Convert.ToString(dsReport.Tables["GRPrint"].Rows[0]["Unit"]);
lblWeight.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Tot_Weght"]);
lblItemName.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Item_Modl"]);
lblRemark.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Remark"]);
lblTotalAMT.Text = string.Format("{0:0,0.00}", Convert.ToDouble(ds.Tables["GRPrint"].Rows[0]["Net_Amnt"]));
lblAdvance.Text = "";
lblFuelPayment.Text = "";
lblTotAdvance.Text = "";
lblLorryOwner.Text = "";
lblLorryAddress.Text = "";
lblLorryDriver.Text = "";
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alearMessage", "alert('Wrong GR No. please correct !')", true);
}
}
private void TotalRecords()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
TyreStockRpt obj = new TyreStockRpt();
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedIndex);
DataTable list1 = obj.SelectTyreStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), 0, Convert.ToInt64(0), 0, Convert.ToInt64(ddlLocation.SelectedValue));
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void PopulateTruckLocation(Int64 iChlnId)
{
ChlnBookingDAL obj = new ChlnBookingDAL();
var data = obj.SelectLorryTrackingLoc(ApplicationFunction.ConnectionString(), iChlnId);
if (data.Rows.Count > 0)
{
grdTruckPrevLoc.DataSource = data;
grdTruckPrevLoc.DataBind();
}
else
{
grdTruckPrevLoc.DataSource = null;
grdTruckPrevLoc.DataBind();
}
}
private void TotalRecords()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
CurrentStockRpt obj = new CurrentStockRpt();
Int64 YearId = Convert.ToInt64(ddlDateRange.SelectedValue);
DataTable list1 = obj.SelectCurrentStockReport(ApplicationFunction.ConnectionString(), Convert.ToDateTime(hidmindate.Value), 0, "", 0, YearId);
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
