public ActionResult GetRiskFactorExcelFile(string UserType, string ResponseType)
{
string filename = string.Format("HCM_RiskFactor_Report_{0}.xlsx", DateTime.Now.ToString("dd'_'MM'_'yyyy HH'_'mm'_'ss"));
try
{
ModifyDashBoardData module_Obj = new ModifyDashBoardData();
DataTable dt = module_Obj.GetRiskFactorExcelFile(UserType, ResponseType, Convert.ToString(Session["VersionID"]));
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt, "HCM_RiskFactor");
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", filename));
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("Index"));
}
public string GetDashBoardInnerData(string ModuleID, string UserType)
{
try
{
ModifyDashBoardData module_Obj = new ModifyDashBoardData();
DataTable dt = module_Obj.GetDashBoardInnerData(ModuleID, UserType, Convert.ToString(Session["VersionID"]));
string json = JsonConvert.SerializeObject(dt, Formatting.Indented);
return(json);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetDashBoardData()
{
try
{
List <HCM_DashBoard> dashBrd_list = new List <HCM_DashBoard>();
ModifyDashBoardData module_Obj = new ModifyDashBoardData();
dashBrd_list = module_Obj.GetDashBoardData(Convert.ToString(Session["VersionID"]));
return(Json(dashBrd_list, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public string GetRiskFactorGuageData()
{
try
{
ModifyDashBoardData module_Obj = new ModifyDashBoardData();
DataTable dt = module_Obj.GetRiskFactorGuageData(Convert.ToString(Session["VersionID"]));
string json = JsonConvert.SerializeObject(dt, Formatting.Indented);
return(json);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetOverallRiskScoreData()
{
try
{
List <HCM_DashBoard> Overall_riskScore_list = new List <HCM_DashBoard>();
ModifyDashBoardData Overall_riskScore_Obj = new ModifyDashBoardData();
Overall_riskScore_list = Overall_riskScore_Obj.GetOverallRiskScoreData(Convert.ToString(Session["VersionID"]));
return(Json(Overall_riskScore_list, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
