/// <summary> /// Gets all Certified Packages from the Database. /// </summary> /// <returns>IList CertifiedPackage</returns> public static async Task <IList <CertifiedPackage> > GetPackagesAsync() { IList <CertifiedPackage> certifiedPackages = new List <CertifiedPackage>(); certifiedPackages = await CertifiedPackageTable.Read(CommandReadModel.SelectCertifiedPackages()); return(certifiedPackages); }
/// <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; }