示例#1
0
        public async Task <IPagedResponse <EmployeeDeclarationResponse> > GetEmployeeHealteDeclarationAsync(int pageSize             = 10, int pageNumber = 1, int?OrganizationId = null, int?SiteId = null,
                                                                                                            bool isHealthDeclaration = false)//, int? SiteId = null, DateTime? DateFrom = null, DateTime? DateTo = null)
        {
            var response = new PagedResponse <EmployeeDeclarationResponse>();

            // Get the "proposed" query from repository
            var query = DbContext.GetEmployeeHealteDeclaration(OrganizationId, SiteId, isHealthDeclaration);// אם רוצים לפי סינונים מסוימים אז יש להשתמש בפונקציה

            // Set paging values

            // response.ItemsCount = await query.CountAsync();

            response.PageSize   = pageSize;
            response.PageNumber = pageNumber;
            response.ItemsCount = await query.CountAsync();


            response.Model = await query
                             //.Paging(pageSize, pageNumber)
                             .ToListAsync();


            //Distinct
            response.Model = response.Model.GroupBy(s => s.EmployeeId)
                             .Select(grp => grp.FirstOrDefault())
                             .ToList();

            //סינון לפי אב
            response.Model = response.Model.OrderBy(x => x.FirstName);

            //מי משויך לאתר
            response.Model = SiteId.HasValue ? response.Model.Where(x => x.SiteId == SiteId) : response.Model;


            var rr = response.Model;



            response.PageSize   = pageSize;
            response.PageNumber = pageNumber;
            response.ItemsCount = response.Model.Count();
            response.SetMessagePages(nameof(GetEmployeesAsync), pageNumber, response.PageCount, response.ItemsCount);
            // throw new NotImplementedException();
            return(response);
        }
示例#2
0
        public async Task <IPagedResponse <OrganizationRequest> > GetOrganizationsAsync(int pageSize = 10, int pageNumber = 1, int?OrganizationId = null, string OrganizationName = null, int?OrganizationNumber = null, int?OrganizationExpertiseTypeId = null, int?OrganizationParentId = null)
        {
            var response = new PagedResponse <OrganizationRequest>();

            // Get the "proposed" query from repository
            var query = DbContext.GetOrganization(OrganizationId, OrganizationName, OrganizationNumber, OrganizationExpertiseTypeId, OrganizationParentId); // אם רוצים לפי סינונים מסוימים אז יש להשתמש בפונקציה

            // Set paging values
            response.PageSize   = pageSize;
            response.PageNumber = pageNumber;
            response.ItemsCount = await query.CountAsync();

            // Get the specific page from database
            // response.Model = await query.Paging(pageSize, pageNumber).ToListAsync();

            response.SetMessagePages(nameof(GetOrganizationsAsync), pageNumber, response.PageCount, response.ItemsCount);

            response.Model = await query
                             .Paging(pageSize, pageNumber)
                             .ToListAsync();

            // throw new NotImplementedException();
            return(response);
        }
示例#3
0
        public async Task <IPagedResponse <EmployeeResponse> > GetEmployeesAsync(int pageSize               = 10, int pageNumber = 1, int?EmployeeId = null, string EmployeeName = null, string IdentityNumber = null, int?OrganizationId = null, int?PassportCountryId = null, int?ProffesionType = null, int?SiteId = null, int?EmployeeIsNotInSiteId = null, bool isEmployeeEntry = false, bool sortByAuthtorization = false,
                                                                                 bool sortByTraining        = false,
                                                                                 bool sortByWorkPermit      = false,
                                                                                 bool sortHealthDeclaration = false)//, int? SiteId = null, DateTime? DateFrom = null, DateTime? DateTo = null)
        {
            var response = new PagedResponse <EmployeeResponse>();

            // Get the "proposed" query from repository
            var query = DbContext.GetEmployee(EmployeeId, EmployeeName, IdentityNumber, OrganizationId, PassportCountryId, ProffesionType, SiteId, EmployeeIsNotInSiteId, isEmployeeEntry, sortByAuthtorization, sortByTraining, sortByWorkPermit);// אם רוצים לפי סינונים מסוימים אז יש להשתמש בפונקציה

            // Set paging values

            // response.ItemsCount = await query.CountAsync();

            response.PageSize   = pageSize;
            response.PageNumber = pageNumber;
            response.ItemsCount = await query.CountAsync();


            response.Model = await query
                             .Paging(pageSize, pageNumber)
                             .ToListAsync();


            //Distinct
            response.Model = response.Model.GroupBy(s => s.EmployeeId)
                             .Select(grp => grp.FirstOrDefault())
                             .ToList();

            //סינון לפי אב
            response.Model = response.Model.OrderBy(x => x.FirstName);

            //סינון לפי הדרכות וכו
            response.Model = sortByAuthtorization ? response.Model.OrderBy(x => x.EmployeeAuthtorization.regular) : response.Model;
            response.Model = sortByWorkPermit ? response.Model.OrderBy(x => x.EmployeeWorkPermit.regular) : response.Model;
            response.Model = sortByTraining ? response.Model.OrderBy(x => x.EmployeeTraining.regular) : response.Model;

            //סינון לפי הצהרת בריאות
            response.Model = sortHealthDeclaration  ? response.Model.OrderBy(x => x.isHealthDeclaration) : response.Model;

            //מי נמצא כרגע באתר
            response.Model = isEmployeeEntry && SiteId.HasValue ? response.Model.OrderByDescending(x => x.isEmployeeEntry) : response.Model;

            //מי משויך לאתר
            response.Model = SiteId.HasValue ? response.Model.Where(x => x.SiteId == SiteId) : response.Model;


            var rr = response.Model;

            //מי לא משויך לאתר
            if (EmployeeIsNotInSiteId.HasValue)
            {
                rr = response.Model.Where(x => x.SiteId == EmployeeIsNotInSiteId);

                foreach (var model in rr)
                {
                    response.Model = response.Model.Where(x => x.EmployeeId != model.EmployeeId);
                }
                //             response.Model = EmployeeIsNotInSiteId.HasValue ? response.Model.Where(x => x.SiteId != EmployeeIsNotInSiteId) : response.Model;
            }


            response.PageSize   = pageSize;
            response.PageNumber = pageNumber;
            response.ItemsCount = response.Model.Count();
            response.SetMessagePages(nameof(GetEmployeesAsync), pageNumber, response.PageCount, response.ItemsCount);
            // throw new NotImplementedException();
            return(response);
        }