protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!IsPostBack)
{
ddlDateRange.Focus();
Datefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateTo.Attributes.Add("onkeypress", "return notAllowAnything(event);");
this.BindDateRange(); this.BindCityFrom(); this.bindsender();
this.ddlDateRange_SelectedIndexChanged(sender, e);
PurchaseBillDAL Obj = new PurchaseBillDAL();
DateTime? datefromValue = null;
DateTime? dateToValue = null;
datefromValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
dateToValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text));
lblTotalRecord.Text = "T. Record (s): " + Obj.Select_PurchaseBillCount(Convert.ToInt32(ddlDateRange.SelectedValue), datefromValue, dateToValue);
prints.Visible = false;
}
}
private void SetDate()
{
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
objFinYearDAL = new FinYearDAL();
var lst = objFinYearDAL.FilldateFromTo(intyearid);
objFinYearDAL = null;
hidmindate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "StartDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "StartDate")).ToString("dd-MM-yyyy"));
hidmaxdate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "EndDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "EndDate")).ToString("dd-MM-yyyy"));
if (ddlDateRange.SelectedIndex >= 0)
{
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmaxdate.Value)) >= DateTime.Now.Date && DateTime.Now.Date >= Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmindate.Value)))
{
txtDateFrom.Text = hidmindate.Value;
txtDateTo.Text = DateTime.Now.Date.ToString("dd-MM-yyyy");
}
else
{
txtDateFrom.Text = hidmindate.Value;
txtDateTo.Text = DateTime.Now.Date.ToString("dd-MM-yyyy");
}
}
}
private void BindGrid()
{
TyreIssueDAL obj = new TyreIssueDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 location = Convert.ToInt32(ddlLocation.SelectedValue);
Int64 truckno = Convert.ToInt32(ddlTruckNo.SelectedValue);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text));
}
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
var lstGridData = obj.SelectMatrial(dtfrom, dtto, location, truckno, yearidno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = false;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): 0 ";
imgBtnExcel.Visible = false;
}
}
private void BindGrid()
{
InvoiceDAL obj = new InvoiceDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int32 challanNo = ((txtReceiptNo.Text) == "" ? 0 : Convert.ToInt32(txtReceiptNo.Text));
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text));
}
int SenderId = Convert.ToInt32((ddlSenderName.SelectedIndex != -1) ? (ddlSenderName.SelectedValue) : "0");
int fromCity = Convert.ToInt32((ddlFromCity.SelectedIndex != -1) ? (ddlFromCity.SelectedValue) : "0");
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, SenderId, fromCity, ddlGrType.SelectedValue);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("InvoiceNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("Sender", typeof(string));
dt.Columns.Add("NetAmount", typeof(string));
double TNet = 0; double TAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["InvoiceNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Inv_prefix")) + Convert.ToString(DataBinder.Eval(lstGridData[i], "Inv_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Inv_Date")).ToString("dd-MM-yyyy");
dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "City_Name"));
dr["Sender"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Sender"] = "Total";
drr["NetAmount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
lblNetTotalAmount.Text = (TNet).ToString("N2");
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
grdprint.DataSource = lstGridData;
grdprint.DataBind();
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
grdprint.DataSource = null;
grdprint.DataBind();
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
DtTemp = (DataTable)ViewState["dt"];
if (DtTemp != null)
{
if (DtTemp.Rows.Count <= 0)
{
ShowMessageErr("Please enter details");
return;
}
}
if (grdMain.Rows.Count <= 0)
{
ShowMessageErr("Please enter details");
return;
}
string strMsg = string.Empty;
LorryHireDAL objlorry = new LorryHireDAL();
Int64 intSlip = 0;
DateTime? slipDate = null;
slipDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtslipdate.Text));
DateTime DateAdded = System.DateTime.Now;
Int64 yearId = Convert.ToInt32(string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue));
if (txtfreight.Text == string.Empty || Convert.ToDouble(txtfreight.Text) <= 0)
{
this.ShowMessage("Freight Amount must be greater than 0!"); txtfreight.Focus(); txtfreight.SelectText();
return;
}
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidlorryhireidno.Value) == true)
{
intSlip = objlorry.Insert(string.IsNullOrEmpty(txtslipno.Text) ? 0 : Convert.ToInt64(txtslipno.Text), slipDate, string.IsNullOrEmpty(ddlFromCity.SelectedValue) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue), string.IsNullOrEmpty(ddllorryno.SelectedValue) ? 0 : Convert.ToInt64(ddllorryno.SelectedValue), txtsupliedby.Text.Trim(), yearId, Convert.ToDouble(txtfreight.Text), Convert.ToDouble(txtadvance.Text), Convert.ToDouble(txtnetamnt.Text), DateAdded, txtremark.Text.Trim(), Convert.ToDouble(txtothercharges.Text), Convert.ToDouble(txtUnloading.Text), Convert.ToDouble(txtDetectionCharges.Text), Convert.ToDouble(txtDiesel.Text), Convert.ToDouble(txtTds.Text), DtTemp);
}
else
{
intSlip = objlorry.Update(Convert.ToInt32(hidlorryhireidno.Value), string.IsNullOrEmpty(txtslipno.Text) ? 0 : Convert.ToInt64(txtslipno.Text), slipDate, string.IsNullOrEmpty(ddlFromCity.SelectedValue) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue), string.IsNullOrEmpty(ddllorryno.SelectedValue) ? 0 : Convert.ToInt64(ddllorryno.SelectedValue), txtsupliedby.Text.Trim(), yearId, Convert.ToDouble(txtfreight.Text), Convert.ToDouble(txtadvance.Text), Convert.ToDouble(txtnetamnt.Text), DateAdded, txtremark.Text.Trim(), Convert.ToDouble(txtothercharges.Text), Convert.ToDouble(txtUnloading.Text), Convert.ToDouble(txtDetectionCharges.Text), Convert.ToDouble(txtDiesel.Text), Convert.ToDouble(txtTds.Text), DtTemp);
}
objlorry = null;
if (intSlip > 0)
{
if (string.IsNullOrEmpty(hidlorryhireidno.Value) == false)
{
Tran.Complete();
strMsg = "Record updated successfully.";
grdMain.DataSource = null;
grdMain.DataBind();
}
else
{
Tran.Complete();
strMsg = "Record saved successfully.";
}
ClearControls();
}
else
{
if (string.IsNullOrEmpty(hidlorryhireidno.Value) == false)
{
Tran.Dispose();
strMsg = "Record not updated.";
}
else
{
Tran.Dispose();
strMsg = "Record not saved.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
private void BindGrid()
{
try
{
TdsReportDAL obj = new TdsReportDAL(); Int32 dt1count = 0, dt2count = 0; double dfreight = 0, dTDSamnt = 0, dBiltyComm = 0;
string iVehicleNo = (Convert.ToString(txtVehicleNo.Text) == "" ? "" : Convert.ToString(txtVehicleNo.Text));
Int32 Type = Convert.ToInt32(ddltype.SelectedValue);
Int64 PartyIdno = (ddlParty.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlParty.SelectedValue));
string PanNo = Convert.ToString(txtPan.Text.Trim());
var DsGrdetail = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iVehicleNo, Type, PartyIdno, PanNo, ApplicationFunction.ConnectionString());
if (DsGrdetail != null && DsGrdetail.Rows.Count > 0)
{
DataTable dt1 = SelectDistinct("[CheckValue]", DsGrdetail, "VehicleNo");
dt1count = dt1.Rows.Count;
DataTable dt2 = SelectDistinct("[CheckValue]", DsGrdetail, "PANHolderName");
dt2count = dt2.Rows.Count;
var row1 = DsGrdetail.NewRow();
row1["SNO"] = "";
row1["Challan_No"] = "";
row1["Challan_Date"] = Convert.ToString("Total Vehicle");
row1["GRNo"] = "";
row1["VehicleNo"] = "";
row1["FrieghtAmount"] = "";
row1["PANNO"] = "";
row1["PANHolderName"] = "";
row1["TDSAmount"] = "";
//row1["Bilty_Commission"] = "";
DsGrdetail.Rows.Add(row1);
var row = DsGrdetail.NewRow();
row["SNO"] = "";
row["Challan_No"] = "";
row["Challan_Date"] = "Total PAN Holder";
row["GRNo"] = "";
row["VehicleNo"] = "";
row["FrieghtAmount"] = "";
row["PANNO"] = "";
row["PANHolderName"] = "";
row["TDSAmount"] = "";
//row["Bilty_Commission"] = "";
DsGrdetail.Rows.Add(row);
var row2 = DsGrdetail.NewRow();
row2["SNO"] = "";
row2["Challan_No"] = "";
row2["Challan_Date"] = "Total Amount";
row2["GRNo"] = "";
row2["VehicleNo"] = "";
row2["FrieghtAmount"] = "";
row2["PANNO"] = "";
row2["PANHolderName"] = "";
row2["TDSAmount"] = "";
//row2["Bilty_Commission"] = "";
DsGrdetail.Rows.Add(row2);
for (int i = 0; i < DsGrdetail.Rows.Count; i++)
{
dfreight = dfreight + Convert.ToDouble(Convert.ToString(DsGrdetail.Rows[i]["FrieghtAmount"]) == "" ? 0 : Convert.ToDouble(DsGrdetail.Rows[i]["FrieghtAmount"]));
dTDSamnt = dTDSamnt + Convert.ToDouble(Convert.ToString(DsGrdetail.Rows[i]["TDSAmount"]) == "" ? 0 : Convert.ToDouble(DsGrdetail.Rows[i]["TDSAmount"]));
//dBiltyComm= dBiltyComm + Convert.ToDouble(Convert.ToString(DsGrdetail.Rows[i]["Bilty_Commission"]) == "" ? 0 : Convert.ToDouble(DsGrdetail.Rows[i]["Bilty_Commission"]));
}
foreach (DataRow dtrow in DsGrdetail.Rows)
{
if (Convert.ToString(dtrow["Challan_Date"]) == Convert.ToString("Total Vehicle"))
{
dtrow["GRNo"] = dt1count; dtrow["SNO"] = "";
}
if (Convert.ToString(dtrow["Challan_Date"]) == Convert.ToString("Total PAN Holder"))
{
dtrow["GRNo"] = dt2count; dtrow["SNO"] = "";
}
if (Convert.ToString(dtrow["Challan_Date"]) == Convert.ToString("Total Amount"))
{
dtrow["FrieghtAmount"] = dfreight.ToString("N2"); dtrow["SNO"] = "";
dtrow["TDSAmount"] = dTDSamnt.ToString("N2");
//dtrow["Bilty_Commission"] = dBiltyComm.ToString("N2");
}
}
ViewState["CSV"] = DsGrdetail;
grdMain.DataSource = DsGrdetail;
grdMain.DataBind();
// printRep.Visible = true;
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "T. Record (s): " + DsGrdetail.Rows.Count.ToString();
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsGrdetail.Rows.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
ViewState["CSV"] = null;
grdMain.DataSource = null;
grdMain.DataBind();
// printRep.Visible = false;
imgBtnExcel.Visible = false;
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
private void BindGrid()
{
QuotationDAL objclsCityMaster = new QuotationDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int QuNo = string.IsNullOrEmpty(Convert.ToString(txtQutNo.Text)) ? 0 : Convert.ToInt32(txtQutNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(txtQutnDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtQutnDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtQutnDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtQutnDateto.Text));
}
int citto = Convert.ToInt32(drpCityTo.SelectedValue);
int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue);
int citydel = Convert.ToInt32(drpCityDelivery.SelectedValue);
int sender = Convert.ToInt32(drpSender.SelectedValue == "" ? 0 : Convert.ToInt32(drpSender.SelectedValue));
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
var lstGridData = objclsCityMaster.SelectQuotation(QuNo, dtfrom, dtto, cityfrom, citydel, citto, sender, yearidno, UserIdno);
objclsCityMaster = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("Sr No.", typeof(string));
dt.Columns.Add("Quatation No.", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("From City", typeof(string));
dt.Columns.Add("City To", typeof(string));
dt.Columns.Add("Delivery Place", typeof(string));
dt.Columns.Add("Sender", typeof(string));
dt.Columns.Add("Net Amount", typeof(string));
double TNet = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["Sr No."] = Convert.ToString(i + 1);
dr["Quatation No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "QuHead_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "QuHead_Date")).ToString("dd-MM-yyyy");
dr["From City"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityFrom"));
dr["City To"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityTo"));
dr["Delivery Place"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityDely"));
dr["Sender"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Sender"));
dr["Net Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Sender"] = "Total";
drr["Net Amount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
Double TotalNetAmount = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
}
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
grdprint.DataSource = lstGridData;
grdprint.DataBind();
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): 0 ";
grdprint.DataSource = null;
grdprint.DataBind();
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void lnkbtnPreview_OnClick(object sender, EventArgs e)
{
try
{
if (txtDateFrom.Text.Trim() != "" && txtDateTo.Text.Trim() != "")
{
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text.Trim())) > Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim())))
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "ShowMessage('Validfrom date can not be greater than Validto date!');", true);
ddlDateRange.Focus();
return;
}
}
this.BindGrid();
}
catch (Exception ex)
{
throw (ex);
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
DateTime?ClaimDate = null;
ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
DateTime CurrentDate = System.DateTime.Now;
Int64 intAgainst = 0;
if (RDbSaleBill.Checked == true)
{
intAgainst = 0;
}
else
{
intAgainst = 1;
}
if (grdMain.Rows.Count > 0)
{
DTMain = CreateDt();
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno");
HiddenField hidSbillIdno = (HiddenField)row.FindControl("hidSbillIdno");
TextBox txtDefRemark = (TextBox)row.FindControl("txtDefRemark");
TextBox txtVchAppDetl = (TextBox)row.FindControl("txtVchAppDetl");
ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidSbillIdno.Value, txtDefRemark.Text, txtVchAppDetl.Text);
}
tblClaimHead objClaimHead = new tblClaimHead();
if (txtClaimDate.Text == "")
{
objClaimHead.ClaimHead_Date = null;
}
else
{
objClaimHead.ClaimHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
}
objClaimHead.Claim_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim());
objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim());
objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue);
objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue);
objClaimHead.Claim_Against = intAgainst;
objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue);
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (ViewState["ClaimHeadIdno"] != null)
{
objClaimHead.Date_Modified = System.DateTime.Now;
lnkbtnNew.Visible = false;
value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(ViewState["ClaimHeadIdno"].ToString()), DTMain);
objClaimFrmDAL = null;
}
else
{
objClaimHead.Date_Added = System.DateTime.Now;
value = objClaimFrmDAL.Insert(objClaimHead, DTMain);
objClaimFrmDAL = null;
}
if (ViewState["ClaimHeadIdno"] != null)
{
if (value > 0 && (ViewState["ClaimHeadIdno"] != null))
{
ShowMessage("Record Update successfully");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not Update");
tScope.Dispose();
}
}
else
{
if (value > 0 && (ViewState["ClaimHeadIdno"] == null))
{
ShowMessage("Record saved Successfully ");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not saved Successfully ");
tScope.Dispose();
}
}
}
}
else
{
ShowMessageErr("Please Search and Select Serial Number.");
return;
}
}
protected void lnkbtnSearch_Click(object sender, EventArgs e)
{
grdSearchRecords.Visible = true;
objClaimFrmDAL = new ClaimToDAL();
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
DateTime? DateFrom = null; DateTime?DateTo = null;
DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text));
DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text));
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
string ClaimNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim())) + "" + (string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()));
Int64 Value = 1;
if (rdoAgnReceived.Checked)
{
Value = 2;
}
else
{
Value = 1;
}
if (Value == 2)
{
var lst = objClaimFrmDAL.SelectForSearchRecvd(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objClaimFrmDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"));
string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy"));
string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
hidid.Value = SbillIdNo;
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId, SbillNo);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
else
{
var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objClaimFrmDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string ClaimNumber = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string ClaimHeadIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"));
string CBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy"));
string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, ClaimHeadIdno, PrefNo + "" + ClaimNumber, ApplicationFunction.mmddyyyy(CBillDate), CityName, PartyName, PartyId, SbillNo);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno")));
HidClaimHeadIdno.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "ClaimHeadIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "ClaimHeadIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
private void BindGrid()
{
try
{
LostAlignRepDAL obj = new LostAlignRepDAL();
Int64 LorryIdno = (Convert.ToString(drpLorryNo.SelectedValue) == "" ? 0 : Convert.ToInt64(drpLorryNo.SelectedValue));
var DsGrdetail = obj.SelectForSearch(Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), LorryIdno);
if ((DsGrdetail != null) && (DsGrdetail.Count > 0))
{
grdMain.DataSource = DsGrdetail;
grdMain.DataBind();
DataTable dttemp1 = ApplicationFunction.CreateTable("tbl",
"SrNo", "String",
"Date", "String",
"LorryNo", "String",
"ItemName", "String",
"SerialNo", "String",
"PrevAlignDate", "String",
"AlignDate", "String"
);
for (int i = 0; i < DsGrdetail.Count; i++)
{
DataRow dr = dttemp1.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Date"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "Date")).ToString("dd-MM-yyyy"));
dr["LorryNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "LorryNo"));
dr["ItemName"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "ItemName"));
dr["SerialNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "SerialNo"));
dr["PrevAlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "PrevAlignDate")).ToString("dd-MM-yyyy"));
dr["AlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "AlignDate")).ToString("dd-MM-yyyy"));
dttemp1.Rows.Add(dr);
}
ViewState["dtCSV"] = dttemp1;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsGrdetail.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "T. Record(s) :" + Convert.ToString(DsGrdetail.Count);
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
// string con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString;
#endregion
#region Page Load...
protected void Page_Load(object sender, EventArgs e)
{
txtReceiptNo.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.Print == false)
{
imgBtnExcel.Visible = false;
}
//this.BindState();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
drpCityFrom.SelectedValue = Convert.ToString(base.UserFromCity);
this.BindDateRange();
ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddldateRange_SelectedIndexChanged(null, null);
this.BindTruckNo();
txtReceiptDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtReceiptDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
lblTruckNo.Text = "Truck No.";
ChlnBookingDAL obj = new ChlnBookingDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
String challanNo = txtReceiptNo.Text;
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex <= 0) ? "0" : drpCityFrom.SelectedValue);
int TruckId = Convert.ToInt32((ddltruckNo.SelectedIndex <= 0) ? "0" : ddltruckNo.SelectedValue);
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
DataTable lstGridData = null;
lstGridData = obj.searchBySP(ApplicationFunction.ConnectionString(), "SelectChallan", Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, cityfrom, TruckId, UserIdno, ddlGrtype.SelectedValue);
obj = null;
if (lstGridData != null && lstGridData.Rows.Count > 0)
{
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Rows.Count;
}
Trantype();
BindCity();
}
}
private void BindGrid()
{
ChlnBookingDAL obj = new ChlnBookingDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
String challanNo = txtReceiptNo.Text;
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex <= 0) ? "0" : drpCityFrom.SelectedValue);
if (txttruck.Visible == true)
{
ddltruckNo.SelectedValue = hfTruckNoId.Value == "" ? "0" : hfTruckNoId.Value;
}
int TruckId = Convert.ToInt32((ddltruckNo.SelectedIndex <= 0) ? "0" : ddltruckNo.SelectedValue);
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
//var lstGridData=(IList)null;
DataTable lstGridData = null;
DataTable dtRcptDetl = new DataTable();
if (ddlGrtype.SelectedValue == "GR")
{
lstGridData = obj.searchBySP(ApplicationFunction.ConnectionString(), "SelectChallan", Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, cityfrom, TruckId, UserIdno, ddlGrtype.SelectedValue);
}
else
{
dtRcptDetl = obj.SelectGRRChlnDetail(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, cityfrom, TruckId, UserIdno, ddlGrtype.SelectedValue, Convert.ToString(ddlTranstype.SelectedValue));
}
#region Gr....
obj = null;
if ((lstGridData != null && lstGridData.Rows.Count > 0))
{
DataTable dt = new DataTable();
dt.Columns.Add("ChlnDate", typeof(string));
dt.Columns.Add("ChlnNo", typeof(string));
dt.Columns.Add("LorryNo", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("NetAmnt", typeof(string));
double TNet = 0;
for (int i = 0; i < lstGridData.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr["ChlnDate"] = Convert.ToDateTime(lstGridData.Rows[i]["Chln_Date"]).ToString("dd-MM-yyyy");
dr["ChlnNo"] = Convert.ToString(lstGridData.Rows[i]["Chln_No"]);
dr["LorryNo"] = Convert.ToString(lstGridData.Rows[i]["Lorry_No"]);
dr["FromCity"] = Convert.ToString(lstGridData.Rows[i]["FromCity"]);
dr["NetAmnt"] = Convert.ToDouble(lstGridData.Rows[i]["Net_Amnt"]).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(lstGridData.Rows[i]["Net_Amnt"]);
if (i == lstGridData.Rows.Count - 1)
{
DataRow drr = dt.NewRow();
drr["ChlnDate"] = "";
drr["ChlnNo"] = "";
drr["LorryNo"] = "";
drr["FromCity"] = "Total";
drr["NetAmnt"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Rows.Count;
Double TotalNetAmount = 0;
for (int i = 0; i < lstGridData.Rows.Count; i++)
{
TotalNetAmount += Convert.ToDouble(lstGridData.Rows[i]["Net_Amnt"]);
}
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Rows.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
}
else if ((dtRcptDetl != null && dtRcptDetl.Rows.Count > 0))
{
DataTable dt = new DataTable();
dt.Columns.Add("ChlnDate", typeof(string));
dt.Columns.Add("ChlnNo", typeof(string));
dt.Columns.Add("LorryNo", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("NetAmnt", typeof(string));
double TNet = 0;
for (int i = 0; i < dtRcptDetl.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr["ChlnDate"] = Convert.ToDateTime(dtRcptDetl.Rows[i]["Chln_Date"]).ToString("dd-MM-yyyy");
dr["ChlnNo"] = Convert.ToString((dtRcptDetl.Rows[i]["Chln_No"]));
dr["LorryNo"] = Convert.ToString((dtRcptDetl.Rows[i]["Lorry_No"]));
dr["FromCity"] = Convert.ToString((dtRcptDetl.Rows[i]["FromCity"]));
dr["NetAmnt"] = Convert.ToDouble((dtRcptDetl.Rows[i]["Net_Amnt"])).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble((dtRcptDetl.Rows[i]["Net_Amnt"]));
if (i == dtRcptDetl.Rows.Count - 1)
{
DataRow drr = dt.NewRow();
drr["ChlnDate"] = "";
drr["ChlnNo"] = "";
drr["LorryNo"] = "";
drr["FromCity"] = "Total";
drr["NetAmnt"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = dtRcptDetl;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + dtRcptDetl.Rows.Count;
Double TotalNetAmount = 0;
for (int i = 0; i < dtRcptDetl.Rows.Count; i++)
{
TotalNetAmount += Convert.ToDouble((dtRcptDetl.Rows[i]["Net_Amnt"]));
}
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + dtRcptDetl.Rows.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
#endregion
}
private void BindGrid()
{
if (ddlCashAc.SelectedIndex > 0)
{
dsFinal = null; OpenBal = ClBal = iPayment = iReceipt = 0; dt = null;
double db, cr, dbopbal, cropbal, totdb, totcr;
db = cr = dbopbal = cropbal = totdb = totcr = 0;
dt = new DataTable("DayBookSumRep"); DataTable dt1 = new DataTable();
DataColumn dtCol; dtCol = new DataColumn("Particular1", typeof(string));
dt.Columns.Add(dtCol); dtCol = new DataColumn("Payment", typeof(string));
dt.Columns.Add(dtCol); dtCol = new DataColumn("Particular2", typeof(string));
dt.Columns.Add(dtCol); dtCol = new DataColumn("Receipt", typeof(string));
dt.Columns.Add(dtCol);
DayBookReportDAL obj = new DayBookReportDAL();
DataColumn dtCol1 = new DataColumn("PertiDebit", typeof(string));
dt1.Columns.Add(dtCol1); dtCol1 = new DataColumn("Debit", typeof(string));
dt1.Columns.Add(dtCol1); dtCol1 = new DataColumn("PertiCredit", typeof(string));
dt1.Columns.Add(dtCol1); dtCol1 = new DataColumn("Credit", typeof(string));
dt1.Columns.Add(dtCol1);
ds.Tables.Add(dt1);
dsOuter = obj.SelectOpenPayRecWithBnk(ApplicationFunction.ConnectionString(), "SelectLdgrDetOneById", Convert.ToInt64(ddlCashAc.SelectedValue), Datefor.Text.Trim(), Convert.ToInt64(ddlDateRange.SelectedValue));
if (dsOuter != null && dsOuter.Tables.Count > 0 && dsOuter.Tables[1].Rows.Count > 0)
{
for (int x = 0; x < dsOuter.Tables[1].Rows.Count; x++)
{
dsTemp = null;
dsTemp = obj.SelectLdgrDetOne(ApplicationFunction.ConnectionString(), "SelectLdgrDetOne", Convert.ToInt64(ddlCashAc.SelectedValue), Convert.ToInt64(dsOuter.Tables[1].Rows[x]["VCHR_IDNO"]), Convert.ToInt64(ddlDateRange.SelectedValue));
if (dsTemp != null && dsTemp.Tables.Count > 0 && dsTemp.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < dsTemp.Tables[1].Rows.Count; i++)
{
if (dsTemp.Tables[1].Rows.Count > 1)
{
ds.Tables[0].Rows.Add(Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiDebit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Debit"]),
Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiCredit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Credit"]));
}
else
{
ds.Tables[0].Rows.Add(Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiDebit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Debit"]),
Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiCredit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Credit"]));
}
}
}
}
}
if (ds != null)
{
if (ds.Tables.Count > 0)
{
dsOuter.Tables[0].TableName = "OpeningBal"; ds.Tables[0].TableName = "PayRec";
if (dsOuter.Tables["OpeningBal"].Rows.Count > 0)
{
OpenBal = Convert.ToDouble(dsOuter.Tables["OpeningBal"].Rows[0][0]);
}
//if (ds.Tables["PayRec"].Rows.Count > 0)
//{
DateTime DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefor.Text.Trim().ToString()));
db = obj.SELECTCRDR(ApplicationFunction.ConnectionString(), "SELECTCRDR", 2, Convert.ToInt64(ddlCashAc.SelectedValue), Datefor.Text.Trim(), Convert.ToInt64(ddlDateRange.SelectedValue));
cr = obj.SELECTCRDR(ApplicationFunction.ConnectionString(), "SELECTCRDR", 1, Convert.ToInt64(ddlCashAc.SelectedValue), Datefor.Text.Trim(), Convert.ToInt64(ddlDateRange.SelectedValue));
dbopbal = obj.SELECTOPBAL(ApplicationFunction.ConnectionString(), "SELECTOPBAL", 2, Convert.ToInt64(ddlCashAc.SelectedValue), Convert.ToInt64(ddlDateRange.SelectedValue));
cropbal = obj.SELECTOPBAL(ApplicationFunction.ConnectionString(), "SELECTOPBAL", 1, Convert.ToInt64(ddlCashAc.SelectedValue), Convert.ToInt64(ddlDateRange.SelectedValue));
totdb = db + dbopbal; totcr = cr + cropbal;
OpenBal = totdb - totcr;
List = dt1.Clone();
DataRow drNew1 = List.NewRow();
drNew1.BeginEdit();
drNew1[0] = "Opening Balance";
if (OpenBal > 0)
{
drNew1[1] = OpenBal.ToString("N2");
}
else
{
drNew1[3] = Math.Abs(OpenBal).ToString("N2");
}
List.Rows.Add(drNew1);
DataRow drNew2 = List.NewRow();
drNew2.BeginEdit();
drNew2[0] = "";
drNew2[1] = "";
List.Rows.Add(drNew2);
DataRow drNew7 = List.NewRow();
drNew7.BeginEdit();
drNew7[0] = ""; drNew7[2] = "";
drNew7[1] = ""; drNew7[3] = "";
List.Rows.Add(drNew7);
for (int i = 3, j = 2, cnt = 0; cnt < ds.Tables["PayRec"].Rows.Count; cnt++)
{
if (Convert.ToString(ds.Tables["PayRec"].Rows[cnt][0]) != "")
{
DataRow drNew4 = List.NewRow();
drNew4.BeginEdit();
drNew4[0] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][0]);
drNew4[1] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][1]);
List.Rows.Add(drNew4);
iPayment = iPayment + Convert.ToDouble(ds.Tables["PayRec"].Rows[cnt][1]); i++;
}
else if (Convert.ToString(ds.Tables["PayRec"].Rows[cnt][2]) != "")
{
List.Rows[j][2] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][2]);
List.Rows[j][3] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][3]);
iReceipt = iReceipt + Convert.ToDouble(ds.Tables["PayRec"].Rows[cnt][3]); j++;
}
}
ClBal = (OpenBal + iReceipt) - iPayment;
DataRow drNew6 = List.NewRow();
drNew6.BeginEdit();
drNew6[0] = "Total Debit"; drNew6[2] = "Total Credit";
drNew6[1] = Convert.ToDouble(iPayment).ToString("N2"); drNew6[3] = Convert.ToDouble(iReceipt).ToString("N2");
List.Rows.Add(drNew6);
DataRow drNew5 = List.NewRow();
drNew5.BeginEdit();
drNew5[1] = "";
List.Rows.Add(drNew5);
double ClBalnew = Math.Abs(ClBal);
List.Rows[List.Rows.Count - 1][0] = "Closing Balance";
if (ClBal < 0)
{
List.Rows[List.Rows.Count - 1][1] = ClBalnew.ToString("N2");
}
else
{
List.Rows[List.Rows.Count - 1][3] = ClBalnew.ToString("N2");
}
grdMain.Width = new Unit("1065px");
//gridRowDel();
ViewState["Dt"] = List;
grdMain.DataSource = List;
grdMain.DataBind();
//lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
//lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
//lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
//}
//else
//{
// grdMain.DataSource = null;
// grdMain.DataBind();
// lblTotalRecord.Text = "T. Record (s): 0 ";
// imgBtnExcel.Visible = false;
// lblcontant.Visible = false;
// divpaging.Visible = false;
//}
}
else
{
//
}
}
}
}
private void BindGrid()
{
TripEntryOwnTohireDAL obj = new TripEntryOwnTohireDAL();
DateTime?dtfrom = null;
DateTime?dtto = null;
String challanNo = txtReceiptNo.Text;
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex <= 0) ? "0" : drpCityFrom.SelectedValue);
int TruckId = Convert.ToInt32((ddltruckNo.SelectedIndex <= 0) ? "0" : ddltruckNo.SelectedValue);
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, cityfrom, TruckId, UserIdno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("TripNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("LorryNo", typeof(string));
dt.Columns.Add("NetAmount", typeof(string));
double TNet = 0; double TAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["TripNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TripOTH_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "TripOTH_Date")).ToString("dd-MM-yyyy");
dr["LorryNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["LorryNo"] = "Total";
drr["NetAmount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
Double TotalNetAmount = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
}
lblNetAmnt.Text = TotalNetAmount.ToString("N2");
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Text = "Showing 0 - 0 of 0";
lblNetAmnt.Text = "0";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
txtTripNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.Print == false)
{
//imgBtnExcel.Visible = false;
}
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCityFrom();
}
else
{
this.BindCityFrom(Convert.ToInt64(Session["UserIdno"]));
}
drpCityFrom.SelectedValue = Convert.ToString(base.UserFromCity);
Datefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
Dateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
this.BindDateRange();
ddlDateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddlDateRange_SelectedIndexChanged(null, null);
this.BindCity();
this.BindLane();
this.bindsender();
this.BindLorry();
imgBtnExcel.Visible = false;
DateTime?dtfrom = null;
DateTime?dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int TripNo = string.IsNullOrEmpty(Convert.ToString(txtTripNo.Text)) ? 0 : Convert.ToInt32(txtTripNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text));
}
int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue);
int senderr = Convert.ToInt32(ddlSender.SelectedValue == "" ? 0 : Convert.ToInt32(ddlSender.SelectedValue));
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
//var lstGridData = obj.SelectGR(GrNo, dtfrom, dtto, cityfrom, citto, senderr, yearidno, UserIdno);
//obj = null;
//if (lstGridData != null && lstGridData.Count > 0)
//{
// lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
//}
}
}
protected void lnkbtnSearch_OnClick(object sender, EventArgs e)
{
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
if (RDbSaleBill.Checked == true)
{
if (txtSBillNo.Text == "" && ddlDivPrtyName.SelectedValue == "0")
{
DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Sale Bill Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return;
}
else
{
grdSearchRecords.Visible = true;
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
DateTime? DateFrom = null; DateTime?DateTo = null;
DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text));
DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text));
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
string SbillNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim()));
var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, SbillNo, PartyIdno, Location, intyearid);
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"));
string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "SBillDate")).ToString("dd-MM-yyyy"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
else
{
grdSearchRecords.Visible = true;
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
var lst = objClaimFrmDAL.SearchByParty(PartyIdno, Location, intyearid);
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = ""; string BillNo = "0"; string SbillIdNo = "0"; string SBillDate = "";
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
objClaimFrmDAL = null;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
DateTime?ClaimDate = null;
ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
objClaimFrmDAL = new ClaimToDAL();
DateTime CurrentDate = System.DateTime.Now;
if (grdMain.Rows.Count > 0)
{
DTMain = CreateDt();
if (rdoAgnReceived.Checked)
{
foreach (GridViewRow row in grdMain.Rows)
{
Label lblGridSerialNo = (Label)row.FindControl("lblGridSerialNo");
TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo");
DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
if (txtNewSerialNo.Text.Trim() == "")
{
ShowMessageErr("Please Fill Serial Number."); txtNewSerialNo.Focus(); return;
}
if (lblGridSerialNo.Text.Trim() == txtNewSerialNo.Text.Trim())
{
ShowMessageErr("New Serial Not same as old Serial,Check New Serial No." + txtNewSerialNo.Text.Trim() + ""); txtNewSerialNo.Focus(); return;
}
if (ddlStatus.SelectedValue == "1")
{
ShowMessageErr("Please Check Status should not be submitted."); ddlStatus.Focus(); return;
}
BindDropdownDAL obj = new BindDropdownDAL();
if (Request.QueryString["ClaimHeadIdno"] == null)
{
if (txtNewSerialNo.Text.Trim() != "")
{
Int64 Count = obj.CheckSerialNo(txtNewSerialNo.Text.Trim());
if (Count != 0)
{
ShowMessageErr("Serial Number :" + txtNewSerialNo.Text.Trim() + " already exists in stock.");
txtNewSerialNo.Focus();
return;
}
}
}
}
}
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno");
HiddenField hidClaimIdno = (HiddenField)row.FindControl("hidClaimIdno");
Label txtDefRemark = (Label)row.FindControl("lblGridDefectNo");
Label txtVchAppDetl = (Label)row.FindControl("lblGridVehDetlNo");
DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
TextBox txtRemarks = (TextBox)row.FindControl("txtRemarks");
TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo");
HiddenField HidClaimDetailsIdno = (HiddenField)row.FindControl("HidClaimDetailsIdno");
ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidClaimIdno.Value, txtDefRemark.Text.Trim(), txtVchAppDetl.Text.Trim(), ddlStatus.SelectedValue, txtRemarks.Text.Trim(), txtNewSerialNo.Text.Trim(), HidClaimDetailsIdno.Value);
}
if (rdoAgnReceived.Checked)
{
foreach (GridViewRow rows in grdMain.Rows)
{
TextBox txtNewSerialNo1 = (TextBox)rows.FindControl("txtNewSerialNo");
DataRow[] drs = DTMain.Select("NewSerialNo='" + txtNewSerialNo1.Text.Trim() + "'");
if (drs.Length > 1)
{
ShowMessageErr("Serial Number :" + txtNewSerialNo1.Text.Trim() + " already exists in list.");
txtNewSerialNo1.Focus();
return;
}
}
}
tblClaimToComHead objClaimHead = new tblClaimToComHead();
if (rdoAgnReceived.Checked)
{
if (txtClaimDate.Text == "")
{
objClaimHead.ClaimToComRec_Date = null;
}
else
{
objClaimHead.ClaimToComRec_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
}
}
else
{
if (txtClaimDate.Text == "")
{
objClaimHead.ClaimToComHead_Date = null;
}
else
{
objClaimHead.ClaimToComHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
}
}
objClaimHead.ClaimToCom_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim());
objClaimHead.ClaimHead_Idno = string.IsNullOrEmpty(Convert.ToString(HidClaimHeadIdno.Value)) ? 0 : Convert.ToInt64(HidClaimHeadIdno.Value);
objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim());
objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue);
objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue);
objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue);
Int64 Against = 0; if (rdoAgnSend.Checked)
{
Against = 1;
}
else
{
Against = 2;
}
objClaimHead.Against = Against;
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
objClaimHead.Date_Added = System.DateTime.Now;
value = objClaimFrmDAL.Insert(objClaimHead, DTMain);
objClaimFrmDAL = null;
}
else
{
objClaimHead.Date_Modified = System.DateTime.Now;
lnkbtnNew.Visible = false;
if (rdoAgnReceived.Checked)
{
value = objClaimFrmDAL.UpdateForRecvd(objClaimHead, Convert.ToInt32(hidid.Value), DTMain);
}
else
{
value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(hidid.Value), DTMain);
}
objClaimFrmDAL = null;
}
if (string.IsNullOrEmpty(hidid.Value) == false)
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not Update");
tScope.Dispose();
}
}
else
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record saved Successfully ");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not saved Successfully ");
tScope.Dispose();
}
}
}
}
else
{
ShowMessageErr("Please Search and Select Serial Number.");
return;
}
}
private void BindGrid()
{
try
{
DateTime?dtDateFrom = null;
DateTime?dtDateTo = null;
if (string.IsNullOrEmpty(txtDateFrom.Text.Trim()) == false)
{
dtDateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text.Trim()));
}
if (string.IsNullOrEmpty(txtDateTo.Text.Trim()) == false)
{
dtDateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim()));
}
TruckwiseRepDAL obj = new TruckwiseRepDAL();
DataTable DsGrdetail = new DataTable();
var detail = obj.SearchLorry(txtLorryNo.Text, dtDateFrom, dtDateTo, Convert.ToInt32(ddllorryType.SelectedValue), Convert.ToInt32(ddlReptype.SelectedValue));
if (detail != null && detail.Count > 0)
{
DsGrdetail = CreateDt();
ViewState["dt"] = DsGrdetail;
if (ViewState["dt"] != null)
{
for (int i = 0; i < detail.Count; i++)
{
ApplicationFunction.DatatableAddRow(DsGrdetail,
Convert.ToString(DataBinder.Eval(detail[i], "Lorry_No")),
Convert.ToDateTime(DataBinder.Eval(detail[i], "LicDate")).ToString("dd-MM-yyyy"),
Convert.ToDateTime(DataBinder.Eval(detail[i], "RC")).ToString("dd-MM-yyyy"),
Convert.ToDateTime(DataBinder.Eval(detail[i], "FitDate")).ToString("dd-MM-yyyy"),
Convert.ToDateTime(DataBinder.Eval(detail[i], "Insurance")).ToString("dd-MM-yyyy")
);
}
}
if (detail != null && detail.Count > 0)
{
ViewState["dt"] = DsGrdetail;
rows = detail.Count;
grdMain.DataSource = detail;
grdMain.DataBind();
imgBtnExcel.Visible = true;
lblTotalRecord.Text = string.Empty;
if (Convert.ToInt32(ddlReptype.SelectedValue) == 1)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = true;
grdMain.Columns[3].Visible = true;
grdMain.Columns[4].Visible = true;
grdMain.Columns[5].Visible = true;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 2)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = true;
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = false;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 3)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = false;
grdMain.Columns[3].Visible = true;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = false;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 4)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = false;
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = true;
grdMain.Columns[5].Visible = false;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 5)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = false;
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = true;
}
if (detail.Count <= 0)
{
lblTotalRecord.Text = "T. Record(s): 0";
imgBtnExcel.Visible = false;
}
else
{
lblTotalRecord.Text = "T. Record(s): " + rows;
imgBtnExcel.Visible = true;
}
}
else
{
lblTotalRecord.Text = "T. Record(s): 0";
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
else
{
lblTotalRecord.Text = "T. Record(s): 0";
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnkbtnEdit = (LinkButton)e.Row.FindControl("lnkbtnEdit");
base.CheckUserRights(intFormId);
if (base.Edit == false)
{
lnkbtnEdit.Visible = true;
grdMain.Columns[7].Visible = true;
}
else
{
lnkbtnEdit.Visible = true;
grdMain.Columns[7].Visible = true;
}
string sBankDate = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Bank_Date"));
DateTime BankDate = new DateTime();
if (string.IsNullOrEmpty(sBankDate) == false)
{
BankDate = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Bank_Date"));
}
DateTime ToDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim()));
if (Convert.ToDateTime(BankDate).ToString("dd-MM-yyyy") == "01-01-0001" || Convert.ToDateTime(BankDate).ToString("dd-MM-yyyy") == "01-01-1900" || (BankDate > ToDate))
{
Amount1 = Math.Round((Amount1 + (string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Debit"))) ? 0 : Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Debit")))), 2);
Amount2 = Math.Round((Amount2 + (string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Credit"))) ? 0 : Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Credit")))), 2);
if ((ddlBankDate.SelectedItem.Text.ToUpper()) == "YES")
{
e.Row.Visible = false;
}
}
else if ((ddlBankDate.SelectedItem.Text.ToUpper()) == "NO")
{
e.Row.Visible = false;
}
Amount3 = Math.Round(Amount3 + (string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Debit"))) ? 0 : Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Debit"))), 2);
Amount4 = Math.Round(Amount4 + (string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Credit"))) ? 0 : Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Credit"))), 2);
lblNetBalance2.Text = String.Format("{0:0,0.00}", Amount1).ToString() + " Dr. - " + String.Format("{0:0,0.00}", Amount2).ToString() + " Cr. ";
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblAmount1 = (Label)e.Row.FindControl("lblAmount1");
lblAmount1.Text = String.Format("{0:0,0.00}", Amount3).ToString();
Label lblAmount2 = (Label)e.Row.FindControl("lblAmount2");
lblAmount2.Text = String.Format("{0:0,0.00}", Amount4).ToString();
double closingBalDr = 0;
double closingBalCr = 0;
double BankBalanceDR = (Amount3 - Amount1);
double BankBalanceCR = (Amount4 - Amount2);
if (lblOpeningBalance2.Text.ToUpper().Contains("DR"))
{
closingBalDr = Amount3 + Convert.ToDouble(lblOpeningBalance2.Text.ToUpper().Replace("DR.", "").ToString());
closingBalCr = Amount4;
BankBalanceDR = BankBalanceDR + Convert.ToDouble(lblOpeningBalance2.Text.ToUpper().Replace("DR.", "").ToString());
}
else
{
closingBalCr = Amount4 + Convert.ToDouble(lblOpeningBalance2.Text.ToUpper().Replace("CR.", "").ToString());
closingBalDr = Amount3;
BankBalanceCR = BankBalanceCR + Convert.ToDouble(lblOpeningBalance2.Text.ToUpper().Replace("CR.", "").ToString());
}
//Balance as per company books
if (closingBalDr > closingBalCr)
{
lblClosingBalance2.Text = String.Format("{0:0,0.00}", closingBalDr - closingBalCr) + "Dr.";
}
else
{
lblClosingBalance2.Text = String.Format("{0:0,0.00}", closingBalCr - closingBalDr) + "Cr.";
}
//Balance as per bank
if (BankBalanceDR > BankBalanceCR)
{
lblBankBalance2.Text = String.Format("{0:0,0.00}", Math.Abs((BankBalanceDR - BankBalanceCR)), 2).ToString() + " Dr.";
}
else
{
lblBankBalance2.Text = String.Format("{0:0,0.00}", Math.Abs((BankBalanceCR - BankBalanceDR)), 2).ToString() + " Cr.";
}
}
}
//private DataTable CreateOpeningBalance(string conString, string strDateFrom, string strDateTo, int intyearIdno)
//{
// AccountBookDAL objAccBookDAL11 = new AccountBookDAL();
// DataTable ds11 = new DataTable();
// hidstr.Value = "";
// //if (ddlParty.SelectedValue.Count() > 0)
// if (ddlParty.Items.Count > 1)
// {
// if (ddlParty.SelectedIndex == 0)
// {
// for (int count = 1; count <= ddlParty.Items.Count - 1; count++)
// {
// hidstr.Value = ddlParty.Items[count].Value + "," + hidstr.Value;
// }
// }
// else
// {
// hidstr.Value = ddlParty.SelectedValue + ",";
// }
// if (hidstr.Value != "" && Convert.ToString(hidstr.Value).Length > 1)
// {
// hidstr.Value = hidstr.Value.Substring(0, hidstr.Value.Length - 1);
// }
// string[] Arr = Convert.ToString(hidstr.Value).Split(new char[] { ',' });
// foreach (string I in Arr)
// {
// DataTable dtOutput = objAccBookDAL11.OpeningBalGrid(ApplicationFunction.ConnectionString(), "OpeningBalGrdyr", strDateFrom, strDateTo, intyearIdno, Convert.ToInt64(I));
// if (dtOutput != null && dtOutput.Rows.Count > 0)
// {
// if (ds11 == null || ds11.Rows.Count == 0)
// {
// ds11.Merge(dtOutput);
// }
// else
// {
// ds11.Merge(dtOutput);
// }
// }
// }
// }
// return ds11;
//}
#endregion
#region Grid Events...
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "cmdshowdetail")
{
#region Ledger Account
string OpeningBal = "0";
DataTable DtLedger = ConvertToDatatable();
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent;
int PreviousRow = row.RowIndex - 1;
LinkButton lnkBtnParticular = (LinkButton)row.FindControl("lnkBtnParticular");
//if (lnkBtnParticular.Text == "April")
//{
// Label lblDebitOP = (Label)grdMain.Rows[PreviousRow].FindControl("lbl2Debit");
// Label lblCreditOP = (Label)grdMain.Rows[PreviousRow].FindControl("lbl3Credit");
// Double DebitOP = Convert.ToDouble(lblDebitOP.Text.Trim());
// Double CreditOP = Convert.ToDouble(lblCreditOP.Text.Trim());
// if (DebitOP > CreditOP)
// {
// OpeningBal = lblDebitOP.Text + " Dr";
// }
// else
// {
// OpeningBal = lblCreditOP.Text + " Cr";
// }
//}
//else
//{
// Label lbl4Balance = (Label)grdMain.Rows[PreviousRow].FindControl("lbl4Balance");
// OpeningBal = lbl4Balance.Text;
//}
int monthNo = 0;
if (OpeningBal.ToLower() != "april")
{
monthNo = ApplicationFunction.monthNo(lnkBtnParticular.Text.Trim());
}
int year = 0;
if (monthNo > 3 && monthNo <= 12)
{
year = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Convert.ToString(Session["StartDate"]))).Year;
}
else
{
year = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Convert.ToString(Session["StartDate"]))).Year + 1;
}
string startDate = Convert.ToString("01-" + monthNo + "-" + year); //dd-MM-yyyy
string endDate = Convert.ToString(DateTime.DaysInMonth(year, monthNo) + "-" + monthNo + "-" + year); //dd-MM-yyyy
Int64 TruckIdno = Convert.ToInt64(Session["TruckIdno"]);
string TruckNo = Convert.ToString(Session["TruckNo"]);
Session["TruckNo"] = TruckNo;
// string PartyName = TruckNo.Replace("&", " ");
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alertpopup", "ShowPopup('" + startDate + "','" + endDate + "','" + partyId + "','" + OpeningBal + "','" + PartyName + "')", true);
Response.Redirect("CostVchrDetail.aspx?startdate=" + startDate + "&enddate=" + endDate + "&TruckIdno=" + TruckIdno + "&TruckNo=" + TruckNo);
#endregion
}
else if (e.CommandName == "cmdshowdetail1D")
{
#region Ledger Year Wise Details...
string StartDate = Convert.ToString(Convert.ToString(Session["StartDate"]));
string EndDate = Convert.ToString(Session["EndDate"]);
string FrmType = "LdgrAll";
Int64 TruckIdno = Convert.ToInt64(Session["TruckIdno"]);
string TruckNo = Convert.ToString(Session["TruckNo"]);
Session["TruckNo"] = TruckNo;
Response.Redirect("CostVchrDetail.aspx?startdate=" + StartDate + "&enddate=" + EndDate + "&TruckIdno=" + TruckIdno + "&FrmType=" + FrmType + "&TruckNo=" + TruckNo);
#endregion
}
}
private void BindGrid()
{
SaleRegDAL obj = new SaleRegDAL();
DateTime? datefromValue = null;
DateTime? dateToValue = null;
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
datefromValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtDateTo.Text)) == false)
{
dateToValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text));
}
Int32 intYearIdno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue);
Int32 intLoc = string.IsNullOrEmpty(Convert.ToString(drpCityFrom.SelectedValue)) ? 0 : Convert.ToInt32(drpCityFrom.SelectedValue);
Int32 intSaletype = string.IsNullOrEmpty(Convert.ToString(ddlSaleType.SelectedValue)) ? 0 : Convert.ToInt32(ddlSaleType.SelectedValue);
int intBillNo = string.IsNullOrEmpty(Convert.ToString(txtBillNo.Text.Trim())) ? 0 : Convert.ToInt32(txtBillNo.Text.Trim());
Int32 intPartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlPartyName.SelectedValue)) ? 0 : Convert.ToInt32(ddlPartyName.SelectedValue);
string strPerfNo = string.IsNullOrEmpty(Convert.ToString(txtPerfNo.Text.Trim())) ? "" : Convert.ToString(txtPerfNo.Text.Trim());
Int32 intAgainst = string.IsNullOrEmpty(Convert.ToString(ddlAgainst.SelectedValue)) ? 0 : Convert.ToInt32(ddlAgainst.SelectedValue);
var lstGridData = obj.SelectSBillReg(intYearIdno, datefromValue, dateToValue, intLoc, intSaletype, strPerfNo, intBillNo, intPartyIdno, intAgainst);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("PerfNo", typeof(string));
dt.Columns.Add("BillNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("BillType", typeof(string));
dt.Columns.Add("Against", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("Location", typeof(string));
dt.Columns.Add("TotTaxable", typeof(string));
dt.Columns.Add("TotTax", typeof(string));
dt.Columns.Add("DiscAmnt", typeof(string));
dt.Columns.Add("OtherAmnt", typeof(string));
dt.Columns.Add("NetAmnt", typeof(string));
double TNet = 0; double TTax = 0; double TTaxable = 0; double TDisc = 0; double TOther = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["PerfNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "PrefNo"));
dr["BillNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "SbillNo"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Date")).ToString("dd-MM-yyyy");
dr["BillType"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "SbillType"));
dr["Against"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Against"));
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "PartyName"));
dr["Location"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromLocation"));
dr["TotTaxable"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TotTaxableAmnt"));
dr["TotTax"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TotTax"));
dr["DiscAmnt"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DiscAmnt"));
dr["OtherAmnt"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "OtherAmnt"));
dr["NetAmnt"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "NetAmnt"));
dt.Rows.Add(dr);
TTaxable += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "TotTax"));
TTax += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "TotTax"));
TDisc += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "DiscAmnt"));
TOther += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "OtherAmnt"));
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "NetAmnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Party"] = "Total";
drr["TotTaxable"] = (TTaxable).ToString("N2");
drr["TotTax"] = (TTax).ToString("N2");
drr["DiscAmnt"] = (TDisc).ToString("N2");
drr["OtherAmnt"] = (TOther).ToString("N2");
drr["NetAmnt"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
}
}
private void BindGrid()
{
RcvdAmntAgnstInvcDAL obj = new RcvdAmntAgnstInvcDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
String InvoiceNo = txtRcptNo.Text;
if (string.IsNullOrEmpty(Convert.ToString(txtInvcDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInvcDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtInvcDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInvcDateto.Text));
}
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), InvoiceNo, dtfrom, dtto, Convert.ToInt32(ddlFromCity.SelectedValue == null ? "0" : ddlFromCity.SelectedValue));
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("InvoiceNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("Sender", typeof(string));
dt.Columns.Add("NetAmount", typeof(string));
double TNet = 0; double TAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["InvoiceNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Rcpt_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Inv_Date")).ToString("dd-MM-yyyy");
dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity"));
dr["Sender"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "SenderName"));
dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Sender"] = "Total";
drr["NetAmount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
Double TotalNetAmount = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
}
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
private void BindGrid()
{
ChlnBookingDAL obj = new ChlnBookingDAL();
DataTable list = null;
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
Int64 ITruckId = (ddlTruckNo.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlTruckNo.SelectedValue));
Int64 ITruckType = Convert.ToInt64(ddllorrytype.SelectedValue);
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
Query += " AND BaseCity_Idno in (select FrmCity_Idno from tblfrmcitydetl where User_Idno= " + Convert.ToInt64(Session["UserIdno"]) + ")";
}
if (txtDateFrom.Text != "")
{
Query += " AND CONVERT(DATE,Chln_Date)>='" + Convert.ToDateTime(txtDateFrom.Text.Trim(), cul).ToString("yyyy-MM-dd") + "'";
// Query += " AND CONVERT(DATETIME,Chln_Date,105) >='" + Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text))+"'";
}
if (txtDateTo.Text != "")
{
Query += " AND CONVERT(DATE,Chln_Date)<='" + Convert.ToDateTime(txtDateTo.Text.Trim(), cul).ToString("yyyy-MM-dd") + "'";
//Query += " AND CONVERT(DATETIME,Chln_Date,105) <='" + Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)) + "'";
}
if (Convert.ToInt32(drpBaseCity.SelectedValue) > 0)
{
Query += " AND BaseCity_Idno=" + Convert.ToInt32(drpBaseCity.SelectedValue);
}
if (Convert.ToInt64(ddlTruckNo.SelectedValue) > 0)
{
Query += " AND Truck_Idno=" + Convert.ToInt64(ddlTruckNo.SelectedValue);
}
if (Convert.ToInt64(ddllorrytype.SelectedValue) != 2)
{
Query += " AND Lorry_Type=" + Convert.ToInt64(ddllorrytype.SelectedValue);
}
if (Convert.ToInt64(ddlDestination.SelectedValue) > 0)
{
Query += " AND GH.DelvryPlce_Idno=" + Convert.ToInt64(ddlDestination.SelectedValue);
}
if (ddlReportType.SelectedValue == "0")
{
list = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iFromCityIDNO, ITruckId, ITruckType, UserIdno, Convert.ToInt64(ddlPartyName.SelectedValue), Convert.ToInt64(ddlDestination.SelectedValue), conString);
}
if (ddlReportType.SelectedValue == "1")
{
list = obj.SelectChlnGrWiseRep("SelectRepGRWise", Query, conString);
}
if ((list != null) && (list.Rows.Count > 0))
{
ViewState["CSVdt"] = list;
//// CALC Footer OF GRID
Amount = Amount + Convert.ToDouble(list.Compute("SUM(Adv_Amnt)", ""));
TDSAmnt = TDSAmnt + Convert.ToDouble(list.Compute("SUM(TDS_Amnt)", ""));
GrossAmnt = GrossAmnt + Convert.ToDouble(list.Compute("SUM(Gross_Amnt)", ""));
NetAmnt = NetAmnt + Convert.ToDouble(list.Compute("SUM(Net_Amnt)", ""));
Weight = Weight + Convert.ToDouble(list.Compute("SUM(Tot_Weight)", ""));
ShrtQty = ShrtQty + Convert.ToDouble((list.Compute("SUM(Shortage_Qty)", "")) is DBNull ? 0 : (list.Compute("SUM(Shortage_Qty)", "")));
Comm = Comm + Convert.ToDouble(list.Compute("SUM(Comm_Amnt)", ""));
Dieselamnt = Dieselamnt + Convert.ToDouble(list.Compute("SUM(Diesel_Amnt)", ""));
ShrtAmnt = ShrtAmnt + Convert.ToDouble((list.Compute("SUM(Shortage_Amount)", "")) is DBNull ? 0 : (list.Compute("SUM(Shortage_Amount)", "")));
grdMain.DataSource = list;
grdMain.DataBind();
if (ddlReportType.SelectedValue == "0")
{
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = false;
grdMain.Columns[12].Visible = false;
grdMain.Columns[11].Visible = false;
grdMain.Columns[15].Visible = false;
}
else
{
grdMain.Columns[3].Visible = true;
grdMain.Columns[4].Visible = true;
grdMain.Columns[5].Visible = true;
grdMain.Columns[12].Visible = true;
grdMain.Columns[11].Visible = true;
grdMain.Columns[15].Visible = true;
}
if (CheckBox1.Checked)
{
grdMain.Columns[16].Visible = true;
var test3 = grdMain.Columns[11].ToString();
}
else
{
grdMain.Columns[16].Visible = false;
}
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
imgBtnExcel.Visible = true;
lnkbtnPrint.Visible = true;
lblTotalRecord.Text = "T. Record (s): " + list.Rows.Count;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lnkbtnPrint.Visible = false;
imgBtnExcel.Visible = false;
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
if (drpBaseCity.SelectedValue == "0")
{
ShowMessageErr("Please Select Location!");
return;
}
if (ddlPartyName.SelectedValue == "0")
{
ShowMessageErr("Please Select Party!");
return;
}
if (ddlItemName.SelectedValue == "0")
{
ShowMessageErr("Please Select Item!");
return;
}
if (ddlCityVia.SelectedValue == "0")
{
ShowMessageErr("Please Select To Via City!");
return;
}
if (ddlCity.SelectedValue == "0")
{
ShowMessageErr("Please Select To City!");
return;
}
if (Convert.ToDouble(txt_Weight.Text) <= 0.00 && IsWeight == true)
{
ShowMessageErr("Please Enter Weight More than 0!");
return;
}
Int64 empIdno = Convert.ToInt64((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
tblPartyRateRetailerMast obj = new tblPartyRateRetailerMast();
obj.Loc_Idno = Convert.ToInt64(drpBaseCity.SelectedValue);
obj.Party_Idno = Convert.ToInt64(ddlPartyName.SelectedValue);
obj.Item_Idno = Convert.ToInt64(ddlItemName.SelectedValue);
obj.Rate_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text.Trim()).ToString());
obj.FrmCity_Idno = Convert.ToInt64(ddlCityVia.SelectedValue);
obj.ToCity_Idno = Convert.ToInt64(ddlCity.SelectedValue);
obj.Item_Rate = Convert.ToDecimal(txtItemRate.Text.Trim());
obj.Emp_Idno = empIdno;
obj.Date_Added = Convert.ToDateTime(DateTime.Now);
obj.Date_Modified = Convert.ToDateTime(DateTime.Now);
obj.Status = true;
obj.Year_idno = Convert.ToInt32(ddlDateRange.SelectedValue);
obj.TranType_Idno = Convert.ToInt64(ddlTranType.SelectedValue);
obj.Tran_Type = Convert.ToString(ddlTranType.SelectedItem.Text);
RateMasterRetailerDAL RM = new RateMasterRetailerDAL();
if (IsWeight == false)
{ // For Without Weight Wise
obj.Item_Weight = 0;
obj.IsWeight = false;
}
else
{
obj.Item_Weight = Convert.ToDecimal(txt_Weight.Text);
obj.IsWeight = true;
}
if ((hidSaveType.Value != "") && (Convert.ToInt64(hidSaveType.Value)) > 0)
{
int value = RM.UpdatePartyItemRate(obj, Convert.ToInt64(Convert.ToInt64(hidSaveType.Value)));
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Updated Successfully");
}
else if (value == 2)
{
BindGrid();
ShowMessageErr("Record Already Exists!");
}
else
{
BindGrid();
ShowMessageErr("Record Not Updated!");
}
}
else
{
int value = RM.InsertPartyItemRate(obj);
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Inserted Successfully");
}
else if (value == 2)
{
BindGrid();
Clear();
ShowMessageErr("Record Already Exists!");
}
else
{
BindGrid();
Clear();
ShowMessageErr("Record Not Inserted!");
}
}
}
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"]);
}
Int64 ITruckType = Convert.ToInt64(ddllorrytype.SelectedValue);
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
Int64 ITruckId = (ddlTruckNo.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlTruckNo.SelectedValue));
ChlnBookingDAL obj = new ChlnBookingDAL();
DataTable list1 = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iFromCityIDNO, ITruckId, ITruckType, UserIdno, string.IsNullOrEmpty(ddlPartyName.SelectedValue) ? 0 : Convert.ToInt64(ddlPartyName.SelectedValue), Convert.ToInt64(ddlDestination.SelectedValue), conString);
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void BindGrid()
{
TyreStockRpt obj = new TyreStockRpt();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 ItemIdno = Convert.ToInt64(ddlItemName.SelectedValue);
//string serialNo = txtSerialNo.Text.Trim();
Int32 tyreType = string.IsNullOrEmpty(Convert.ToString(ddlTyreType.SelectedValue)) ? 0 : Convert.ToInt32(ddlTyreType.SelectedValue);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text));
}
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
DataTable dt = obj.SelectTyreStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, ItemIdno, tyreType, Convert.ToInt64(ddlLocation.SelectedValue));
obj = null;
if (dt != null && dt.Rows.Count > 0)
{
Double TotalIssue = 0, TotalOpening = 0, TotalPur = 0, TotSale = 0, Total = 0, TotalBal = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
TotalOpening += Convert.ToDouble(dt.Rows[i]["OPN"]);
TotalPur += Convert.ToDouble(dt.Rows[i]["PB"]);
TotalIssue += Convert.ToDouble(dt.Rows[i]["ISSUED"]);
TotSale += Convert.ToDouble(dt.Rows[i]["SB"]);
Total += Convert.ToDouble(dt.Rows[i]["TTL"]);
TotalBal += Convert.ToDouble(dt.Rows[i]["BAL"]);
}
lblTotOpening.Text = TotalOpening.ToString();
lblTotPur.Text = TotalPur.ToString();
lblTotSale.Text = TotSale.ToString();
lblTotal.Text = Total.ToString();
lblTotIssue.Text = TotalIssue.ToString();
lblBalance.Text = TotalBal.ToString();
lblTotRecv.Text = Convert.ToString(dt.Compute("Sum(RECV)", ""));
lblTotTran.Text = Convert.ToString(dt.Compute("Sum(TRAN)", ""));
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = dt;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record(s): " + dt.Rows.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + dt.Rows.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record(s): 0 ";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
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"]);
}
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
Int64 iSenderIDNO = (ddlSender.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlSender.SelectedValue));
Int64 GrNO = string.IsNullOrEmpty(txtGrNo.Text.Trim()) ? 0 : Convert.ToInt64(txtGrNo.Text.Trim());
GRRetailerRepDAL obj = new GRRetailerRepDAL();
DataTable list1 = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iFromCityIDNO,
iSenderIDNO, GrNO, conString);
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void SetDate()
{
if (ddldateRange.SelectedIndex != -1)
{
Int32 intyearid = Convert.ToInt32(ddldateRange.SelectedValue);
FinYearDAL objDAL = new FinYearDAL();
var lst = objDAL.FilldateFromTo(intyearid);
hidmindate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "StartDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "StartDate")).ToString("dd-MM-yyyy"));
hidmaxdate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "EndDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "EndDate")).ToString("dd-MM-yyyy"));
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmaxdate.Value)) >= DateTime.Now.Date && DateTime.Now.Date >= Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmindate.Value)))
{
BindDropdownDAL obj = new BindDropdownDAL();
Array list = obj.BindDate();
txtReceiptDatefrom.Text = Convert.ToString(list.GetValue(0));
txtReceiptDateto.Text = Convert.ToString(list.GetValue(1));
}
else
{
txtReceiptDatefrom.Text = Convert.ToString(hidmindate.Value);
txtReceiptDateto.Text = Convert.ToString(hidmaxdate.Value);
}
}
}
private void BindGrid()
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 Lane_Idno = Convert.ToInt64(ddlLane.SelectedValue);
Int64 lorry_Idno = Convert.ToInt64(ddlLorry_No.SelectedValue);
int TripNo = string.IsNullOrEmpty(Convert.ToString(txtTripNo.Text)) ? 0 : Convert.ToInt32(txtTripNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text));
}
int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue);
int sender = Convert.ToInt32(ddlSender.SelectedValue == "" ? 0 : Convert.ToInt32(ddlSender.SelectedValue));
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
var lstGridData = obj.SelectTrip(TripNo, dtfrom, dtto, cityfrom, sender, yearidno, Lane_Idno, lorry_Idno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("Trip No.", typeof(string));
dt.Columns.Add("Pref No.", typeof(string));
dt.Columns.Add("Trip_Date", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("City", typeof(string));
dt.Columns.Add("Truck No", typeof(string));
dt.Columns.Add("Driver", typeof(string));
dt.Columns.Add("Driver No", typeof(string));
dt.Columns.Add("Vehicle Size", typeof(string));
dt.Columns.Add("StartKm", typeof(string));
dt.Columns.Add("EndKm", typeof(string));
dt.Columns.Add("Total KM", typeof(string));
dt.Columns.Add("Qty", typeof(string));
dt.Columns.Add("Lane", typeof(string));
dt.Columns.Add("DSL_Card_Name", typeof(string));
dt.Columns.Add("DSL_Card_Number", typeof(string));
dt.Columns.Add("DSL_Qty", typeof(string));
dt.Columns.Add("DSL_Rate", typeof(string));
dt.Columns.Add("DSL_Amt", typeof(string));
dt.Columns.Add("DSL_Card_Amt", typeof(string));
dt.Columns.Add("Total_DSL_Qty", typeof(string));
dt.Columns.Add("Total_DSL_Amt", typeof(string));
dt.Columns.Add("Milage", typeof(string));
dt.Columns.Add("Cash", typeof(string));
dt.Columns.Add("Toll", typeof(string));
dt.Columns.Add("Wages", typeof(string));
dt.Columns.Add("Food_Exp", typeof(string));
dt.Columns.Add("Repair", typeof(string));
dt.Columns.Add("Adv_in_Driver", typeof(string));
dt.Columns.Add("Other", typeof(string));
dt.Columns.Add("Net Amount", typeof(string));
dt.Columns.Add("Remark", typeof(string));
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Trip No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Trip_Idno"));
dr["Trip_Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Trip_Date")).ToString("dd-MM-yyyy");;
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["City"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "City_Name"));
dr["Truck No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Driver_Name"));
dr["StartKm"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "StartKms"));
dr["EndKm"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "EndKms"));
dr["Total KM"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TotalKms"));
dr["Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Quantity"));
dr["Lane"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lane_Name"));
dr["Pref No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Pref_No"));
dr["Driver No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Driver_No"));
dr["Vehicle Size"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Vehicle_Size"));
dr["DSL_Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Qty"));
dr["DSL_Rate"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Rate"));
dr["DSL_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "DSL_Amt")).ToString("N2");
dr["DSL_Card_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "DSL_Card_Amt")).ToString("N2");
dr["DSL_Card_Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Name"));
dr["DSL_Card_Number"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Number"));
dr["Total_DSL_Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Total_DSL_Qty"));
dr["Total_DSL_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "Total_DSL_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "Total_DSL_Amt")).ToString("N2");
dr["Cash"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Cash"));
dr["Toll"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Toll"));
dr["Wages"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Wages"));
dr["Food_Exp"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Food_Exp"));
dr["Repair"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Repair"));
dr["Adv_in_Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Adv_in_Driver"));
dr["Other"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Other"));
dr["Milage"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Milage"));
dr["Net Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Total_Amt")).ToString("N2");
dr["Remark"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Remark"));
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
