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; } }