public static List <DispositionRow> GetResearchRows(string filePath) { try { List <DispositionRow> resRows = new ExcelData(filePath).GetData().Select(dataRow => new DispositionRow { RecordID = Convert.ToInt32(dataRow["Record ID"].ToString()), Lname = dataRow["Last Name"].ToString(), Fname = dataRow["First Name"].ToString(), InterviewRecordID = Convert.ToInt32(dataRow["Interview Record ID"].ToString()), Date = Convert.ToDateTime(dataRow["OPID Interview Date"].ToString()), LBVDCheckNum = Convert.ToInt32(dataRow["LBVD Check Number"].ToString()), LBVDCheckDisposition = dataRow["LBVD Check Disposition"].ToString(), LBVDCheckNum2 = Convert.ToInt32(dataRow["LBVD Check Number Two"].ToString()), LBVDCheck2Disposition = dataRow["LBVD Check Two Disposition"].ToString(), LBVDCheckNum3 = Convert.ToInt32(dataRow["LBVD Check Number Three"].ToString()), LBVDCheck3Disposition = dataRow["LBVD Check Three Disposition"].ToString(), TIDCheckNum = Convert.ToInt32(dataRow["TID Check Number"].ToString()), TIDCheckDisposition = dataRow["TID Check Disposition"].ToString(), TIDCheckNum2 = Convert.ToInt32(dataRow["TID Check Number Two"].ToString()), TIDCheck2Disposition = dataRow["TID Check Two Disposition"].ToString(), TIDCheckNum3 = Convert.ToInt32(dataRow["TID Check Number Three"].ToString()), TIDCheck3Disposition = dataRow["TID Check Three Disposition"].ToString(), TDLCheckNum = Convert.ToInt32(dataRow["TDL Check Number"].ToString()), TDLCheckDisposition = dataRow["TDL Check Disposition"].ToString(), TDLCheckNum2 = Convert.ToInt32(dataRow["TDL Check Number Two"].ToString()), TDLCheck2Disposition = dataRow["TDL Check Two Disposition"].ToString(), TDLCheckNum3 = Convert.ToInt32(dataRow["TDL Check Number Three"].ToString()), TDLCheck3Disposition = dataRow["TDL Check Three Disposition"].ToString(), MBVDCheckNum = Convert.ToInt32(dataRow["MBVD Check Number"].ToString()), MBVDCheckDisposition = dataRow["MBVD Check Disposition"].ToString(), MBVDCheckNum2 = Convert.ToInt32(dataRow["MBVD Check Number Two"].ToString()), MBVDCheck2Disposition = dataRow["MBVD Check Two Disposition"].ToString(), MBVDCheckNum3 = Convert.ToInt32(dataRow["MBVD Check Number Three"].ToString()), MBVDCheck3Disposition = dataRow["MBVD Check Three Disposition"].ToString(), // SDCheckNum = Convert.ToInt32(dataRow["SD Check Number"].ToString()), // SDCheckDisposition = dataRow["SD Check Disposition"].ToString() }).ToList(); return(resRows); } catch (Exception e) { return(null); } }
public static List <CheckViewModel> GetCVMS(string filePath) { List <CheckViewModel> rchecks = new ExcelData(filePath).GetData().Select(dataRow => new CheckViewModel { Date = Convert.ToDateTime(dataRow["Date"].ToString()), //dataRow["Date"].ToString(), sDate = Convert.ToDateTime(dataRow["Date"].ToString()).ToString("MM/dd/yyyy"), RecordID = Convert.ToInt32(dataRow["Record ID"].ToString()), sRecordID = dataRow["Record ID"].ToString(), InterviewRecordID = Convert.ToInt32(dataRow["Interview Record ID"].ToString()), sInterviewRecordID = dataRow["Interview Record ID"].ToString(), Name = dataRow["Name"].ToString(), Num = Convert.ToInt32(dataRow["Check Number"].ToString()), sNum = dataRow["Check Number"].ToString(), Service = dataRow["Service"].ToString(), Disposition = dataRow["Disposition"].ToString() }).ToList(); return(rchecks); }
public static List <Check> GetExcelChecks(string filePath) { List <Check> rowChecks = new ExcelData(filePath).GetData().Select(dataRow => new Check { Date = GetDateValue(dataRow), Num = GetCheckNum(dataRow), }).ToList(); List <Check> excelChecks = new List <Check>(); // Remove checks corresponding to blank rows in Excel file. foreach (Check check in rowChecks) { if (check.Num != 0) { excelChecks.Add(check); } } return(excelChecks); }