public string GetAsyncReportByID(string TransactionID)
{
DataControl.CurrentInfo _objCurrentInfo = new CurrentInfo();
string CompanyCode = _objCurrentInfo.GetCompanyCode();
string UserCode = _objCurrentInfo.GetUserCode();
string HTMLFileContent = string.Empty;
DataControl.HiDoctor_ReportsFactoryClasses.BL_ReportRegion objBLReportRegion = new DataControl.HiDoctor_ReportsFactoryClasses.BL_ReportRegion();
try
{
List <MVCModels.HiDoctor_Reports.UsersReportQueues> ReportQueueByID = objBLReportRegion.GetReportQueueByID(CompanyCode, TransactionID).ToList();
using (WebClient client = new WebClient())
{
HTMLFileContent = client.DownloadString(ReportQueueByID.FirstOrDefault().HTML_File_Path.ToString());
}
return(HTMLFileContent);
}
finally
{
_objCurrentInfo = null;
objBLReportRegion = null;
}
}
public string GetReportProcessQueueStatus(string ReportName)
{
DataControl.CurrentInfo _objCurrentInfo = new CurrentInfo();
string CompanyCode = _objcurrentInfo.GetCompanyCode();
string UserCode = _objCurrentInfo.GetUserCode();
DataControl.HiDoctor_ReportsFactoryClasses.BL_ReportRegion objBLReportRegion = new DataControl.HiDoctor_ReportsFactoryClasses.BL_ReportRegion();
List <MVCModels.HiDoctor_Reports.UsersReportQueues> lstReportQueue = objBLReportRegion.GetUsersReportProcessQueue(CompanyCode, UserCode, ReportName).ToList();
StringBuilder strTbl = new StringBuilder();
// strTbl.Append("<div><input type='button' value='Refresh' onclick='fnRefresh();'></input></div>");
strTbl.Append("<table WIDTH='90%' id='tblsummary' class='table table-striped'>");
strTbl.Append("<thead class='active'>");
strTbl.Append("<tr>");
strTbl.Append("<td width='25%'>Transaction ID</td><td width='10%'>Report Request Date time</td><td width='28%'>Report Parameters</td><td width='10%'>Process State</td><td width='17%'>Action</td>");
strTbl.Append("</tr>");
strTbl.Append("</thead>");
strTbl.Append("<tbody>");
if (lstReportQueue != null)
{
foreach (var item in lstReportQueue)
{
if (ReportName == "ProductWiseDoctorTabularReport")
{
string[] seperators = { "<br/>" };
string value = item.Report_Parameters;
string[] result = value.Split(seperators, StringSplitOptions.RemoveEmptyEntries);
result[2] = result[2].Replace("1", "Doctor Wise Product").Replace("2", "Product Wise Doctor").Replace("^", ",");
result[3] = result[3].Replace("0", "UnApproved").Replace("1", "Applied").Replace("2", "Approved").Replace("^", ",");
result[4] = result[4].Replace("1", "Exclude Quantity Given 0").Replace("2", "Include Quantity given 0");
strTbl.Append("<tr>");
strTbl.Append("<td>" + item.Transaction_ID + "</td>");
strTbl.Append("<td>" + item.Rpt_Req_DateTime + "</td>");
strTbl.Append("<td>" + result[0] + "<br/>" + result[1] + "<br/>" + result[2] + "<br/>" + result[3] + "<br/>" + result[4] + "</td>");
// strTbl.Append("<td>" + item.Report_Parameters + "</td>");
strTbl.Append("<td>" + item.Process_State + "</td>");
if (item.Process_State.Trim() == "Completed")
{
//strTbl.Append("<td class='td-a'><a onclick='fnGetAsyncReportByID(\"" + item.Transaction_ID + "," + ReportName + "\");'>View</a></td>");
strTbl.Append("<td class='td-a'><a onclick='fnGetAsyncReportByID(\"" + item.Transaction_ID + "\",\"" + ReportName + "\");'>View</a></td>");
}
else if (item.Process_State.Trim() == "Error")
{
strTbl.Append("<td class='td'>" + item.User_Error_Desc + "</td>");
}
else
{
strTbl.Append("<td>" + item.Process_State + "</td>");
}
strTbl.Append("</tr>");
}
else
{
strTbl.Append("<tr>");
strTbl.Append("<td>" + item.Transaction_ID + "</td>");
strTbl.Append("<td>" + item.Rpt_Req_DateTime + "</td>");
strTbl.Append("<td>" + item.Report_Parameters + "</td>");
strTbl.Append("<td>" + item.Process_State + "</td>");
if (item.Process_State.Trim() == "Completed")
{
//strTbl.Append("<td class='td-a'><a onclick='fnGetAsyncReportByID(\"" + item.Transaction_ID + "," + ReportName + "\");'>View</a></td>");
strTbl.Append("<td class='td-a'><a onclick='fnGetAsyncReportByID(\"" + item.Transaction_ID + "\",\"" + ReportName + "\");'>View</a></td>");
}
else if (item.Process_State.Trim() == "Error")
{
strTbl.Append("<td class='td'>" + item.User_Error_Desc + "</td>");
}
else
{
strTbl.Append("<td>" + item.Process_State + "</td>");
}
strTbl.Append("</tr>");
}
}
}
else
{
strTbl.Append("<tr><td colspan='4' style='text-align:center;'>No Details Found.</td></tr>");
}
strTbl.Append("</tbody>");
strTbl.Append("</table>");
return(strTbl.ToString());
}
