protected void binddata()
{
DataTable dt = new DataTable();
string from = txtFrom.Text;
string to = txtTo.Text;
Cls_Business_RptBulkTransProces objTran = new Cls_Business_RptBulkTransProces();
dt = objTran.GetBulkEcafDetails(Session["username"].ToString(), from, to);
if (dt.Rows.Count == 0)
{
grdBulkUpload.DataSource = null;
grdBulkUpload.DataBind();
grdBulkUpload.Visible = false;
lblSearchMsg.Text = "No data found";
}
else
{
//lblSearchParams.Text = "SELECT * from view_lcopre_bulk_ecaf_summary where trunc(insdate)>='" + from + "' and trunc(insdate)<='" + to + "' and insby='" + Session["username"].ToString() + "'";
grdBulkUpload.DataSource = dt;
ViewState["Data"] = dt;
grdBulkUpload.DataBind();
grdBulkUpload.Visible = true;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
lbSearchMsg.Text = "";
string Unique_id = "";
if (txtUniqueid.Text == "")
{
lblerrormsg.Text = "Please Enter unique Id....";
return;
}
else
{
Unique_id = txtUniqueid.Text.Trim().ToString();
}
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;
}
DataTable dt = new DataTable();
Cls_Business_RptBulkTransProces objTran = new Cls_Business_RptBulkTransProces();
dt = objTran.GetDetails(username, operator_id, catid, Unique_id);
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
else
{
DivShowValue.Visible = true;
lblSumFile.Text = dt.Rows[0]["uploadid"].ToString();
lblSumTotal.Text = dt.Rows[0]["total"].ToString();
lblSumSuccess.Text = dt.Rows[0]["success"].ToString();
lblSumFailure.Text = dt.Rows[0]["failed"].ToString();
lblRemaing.Text = dt.Rows[0]["remaing"].ToString();
}
}
catch (Exception ex)
{
Response.Redirect("../errorPage.aspx");
}
}
protected void SearchbindData(string Unique_id)
{
//try
//{
lbSearchMsg.Text = "";
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;
}
DataTable dt = new DataTable();
Cls_Business_RptBulkTransProces objTran = new Cls_Business_RptBulkTransProces();
dt = objTran.GetDetails(username, operator_id, catid, Unique_id);
if (dt == null)
{
lblResponseMsg.Text = "No Data Found";
}
else if (dt.Rows.Count == 0)
{
lblResponseMsg.Text = "No Data Found";
DivShowValue.Visible = false;
//SearchbindData(Unique_id);
}
else
{
DivShowValue.Visible = true;
lblSumFile.Text = dt.Rows[0]["uploadid"].ToString();
lblSumTotal.Text = dt.Rows[0]["total"].ToString();
lblSumSuccess.Text = dt.Rows[0]["success"].ToString();
lblSumFailure.Text = dt.Rows[0]["failed"].ToString();
lblRemaing.Text = dt.Rows[0]["remaing"].ToString();
}
//}
//catch (Exception ex)
//{
// Response.Redirect("../errorPage.aspx");
//}
}
protected void binddata(string upload_id, int IntBulkStatus)
{
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;
}
DataTable dt = new DataTable();
Cls_Business_RptBulkTransProces objTran = new Cls_Business_RptBulkTransProces();
dt = objTran.GetBulkchange(username, upload_id, IntBulkStatus);
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
if (dt.Rows.Count == 0)
{
grdBulkstatus.Visible = false;
lbSearchMsg.Text = "No data found";
}
else
{
//{
// btnGenerateExcel.Visible = true;
DivGried.Visible = true;
}
grdBulkstatus.Visible = true;
grdBulkstatus.DataSource = dt;
grdBulkstatus.DataBind();
}
protected void btn_genExl_Click(object sender, EventArgs e)
{
string username;
if (Session["username"] != null)
{
username = Session["username"].ToString();
}
else
{
Session.Abandon();
Response.Redirect("~/Login.aspx");
return;
}
Cls_Business_RptBulkTransProces objTran = new Cls_Business_RptBulkTransProces();
DataTable dt = null; //check for exception
string from = txtFrom.Text;
string to = txtTo.Text;
dt = objTran.GetBulkEcafDetails(Session["username"].ToString(), from, to);
ViewState["Data"] = dt;
if (ViewState["Data"] != null)
{
dt = (DataTable)ViewState["Data"];
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/") + "BulkEcaf_" + datetime + ".csv");
try
{
int j = 0;
String strheader = "Sr. No." + ","
+ "Uniqu No" + ","
+ "STB NO" + ","
+ "VC ID" + ","
+ "VC ID" + ","
+ "First Name" + ","
+ "Meddil Name" + ","
+ "Last Name" + ","
+ "Mobile No" + ","
+ "Email Id" + ","
+ "User Name" + ","
+ "Status" + ","
+ "Status MSG" + ","
+ "Transaction by" + ","
+ "'Transaction Date";
while (j < dt.Rows.Count)
{
sw.WriteLine(strheader);
for (int i = 0; i < dt.Rows.Count; i++)
{
j = j + 1;
string strrow = j.ToString() + ","
+ dt.Rows[i]["uniquno"].ToString() + ","
+ dt.Rows[i]["stb"].ToString() + ","
+ dt.Rows[i]["vc"].ToString() + ","
+ dt.Rows[i]["firstnm"].ToString() + ","
+ dt.Rows[i]["meddilnm"].ToString() + ","
+ dt.Rows[i]["lastnm"].ToString() + ","
+ dt.Rows[i]["mobileno"].ToString() + ","
+ dt.Rows[i]["email"].ToString() + ","
+ dt.Rows[i]["Status"].ToString() + ","
+ dt.Rows[i]["errormsg"].ToString() + ","
+ dt.Rows[i]["insby"].ToString() + ","
+ "'" + dt.Rows[i]["insdate"].ToString();
sw.WriteLine(strrow);
}
}
sw.Flush();
sw.Close();
}
catch (Exception ex)
{
sw.Flush();
sw.Close();
Response.Write("Error : " + ex.Message.Trim());
return;
}
dt.Dispose();
Response.AddHeader("Content-disposition", "attachment; filename=BulkEcaf_" + datetime + ".csv");
Response.ContentType = "text/csv";
Response.Redirect("../MyExcelFile/" + "BulkEcaf_" + datetime + ".csv");
}
}
protected void generateExcel(string upload_id, int status_flag)
{
string username;
if (Session["username"] != null)
{
username = Session["username"].ToString();
}
else
{
Session.Abandon();
Response.Redirect("~/Login.aspx");
return;
}
Cls_Business_RptBulkTransProces obj = new Cls_Business_RptBulkTransProces();
DataTable dt = null;
dt = obj.GetExcelData(username, upload_id, status_flag);
if (dt == null)
{
lblSearchMsg.Text = "Something went wrong while fetching details...";
return;
}
if (dt.Rows.Count == 0)
{
lblSearchMsg.Text = "No data found for clicked count figure...";
return;
}
DateTime dd = DateTime.Now;
string datetime = dd.Day + "" + dd.Month + "" + dd.Year + "" + dd.Hour + "" + dd.Minute + "" + dd.Second;
string xls_file_name = "";
if (status_flag == 0)
{
xls_file_name += "_all_";
}
else if (status_flag == 1)
{
xls_file_name += "_success_";
}
else if (status_flag == 2)
{
xls_file_name += "_fail_";
}
StreamWriter sw = new StreamWriter(Server.MapPath("../MyExcelFile/") + xls_file_name + datetime + ".xls");
try
{
int j = 0;
String strheader = "Sr. No." + Convert.ToChar(9)
+ "Unique No" + Convert.ToChar(9)
+ "STB NO" + Convert.ToChar(9)
+ "VC ID" + Convert.ToChar(9)
+ "First Name" + Convert.ToChar(9)
+ "Meddle Name" + Convert.ToChar(9)
+ "Last Name" + Convert.ToChar(9)
+ "Mobile No" + Convert.ToChar(9)
+ "Email Id" + Convert.ToChar(9)
+ "Status" + Convert.ToChar(9)
+ "Status MSG" + Convert.ToChar(9)
+ "Transaction by" + Convert.ToChar(9)
+ "'Transaction Date";
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]["UNIQUNO"].ToString() + Convert.ToChar(9)
+ "'" + dt.Rows[i]["stb"].ToString() + Convert.ToChar(9)
+ "'" + dt.Rows[i]["vc"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["firstnm"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["meddilnm"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["lastnm"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["mobileno"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["email"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["Status"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["errormsg"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["insby"].ToString() + Convert.ToChar(9)
+ "'" + dt.Rows[i]["insdate"].ToString();
sw.WriteLine(strrow);
}
}
sw.Flush();
sw.Close();
}
catch (Exception ex)
{
sw.Flush();
sw.Close();
Response.Write("Error : " + ex.Message.Trim());
return;
}
Response.Redirect("../MyExcelFile/" + xls_file_name + datetime + ".xls");
}
