public static DataTable ByUploadCert(int CertEdipi) { IList <CertifiedPackage> list = CertifiedPackageList.Uploaded() .Where(o => o.CertifierEdipi <= CertEdipi) .ToList(); return(PackagePager.First(list, Records)); }
public static DataTable ByUploaded(int DiaryNumber) { IList <CertifiedPackage> list = CertifiedPackageList.Uploaded() .Where(o => o.UDNumber >= DiaryNumber) .ToList(); return(PackagePager.First(list, Records)); }
public static DataTable ByNotUploadedCert(int CertEdipi) { IList <UnitDiary> list = CertifiedPackageList.NotUploaded() .Where(o => o.CertifierEdipi <= CertEdipi) .ToList(); return(DiaryPager.First(list, Records)); }
public static DataTable ByUploadCert(string CertLastName) { IList <CertifiedPackage> list = CertifiedPackageList.Uploaded() .Where(o => o.LastName.Contains(CertLastName.ToUpper())) .ToList(); return(PackagePager.First(list, Records)); }
public static DataTable ByMember(string MemberLastName) { IList <CertifiedPackage> list = CertifiedPackageList.Uploaded() .Where(o => o.MembersLastName.Contains(MemberLastName)) .ToList(); return(PackagePager.First(list, Records)); }
public static DataTable ByUploader(string UploadUser) { IList <CertifiedPackage> list = CertifiedPackageList.Uploaded() .Where(o => o.UploadedBy.Contains(UploadUser)) .ToList(); return(PackagePager.First(list, Records)); }
public static DataTable ByNotUploaded(int DiaryNumber, string CertLastName) { IList <UnitDiary> list = CertifiedPackageList.NotUploaded() .Where(o => o.UDNumber >= DiaryNumber) .Where(o => o.LastName.Contains(CertLastName.ToUpper())) .ToList(); return(DiaryPager.First(list, Records)); }
public static DataTable ByUploaded(int DiaryNumber, string CertLastName, int CertEdipi) { IList <CertifiedPackage> list = CertifiedPackageList.Uploaded() .Where(o => o.UDNumber >= DiaryNumber) .Where(o => o.CertifierEdipi <= CertEdipi) .Where(o => o.LastName.Contains(CertLastName.ToUpper())) .ToList(); return(PackagePager.First(list, Records)); }
/// <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; }