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