public int GetCount(string word, EStatusEquipment status) { return(_context .Equipment .Where(EquipmentSpecs.GetEquipment(word, status)) .Count()); }
public List <Equipment> GetAllEquipmentControlLoan(string word, EStatusEquipment statusEquipment, EStatusControlLoan statusControlLoan) { List <Equipment> listEquipmentAvailable = new List <Equipment>(); List <ControlLoan> ControlLoan = (List <ControlLoan>)_context.ControlLoan.Where(ControlLoanSpecs.GetControlLoan(statusControlLoan)).ToList(); List <Equipment> Equipment = _context.Equipment.Where(EquipmentSpecs.GetEquipment(word, statusEquipment)).ToList(); var joined = ControlLoan.Join(Equipment, controlLoan => controlLoan.IdEquipment, equipment => equipment.IdEquipment, (Person, PersoneType) => new { Name = Person.IdEquipment, TypeID = PersoneType.IdEquipment }); foreach (var equi in Equipment) { foreach (var cont in ControlLoan) { if (cont.IdEquipment == equi.IdEquipment) { listEquipmentAvailable.Add(equi); } } } //joined.Where(a=>a.Name); //var result = _context.Equipment.Join(_context.ControlLoan,) //.Include("TypeEquipment") //.Where(EquipmentSpecs.GetEquipment(word, status)) //.OrderBy(x => x.Patrimony).ToList(); return(listEquipmentAvailable); }
public List <Equipment> GetByRange(int skip, int take, string word, EStatusEquipment status) { return(_context .Equipment .Include("TypeEquipment") .Where(EquipmentSpecs.GetEquipment(word, status)) .OrderBy(x => x.Patrimony).Skip((skip - 1) * take).Take(take).ToList()); }
public static Expression <Func <Equipment, bool> > GetEquipment(string word, EStatusEquipment status) { if (string.IsNullOrEmpty(word) || word.Equals("null")) { return(x => !x.IdEquipment.Equals(null) && x.StatusEquipment == status); } return(x => (x.Patrimony.Contains(word) || x.Model.Contains(word) || x.SerialNumber.Contains(word) || x.TypeEquipment.Type.Contains(word)) && x.StatusEquipment == status); }
public void Update(UpdateEquipmentCommand command, EStatusEquipment status) { if (!this.UpdateEquipmentScopeIsValid(command, status)) { return; } this.IdTypeEquipment = command.IdTypeEquipment; this.Description = command.Description; this.Model = command.Model; this.SerialNumber = command.SerialNumber; this.DateBuy = command.DateBuy; this.Patrimony = command.Patrimony; this.StatusEquipment = command.StatusEquipment; }
public int GetCount(string word, EStatusEquipment status) { return(_repository.GetCount(word, status)); }
public List <Equipment> GetByRange(int skip, int take, string word, EStatusEquipment status) { return(_repository.GetByRange(skip, take, word, status)); }
public List <Equipment> GetAllEquipmentControlLoan(string word, EStatusEquipment statusEquipment, EStatusControlLoan statusControlLoan) { return(_repository.GetAllEquipmentControlLoan(word, statusEquipment, statusControlLoan)); }
public static bool UpdateEquipmentScopeIsValid(this Equipment equipment, UpdateEquipmentCommand command, EStatusEquipment status) { return(AssertionConcern.IsSatisfiedBy( AssertionConcern.AssertNotEmpty(command.Model, "O Modelo é obrigatório"), AssertionConcern.AssertNotEmpty(command.Patrimony, "O Patrimônio é obrigatório"), AssertionConcern.AssertNotEmpty(command.SerialNumber, "O Serial é obrigatório"), AssertionConcern.AssertTrue(!status.Equals(EStatusEquipment.Desabilitado), "Não é permitido editar equipamentos desabilitados") )); }
public Task <HttpResponseMessage> GetCount(string word, EStatusEquipment status) { var countEquipment = _service.GetCount(word, status); return(CreateResponse(HttpStatusCode.OK, countEquipment)); }
public Task <HttpResponseMessage> GetByRange(int skip, string word, EStatusEquipment status, int take = 12) { var equipment = _service.GetByRange(skip, take, word, status); return(CreateResponse(HttpStatusCode.OK, equipment)); }
public void UpdateStatus(EStatusEquipment status) { this.StatusEquipment = status; }
public UpdateEquipmentCommand(int idEquipment, int idTypeEquipment, string description, string model, string serialNumber, DateTime dateBuy, string patrimony, EStatusEquipment statusEquipment) { this.IdEquipment = idEquipment; this.IdTypeEquipment = idTypeEquipment; this.Description = description; this.Model = model; this.SerialNumber = serialNumber; this.DateBuy = dateBuy; this.Patrimony = patrimony; this.StatusEquipment = statusEquipment; }