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 ByNotUploaded(int DiaryNumber)
{
IList <UnitDiary> list = CertifiedPackageList.NotUploaded()
.Where(o => o.UDNumber >= DiaryNumber)
.ToList();
return(DiaryPager.First(list, Records));
}
public static DataTable ByNotUploadedCert(string CertLastName)
{
IList <UnitDiary> list = CertifiedPackageList.NotUploaded()
.Where(o => o.LastName.Contains(CertLastName.ToUpper()))
.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 Diary Number and Certifier EDIPI
/// </summary>
/// <param name="DiaryNumber"></param>
/// <param name="CertEdipi"></param>
/// <returns>DataTable</returns>
public static DataTable ByUploaded(int DiaryNumber, int CertEdipi)
{
IList <UnitDiary> list = DiaryList.Uploaded()
.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));
}
public static DataTable ByNotUploaded(int DiaryNumber, int CertEdipi, string CertLastName)
{
IList <UnitDiary> list = CertifiedPackageList.NotUploaded()
.Where(o => o.UDNumber >= DiaryNumber)
.Where(o => o.CertifierEdipi <= CertEdipi)
.Where(o => o.LastName.Contains(CertLastName.ToUpper()))
.ToList();
return(DiaryPager.First(list, Records));
}