public static List <DispositionRow> GetResearchRows(string uploadedFileName)
{
string pathToResearchReportFile = System.Web.HttpContext.Current.Request.MapPath(string.Format("~/Uploads/{0}", uploadedFileName));
List <DispositionRow> resRows = MyExcelDataReader.GetResearchRows(pathToResearchReportFile);
return(resRows);
}
public static void RestoreResearchTable(string rtFileName)
{
string pathToResearchTableFile = System.Web.HttpContext.Current.Request.MapPath(string.Format("~/Uploads/{0}", rtFileName));
List <CheckViewModel> rchecks = MyExcelDataReader.GetCVMS(pathToResearchTableFile);
RestoreRChecksTable(rchecks);
}
public static List <Check> GetExcelChecks(string uploadedFileName, string disposition)
{
if (uploadedFileName.Equals("unknown"))
{
// Return an emmpty list of checks.
return(new List <Check>());
}
string pathToUploadedChecksFile = System.Web.HttpContext.Current.Request.MapPath(string.Format("~/Uploads/{0}", uploadedFileName));
List <Check> excelChecks = MyExcelDataReader.GetExcelChecks(pathToUploadedChecksFile);
foreach (Check check in excelChecks)
{
// Implicit status of voided checks is "Voided"
check.Disposition = disposition;
}
return(excelChecks);
}
