public SupplyQuery GetSupplyCNPJ(string cnpj) { var query = (from supply in _context.Set <Supply>() where supply.CNPJ == cnpj select new SupplyQuery { ID = supply.ID, Agent = supply.Agent, CNPJ = supply.CNPJ, CompanyName = supply.CompanyName, DateOfChange = supply.DateOfChange, DateRegister = supply.DateRegister, Email = supply.Email, Phone = supply.Phone }).SingleOrDefault(); return(query); }
public CustomerQuery GetCustomer(Guid Id) { return(_context.Set <Customer>().Where(c => c.ID.Equals(Id)) .Select(c => new CustomerQuery { CustomerId = c.ID, DateBirthday = c.DateBirthday, DateOfChange = c.DateOfChange, DateRegister = c.DateRegister, Document = c.Document, Gender = c.Gender, Phone = c.Phone }).FirstOrDefault()); }
public IEnumerable <T> GetAll() => _context.Set <T>().ToList();
public Repository(DbContextEF context) { this.context = context; this.dbSet = context.Set <TEntity>(); }
public Users Authenticate(string email, string password) { return(_context.Set <Users>().FirstOrDefault(x => x.Email.Equals(email) && x.Password.Equals(password))); }
public void AddEntity(T entity) => _context.Set <T>().Add(entity);