private void BindItemName() { TyreMoveRpt obj = new TyreMoveRpt(); 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"]); } TyreMoveRpt obj = new TyreMoveRpt(); Int64 list1 = obj.TotalRecords(Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text)), Convert.ToInt32(ddlDateRange.SelectedIndex), 0, ""); lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1); } }
private void BindGrid() { TyreMoveRpt obj = new TyreMoveRpt(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 ItemIdno = Convert.ToInt64(ddlItemName.SelectedValue); string serialNo = txtSerialNo.Text.Trim(); 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)); var lstGridData = obj.SelectTyreMovementReport(dtfrom, dtto, yearidno, ItemIdno, serialNo); obj = null; if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("Item Name", typeof(string)); dt.Columns.Add("Location", typeof(string)); dt.Columns.Add("In Type", typeof(string)); dt.Columns.Add("Doc No.", typeof(string)); dt.Columns.Add("Doc Date", typeof(string)); dt.Columns.Add("Out Type", typeof(string)); for (int i = 0; i < lstGridData.Count; i++) { DataRow dr = dt.NewRow(); dr["Item Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "ItemName")); dr["Location"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Location")); dr["In Type"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "StckIn")); dr["Doc No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DocNo")); dr["Doc Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "DocDate")).ToString("dd-MM-yyyy"); dr["Out Type"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "StckOut")); dt.Rows.Add(dr); if (i == lstGridData.Count - 1) { DataRow drr = dt.NewRow(); drr["Item Name"] = ""; drr["Location"] = ""; drr["In Type"] = ""; drr["Doc No."] = ""; drr["Doc Date"] = ""; drr["Out Type"] = ""; dt.Rows.Add(drr); } } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "T. 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 = "T. Record(s): 0 "; imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }