// string con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString; #endregion #region Page Load... protected void Page_Load(object sender, EventArgs e) { if (Request.UrlReferrer == null) { base.AutoRedirect(); } txtRcptNo.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);"); txtGrDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtGrDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);"); if (!Page.IsPostBack) { this.BindDateRange(); ddldateRange.SelectedIndex = 0; ddldateRange_SelectedIndexChanged(null, null); this.BindCity(); RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text); if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text)); } int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex != -1) ? "0" : drpCityFrom.SelectedValue); var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom); obj = null; if (lstGridData != null && lstGridData.Count > 0) { lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count; } } }
private void BindGrid() { RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text); if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text)); } int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex == 0) ? "0" : drpCityFrom.SelectedValue); var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom); obj = null; if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("SrNo", typeof(string)); dt.Columns.Add("RecpNo", typeof(string)); dt.Columns.Add("Date", typeof(string)); dt.Columns.Add("FromCity", typeof(string)); dt.Columns.Add("Party", 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["RecpNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Rcpt_No")); dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Rcpt_date")).ToString("dd-MM-yyyy"); dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity")); dr["Party"] = 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["Party"] = "Total"; drr["NetAmount"] = (TNet).ToString("N2"); dt.Rows.Add(drr); lblNetTotalAmount.Text = TNet.ToString("N2"); } } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } // grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "Total Record (s): " + lstGridData.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 " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "Total Record (s): 0 "; divpaging.Visible = false; imgBtnExcel.Visible = false; } }