public void addProd(List <Item> li, string name, double t) { Order o = new Order(); o.OrderAmount = li.Count(); o.OrderPrice = t; using (ShoppingDatabaseEntities1 db = new ShoppingDatabaseEntities1()) { var user = db.Users.Where(x => x.UserName == name).Select(x => new { x.Id, x.Name, x.Password, x.Address, x.Number, x.Email }).ToList(); if (user.Count() > 0) { User us = new User(); foreach (var i in user) { o.UserId = i.Id; } } db.Orders.Add(o); db.SaveChanges(); int orderid = 0; var order = db.Orders.Where(x => x.UserId == o.UserId).Select(x => new { x.Id }).ToList(); foreach (var i in order) { orderid = i.Id; } foreach (var i in li) { ProductDetail d = new ProductDetail(); d.OrderId = orderid; d.ProdId = i.Product.Id; db.ProductDetails.Add(d); db.SaveChanges(); } } }
public void save(User u) { using (ShoppingDatabaseEntities1 db = new ShoppingDatabaseEntities1()) { db.Users.Add(u); db.SaveChanges(); } }
public void SaveProduct(Product p) { using (ShoppingDatabaseEntities1 db = new ShoppingDatabaseEntities1()) { db.Products.Add(p); db.SaveChanges(); } }
public void UpdateProduct(Product p) { using (ShoppingDatabaseEntities1 db = new ShoppingDatabaseEntities1()) { Product i = db.Products.Find(p.Id); if (i != null) { //i.Id = p.Id; i.ProductName = p.ProductName; i.ProductCategory = p.ProductCategory; i.ProductPrice = p.ProductPrice; i.ProductQuantity = p.ProductQuantity; i.Detail = p.Detail; db.SaveChanges(); } } }