/// <summary>
/// Search uploaded Diaries by Diary Number
/// </summary>
/// <param name="DiaryNumber"></param>
/// <returns>DataTable</returns>
public static DataTable ByUploaded(int DiaryNumber)
{
IList <UnitDiary> list = DiaryList.Uploaded()
.Where(o => o.UDNumber >= DiaryNumber)
.ToList();
return(DiaryPager.First(list, Records));
}
/// <summary>
/// Search by User who uploaded
/// </summary>
/// <param name="Uploader"></param>
/// <returns>DataTable</returns>
public static DataTable ByUploader(string Uploader)
{
IList <UnitDiary> list = DiaryList.Uploaded()
.Where(o => o.UploadedBy.Contains(Uploader))
.ToList();
return(DiaryPager.First(list, Records));
}
/// <summary>
/// Search Uploaded Diaries by Certifier Last Name
/// </summary>
/// <param name="CertLastName"></param>
/// <returns>DataTable</returns>
public static DataTable ByUploadedCert(string CertLastName)
{
IList <UnitDiary> list = DiaryList.Uploaded()
.Where(o => o.LastName.Contains(CertLastName))
.ToList();
return(DiaryPager.First(list, Records));
}
/// <summary>
/// Search uploaded Diaries by Certifier EDIPI
/// </summary>
/// <param name="CertEdipi"></param>
/// <returns></returns>
public static DataTable ByUploadedCert(int CertEdipi)
{
IList <UnitDiary> list = DiaryList.Uploaded()
.Where(o => o.CertifierEdipi <= CertEdipi)
.ToList();
return(DiaryPager.First(list, Records));
}
/// <summary>
/// Search by not Uploaded Diary Number and Certifier EDIPI
/// </summary>
/// <param name="DiaryNumber"></param>
/// <param name="CertEdipi"></param>
/// <returns></returns>
public static DataTable ByNotUploaded(int DiaryNumber, int CertEdipi)
{
IList <UnitDiary> list = DiaryList.NeedUploaded()
.Where(o => o.UDNumber >= DiaryNumber)
.Where(o => o.CertifierEdipi <= CertEdipi)
.ToList();
return(DiaryPager.First(list, Records));
}
/// <summary>
/// Search by Not Uploaded Diary Numbers and Certifier Last Name
/// </summary>
/// <param name="DiaryNumber"></param>
/// <param name="CertLastName"></param>
/// <returns>DataTable</returns>
public static DataTable ByNotUploaded(int DiaryNumber, string CertLastName)
{
IList <UnitDiary> list = DiaryList.NeedUploaded()
.Where(o => o.LastName.Contains(CertLastName))
.Where(o => o.UDNumber >= DiaryNumber)
.ToList();
return(DiaryPager.First(list, Records));
}
/// <summary>
/// Search Uploaded Diaries by Diary Number and Certifier EDIPI and Certifier Last Name
/// </summary>
/// <param name="DiaryNumber"></param>
/// <param name="CertLastName"></param>
/// <param name="CertEdipi"></param>
/// <returns>DataTable</returns>
public static DataTable ByUploaded(int DiaryNumber, string CertLastName, int CertEdipi)
{
IList <UnitDiary> list = DiaryList.Uploaded()
.Where(o => o.UDNumber >= DiaryNumber)
.Where(o => o.CertifierEdipi <= CertEdipi)
.Where(o => o.LastName.Contains(CertLastName))
.ToList();
return(DiaryPager.First(list, Records));
}
/// <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;
}
