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