public Customer GetById(Guid id)
{
using (var context = new RepositoryContext())
{
IQueryable<Customer> query = context.Set<Customer>().Include("Transactions");
return query.First(x => x.CustomerID == id);
}
}
public Customer GetByName(string name, string surname)
{
using (var context = new RepositoryContext())
{
IQueryable<Customer> query = context.Set<Customer>().Include("Transactions");
return query.First(x => x.Name == name && x.Surmame==surname);
}
}
public IEnumerable<Customer> GetAll()
{
using (var context = new RepositoryContext())
{
IQueryable<Customer> query= context.Set<Customer>().Include("Transactions");
return query.ToList();
}
}