protected void Page_Load(object sender, EventArgs e) { Master.PageHeading = "Last Five Transaction Report"; if (!IsPostBack) { Session["RightsKey"] = null; Session["pagenos"] = "1"; operid = Convert.ToString(Session["operator_id"]); username = Convert.ToString(Session["username"]); catid = Convert.ToString(Session["category"]); btn_genExl.Visible = false; if (catid == "3") { tbldet.Visible = false; Hashtable htAddPlanParams = getUserPara(); Cls_Business_RptLastFiveGridBind cls = new Cls_Business_RptLastFiveGridBind(); Hashtable htResponse = cls.GetLastFiveTransaction(htAddPlanParams, username, catid, operid); DataTable dt = null; //check for exception if (htResponse["htResponse"] != null) { dt = (DataTable)htResponse["htResponse"]; } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } if (dt.Rows.Count == 0) { grdTransDet.Visible = false; lblSearchMsg.Text = "No data found"; btn_genExl.Visible = false; } else { btn_genExl.Visible = true; grdTransDet.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdTransDet.DataSource = dt; grdTransDet.DataBind(); } } else { tbldet.Visible = true; FillLcoDetails(); // FillLco(); } } }
protected void btn_genExl_Click(object sender, EventArgs e) { string username; string 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; } Hashtable htAddPlanParams = getUserPara(); Cls_Business_RptLastFiveGridBind cls = new Cls_Business_RptLastFiveGridBind(); Hashtable htResponse = cls.GetLastFiveTransaction(htAddPlanParams, username, catid, operator_id); DataTable dt = null; //check for exception if (htResponse["htResponse"] != null) { dt = (DataTable)htResponse["htResponse"]; 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/") + "LastFiveTrans_" + datetime + ".xls"); try { int j = 0; String strheader = "Customer ID" + Convert.ToChar(9) + "VC" + Convert.ToChar(9) + "Plan Name" + Convert.ToChar(9) + "Plan Type" + Convert.ToChar(9); strheader += " Transaction Type" + Convert.ToChar(9) + "Reason" + Convert.ToChar(9); strheader += "User ID" + Convert.ToChar(9) + "User Name" + Convert.ToChar(9) + "'" + "Transaction Date & Time" + Convert.ToChar(9) + "MRP" + Convert.ToChar(9) + "Amount deducted" + Convert.ToChar(9) + "'" + "Expiry date" + Convert.ToChar(9); strheader += "Pay Term" + Convert.ToChar(9) + "Balance" + Convert.ToChar(9) + "LCO Code" + Convert.ToChar(9) + "LCO Name" + Convert.ToChar(9) + "JV Name" + Convert.ToChar(9); strheader += "ERP LCO A/C" + Convert.ToChar(9) + "Distributor" + Convert.ToChar(9) + "Sub distributor" + Convert.ToChar(9); strheader += "City" + Convert.ToChar(9) + "State" + 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() + dt.Rows[i]["custid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["vc"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["plnname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["plntyp"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["flag"].ToString() + Convert.ToChar(9) + dt.Rows[i]["reason"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["uname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["userowner"].ToString() + Convert.ToChar(9) + "'" + dt.Rows[i]["tdt"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["custprice"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["amtdd"].ToString() + Convert.ToChar(9) + "'" + dt.Rows[i]["expdt"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["payterm"].ToString() + Convert.ToChar(9) + dt.Rows[i]["bal"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["lcocode"].ToString() + Convert.ToChar(9) + dt.Rows[i]["lconame"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["jvname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["erplco_ac"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["distname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["subdist"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["city"].ToString() + Convert.ToChar(9) + dt.Rows[i]["state"].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/" + "LastFiveTrans_" + datetime + ".xls"); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } if (dt.Rows.Count == 0) { btn_genExl.Visible = false; grdTransDet.Visible = false; lblSearchMsg.Text = "No data found"; } else { btn_genExl.Visible = true; grdTransDet.Visible = true; } }
protected void btnSubmit_Click(object sender, EventArgs e) { //if (ddlUser.SelectedIndex == 0) //{ // msgbox("Please Select User", ddlUser); // return; //} 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(ddlLco.SelectedValue); //Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } Hashtable htAddPlanParams = getUserPara(); Cls_Business_RptLastFiveGridBind cls = new Cls_Business_RptLastFiveGridBind(); Hashtable htResponse = cls.GetLastFiveTransaction(htAddPlanParams, 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; } if (dt.Rows.Count == 0) { grdTransDet.Visible = false; lblSearchMsg.Text = "No data found"; btn_genExl.Visible = false; } else { btn_genExl.Visible = true; grdTransDet.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdTransDet.DataSource = dt; grdTransDet.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 } }