protected void binddata() { string from = txtFrom.Text; string to = txtTo.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); if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; grdExpiry.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 From date later or equal to current date!"; //"You can not select From date later than 15 days from current date!"; return; } else if (Convert.ToDateTime(txtTo.Text.ToString()) >= DateTime.Now.Date) { lblSearchMsg.Text = "You can not select To date later or equal to current date!"; // "You can not select To date later than 15 days from current date!"; return; } else { lblSearchMsg.Text = ""; grdExpiry.Visible = true; } } Hashtable htAddPlanParams = getLedgerParamsData(); string username, catid, operator_id, search_type; string txtsearch = ""; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Convert.ToString(Session["operator_id"]); search_type = Convert.ToString(Session["search"]); txtsearch = Convert.ToString(Session["txtsearch"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } DataTable dt = new DataTable(); Cls_Business_rptsplcoprecolldetails objTran = new Cls_Business_rptsplcoprecolldetails(); dt = objTran.lcoprecolldetails(htAddPlanParams, username, operator_id, catid); if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } if (dt.Rows.Count == 0) { btnGenerateExcel.Visible = false; grdExpiry.Visible = false; lblSearchMsg.Text = "No data found"; } else { btnGenerateExcel.Visible = true; grdExpiry.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdExpiry.DataSource = dt; grdExpiry.DataBind(); ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + grdExpiry.ClientID + "', 400, 1200 , 46 ,false); </script>", false); DivRoot.Style.Add("display", "block"); } }
protected void ExportExcel() { Hashtable htAddPlanParams = getLedgerParamsData(); 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_rptsplcoprecolldetails objTran = new Cls_Business_rptsplcoprecolldetails(); dt = objTran.lcoprecolldetails(htAddPlanParams, username, operator_id, catid); if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } 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/") + "lcoprecolldetails_" + datetime + ".xls"); try { int j = 0; String strheader = "Sr. No." + Convert.ToChar(9) + "Account Number" + Convert.ToChar(9) + "Customer Name" + Convert.ToChar(9) + "Entity Code" + Convert.ToChar(9) + "LCO_Name" + Convert.ToChar(9) + "City" + Convert.ToChar(9) + "State" + Convert.ToChar(9) + "Area" + Convert.ToChar(9) + "Receipt No." + Convert.ToChar(9) + "Amount" + Convert.ToChar(9) + "Receipt Date" + Convert.ToChar(9) + "Reversal date" + Convert.ToChar(9) + "Created By Username" + Convert.ToChar(9) + "Description" + Convert.ToChar(9) + "Customer Type" + Convert.ToChar(9) + "Payment Mode" + Convert.ToChar(9) + "Cheque No." + Convert.ToChar(9) + "Cheque Date" + Convert.ToChar(9) + "Bank Name" + Convert.ToChar(9) + "Branch Name" + Convert.ToChar(9) + "Bank Code" + Convert.ToChar(9) + "Payment Channel" + Convert.ToChar(9) + "Upass Receipt No." + Convert.ToChar(9) + "Reversal Status" + Convert.ToChar(9) + "JV" + Convert.ToChar(9) + "Distributer" + Convert.ToChar(9) + "Sub Distributer" + Convert.ToChar(9) + "Company" + Convert.ToChar(9) + "Report Date" + Convert.ToChar(9) + "From Date" + Convert.ToChar(9) + "to Date" + 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]["account_no"].ToString() + Convert.ToChar(9) + dt.Rows[i]["customer_name"].ToString() + Convert.ToChar(9) + dt.Rows[i]["entity_code"].ToString() + Convert.ToChar(9) + dt.Rows[i]["lco_name"].ToString() + Convert.ToChar(9) + dt.Rows[i]["city"].ToString() + Convert.ToChar(9) + dt.Rows[i]["state"].ToString() + Convert.ToChar(9) + dt.Rows[i]["area"].ToString() + Convert.ToChar(9) + dt.Rows[i]["receipt_no"].ToString() + Convert.ToChar(9) + dt.Rows[i]["amount"].ToString() + Convert.ToChar(9) + dt.Rows[i]["receipt_date"].ToString() + Convert.ToChar(9) + dt.Rows[i]["reversal_date"].ToString() + Convert.ToChar(9) + dt.Rows[i]["created_by_username"].ToString() + Convert.ToChar(9) + dt.Rows[i]["description"].ToString() + Convert.ToChar(9) + dt.Rows[i]["customer_type"].ToString() + Convert.ToChar(9) + dt.Rows[i]["payment_mode"].ToString() + Convert.ToChar(9) + dt.Rows[i]["cheque_no"].ToString() + Convert.ToChar(9) + dt.Rows[i]["cheque_date"].ToString() + Convert.ToChar(9) + dt.Rows[i]["bank_name"].ToString() + Convert.ToChar(9) + dt.Rows[i]["branch_name"].ToString() + Convert.ToChar(9) + dt.Rows[i]["bank_code"].ToString() + Convert.ToChar(9) + dt.Rows[i]["payment_channel"].ToString() + Convert.ToChar(9) + dt.Rows[i]["upass_reciept_no"].ToString() + Convert.ToChar(9) + dt.Rows[i]["reversal_status"].ToString() + Convert.ToChar(9) + dt.Rows[i]["jv"].ToString() + Convert.ToChar(9) + dt.Rows[i]["distributer"].ToString() + Convert.ToChar(9) + dt.Rows[i]["sub_distributer"].ToString() + Convert.ToChar(9) + dt.Rows[i]["company"].ToString() + Convert.ToChar(9) + dt.Rows[i]["report_date"].ToString() + Convert.ToChar(9) + dt.Rows[i]["from_date"].ToString() + Convert.ToChar(9) + dt.Rows[i]["to_date"].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; } dt.Dispose(); Response.Redirect("../MyExcelFile/" + "lcoprecolldetails_" + datetime + ".xls"); } if (dt.Rows.Count == 0) { grdExpiry.Visible = false; lblSearchMsg.Text = "No data found"; } }