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