public void GenerateDs() { string connStr = string.Empty; if (Request.Cookies["Company"] != null) { connStr = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString(); } else { Response.Redirect("~/frm_Login.aspx"); } string sArea = string.Empty; string sDataSource = connStr.Remove(0, 45); string sXmlPath = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["BillDetailsFileName"].ToString()); string sXmlNodeName = "BillDetails"; DateTime startDate, endDate; CustomerReportBL.ReportClass custReport; sArea = drpArea.SelectedItem.Text; startDate = Convert.ToDateTime(txtStartDate.Text); endDate = Convert.ToDateTime(txtEndDate.Text); custReport = new CustomerReportBL.ReportClass(); custReport.generateBillDetailsReport(sArea, startDate, endDate, sXmlNodeName, sDataSource, sXmlPath); DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["BillDetailsFileName"].ToString()), XmlReadMode.InferSchema); //return ds; }
public DataSet GenerateDs() { string connStr = string.Empty; if (Request.Cookies["Company"] != null) { connStr = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString(); } else { Response.Redirect("~/frm_Login.aspx"); } string sArea = string.Empty; string sDataSource = connStr.Remove(0, 45); string sXmlPath = Server.MapPath(ConfigurationSettings.AppSettings["OutstandingBalanceFileName"].ToString()); string sXmlNodeName = "Outstanding"; CustomerReportBL.ReportClass outsReport; sArea = drpArea.SelectedItem.Text; outsReport = new CustomerReportBL.ReportClass(); outsReport.generateOutstandingReport(sArea.Replace("'", "''"), sXmlNodeName, sDataSource, sXmlPath); DataSet ds = new DataSet(); Session["OutStandingFilename"] = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["OutstandingBalanceFileName"].ToString()); ds.ReadXml(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["OutstandingBalanceFileName"].ToString()), XmlReadMode.InferSchema); return(ds); }