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