protected void grdAddPlantopup_PageIndexChanging(object sender, GridViewPageEventArgs e) { grdchildTVdiscount.PageIndex = e.NewPageIndex; Hashtable htTopupParams = getTopupParamsData(); 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_rptChildTVDiscount objTran = new Cls_Business_rptChildTVDiscount(); Hashtable htResponse = objTran.GetTransations(htTopupParams, username, catid); DataTable dt = null; if (htResponse["htResponse"] != null) { dt = (DataTable)htResponse["htResponse"]; } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } if (dt.Rows.Count == 0) { grdchildTVdiscount.Visible = false; lblSearchMsg.Text = "No data found"; } else { btngrnExel.Visible = true; btnGenerateExcel.Visible = true; grdchildTVdiscount.Visible = true; lblSearchMsg.Text = ""; //ViewState["searched_trans"] = dt; grdchildTVdiscount.DataSource = dt; grdchildTVdiscount.DataBind(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string from = txtFrom.Text; string to = txtTo.Text; lblResultCount.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); // DateTime fromDt; // DateTime toDt; Double dateDiff = 0; 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); dateDiff = (toDt - fromDt).TotalDays; } if (dateDiff >= 3) { btnGenerateExcel_Click(null, null); } if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; grdchildTVdiscount.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 = ""; grdchildTVdiscount.Visible = true; } } Hashtable htTopupParams = getTopupParamsData(); string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); // operator_id = ddlLco.SelectedValue.Split('#')[0].ToString(); //Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } Cls_Business_rptChildTVDiscount objTran = new Cls_Business_rptChildTVDiscount(); Hashtable htResponse = objTran.GetTransations(htTopupParams, username, catid); //, operator_id DataTable dt = null; //check for exception if (htResponse["htResponse"] != null) { dt = (DataTable)htResponse["htResponse"]; } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } //showing parameters string strParams = htResponse["ParamStr"].ToString(); if (!String.IsNullOrEmpty(strParams)) { // lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'>Top-up Parameters : </b>" + strParams); lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'></b>" + strParams); } if (dt.Rows.Count == 0) { grdchildTVdiscount.Visible = false; lblSearchMsg.Text = "No data found"; } else { btngrnExel.Visible = true; btnGenerateExcel.Visible = true; grdchildTVdiscount.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdchildTVdiscount.DataSource = dt; grdchildTVdiscount.DataBind(); DivRoot.Style.Add("display", "block"); //showing result count //lblResultCount.Text = Server.HtmlDecode("<b>Showing Top " + dt.Rows.Count.ToString() + " Matching Results</b>"); //to get transaction type on frmSerTransDetails.aspx } /*DataTable dt = new DataTable("Pager"); * dt.Columns.Add("dtttime"); * dt.Columns.Add("amt"); * dt.Columns.Add("paymode"); * dt.Columns.Add("erprcptno"); * dt.Columns.Add("rcptno"); * dt.Columns.Add("finuid"); * dt.Columns.Add("fiuname"); * dt.Columns.Add("action"); * dt.Rows.Add(); * dt.Rows[0]["dtttime"] = "24-Nov-2014 10:20:04 pm"; * dt.Rows[0]["amt"] = "1000"; * dt.Rows[0]["paymode"] = "Cash"; * dt.Rows[0]["erprcptno"] = "1112"; * dt.Rows[0]["rcptno"] = "5501"; * dt.Rows[0]["finuid"] = "0600001"; * dt.Rows[0]["fiuname"] = "ADMIN"; * dt.Rows[0]["action"] = "Refund"; * dt.Rows.Add(); * dt.Rows[1]["dtttime"] = "23-Nov-2014 11:03:33 pm"; * dt.Rows[1]["amt"] = "2000"; * dt.Rows[1]["paymode"] = "Cheque"; * dt.Rows[1]["erprcptno"] = "4567"; * dt.Rows[1]["rcptno"] = "5572"; * dt.Rows[1]["finuid"] = "0600101"; * dt.Rows[1]["fiuname"] = "UPASS"; * dt.Rows[1]["action"] = "Topup"; * dt.Rows.Add(); * dt.Rows[2]["dtttime"] = "22-Nov-2014 08:11:00 pm"; * dt.Rows[2]["amt"] = "3000"; * dt.Rows[2]["paymode"] = "Cash"; * dt.Rows[2]["erprcptno"] = "98788"; * dt.Rows[2]["rcptno"] = "5598"; * dt.Rows[2]["finuid"] = "060010001"; * dt.Rows[2]["fiuname"] = "UPASS"; * dt.Rows[2]["action"] = "Reversal"; * * * if (dt == null) * { * Response.Redirect("~/ErrorPage.aspx"); * return; * } * * if (dt.Rows.Count == 0) * { * grdAddPlantopup.Visible = false; * lblSearchMsg.Text = "No data found"; * } * else * { * grdAddPlantopup.Visible = true; * lblSearchMsg.Text = ""; * grdAddPlantopup.DataSource = dt; * grdAddPlantopup.DataBind(); * }*/ }
protected void btnGenerateExcel_Click(object sender, EventArgs e) { string from = txtFrom.Text; string to = txtTo.Text; lblResultCount.Text = ""; Hashtable htTopupParams = getTopupParamsData(); string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); //operator_id = ddlLco.SelectedValue.Split('#')[0].ToString(); //Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } Cls_Business_rptChildTVDiscount objTran = new Cls_Business_rptChildTVDiscount(); Hashtable htResponse = objTran.GetTransations(htTopupParams, username, catid); DataTable dt = null; //check for exception if (htResponse["htResponse"] != null) { dt = (DataTable)htResponse["htResponse"]; if (dt.Rows.Count > 0) { DateTime dd = DateTime.Now; string datetime = dd.Day + "" + dd.Month + "" + dd.Year + "" + dd.Hour + "" + dd.Minute + "" + dd.Second; StreamWriter sw = new StreamWriter(Server.MapPath("../MyExcelFile/") + "ChildTVDiscount_" + datetime + ".xls"); try { int j = 0; String strheader = "Sr.No." + Convert.ToChar(9) + "Receipt No" + Convert.ToChar(9) + "Customer ID" + Convert.ToChar(9) + "VC Id" + Convert.ToChar(9) + "Plan Name" + Convert.ToChar(9) + "Plan Type" + Convert.ToChar(9) + "Flag" + Convert.ToChar(9) + "LCO Price" + Convert.ToChar(9) + "Rate" + Convert.ToChar(9) + "Amount" + Convert.ToChar(9) + "Credit" + Convert.ToChar(9) + "Child Id" + Convert.ToChar(9) + "CR Type" + Convert.ToChar(9) + "Inserted By" + Convert.ToChar(9) + "LCO Code" + Convert.ToChar(9) + "Date" + Convert.ToChar(9) + "City" + Convert.ToChar(9) + "State" + Convert.ToChar(9) + "DAS Area" + Convert.ToChar(9) + "Source Flag" + Convert.ToChar(9) + "Share Type" + Convert.ToChar(9) + "JV Name" + Convert.ToChar(9) + "JV No." + Convert.ToChar(9); while (j < dt.Rows.Count) { sw.WriteLine(strheader); for (int i = 0; i < dt.Rows.Count; i++) { j = j + 1; string strrow = j.ToString() + Convert.ToChar(9) + "'" + dt.Rows[i]["var_distrans_receiptno"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_custid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_vcid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_planname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_plantype"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_flag"].ToString() + Convert.ToChar(9) + dt.Rows[i]["num_distrans_lcoprice"].ToString() + Convert.ToChar(9) + dt.Rows[i]["num_distrans_rate"].ToString() + Convert.ToChar(9) + dt.Rows[i]["num_distrans_amt"].ToString() + Convert.ToChar(9) + dt.Rows[i]["num_distrans_credited"].ToString() + Convert.ToChar(9) + dt.Rows[i]["num_distrans_childid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_crtype"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_insby"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_lcocode"].ToString() + Convert.ToChar(9) + dt.Rows[i]["dat_distrans_transdt"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_city"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_state"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_dasarea"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_sourceflag"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_sharetype"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_jvname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["var_distrans_jvno"].ToString() + Convert.ToChar(9) ; sw.WriteLine(strrow); } } sw.Flush(); sw.Close(); } catch (Exception ex) { sw.Flush(); sw.Close(); Response.Write("Error : " + ex.Message.Trim()); return; } Response.Redirect("../MyExcelFile/" + "ChildTVDiscount_" + datetime + ".xls"); } } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } if (dt.Rows.Count == 0) { grdchildTVdiscount.Visible = false; lblSearchMsg.Text = "No data found"; } else { grdchildTVdiscount.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdchildTVdiscount.DataSource = dt; grdchildTVdiscount.DataBind(); //showing result count //lblResultCount.Text = Server.HtmlDecode("<b>Showing Top " + dt.Rows.Count.ToString() + " Matching Results</b>"); //to get transaction type on frmSerTransDetails.aspx } }