public List <Stock> GetAllWithProperties()
{
LNTKEntities context = CreateContext();
var query = from x in context.Stocks
where x.ExhaustedDate == null
select new
{
Stock = x,
GroceryName = x.Grocery.Item
};
//var query = from x in context.Stocks
// select new { Stock = x, GroceryName = x.Grocery.Item, ReceivedDate
// RemainingTime = (x.ReceivedDate.AddDays((double)x.ExpirationDate)-DateTime.Now)};
var items = query.ToList();
foreach (var item in items)
{
item.Stock.GroceryName = item.GroceryName;
//if(item.RemainingTime.Days > 0)
item.Stock.RemainingTime = (item.Stock.ReceivedDate.AddDays(30) - DateTime.Now).Days;
}
return(items.ConvertAll(x => x.Stock));
}
public void CreateContext()
{
LNTKEntities context = new LNTKEntities();
context.Configuration.ProxyCreationEnabled = false;
Assert.IsTrue(context.Products.Count() > 0);
}
protected LNTKEntities CreateContext()
{
LNTKEntities context = new LNTKEntities();
context.Configuration.ProxyCreationEnabled = false;
return(context);
}
public int GetMaxId()
{
LNTKEntities context = CreateContext();
var query = from x in context.OrderDetails
orderby x.OrderDetailId descending
select x.OrderDetailId;
return(query.FirstOrDefault());
}
public int GetCountByOrder(int orderId)
{
LNTKEntities context = CreateContext();
var query = from x in context.OrderDetails
where x.OrderId == orderId
select x;
return(query.Count());
}
public object GetwithNonCompleted()
{
LNTKEntities context = CreateContext();
var query = from x in context.Orders
where x.IsCompleted == false
select x;
return(query.ToList());
}
public List <Grocery> GetAllWithProperties()
{
LNTKEntities context = CreateContext();
var query = from x in context.Groceries
select new { Grocery = x, CategoryName = x.CodeCategory.Item };
var items = query.ToList();
foreach (var item in items)
{
item.Grocery.CategoryName = item.CategoryName;
}
return(items.ConvertAll(x => x.Grocery));
}
public List <Recipe> GetAllWithProperties()
{
LNTKEntities context = CreateContext();
var query = from x in context.Recipes
select new { Recipe = x, ProductName = x.Product.Name, GroceryName = x.Grocery.Item };
var items = query.ToList();
foreach (var item in items)
{
item.Recipe.ProductName = item.ProductName;
item.Recipe.GroceryName = item.GroceryName;
}
return(items.ConvertAll(x => x.Recipe));
}
public List <Stock> GetByGroceryId(int groceryId)
{
LNTKEntities context = CreateContext();
var query = from x in context.Stocks
where x.GroceryId == groceryId
select new { Stock = x, GroceryName = x.Grocery.Item };
var items = query.ToList();
foreach (var item in items)
{
item.Stock.GroceryName = item.GroceryName;
}
return(items.ConvertAll(x => x.Stock));
}
public object GetwithNonCompletedOrderDetail()
{
LNTKEntities context = CreateContext();
var query = from x in context.OrderDetails
where x.Order.IsCompleted == false
select new { OrderDetail = x, OrderId = x.OrderId, ProductName = x.Product.Name };
var items = query.ToList();
foreach (var item in items)
{
item.OrderDetail.OrderId = item.OrderId;
item.OrderDetail.ProductName = item.ProductName;
}
return(query.ToList());
}
public object GetwithCompletedOrderDetail()
{
LNTKEntities context = CreateContext();
var query = from x in context.OrderDetails
where x.Order.IsCompleted == true
select new { OrderDetail = x, OrderId = x.OrderId, ProductName = x.Product.Name };
var items = query.ToList();
foreach (var item in items)
{
item.OrderDetail.OrderId = item.OrderId;
item.OrderDetail.ProductName = item.ProductName;
}
return(items.ConvertAll(x => x.OrderDetail).OrderByDescending(x => x.OrderId).Take(5));
}
public List <OrderDetail> GetByOrderWithProduct(int orderId)
{
LNTKEntities context = CreateContext();
var query = from x in context.OrderDetails
where x.OrderId == orderId
select new
{
OrderDetail = x,
ProductName = x.Product.Name
};
var items = query.ToList();
foreach (var item in items)
{
item.OrderDetail.ProductName = item.ProductName;
}
return(items.ConvertAll(x => x.OrderDetail));
}
public List <Recipe> GetByProductIdWithProperties(int?productId)
{
LNTKEntities context = CreateContext();
var query = from x in context.Recipes
select new { Recipe = x, ProductName = x.Product.Name, GroceryName = x.Grocery.Item };
if (productId.HasValue)
{
query = query.Where(x => x.Recipe.ProductId == productId);
}
var items = query.ToList();
foreach (var item in items)
{
item.Recipe.ProductName = item.ProductName;
item.Recipe.GroceryName = item.GroceryName;
}
return(items.ConvertAll(x => x.Recipe));
}
public List <OrderDetail> GetAllWithProperties()
{
LNTKEntities context = CreateContext();
var query = from x in context.OrderDetails
select new { OrderDetail = x,
Product = x.Product,
OrderDate = x.Order.Date,
ProductName = x.Product.Name,
CategoryName = x.Product.CodeCategory.Item };
var items = query.ToList();
foreach (var item in items)
{
item.OrderDetail.ProductPrice = item.Product.Price * (100 - DataRepository.Product.GetDiscountRate(item.Product, item.OrderDate)) / 100;
item.OrderDetail.OrderTime = item.OrderDate;
item.OrderDetail.ProductName = item.ProductName;
item.OrderDetail.CategoryName = item.CategoryName;
}
return(items.ConvertAll(x => x.OrderDetail));
}
public Recipe Get(int productId, int groceryId)
{
LNTKEntities context = CreateContext();
return(context.Recipes.FirstOrDefault(a => a.ProductId == productId && a.GroceryId == groceryId));
}
public OrderStock Get(int orderId, int stockId)
{
LNTKEntities context = CreateContext();
return(context.OrderStocks.FirstOrDefault(a => a.OrderId == orderId && a.StockId == stockId));
}
public Event Get(int eventId)
{
LNTKEntities context = CreateContext();
return(context.Events.FirstOrDefault(a => a.EventId == eventId));
}
public Product Get(int productId)
{
LNTKEntities context = CreateContext();
return(context.Products.FirstOrDefault(a => a.ProductId == productId));
}
public Product GetByName(string name)
{
LNTKEntities context = CreateContext();
return(context.Products.FirstOrDefault(a => a.Name == name));
}
public OrderDetail Get(int orderDetailId)
{
LNTKEntities context = CreateContext();
return(context.OrderDetails.FirstOrDefault(a => a.OrderDetailId == orderDetailId));
}
public CodeCategory Get(int codecategoryId)
{
LNTKEntities context = CreateContext();
return(context.CodeCategories.FirstOrDefault(a => a.CodeCategoryId == codecategoryId));
}
public EventProduct Get(int eventId, int productId)
{
LNTKEntities context = CreateContext();
return context.EventProducts.FirstOrDefault(a => a.EventId == eventId && a.ProductId == productId);
}
public Grocery Get(int groceryId)
{
LNTKEntities context = CreateContext();
return(context.Groceries.FirstOrDefault(a => a.GroceryId == groceryId));
}
public Stock Get(int stockId)
{
LNTKEntities context = CreateContext();
return(context.Stocks.FirstOrDefault(a => a.StockId == stockId));
}
