public Order GetOrderById(int id)
{
using (var context = new GlassContext())
{
return(context.OrderSet.Find(id));
}
}
public void SaveUpdatedGlass(Glass glass)
{
using (var context = new GlassContext())
{
context.Entry(glass).State = EntityState.Modified;
context.SaveChanges();
}
}
public void SaveNewGlass(Glass glass)
{
using (var context = new GlassContext())
{
context.GlassSet.Add(glass);
context.SaveChanges();
}
}
public Customer GetCustomerById(int id)
{
using (var context = new GlassContext())
{
return(context.CustomerSet.Find(id));
// return context.CustomerSet.AsNoTracking().SingleOrDefault(n => n.Id == id);
}
}
public Glass GetGlassById(int id)
{
using (var context = new GlassContext())
{
return(context.GlassSet.Find(id));
// return context.GlassSet.AsNoTracking().SingleOrDefault(g => g.Id == id);
}
}
public void SaveNewCustomer(Customer customer)
{
using (var context = new GlassContext())
{
context.CustomerSet.Add(customer);
context.SaveChanges();
}
}
public void SaveUpdatedCustomer(Customer customer)
{
using (var context = new GlassContext())
{
context.Entry(customer).State = EntityState.Modified;
context.SaveChanges();
}
}
public Customer GetCustomerWithOrders(int id)
{
using (var context = new GlassContext())
{
return(context.CustomerSet.AsNoTracking().Include(c => c.OrdersList)
.FirstOrDefault(n => n.Id == id));
}
}
public void SaveUpdatedOrder(Order order)
{
using (var context = new GlassContext())
{
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
}
public void SaveNewOrder(Order order) //, int customerId
{
using (var context = new GlassContext())
{
context.OrderSet.Add(order);
context.SaveChanges();
}
}
public void DeleteGlass(int glassId)
{
using (var context = new GlassContext())
{
var glass = context.GlassSet.Find(glassId);
context.Entry(glass).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void DeleteCustomer(int customerId)
{
using (var context = new GlassContext())
{
var customer = context.CustomerSet.Find(customerId);
context.Entry(customer).State = EntityState.Deleted;
context.SaveChanges();
}
}
public IEnumerable GetOrderList()
{
using (var context = new GlassContext())
{
return(context.OrderSet.AsNoTracking()
.OrderBy(o => o.Number)
.Select(o => new { o.Id, o.Number }).ToList()); //, o.DateTime, o.Customer, o.CustomerId
}
}
//public List<Glass> GetGlassesWithCustomer()
//{
// using (var context = new GlassContext())
// {
// //return context.GlassSet.Include(g => g.Customer).Include(g => g.Order).ToList();
// return context.GlassSet.AsNoTracking()
// .Include(g => g.Customer).ToList();
// }
//}
//public List<Glass> GetGlassesWithOrderCustomer()
//{
// using (var context = new GlassContext())
// {
// //return context.GlassSet.Include(g => g.Customer).Include(g => g.Order).ToList();
// return context.GlassSet.AsNoTracking()
// .Include(g => g.Customer)
// .Include(g => g.Order).ToList();
// }
//}
public Glass GetGlassWithOrder(int id)
{
using (var context = new GlassContext())
{
return(context.GlassSet.AsNoTracking()
.Include(g => g.Order)
.FirstOrDefault(g => g.Id == id)); //.Include(g => g.Customer)
}
}
public List <Glass> GetGlassesWithOrder()
{
using (var context = new GlassContext())
{
//return context.GlassSet.Include(g => g.Customer).Include(g => g.Order).ToList();
return(context.GlassSet.AsNoTracking()
.Include(g => g.Order).ToList());
}
}
//public Order GetOrderById(int id)
//{
// using (var context = new GlassContext())
// {
// Order order = context.OrderSet.Find(id);
// Customer customer = GetCustomerById(order.CustomerId);
// order.Customer = customer;
// return order;
// }
//}
public void DeleteOrder(int orderId)
{
using (var context = new GlassContext())
{
var order = context.OrderSet.Find(orderId);
context.Entry(order).State = EntityState.Deleted;
context.SaveChanges();
}
}
public IEnumerable GetCustomerList()
{
using (var context = new GlassContext())
{
return(context.CustomerSet.AsNoTracking()
.OrderBy(c => c.Name)
.Select(c => new { c.Id, c.Name }).ToList()); //, c.Address, c.Phone, c.OrdersList, c.GlassesList
}
}
public Order GetOrderWithCustomerAndGlasses(int id)
{
using (var context = new GlassContext())
{
return(context.OrderSet.AsNoTracking()
.Include(o => o.GlassesList)
.Include(o => o.Customer)
.FirstOrDefault(o => o.Id == id));
}
}
/// <summary>
/// Customer
/// </summary>
/// <returns></returns>
///
#region Customer
public List <Customer> GetCustomersWithOrders()
{
using (var context = new GlassContext())
{
//return context.GlassSet.Include(g => g.Customer).Include(g => g.Order).ToList();
return(context.CustomerSet.AsNoTracking()
.OrderBy(c => c.Name)
.Include(c => c.OrdersList).ToList());
}
}
/// <summary>
/// Order
/// </summary>
/// <returns></returns>
#region Order
public List <Order> GetOrdersWithCustomers()
{
using (var context = new GlassContext())
{
//return context.GlassSet..OrderBy(o => o.Number).Include(o => o.Customer).Include(o => o.GlassesList).ToList();
return(context.OrderSet.AsNoTracking()
.OrderBy(o => o.Number)
.Include(o => o.Customer)
.Include(o => o.GlassesList).ToList());
}
}
/// <summary>
/// Glass
/// </summary>
/// <param name="query"></param>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List <Glass> GetQueryableGlassWithOrderCustomer(string query, int page, int pageSize)
{
using (var context = new GlassContext())
{
context.Database.Log = message => Debug.WriteLine(message);
var linqQuery = context.GlassSet.Include(g => g.Order); //.Include(g => g.Customer)
if (!string.IsNullOrEmpty(query))
{
linqQuery = linqQuery.Where(g => g.GlassId.Contains(query));
}
if (page > 0 && pageSize > 0)
{
linqQuery = linqQuery.OrderBy(n => n.GlassId).Skip(page - 1).Take(pageSize);
}
return(linqQuery.ToList());
}
}