//[AuthorizeController.CustomAuthorize]
public ActionResult RiskManagementGraphPrint(ModelViewRiskReport model)
{
if (string.IsNullOrEmpty(model.Year))
{
model.Year = DateTime.Now.Year.ToString();
}
if (string.IsNullOrEmpty(model.Type))
{
model.Type = "risk";
}
if (model.strLists != null)
{
model.Lists = model.strLists.Split(',').ToList();
}
DAL.DAL dal = new DAL.DAL();
List <string> riskType = new List <string>();
if (model.strRiskType != null)
{
riskType = model.strRiskType.Split(',').ToList();
}
ViewData["RiskType"] = riskType;
ViewData["AcceptanceCriteria"] = dal.ReadData(
"SELECT RISK_CRITERIA, UPDATE_DATE, UPDATE_BY FROM RISK_THRESHOLD",
x => new ModelAcceptanceCriteria(x)).Select(x => x.RISK_CRITERIA).FirstOrDefault();
List <ModelGetRisk> riskReport = this.GetData(model);
return(View(riskReport));
}
public ActionResult RiskManagementGraphExport(ModelViewRiskReport model)
{
return(new ActionAsPdf("RiskManagementGraphPrint", model)
{
//FileName = "Test.pdf",
PageSize = Size.A4,
PageOrientation = Orientation.Landscape,
PageMargins = new Margins(5, 0, 5, 0),
CustomSwitches = "--enable-javascript"
});
}
private List <ModelGetRisk> GetData(ModelViewRiskReport model)
{
string strCommand = $"SELECT * FROM VIEW_RISK_HISTORY WHERE YEAR = {model.Year}";
if (model.Type.Equals("risk"))
{
strCommand = $"{strCommand} AND (RISK_SCORE_RISK = 'RISK' OR INTERNAL_CORROSION_RISK = 'RISK' OR EXTERNAL_CORROSION_RISK = 'RISK' OR THIRD_PARTY_INTERFERENCE_RISK = 'RISK' OR LOSS_OF_GROUND_SUPPORT_RISK = 'RISK')";
}
else if (model.Lists != null)
{
if (model.Type.Equals("region"))
{
strCommand = $"{strCommand} AND REGION IN ('{ string.Join("','", model.Lists) }')";
}
else if (model.Type.Equals("license"))
{
strCommand = $"{strCommand} AND LICENSE_NO IN ('{ string.Join("','", model.Lists) }')";
}
}
DAL.DAL dal = new DAL.DAL();
List <ModelGetRisk> riskReport = dal.ReadData(strCommand, x => new ModelGetRisk(x)).ToList();
riskReport.ForEach(x =>
{
ModelViewRiskImport _model = new ModelViewRiskImport
{
RC_NAME = x.RC_NAME,
YEAR = x.YEAR
};
string _path = GetPathUploadPath(_model);;
string[] FileList = new string[] { };
if (Directory.Exists(_path))
{
DirectoryInfo d = new DirectoryInfo(_path);
FileInfo[] Files = d.GetFiles(); //Getting files
FileList = Files.Select(s => s.Name).ToArray();
}
x.FILES = FileList;
x.HAS_FILE = FileList.Count() > 0;
});
return(riskReport);
}
//[AuthorizeController.CustomAuthorize]
public JsonResult Json(ModelViewRiskReport model)
{
List <ModelGetRisk> riskReport = this.GetData(model);
return(Json(riskReport, JsonRequestBehavior.AllowGet));
}
