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