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