public static List <DispositionRow> OldGetResearchRows(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(),
TIDCheckNum = Convert.ToInt32(dataRow["TID Check Number"].ToString()),
TIDCheckDisposition = dataRow["TID Check Disposition"].ToString(),
TDLCheckNum = Convert.ToInt32(dataRow["TDL Check Number"].ToString()),
TDLCheckDisposition = dataRow["TDL Check Disposition"].ToString(),
MBVDCheckNum = Convert.ToInt32(dataRow["MBVD Check Number"].ToString()),
MBVDCheckDisposition = dataRow["MBVD Check 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 <ModificationRow> GetModificationRows(string filePath)
{
List <ModificationRow> modRows = new ExcelData(filePath).GetData().Select(dataRow => new ModificationRow
{
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()),
Date = Convert.ToDateTime(dataRow["OPID Modification Date"].ToString()),
// ModificationType = dataRow["Modification Type"].ToString(),
LBVDModificationReason = dataRow["LBVD Modification Reason"].ToString(),
LBVDCheckNum = Convert.ToInt32(dataRow["LBVD Modified Check Number"].ToString()),
LBVDCheckDisposition = dataRow["LBVD Modified Check Disposition"].ToString(),
TIDModificationReason = dataRow["TID Modification Reason"].ToString(),
TIDCheckNum = Convert.ToInt32(dataRow["TID Modified Check Number"].ToString()),
TIDCheckDisposition = dataRow["TID Modified Check Disposition"].ToString(),
TDLModificationReason = dataRow["TDL Modification Reason"].ToString(),
TDLCheckNum = Convert.ToInt32(dataRow["TDL Modified Check Number"].ToString()),
TDLCheckDisposition = dataRow["TDL Modified Check Disposition"].ToString(),
MBVDModificationReason = dataRow["MBVD Modification Reason"].ToString(),
MBVDCheckNum = Convert.ToInt32(dataRow["MBVD Modified Check Number"].ToString()),
MBVDCheckDisposition = dataRow["MBVD Modified Check Disposition"].ToString(),
SDMReason = dataRow["SDM Reason"].ToString(),
SDCheckNum = Convert.ToInt32(dataRow["SDM Check Number"].ToString()),
SDCheckDisposition = dataRow["SDM Check Disposition"].ToString()
}).ToList();
return(modRows);
}
public static List <EmptyCol> GetEmptyFile(string filePath)
{
List <EmptyCol> emptyCols = new ExcelData(filePath).GetData().Select(dataRow =>
new EmptyCol
{
Empty = GetEmpty(dataRow)
}).ToList();
return(emptyCols);
}
/*
* public static List<ResearchCheck> GetResearchChecks(string filePath)
* {
* List<ResearchCheck> resChecks = new ExcelData(filePath).GetData().Select(dataRow => new ResearchCheck
* {
* Date = Convert.ToDateTime(dataRow["Date"].ToString()),
* RecordID = Convert.ToInt32(dataRow["Record ID"].ToString()),
* InterviewRecordID = (DBNull.Value.Equals(dataRow["Interview Record ID"]) ? 0 : Convert.ToInt32(dataRow["Interview Record ID"].ToString())),
* Name = dataRow["Name"].ToString(),
* Num = Convert.ToInt32(dataRow["Check Number"].ToString()),
* Service = dataRow["Service"].ToString(),
* Disposition = dataRow["Disposition"].ToString()
* }).ToList();
*
* return resChecks;
* }
*/
public static List <UnresolvedCheck> GetUnresolvedChecks(string filePath)
{
List <UnresolvedCheck> unresolvedChecks = new ExcelData(filePath).GetData().Select(dataRow => new UnresolvedCheck
{
Date = Convert.ToDateTime(dataRow["Date"].ToString()),
RecordID = Convert.ToInt32(dataRow["Record ID"].ToString()),
InterviewRecordID = (DBNull.Value.Equals(dataRow["Interview Record ID"]) ? 0 : Convert.ToInt32(dataRow["Interview Record ID"].ToString())),
Name = dataRow["Name"].ToString(),
Num = Convert.ToInt32(dataRow["Check Number"].ToString()),
Service = dataRow["Service"].ToString(),
Disposition = dataRow["Disposition"].ToString()
}).ToList();
return(unresolvedChecks);
}
public static List <Check> GetQuickbooksChecks(string filePath)
{
int k = 0;
List <Check> rowChecks = new ExcelData(filePath).GetData().Select(dataRow =>
GetClearedCheck(dataRow, k++)
).ToList();
List <Check> quickbooksChecks = new List <Check>();
// Remove checks corresponding to blank rows in Excel file.
foreach (Check check in rowChecks)
{
if (check.Num != 0) // check.Num == 0 denotes blank row. Could be because Num = EFT. See GetCheckNum.
//if (!check.Memo.Equals("NoCheck"))
{
quickbooksChecks.Add(check);
}
}
return(quickbooksChecks);
}
public static List <Check> GetVoidedChecks(string filePath)
{
List <Check> rowChecks = new ExcelData(filePath).GetData().Select(dataRow =>
new Check
{
Date = GetDateValue(dataRow),
Num = GetCheckNum(dataRow),
Memo = GetMemo(dataRow)
}).ToList();
List <Check> voidedChecks = new List <Check>();
// Remove checks corresponding to blank rows in Excel file.
foreach (Check check in rowChecks)
{
if (!check.Memo.Equals("NoCheck"))
{
voidedChecks.Add(check);
}
}
return(voidedChecks);
}
public static List <Check> GetVoidedChecks(string filePath)
{
List <Check> rowChecks = new ExcelData(filePath).GetData().Select(dataRow =>
new Check
{
Date = GetDateValue(dataRow), // PLB 10/12/2017 Used when clicking on Inspect tab.
Num = GetCheckNum(dataRow),
Memo = "Voided check" //GetMemo(dataRow),
}).ToList();
List <Check> voidedChecks = new List <Check>();
// Remove checks corresponding to blank rows in Excel file.
foreach (Check check in rowChecks)
{
if (check.Num != 0) // if (!check.Memo.Equals("NoCheck"))
{
voidedChecks.Add(check);
}
}
return(voidedChecks);
}
public static List <Check> GetImportMeChecks(string filePath)
{
List <Check> importedChecks = new List <Check>();
List <ImportRow> rowChecks = new ExcelData(filePath).GetData().Select(dataRow =>
new ImportRow
{
Date = DateTime.Today, // PLB 12/19/2018 Used when clicking on Inspect tab.
RecordID = GetRowRID(dataRow),
// LBVD
LBVDCheckNum = GetRowCheckNum(dataRow, "LBVD"),
LBVDCheckDisposition = GetRowCheckDisposition(dataRow, "LBVDD"),
LBVDCheckNum2 = GetRowCheckNum(dataRow, "LBVD2"),
LBVDCheck2Disposition = GetRowCheckDisposition(dataRow, "LBVD2D"),
LBVDCheckNum3 = GetRowCheckNum(dataRow, "LBVD3"),
LBVDCheck3Disposition = GetRowCheckDisposition(dataRow, "LBVD3D"),
// TID
TIDCheckNum = GetRowCheckNum(dataRow, "TID"),
TIDCheckDisposition = GetRowCheckDisposition(dataRow, "TIDD"),
TIDCheckNum2 = GetRowCheckNum(dataRow, "TID2"),
TIDCheck2Disposition = GetRowCheckDisposition(dataRow, "TID2D"),
TIDCheckNum3 = GetRowCheckNum(dataRow, "TID3"),
TIDCheck3Disposition = GetRowCheckDisposition(dataRow, "TID3D"),
// TDL
TDLCheckNum = GetRowCheckNum(dataRow, "TDL"),
TDLCheckDisposition = GetRowCheckDisposition(dataRow, "TDLD"),
TDLCheckNum2 = GetRowCheckNum(dataRow, "TDL2"),
TDLCheck2Disposition = GetRowCheckDisposition(dataRow, "TDL2D"),
TDLCheckNum3 = GetRowCheckNum(dataRow, "TDL3"),
TDLCheck3Disposition = GetRowCheckDisposition(dataRow, "TDL3D"),
// MBVD
MBVDCheckNum = GetRowCheckNum(dataRow, "MBVD"),
MBVDCheckDisposition = GetRowCheckDisposition(dataRow, "MBVDD"),
MBVDCheckNum2 = GetRowCheckNum(dataRow, "MBVD2"),
MBVDCheck2Disposition = GetRowCheckDisposition(dataRow, "MBVD2D"),
MBVDCheckNum3 = GetRowCheckNum(dataRow, "MBVD3"),
MBVDCheck3Disposition = GetRowCheckDisposition(dataRow, "MBVD3D")
}).ToList();
foreach (ImportRow row in rowChecks)
{
// LBVD
if (row.LBVDCheckNum != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.LBVDCheckNum,
Service = "LBVD",
Disposition = row.LBVDCheckDisposition
});
}
if (row.LBVDCheckNum2 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.LBVDCheckNum2,
Service = "LBVD2",
Disposition = row.LBVDCheck2Disposition
});
}
if (row.LBVDCheckNum3 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.LBVDCheckNum3,
Service = "LBVD3",
Disposition = row.LBVDCheck3Disposition
});
}
// TID
if (row.TIDCheckNum != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.TIDCheckNum,
Service = "TID",
Disposition = row.TIDCheckDisposition
});
}
if (row.TIDCheckNum2 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.TIDCheckNum2,
Service = "TID2",
Disposition = row.TIDCheck2Disposition
});
}
if (row.TIDCheckNum3 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.TIDCheckNum3,
Service = "TID3",
Disposition = row.TIDCheck3Disposition
});
}
// TDL
if (row.TDLCheckNum != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.TDLCheckNum,
Service = "TDL",
Disposition = row.TDLCheckDisposition
});
}
if (row.TDLCheckNum2 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.TDLCheckNum2,
Service = "TDL2",
Disposition = row.TDLCheck2Disposition
});
}
if (row.TDLCheckNum3 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.TDLCheckNum3,
Service = "TDL3",
Disposition = row.TDLCheck3Disposition
});
}
// MBVD
if (row.MBVDCheckNum != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.MBVDCheckNum,
Service = "MBVD",
Disposition = row.MBVDCheckDisposition
});
}
if (row.MBVDCheckNum2 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.MBVDCheckNum2,
Service = "MBVD2",
Disposition = row.MBVDCheck2Disposition
});
}
if (row.MBVDCheckNum3 != 0)
{
importedChecks.Add(new Check
{
InterviewRecordID = row.RecordID,
Date = row.Date,
Num = row.MBVDCheckNum3,
Service = "MBVD3",
Disposition = row.MBVDCheck3Disposition
});
}
}
return(importedChecks);
}