public bool DisplayPPRDetails() { try { PPRDataBL obj = new PPRDataBL(); DataTable dt = new DataTable(); dt = obj.GetPPRDetailsDataBL(Session["UserId"].ToString()); if (dt.Rows.Count > 0) { PPRDetailsGridView.DataSource = dt; PPRDetailsGridView.DataBind(); if (Session["Rolls"] != null) { if (Session["Rolls"].ToString() == "3") { PPRDetailsGridView.Columns[PPRDetailsGridView.Columns.Count - 1].Visible = false; } } } else { PPRDetailsGridView.DataSource = null; PPRDetailsGridView.DataBind(); } } catch (Exception ex) { LogError(ex); } return(false); }
public void FilterMinistry(string ministry = "----All Ministry----", string pprid = "") { string Query = string.Empty; //pprid= pprid!=""? " and PPRId like '%" + pprid + "%'":"" ; //if (!string.IsNullOrEmpty(ministry)) //{ DataTable dt = (DataTable)ViewState["DataList"]; DataView dataView = dt.DefaultView; if (ministry != "-----Select Ministry-----" && ministry != "" && pprid != "") { Query += "Minid = '" + ministry + "'"; pprid = pprid != "" ? " and PPRId like '%" + pprid + "%'" : ""; dataView.RowFilter = Query + pprid; } else if (ministry != "-----Select Ministry-----" && ministry != "") { dataView.RowFilter = "Minid = '" + ministry + "'"; } else if (pprid != "") { pprid = pprid != "" ? " PPRId like '%" + pprid + "%'" : ""; dataView.RowFilter = pprid; } PPRDetailsGridView.DataSource = dataView; PPRDetailsGridView.DataBind(); //} }
private void SearchMinistry() { try { if (ddlpprid.SelectedItem.Value == "") { lblmsg.Text = "Please Select PPR Id"; PPRDetailsGridView.Visible = false; } else { PPRDataBL obj = new PPRDataBL(); DataTable dt = new DataTable(); dt = obj.GetSearchMinistryBL(HttpUtility.HtmlEncode(ddlpprid.SelectedItem.Value)); if (dt.Rows.Count > 0) { PPRDetailsGridView.DataSource = dt; PPRDetailsGridView.DataBind(); PPRDetailsGridView.Visible = true; lblmsg.Text = ""; } } } catch (Exception ex) { LogError(ex); } }
public bool DisplayMisReportData() { try { string[] pprids = txtPprId.Text.Split('-'); PPRDataBL obj = new PPRDataBL(); DataTable dt = new DataTable(); dt = obj.GetPPRDetailsDeleteBL(Session["LoginId"].ToString()); ViewState["DataList"] = dt; PPRDetailsGridView.DataSource = dt; PPRDetailsGridView.DataBind(); } catch (Exception ex) { LogError(ex); } return(false); }
public bool DisplayPPRDetails() { try { PPRDataBL obj = new PPRDataBL(); DataTable dt = new DataTable(); dt = obj.GetPPRDetailsDeleteBL(Session["LoginId"].ToString()); if (dt.Rows.Count > 0) { PPRDetailsGridView.DataSource = dt; PPRDetailsGridView.DataBind(); } else { PPRDetailsGridView.DataSource = null; PPRDetailsGridView.DataBind(); } } catch (Exception ex) { LogError(ex); } return(false); }