private void bindIssueGrd(int custId) { try { grdIssueStatus.DataSource = null; grdIssueStatus.DataBind(); string searchValue = txtsearchValue.Text.Trim(); searchValue = Regex.Replace(searchValue, @"\s+", " "); string stprocedure = "spIssueDetails"; DataTable dt = new DataTable(); if (ddlsortby.SelectedIndex == 0) { DataSet ds = q.ProcdureWith6Param(stprocedure, 1, custId, 0, "", "", ""); dt = ds.Tables[0]; } if (ddlsortby.SelectedIndex == 1) { DataSet ds = q.ProcdureWith6Param(stprocedure, 3, custId, 0, "", searchValue, ""); dt = ds.Tables[0]; } else if (ddlsortby.SelectedIndex == 2) { DataSet ds = q.ProcdureWith6Param(stprocedure, 4, custId, 0, "", "", searchValue); dt = ds.Tables[0]; } else if (ddlsortby.SelectedIndex == 3) { DataSet ds = q.ProcdureWith6Param(stprocedure, 6, custId, 0, searchValue, "", ""); dt = ds.Tables[0]; } else if (ddlsortby.SelectedIndex == 4) { try { int issueid = Convert.ToInt32(searchValue); DataSet ds = q.ProcdureWith6Param(stprocedure, 5, custId, issueid, "", "", ""); dt = ds.Tables[0]; } catch (Exception ex) { g.ShowMessage(this.Page, "Issue Id is accept only numeric value. " + ex.Message); } } grdIssueStatus.DataSource = dt; grdIssueStatus.DataBind(); checkAuthority(); } catch (Exception ex) { g.ShowMessage(this.Page, ex.Message); } }
private void bindGaugeSupplierGrd(int custId) { try { string stprocedure = "spGaugeSupplier"; DataTable dt = new DataTable(); if (ddlsortby.SelectedItem.Text == "--Select--") { DataSet ds = q.ProcdureWith6Param(stprocedure, 1, custId, "", "", "", ""); dt = ds.Tables[0]; } else if (ddlsortby.SelectedItem.Text == "Gauge Name-Wise") { DataSet ds = q.ProcdureWith6Param(stprocedure, 2, custId, txtsearchValue.Text, "", "", ""); dt = ds.Tables[0]; } else if (ddlsortby.SelectedItem.Text == "Gauge Sr.No.-Wise") { DataSet ds = q.ProcdureWith6Param(stprocedure, 4, custId, "", txtsearchValue.Text, "", ""); dt = ds.Tables[0]; } else if (ddlsortby.SelectedItem.Text == "Supplier Name-Wise") { DataSet ds = q.ProcdureWith6Param(stprocedure, 5, custId, "", "", txtsearchValue.Text, ""); dt = ds.Tables[0]; } else if (ddlsortby.SelectedItem.Text == "Gauge Type-Wise") { DataSet ds = q.ProcdureWith6Param(stprocedure, 6, custId, "", "", "", txtsearchValue.Text); dt = ds.Tables[0]; } grdGaugeSupplier.DataSource = dt; grdGaugeSupplier.DataBind(); checkAuthority(); } catch (Exception ex) { g.ShowMessage(this.Page, ex.Message); } }
private void bindIssueReportGrd() { try { Session["AllPrintData"] = null; dtPrint = null; bool Status = g.CheckSuperAdmin(Convert.ToInt32(Session["User_ID"])); string stprocedure = "spIssueDetails"; // Check super Admin condition #region Supper admin if (Status == true) { if (ddlcust.SelectedIndex == 0) { DataSet ds = q.ProcdureWith6Param(stprocedure, 2, 0, 0, "", "", ""); grdIssueReport.DataSource = ds.Tables[0]; grdIssueReport.DataBind(); if (ds.Tables[0].Rows.Count > 0) { Session["AllPrintData"] = ds.Tables[0]; } else { Session["AllPrintData"] = null; } } else if (ddlcust.SelectedIndex > 0) { fillSortWiseData(Convert.ToInt32(ddlcust.SelectedValue)); } } #endregion #region Employee wise else { fillSortWiseData(Convert.ToInt32(Session["Customer_ID"])); } #endregion checkAuthority(); } catch (Exception ex) { g.ShowMessage(this.Page, ex.Message); } }