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;
}
}
