private void BindGrid()
{
ChallanDelverdDAL obj = new ChallanDelverdDAL();
Int32 iTocityIdno = (drpToCity.SelectedIndex <= 0 ? 0 : Convert.ToInt32(drpToCity.SelectedValue));
string UserClass = Convert.ToString(Session["Userclass"]);
Int32 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt32(Session["UserIdno"]);
}
DataSet DsDetl = obj.SearchDelevryRegisterReport(Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)),
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iTocityIdno, Convert.ToInt32(ddlDateRange.SelectedValue), UserIdno, ApplicationFunction.ConnectionString());
if ((DsDetl != null) && (DsDetl.Tables[0].Rows.Count > 0))
{
Double TotalNetAmountLocGRAmnt = 0;
Double TotalNetAmountCrsngGRAmnt = 0;
Double TotalNetAmount = 0;
for (int i = 0; i < DsDetl.Tables[0].Rows.Count; i++)
{
TotalNetAmountLocGRAmnt += Convert.ToDouble(DsDetl.Tables[0].Rows[i]["LocGR_Amnt"]);
TotalNetAmountCrsngGRAmnt += Convert.ToDouble(DsDetl.Tables[0].Rows[i]["CrsngGR_Amnt"]);
TotalNetAmount += Convert.ToDouble(DsDetl.Tables[0].Rows[i]["Net_Amnt"]);
}
lblNetTotalAmountLocGRAmnt.Text = TotalNetAmountLocGRAmnt.ToString("N2");
lblNetTotalAmountCrsngGRAmnt.Text = TotalNetAmountCrsngGRAmnt.ToString("N2");
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
ViewState["CSVdt"] = DsDetl.Tables[0];
grdMain.DataSource = DsDetl.Tables[0];
grdMain.DataBind();
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "Total Record (s): " + DsDetl.Tables[0].Rows.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsDetl.Tables[0].Rows.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
lblTotalRecord.Text = "Total Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
