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