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); }