/// <summary>
/// Gets the Unit Diaries from the Database
/// </summary>
/// <returns>IList UnitDiary</returns>
public static async Task <IList <UnitDiary> > GetDiariesAsync()
{
IList <UnitDiary> unitDiaries = new List <UnitDiary>();
unitDiaries = await DiaryTable.ReadDiaryTable(CommandReadModel.SelectDiaries());
return(unitDiaries);
}
/// <summary>
/// Updates the Selected Diary in the Table
/// </summary>
/// <param name="DiaryID"></param>
/// <param name="UDNumber"></param>
/// <param name="FilePath"></param>
/// <returns>Task Complete</returns>
public static async Task UpdateRegularDiaryAsync(int DiaryID, string UDNumber, string FilePath)
{
string fileName = UDNumber + ".pdf";
Task <string> SaveFile = Task.Run(() => FileOperation.CopyFile(fileName, "Diary", FilePath));
string FileSaveLocation = await SaveFile;
Task UpdateDatabase = Task.Run(() => DiaryTable.UpdateUnitDiary(CommandUpdateModel.DiaryUpdate(FileSaveLocation, DiaryID)));
await UpdateDatabase;
DiaryList.UpdateList(DiaryID, UserName, InsertDate, FileSaveLocation);
return;
}
/// <summary>
/// Updates the Associated Diary and adds a Record to the Certified Package Table
/// </summary>
/// <param name="DiaryID"></param>
/// <param name="UDNumber"></param>
/// <param name="FilePath"></param>
/// <param name="MembersEdipi"></param>
/// <param name="MembersFirstName"></param>
/// <param name="MembersLastName"></param>
/// <param name="MembersMI"></param>
/// <returns></returns>
public static async Task UpdateCertifiedPackageAsync(int DiaryID, string UDNumber, string FilePath, int MembersEdipi, string MembersFirstName, string MembersLastName, string MembersMI)
{
string fileName = UDNumber + '.' + MembersEdipi + ".pdf";
Task <string> SaveFile = Task.Run(() => FileOperation.CopyFile(fileName, "Certified Package", FilePath));
string FileSaveLocation = await SaveFile;
Task UpdateDiaryTable = Task.Run(() => DiaryTable.UpdateUnitDiary(CommandUpdateModel.DiaryUpdate(FileSaveLocation, DiaryID)));
Task InsertCertifiedPackage = Task.Run(() => CertifiedPackageTable.Insert(CommandInsertModel.InsertCertifiedPackage(DiaryID, UDNumber, MembersEdipi, MembersLastName, MembersFirstName, MembersMI)));
await UpdateDiaryTable;
await InsertCertifiedPackage;
CertifiedPackageList.UpdateList(DiaryID, UserName, InsertDate, FileSaveLocation, MembersEdipi, MembersLastName, MembersFirstName, MembersMI);
return;
}
/// <summary>
/// Inserts all Unit Diaries from the CSV into the Database
/// </summary>
/// <param name="UnitDiariesList"></param>
/// <param name="progress"></param>
/// <returns>Task Complete</returns>
public static async Task InsertDiariesAsync(IList <UnitDiary> UnitDiariesList, IProgress <ReportModel> progress)
{
Task <string> InsertTask = Task.Run(() => DiaryTable.InsertBulkDiaryInfoAsync(UnitDiariesList));
Task TimerTask = Task.Run(() => DiaryTable.BulkInsertTimer(UnitDiariesList, progress));
await Task.WhenAll(InsertTask, TimerTask);
}
