public decimal GetTotalVideoByEquipment(int idVideo)
{
return(_context.VideoEquipment
.Include("Equipment")
.Include("Video")
.Where(VideoEquipmentSpecs.GetTotalByEquipment(idVideo)).Sum(x => x.Video.Plan.ValueEquipmentMain));//verificar aqui a lógica
}
public int GetCount(string word)
{
return(_context.VideoEquipment
.Include("Equipment")
.Include("Video")
.Where(VideoEquipmentSpecs.GetVideoEquipment(word)).Count());
}
public List <VideoEquipment> GetByRange(int skip, int take, string word)
{
return(_context.VideoEquipment
.Include("Equipment")
.Include("Video")
.Where(VideoEquipmentSpecs.GetVideoEquipment(word))
.Skip((skip - 1) * take).Take(take).ToList());
}
public List <VideoEquipment> GetAllByVideo(int video)
{
return(_context.VideoEquipment
.Include("Equipment")
.Include("Video")
.Include("Video.Plan")
.Include("Video.Company")
.Include("ControlLoan.Company")
.Where(VideoEquipmentSpecs.GetByVideo(video)).ToList());
}
public List <VideoEquipment> GetByRange(int skip, int take, int id)
{
return(_context.VideoEquipment
.Include("Equipment")
.Include("Video")
.Include("Video.Plan")
.Include("Video.Company")
.Where(VideoEquipmentSpecs.GetVideoEquipmentByCompany(id))
.OrderBy(x => x.IdVideoEquipment)
.Skip((skip - 1) * take).Take(take).ToList());
}
public VideoEquipment GetIdVideoEquipment(int equipment, int video)
{
return(_context.VideoEquipment
.SingleOrDefault(VideoEquipmentSpecs.GetIdVideoEquipment(equipment, video)));
}
public int GetVideoCountByCompany(int id)
{
return(_context.VideoEquipment
.Where(VideoEquipmentSpecs.GetVideoByCompany(id)).Count());
}
public int GetVideoCountByEquipment(int idVideo)
{
return(_context.VideoEquipment
.Where(VideoEquipmentSpecs.GetTotalByEquipment(idVideo)).Count());// não estou usando ***verificar
}
