//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();
}
}
