private void TotalRecordCount() { 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) { lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count.ToString(); } else { lblTotalRecord.Text = "T. Record (s): 0 "; } }
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; } }