public IEnumerable <office> GetAll()
{
using (var context = new CloudServiceProjectEntities())
{
return(context.offices.ToList());
}
}
public employee GetById(int employeeNumber)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.employees.FirstOrDefault(e => e.employeeNumber == employeeNumber));
}
}
public product GetByProductCode(string productCode)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.products
.FirstOrDefault(p => p.productCode.Equals(productCode, StringComparison.OrdinalIgnoreCase)));
}
}
public IEnumerable <customer> GetAll(int page, int count)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.customers
.OrderBy(c => c.customerNumber)
.GetPage(page, count)
.ToList());
}
}
public IEnumerable <product> GetAll(int page, int count)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.products
.OrderBy(p => p.productCode)
.GetPage(page, count)
.ToList());
}
}
public IEnumerable <employee> GetAll(int page, int count)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.employees
.OrderBy(e => e.employeeNumber)
.GetPage(page, count)
.ToList());
}
}
public IEnumerable <customer> GetAllBySalesRepresentativeEmployeeNumber(int salesRepresentativeEmployeeNumber)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.employees
.FirstOrDefault(e => e.employeeNumber == salesRepresentativeEmployeeNumber)?
.customers
.ToList()
?? Enumerable.Empty <customer>());
}
}
public IEnumerable <orderdetail> GetAllByOrderNumber(int orderNumber)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.orders
.FirstOrDefault(o => o.orderNumber == orderNumber)?
.orderdetails
.ToList()
?? Enumerable.Empty <orderdetail>());
}
}
public IEnumerable <order> GetAllByCustomerNumber(int customerNumber)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.customers
.FirstOrDefault(c => c.customerNumber == customerNumber)
.orders
.ToList()
?? Enumerable.Empty <order>());
}
}
public IEnumerable <payment> GetAll(int page, int count)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.payments
.OrderBy(p => p.customerNumber)
.ThenBy(p => p.checkNumber)
.GetPage(page, count)
.ToList());
}
}
public IEnumerable <product> GetAllByProductLine(string productLine)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.productlines
.FirstOrDefault(pl => pl.productLine1 == productLine)
.products
.ToList()
?? Enumerable.Empty <product>());
}
}
public IEnumerable <orderdetail> GetAll(int page, int count)
{
using (var context = new CloudServiceProjectEntities())
{
return(context.orderdetails
.Include("product")
.OrderBy(od => od.orderNumber)
.ThenBy(od => od.productCode)
.GetPage(page, count)
.ToList());
}
}
public office GetByOfficeCode(string officeCode)
{
if (officeCode.IsNullOrEmpty())
{
throw new ArgumentNullException(nameof(officeCode));
}
using (var context = new CloudServiceProjectEntities())
{
return(context.offices
.FirstOrDefault(o => officeCode.Equals(o.officeCode, StringComparison.OrdinalIgnoreCase)));
}
}
public employee GetByEmail(string emailAddress)
{
if (emailAddress.IsNullOrEmpty())
{
throw new ArgumentNullException(nameof(emailAddress));
}
using (var context = new CloudServiceProjectEntities())
{
return(context.employees
.FirstOrDefault(e => emailAddress.Equals(e.email, StringComparison.OrdinalIgnoreCase)));
}
}
