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"]); } TyreStockRpt obj = new TyreStockRpt(); Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedIndex); DataTable list1 = obj.SelectTyreStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), 0, Convert.ToInt64(0), 0, Convert.ToInt64(ddlLocation.SelectedValue)); 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; } }