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;
}
