private void BindItemName() { AccessoryStockRpt obj = new AccessoryStockRpt(); var itmName = obj.BindActiveItemName(); ddlItemName.DataSource = itmName; ddlItemName.DataTextField = "Item_name"; ddlItemName.DataValueField = "Item_idno"; ddlItemName.DataBind(); ddlItemName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); }
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"]); } AccessoryStockRpt obj = new AccessoryStockRpt(); Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedIndex); //DataTable list1 = obj.SelectAccStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, Convert.ToInt64(ddlItemName.SelectedValue), 2, Convert.ToInt64(ddlLocation.SelectedValue)); //lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count); } }
private void BindGrid() { AccessoryStockRpt obj = new AccessoryStockRpt(); DateTime? dtfrom = null; DateTime? dtto = null; string strchkDetlValue = string.Empty; Int64 ItemIdno = Convert.ToInt64(ddlItemName.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)); if (ddlItemName.SelectedValue != "0") { DataTable dt = obj.SelectAccStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, Convert.ToString(ddlItemName.SelectedValue), 2, Convert.ToInt64(ddlLocation.SelectedValue)); } else { DataTable grdGrdetals = obj.FetchItemIDno(ApplicationFunction.ConnectionString()); if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0)) { string strchkValue = string.Empty; string sAllItemIdnos = string.Empty; for (int count = 0; count < grdGrdetals.Rows.Count; count++) { strchkDetlValue = strchkDetlValue + grdGrdetals.Rows[count]["ITEM_IDNO"] + ","; } if (strchkDetlValue != "") { strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1); } } DataTable dt = obj.SelectAccStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, strchkDetlValue, 2, Convert.ToInt64(ddlLocation.SelectedValue)); } DataTable dtnew = obj.FetchAccStockReport(ApplicationFunction.ConnectionString()); obj = null; if (dtnew != null && dtnew.Rows.Count > 0) { Double TotalIssue = 0, TotalOpening = 0, TotalPur = 0, TotSale = 0, Total = 0, TotalBal = 0; for (int i = 0; i < dtnew.Rows.Count; i++) { TotalOpening += Convert.ToDouble(dtnew.Rows[i]["OpenBal"]); TotalPur += Convert.ToDouble(dtnew.Rows[i]["Purchase"]); TotalIssue += Convert.ToDouble(dtnew.Rows[i]["MtrlIss"]); TotSale += Convert.ToDouble(dtnew.Rows[i]["Sale"]); Total += Convert.ToDouble(dtnew.Rows[i]["Total"]); TotalBal += Convert.ToDouble(dtnew.Rows[i]["BalQty"]); } 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(dtnew.Compute("Sum(StkRec)", "")); lblTotTran.Text = Convert.ToString(dtnew.Compute("Sum(StkTrns)", "")); if (dtnew != null && dtnew.Rows.Count > 0) { ViewState["Dt"] = dtnew; } grdMain.DataSource = dtnew; 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 " + dtnew.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; } }