//static ASPProjectDB DB = new ASPProjectDB(); public static void AddUser(User user) { using (var DB = new ASPProjectDB()) { DB.Users.Add(user); DB.SaveChanges(); } }
public static void ReleaseProducts(params string[] ids) { using (var DB = new ASPProjectDB()) { var prods = DB.Products.Where(p => ids.Contains(p.Id.ToString())); foreach (var prod in prods) { prod.State = ProductState.Available; prod.ReleaseTime = DateTime.Now; if (prod.UserId.HasValue) { var user = DB.Users.First(u => u.ProductsInCart.Select(p => p.Id).Contains(prod.Id)); user.ProductsInCart.Remove(user.ProductsInCart.First(p => p.Id == prod.Id)); } } DB.SaveChanges(); } }
public static void SaveProductFor(string productId, string userId = null) { using (var DB = new ASPProjectDB()) { var prod = DB.Products.Find(int.Parse(productId)); User user = null; if (!string.IsNullOrEmpty(userId)) { user = DB.Users.Find(int.Parse(userId)); prod.State = ProductState.Occupied; } else { prod.ReleaseTime = DateTime.Now + new TimeSpan(0, 30, 0); } user?.ProductsInCart.Add(prod); DB.SaveChanges(); } }