public static Product GetProduct(int productId)
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
return(_OnlineJewelleryDB.Product.Include("Review").Where(p => p.Id == productId).FirstOrDefault());
}
}
public static void SaveReview(Review review)
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
_OnlineJewelleryDB.Review.Add(review);
_OnlineJewelleryDB.SaveChanges();
}
}
public static void SaveProduct(Product product)
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
_OnlineJewelleryDB.Entry(product).State = System.Data.Entity.EntityState.Modified;
_OnlineJewelleryDB.SaveChanges();
}
}
public static List <Product> GetProductByPageNumber(int pagenumber)
{
//return GetProduct().Skip(pagenumber * 9).Take(9).ToList();
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
return(_OnlineJewelleryDB.Product.AsNoTracking().ToList().Skip(pagenumber * 9).Take(9).ToList());
}
}
public static void DeleteProduct(int productId)
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
var product = GetProduct(productId);
//_OnlineJewelleryDB.Product.Remove(product);
_OnlineJewelleryDB.Entry(product).State = System.Data.Entity.EntityState.Deleted;
_OnlineJewelleryDB.SaveChanges();
}
}
public static Order AddtoOrder(List <Basket> ListBasket, string userid, string username)
{
using (OnlineJewelleryDB _onlineDB = new OnlineJewelleryDB())
{
List <OrderItems> ListOrderitems = new List <OrderItems>();
Order orderplace = new Order()
{
OdrNum = Guid.NewGuid().ToString("N"),
OrderPlacedDate = DateTime.Now,
ApplicationUserId = userid,
UserName = username,
OrderItems = ListOrderitems
};
_onlineDB.Order.Add(orderplace);
_onlineDB.SaveChanges();
foreach (var basket in ListBasket)
{
OrderItems Orderhere = new OrderItems()
{
//Product = basket.Product,
Quantity = basket.Quantity,
ProductId = basket.Product.Id,
OrderId = orderplace.Id
};
var product = _onlineDB.Product.Find(basket.Product.Id);
product.Quantity = product.Quantity - basket.Quantity; // reduce the stock
_onlineDB.Entry(product).State = EntityState.Modified;
ListOrderitems.Add(Orderhere);
}
_onlineDB.OrderItems.AddRange(ListOrderitems);
_onlineDB.SaveChanges();
ClearBasket();
// get the saved order back to display to the user
var orderplaceDB = _onlineDB.Order.Include("OrderItems.Product").Where(ord => ord.Id == orderplace.Id).FirstOrDefault();
return(orderplaceDB);
}
}
//public static List<Order> GetOrder()
//{
// using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
// {
// return _OnlineJewelleryDB.Order.ToList();
// }
//}
public static List <Order> GetPreviousOrders(string userid)
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
//var idParam = new SqlParameter
//{
// ParameterName = "UserId",
// Value = userid
//};
//var orders = _OnlineJewelleryDB.Database.SqlQuery<Object>("EXEC GetOrderDetails @UserId", idParam).ToList();
var orders = _OnlineJewelleryDB.Order.Include("OrderItems.Product.Review").Where(ord => ord.ApplicationUserId == userid).OrderByDescending(ord => ord.OrderPlacedDate).ToList();
return(orders);
}
}
public static void AddOrder()
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
List <Order> Order1 = new List <Order>();
for (int i = 10; i < 100; i++)
{
Order addtoList = new Order()
{
// OdrNum = 10 + i,
};
Order1.Add(addtoList);
}
//_OnlineJewelleryDB.Order.AddRange(Order1);
_OnlineJewelleryDB.SaveChanges();
}
}
public static void AddProduct()
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB())
{
List <Product> Product1 = new List <Product>();
for (int i = 2; i < 100; i++)
{
Product addtolist = new Product()
{
Name = "Product" + i,
Description = "asdsh",
Price = 100 * i,
Quantity = 10 + i,
InStore = i % 2 == 0
};
Product1.Add(addtolist);
}
_OnlineJewelleryDB.Product.AddRange(Product1);
_OnlineJewelleryDB.SaveChanges();
}
}
public static List <Product> GetProduct()
{
using (OnlineJewelleryDB _OnlineJewelleryDB = new OnlineJewelleryDB()) {
return(_OnlineJewelleryDB.Product.ToList());
}
}
