private void BindGrid()
{
DispatchRegDAL obj = new DispatchRegDAL();
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
DataTable list = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)),
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iFromCityIDNO, Convert.ToInt64(ddllorrytype.SelectedValue), Convert.ToInt64(ddlDestination.SelectedValue), conString);
DataRow drw = list.NewRow();
if ((list != null) && (list.Rows.Count > 0))
{
CalculateTotal(list);
grdMain.DataSource = list;
grdMain.DataBind();
drw["OwnerName"] = "Total";
drw["Tot_Weght"] = TotalWeight;
drw["Amount"] = GrossAmnt;
drw["Adv_Amnt"] = SurChrgeAmnt;
drw["Commsn_Amnt"] = Commssion;
drw["Net_Amnt"] = Total;
list.Rows.Add(drw);
ViewState["CSVdt"] = list;
Double TotalNetAmount = 0, TotGrossAmnt = 0, TotSurcharge = 0, TotWages = 0, TotServTax = 0;
for (int i = 0; i < list.Rows.Count; i++)
{
//TotGrossAmnt += Convert.ToDouble(list.Rows[i]["Gross_Amnt"]);
//TotSurcharge += Convert.ToDouble(list.Rows[i]["Surcrg_Amnt"]);
//TotWages += Convert.ToDouble(list.Rows[i]["Wages_Amnt"]);
//TotServTax += Convert.ToDouble(list.Rows[i]["ServTax_Amnt"]);
//TotalNetAmount += Convert.ToDouble(list.Rows[i]["Net_Amnt"]);
}
//lblGrossAmnt.Text = TotGrossAmnt.ToString("N2");
//lblSurcharge.Text = TotSurcharge.ToString("N2");
//lblWages.Text = TotWages.ToString("N2");
//lblServtax.Text = TotServTax.ToString("N2");
//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 " + list.Rows.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
lblTotalRecord.Text = "T. Record (s): " + list.Rows.Count;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
