public List <Alimento> GetAllAlimentos() { using (var _dbContext = new DbUniHealthContext()) { return(_dbContext.Alimentos.ToList()); } }
public IMC GetLastIMC(string cpf) { using (var _dbContext = new DbUniHealthContext()) { return(_dbContext.IMCs.Include("Usuario").ToList().Where(x => x.Usuario.CPF == cpf).OrderByDescending(x => x.DataCalculo).FirstOrDefault()); } }
public void AddIMC(IMC imc) { using (var _dbContext = new DbUniHealthContext()) { _dbContext.IMCs.Add(imc); _dbContext.SaveChanges(); } }
public void AddAlimentoConsumido(AlimentoConsumido alimentoConsumido) { using (var _dbContext = new DbUniHealthContext()) { _dbContext.AlimentoConsumidos.Add(alimentoConsumido); _dbContext.SaveChanges(); } }
public List <AlimentoConsumido> GetAlimentosByUserDateAndRefeicao(string cpf, DateTime date, string refeicao) { using (var _dbContext = new DbUniHealthContext()) { return(_dbContext.AlimentoConsumidos .Include("Usuario") .Include("Alimento") .ToList() .Where(x => x.Usuario.CPF == cpf) .Where(x => x.Data.Date == date.Date) .Where(x => x.Refeicao == refeicao) .ToList()); } }
public PerfilUsuarioRepository(DbUniHealthContext dataContext) { _dbContext = dataContext; }
public StatusUsuarioRepository(DbUniHealthContext dataContext) { _dbContext = dataContext; }