protected void generateTxCurrExcell(string reportingdatefrom, string reportingdateto)
{
ReportingResultsManager reportingLogic = new ReportingResultsManager();
//int txcurrcount = 0;
DataTable dt = reportingLogic.gettxcurr(Convert.ToDateTime(reportingdateto));
//IQWebUtils theUtils = new IQWebUtils();
//theUtils.ExporttoExcel(dt, Response);
using (XLWorkbook wb = new XLWorkbook())
{
String timeStamp = GetTimestamp(DateTime.Now);
var ws = wb.Worksheets.Add(dt, "txcurr");
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + "txcurr" + timeStamp + ".xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(HttpContext.Current.Response.OutputStream);
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
}
}
public int getNumberOfTxcurr(string reportingdate)
{
ReportingResultsManager reportingLogic = new ReportingResultsManager();
int txcurrcount = 0;
DataTable theDT = reportingLogic.gettxcurr(Convert.ToDateTime(reportingdate));
txcurrcount = theDT.Rows.Count;
return(txcurrcount);
}
public ArrayList gettxcurrlinelist(string reportingdate)
{
ReportingResultsManager reportingLogic = new ReportingResultsManager();
//int txcurrcount = 0;
DataTable theDT = reportingLogic.gettxcurr(Convert.ToDateTime(reportingdate));
ArrayList rows = new ArrayList();
int n = 0;
foreach (DataRow items in theDT.Rows)
{
n = n + 1;
string[] i = new string[13] {
n.ToString(), items["CCCNumber"].ToString(), items["FirstName"].ToString(), items["MiddleName"].ToString(), items["LastName"].ToString(), items["MobileNumber"].ToString(), Convert.ToDateTime(items["DispenseDate"]).ToString("dd-MMM-yyyy"), items["Drug"].ToString(), Convert.ToDateTime(items["ExpectedReturn"]).ToString("dd-MMM-yyyy"), items["DaysOverDue"].ToString(), items["Traced"].ToString(), items["PID"].ToString(), items["personid"].ToString()
};
rows.Add(i);
}
return(rows);
}