public List <LACK2> GetCompletedByParam(Lack2GetByParamInput input) { Expression <Func <LACK2, bool> > queryFilter = c => c.STATUS == Enums.DocumentStatus.Completed; if (!string.IsNullOrEmpty((input.PlantId))) { queryFilter = queryFilter.And(c => c.LEVEL_PLANT_ID == input.PlantId); } if (!string.IsNullOrEmpty((input.Creator))) { queryFilter = queryFilter.And(c => c.CREATED_BY == input.Creator); } if (!string.IsNullOrEmpty((input.Poa))) { queryFilter = queryFilter.And(c => c.APPROVED_BY == input.Poa); } if (input.UserRole != Enums.UserRole.Administrator && input.UserRole != Enums.UserRole.Controller) { queryFilter = queryFilter.And(c => input.PlantList.Contains(c.LEVEL_PLANT_ID)); } Func <IQueryable <LACK2>, IOrderedQueryable <LACK2> > orderBy = null; if (!string.IsNullOrEmpty(input.SortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK2>(input.SortOrderColumn)); } var dbData = _repository.Get(queryFilter, orderBy, includeTables); return(dbData == null ? null : dbData.ToList()); }
private List <REVERSAL> GetReversalData(Expression <Func <REVERSAL, bool> > queryFilter, string orderColumn) { Func <IQueryable <REVERSAL>, IOrderedQueryable <REVERSAL> > orderBy = null; if (!string.IsNullOrEmpty(orderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <REVERSAL>(orderColumn)); } var dbData = _repository.Get(queryFilter); return(dbData.ToList()); }
public List <PRODUCTION> GetFactAllByParam(ProductionGetByParamInput input) { Expression <Func <PRODUCTION, bool> > queryFilter = PredicateHelper.True <PRODUCTION>(); if (!string.IsNullOrEmpty(input.Company)) { queryFilter = queryFilter.And(c => c.COMPANY_CODE == input.Company); } if (!string.IsNullOrEmpty(input.Plant)) { queryFilter = queryFilter.And(c => c.WERKS == input.Plant); } if (!string.IsNullOrEmpty(input.ProoductionDate)) { var dt = Convert.ToDateTime(input.ProoductionDate); queryFilter = queryFilter.And(c => c.PRODUCTION_DATE == dt); } if (input.Month > 0) { queryFilter = queryFilter.And(c => c.PRODUCTION_DATE.Month == input.Month); } if (input.Year > 0) { queryFilter = queryFilter.And(c => c.PRODUCTION_DATE.Year == input.Year); } if (!string.IsNullOrEmpty(input.UserId)) { var listUserPlant = _userPlantBll.GetPlantByUserId(input.UserId); var listPoaPlant = _poaMapBll.GetPlantByPoaId(input.UserId); queryFilter = queryFilter.And(c => listUserPlant.Contains(c.WERKS) || listPoaPlant.Contains(c.WERKS)); } Func <IQueryable <PRODUCTION>, IOrderedQueryable <PRODUCTION> > orderBy = null; { if (!string.IsNullOrEmpty(input.ShortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <PRODUCTION>(input.ShortOrderColumn)); } var dbData = _repository.Get(queryFilter, orderBy); if (dbData == null) { throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound); } var mapResult = dbData.ToList(); return(mapResult); } }
public List <Pbck1QuotaDto> GetByParam(Pbck1QuotaGetByParamInput input) { Expression <Func <PBCK1_QUOTA, bool> > queryFilter = PredicateHelper.True <PBCK1_QUOTA>(); if (!string.IsNullOrEmpty(input.CompanyCode)) { queryFilter = queryFilter.And(c => c.PBCK1 != null && c.PBCK1.NPPBKC_BUKRS == input.CompanyCode); } if (input.YearFrom.HasValue) { queryFilter = queryFilter.And( c => c.PBCK1 != null && c.PBCK1.PERIOD_FROM.HasValue && c.PBCK1.PERIOD_FROM.Value.Year >= input.YearFrom.Value); } if (input.YearTo.HasValue) { queryFilter = queryFilter.And( c => c.PBCK1 != null && c.PBCK1.PERIOD_TO.HasValue && c.PBCK1.PERIOD_TO.Value.Year >= input.YearTo.Value); } if (!string.IsNullOrEmpty(input.NppbkcId)) { queryFilter = queryFilter.And(c => c.PBCK1 != null && c.PBCK1.NPPBKC_ID == input.NppbkcId); } Func <IQueryable <PBCK1_QUOTA>, IOrderedQueryable <PBCK1_QUOTA> > orderBy = null; if (!string.IsNullOrEmpty(input.SortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <PBCK1_QUOTA>(input.SortOrderColumn)); } var dbData = _quotaRepository.Get(queryFilter, orderBy, includeTables); return(Mapper.Map <List <Pbck1QuotaDto> >(dbData.ToList())); }
public List <LACK1> GetCompletedDocumentByParam(Lack1GetByParamInput input) { includeTables += ", LACK1_PLANT"; Expression <Func <LACK1, bool> > queryFilter = c => (int)c.STATUS >= (int)Core.Enums.DocumentStatus.Completed; queryFilter = queryFilter.And(ProcessQueryFilter(input)); Func <IQueryable <LACK1>, IOrderedQueryable <LACK1> > orderBy = null; if (!string.IsNullOrEmpty(input.SortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK1>(input.SortOrderColumn)); } if (input.UserRole == Enums.UserRole.POA) { queryFilter = queryFilter.And(c => input.ListNppbkc.Contains(c.NPPBKC_ID)); } else if (input.UserRole == Enums.UserRole.Administrator) { queryFilter = queryFilter.And(c => c.LACK1_LEVEL != null); } else if (input.UserRole == Enums.UserRole.Controller) { queryFilter = queryFilter.And(c => c.STATUS == Enums.DocumentStatus.Completed); } else { queryFilter = queryFilter.And(c => (input.ListUserPlant.Contains(c.LACK1_PLANT.FirstOrDefault().PLANT_ID) && c.LACK1_LEVEL == Enums.Lack1Level.Plant) || (input.ListNppbkc.Contains(c.NPPBKC_ID) && c.LACK1_LEVEL == Enums.Lack1Level.Nppbkc)); } var dbData = _repository.Get(queryFilter, orderBy, includeTables); if (dbData == null) { throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound); } return(dbData.ToList()); }
public List <LACK1> GetAllByParam(Lack1GetByParamInput input) { includeTables += ", LACK1_PLANT"; Expression <Func <LACK1, bool> > queryFilter = c => c.LACK1_LEVEL == input.Lack1Level; queryFilter = queryFilter.And(ProcessQueryFilter(input)); Func <IQueryable <LACK1>, IOrderedQueryable <LACK1> > orderBy = c => c.OrderByDescending(l => l.LACK1_ID); if (!string.IsNullOrEmpty(input.SortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK1>(input.SortOrderColumn)); } var dbData = _repository.Get(queryFilter, orderBy, includeTables); if (dbData == null) { throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound); } return(dbData.ToList()); }
public List <ProductionDto> GetAllByParam(ProductionGetByParamInput input) { Expression <Func <PRODUCTION, bool> > queryFilter = PredicateHelper.True <PRODUCTION>(); if (!string.IsNullOrEmpty(input.Company)) { queryFilter = queryFilter.And(c => c.COMPANY_CODE == input.Company); } if (!string.IsNullOrEmpty(input.Plant)) { queryFilter = queryFilter.And(c => c.WERKS == input.Plant); } if (!string.IsNullOrEmpty(input.ProoductionDate)) { var dt = Convert.ToDateTime(input.ProoductionDate); queryFilter = queryFilter.And(c => c.PRODUCTION_DATE == dt); } if (input.UserRole != Core.Enums.UserRole.Administrator) { queryFilter = queryFilter.And(c => input.ListUserPlants.Contains(c.WERKS)); } Func <IQueryable <PRODUCTION>, IOrderedQueryable <PRODUCTION> > orderBy = null; { if (!string.IsNullOrEmpty(input.ShortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <PRODUCTION>(input.ShortOrderColumn)); } var dbData = _repository.Get(queryFilter, orderBy); if (dbData == null) { throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound); } var mapResult = Mapper.Map <List <ProductionDto> >(dbData.ToList()); return(mapResult); } }
public List <USER> GetUsers(UserInput input) { Expression <Func <USER, bool> > queryFilter = PredicateHelper.True <USER>(); if (!string.IsNullOrEmpty(input.UserName)) { queryFilter = queryFilter.And(s => s.USER_ID.Contains(input.UserName)); } if (!string.IsNullOrEmpty(input.FirstName)) { queryFilter = queryFilter.And(s => s.FIRST_NAME.Contains(input.FirstName)); } if (!string.IsNullOrEmpty(input.LastName)) { queryFilter = queryFilter.And(s => s.LAST_NAME.Contains(input.LastName)); } Func <IQueryable <USER>, IOrderedQueryable <USER> > orderBy = null; if (!string.IsNullOrEmpty(input.SortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <USER>(input.SortOrderColumn)) as IOrderedQueryable <USER>; } var rc = _repository.Get(queryFilter, orderBy); if (rc == null) { throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound); } return(rc.ToList()); }
public List <LACK2> GetByParam(Lack2GetByParamInput input) { Expression <Func <LACK2, bool> > queryFilter = PredicateHelper.True <LACK2>(); if (!string.IsNullOrEmpty((input.NppbKcId))) { queryFilter = queryFilter.And(c => c.NPPBKC_ID == input.NppbKcId); } if (!string.IsNullOrEmpty((input.PlantId))) { queryFilter = queryFilter.And(c => c.LEVEL_PLANT_ID == input.PlantId); } if (!string.IsNullOrEmpty((input.Creator))) { queryFilter = queryFilter.And(c => c.CREATED_BY == input.Creator); } if (!string.IsNullOrEmpty((input.Poa))) { queryFilter = queryFilter.And(c => c.APPROVED_BY == input.Poa); } if (input.SubmissionDate.HasValue) { var date = input.SubmissionDate.Value.Day; var month = input.SubmissionDate.Value.Month; var year = input.SubmissionDate.Value.Year; var dateToCompare = new DateTime(year, month, date); queryFilter = queryFilter.And(c => c.SUBMISSION_DATE.Equals(dateToCompare)); } queryFilter = input.IsOpenDocList ? queryFilter.And(c => c.STATUS != Enums.DocumentStatus.Completed) : queryFilter.And(c => c.STATUS == Enums.DocumentStatus.Completed); //switch (input.UserRole) //{ //case Enums.UserRole.POA: // queryFilter = queryFilter.And(c => (c.CREATED_BY == input.UserId // || (c.STATUS != Enums.DocumentStatus.Draft // && input.NppbkcList.Contains(c.NPPBKC_ID)))); // break; //case Enums.UserRole.Manager: // queryFilter = // queryFilter.And( // c => // c.STATUS != Enums.DocumentStatus.Draft && // c.STATUS != Enums.DocumentStatus.WaitingForApproval && // input.DocumentNumberList.Contains(c.LACK2_NUMBER)); // break; // default: // queryFilter = queryFilter.And(c => c.CREATED_BY == input.UserId); // break; //} if (input.UserRole != Enums.UserRole.Administrator && input.UserRole != Enums.UserRole.Controller) { queryFilter = queryFilter.And(c => input.PlantList.Contains(c.LEVEL_PLANT_ID)); } Func <IQueryable <LACK2>, IOrderedQueryable <LACK2> > orderBy = null; if (!string.IsNullOrEmpty(input.SortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK2>(input.SortOrderColumn)); } var dbData = _repository.Get(queryFilter, orderBy, includeTables); return(dbData == null ? null : dbData.ToList()); }
public List <WasteDto> GetAllByParam(WasteGetByParamInput input) { Expression <Func <WASTE, bool> > queryFilter = PredicateHelper.True <WASTE>(); if (!string.IsNullOrEmpty(input.Company)) { queryFilter = queryFilter.And(c => c.COMPANY_CODE == input.Company); } if (!string.IsNullOrEmpty(input.Plant)) { queryFilter = queryFilter.And(c => c.WERKS == input.Plant); } if (!string.IsNullOrEmpty(input.WasteProductionDate)) { var dt = Convert.ToDateTime(input.WasteProductionDate); queryFilter = queryFilter.And(c => c.WASTE_PROD_DATE == dt); } if (input.Month > 0) { queryFilter = queryFilter.And(c => c.WASTE_PROD_DATE.Month == input.Month); } if (input.Year > 0) { queryFilter = queryFilter.And(c => c.WASTE_PROD_DATE.Year == input.Year); } if (!string.IsNullOrEmpty(input.UserId)) { if (input.UserRole != Core.Enums.UserRole.Administrator) { queryFilter = queryFilter.And(c => input.ListUserPlants.Contains(c.WERKS)); } } if (input.BeginingProductionDate.HasValue) { queryFilter = queryFilter.And(c => c.WASTE_PROD_DATE >= input.BeginingProductionDate.Value); } if (input.EndProductionDate.HasValue) { queryFilter = queryFilter.And(c => c.WASTE_PROD_DATE <= input.EndProductionDate.Value); } if (!string.IsNullOrEmpty(input.FaCode)) { queryFilter = queryFilter.And(c => c.FA_CODE == input.FaCode); } Func <IQueryable <WASTE>, IOrderedQueryable <WASTE> > orderBy = null; { if (!string.IsNullOrEmpty(input.ShortOrderColumn)) { orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <WASTE>(input.ShortOrderColumn)); } var dbData = _repository.Get(queryFilter, orderBy); if (dbData == null) { throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound); } var mapResult = Mapper.Map <List <WasteDto> >(dbData.ToList()); return(mapResult); } }