protected void xDGr_UpdateCommand(object source, DataGridCommandEventArgs e) { dIVtOTgRIDD.Visible = false; cls_business_rptEcafCust ob = new cls_business_rptEcafCust(); DataTable dt = new DataTable(); Hashtable htCrf = getCrfParams(); Hashtable htResponse; if (chkdt.Checked == true) { htResponse = ob.getReport(Session["username"].ToString(), htCrf); } else { //htCrf = null; htResponse = ob.getReportVC(Session["username"].ToString(), txtVCid.Text.Trim()); } if (htResponse["data"] != null) { dt = (DataTable)htResponse["data"]; } string strParams = htResponse["ParamStr"].ToString(); if (!String.IsNullOrEmpty(strParams)) { // lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'>Top-up Parameters : </b>" + strParams); lblSearchMsg.Text = Server.HtmlDecode("<b style='color:#094791;'></b>" + strParams); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } else if (dt.Rows.Count == 0) { Label1.Text = "No Data Found"; // divData.Visible = false; } else { grd.DataSource = dt; grd.DataBind(); // divData.Visible = true; dIvGridReport.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { Master.PageHeading = "ECAF Report"; if (!IsPostBack) { // grd.PageIndex = 0; txtFrom.Attributes.Add("readonly", "readonly"); txtTo.Attributes.Add("readonly", "readonly"); txtFrom.Text = dtime.ToString("dd-MMM-yyyy").Trim(); txtTo.Text = dtime.ToString("dd-MMM-yyyy").Trim(); // btngrnExel.Visible = false; btnGenerateExcel.Visible = false; try { Label2.Text = ""; if (Request.QueryString["vc"].ToString().Trim() != "") { pnldetail.Visible = false; dIVtOTgRIDD.Visible = false; cls_business_rptEcafCust ob = new cls_business_rptEcafCust(); DataTable dt = new DataTable(); Hashtable htCrf = getCrfParams(); Hashtable htResponse; htResponse = ob.getReportVC(Session["username"].ToString(), Request.QueryString["vc"].ToString()); if (htResponse["data"] != null) { dt = (DataTable)htResponse["data"]; } if (dt.Rows.Count > 0) { divData.Visible = true; dIvGridReport.Visible = true; grd.DataSource = dt; grd.DataBind(); } else { divData.Visible = true; dIvGridReport.Visible = true; Label2.Text = "No ECAF found for the customer"; } } } catch { } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string from = txtFrom.Text; string to = txtTo.Text; // lblResultCount.Text = ""; Label1.Text = ""; lblSearchMsg.Text = ""; DateTime fromDt; DateTime toDt; if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; // grdAddPlantopup.Visible = false; lblSearchMsg.ForeColor = System.Drawing.Color.Red; return; } else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return; } else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return; } else { lblSearchMsg.Text = ""; // grdAddPlantopup.Visible = true; } } Hashtable htCrf = getCrfParams(); string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } cls_business_rptEcafCust obj = new cls_business_rptEcafCust(); DataTable dt = new DataTable(); Hashtable htResponse; if (chkdt.Checked == true) { htResponse = obj.getCrfdata(username, htCrf); } else if (chkVC.Checked == true) { if (txtVCid.Text == "" || txtVCid.Text == null) { Label1.Text = "VC Id Can't Be Blank"; return; } else { string valid = SecurityValidation.chkData("T", txtVCid.Text); if (valid == "") { htResponse = obj.getCrfVC(username, txtVCid.Text.Trim()); } else { Label1.Text = valid.ToString(); return; } } // htResponse = obj.getCrfVC(username, txtVCid.Text.Trim()); } else { Label1.Text = "Please search by any one of the choice!!"; return; } if (htResponse["data"] != null) { dt = (DataTable)htResponse["data"]; } string strParams = htResponse["ParamStr"].ToString(); if (!String.IsNullOrEmpty(strParams)) { // lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'>Top-up Parameters : </b>" + strParams); lblSearchMsg.Text = Server.HtmlDecode("<b style='color:#094791;'></b>" + strParams); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } else if (dt.Rows.Count == 0) { Label1.Text = "No Data Found"; divData.Visible = false; } else { xDGr.DataSource = dt; xDGr.DataBind(); divData.Visible = true; dIVtOTgRIDD.Visible = true; dIvGridReport.Visible = false; } }