Esempio n. 1
0
        public static DataTable ByNotUploadedCert(int CertEdipi)
        {
            IList <UnitDiary> list = CertifiedPackageList.NotUploaded()
                                     .Where(o => o.CertifierEdipi <= CertEdipi)
                                     .ToList();

            return(DiaryPager.First(list, Records));
        }
Esempio n. 2
0
        public static DataTable ByNotUploaded(int DiaryNumber)
        {
            IList <UnitDiary> list = CertifiedPackageList.NotUploaded()
                                     .Where(o => o.UDNumber >= DiaryNumber)
                                     .ToList();

            return(DiaryPager.First(list, Records));
        }
Esempio n. 3
0
        public static DataTable ByNotUploadedCert(string CertLastName)
        {
            IList <UnitDiary> list = CertifiedPackageList.NotUploaded()
                                     .Where(o => o.LastName.Contains(CertLastName.ToUpper()))
                                     .ToList();

            return(DiaryPager.First(list, Records));
        }
Esempio n. 4
0
        /// <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));
        }
Esempio n. 5
0
        /// <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));
        }
Esempio n. 6
0
        /// <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));
        }
Esempio n. 7
0
        /// <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));
        }
Esempio n. 8
0
        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));
        }