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