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 }