protected void grdAddPlanSearch_PageIndexChanging(object sender, GridViewPageEventArgs e) { grdAddPlanSearch.PageIndex = e.NewPageIndex; Hashtable htAddPlanParams = getAddPlanParamsData(); 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_RptAddPlan objTran = new Cls_Business_RptAddPlan(); Hashtable htResponse = objTran.GetTransations(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) { grdAddPlanSearch.Visible = false; btnAll.Visible = false; lblSearchMsg.Text = "No data found"; btn_genExl.Visible = false; } else { btn_genExl.Visible = true; grdAddPlanSearch.Visible = true; btnAll.Visible = true; lblSearchMsg.Text = ""; // ViewState["searched_trans"] = dt; grdAddPlanSearch.DataSource = dt; grdAddPlanSearch.DataBind(); htResponse["htResponse"] = null; dt.Dispose(); } }
public void Binddata() { lblSearchMsg.Text = ""; grdAddPlanSearch.Visible = true; btnAll.Visible = true; Hashtable htAddPlanParams = getAddPlanParamsData(); 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; } //if (catid == "3") //{ // Session["lcoid"] = operator_id.ToString(); // Session["lconame"] = "All"; // Session["showall"] = "1"; // Response.Redirect("../Reports/rptAddPlanTransUSER.aspx");//?lcoid=" + operator_id.ToString());// + "'" + "lcoid=" + operator_id.ToString()); //} Cls_Business_RptAddPlan objTran = new Cls_Business_RptAddPlan(); Hashtable htResponse = objTran.GetTransations(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; } string strParams = htResponse["ParamStr"].ToString(); if (!String.IsNullOrEmpty(strParams)) { lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'></b>" + strParams); } if (dt.Rows.Count == 0) { grdAddPlanSearch.Visible = false; btnAll.Visible = false; lblSearchMsg.Text = "No data found"; btn_genExl.Visible = false; } else { btn_genExl.Visible = true; grdAddPlanSearch.Visible = true; btnAll.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdAddPlanSearch.DataSource = dt; grdAddPlanSearch.DataBind(); htResponse["htResponse"] = null; dt.Dispose(); } }
protected void btn_genExl_Click(object sender, EventArgs e) { Hashtable htAddPlanParams = getAddPlanParamsData(); 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_RptAddPlan objTran = new Cls_Business_RptAddPlan(); Hashtable htResponse = objTran.GetTransations(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/") + "PlanAddLCO_" + datetime + ".xls"); try { int j = 0; String strheader = "SrNo" + Convert.ToChar(9) + "LCO Name" + Convert.ToChar(9) + "LCO Code" + Convert.ToChar(9) //+ "Balance" + Convert.ToChar(9) + "Amount Deducted" + Convert.ToChar(9) + "Count" + 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]["lconame"].ToString() + Convert.ToChar(9) + dt.Rows[i]["lcocode"].ToString() + Convert.ToChar(9) //+ dt.Rows[i]["amt"].ToString() + Convert.ToChar(9) + dt.Rows[i]["amtdd"].ToString() + Convert.ToChar(9) + dt.Rows[i]["cnt"].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; } htResponse["htResponse"] = null; dt.Dispose(); Response.Redirect("../MyExcelFile/" + "PlanAddLCO_" + datetime + ".xls"); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } }