public Task <shopping_list> AddAsync(Guid token, shopping_list sl) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { var newSl = new shopping_list { gid = sl.gid, slname = sl.slname }; var result = db.shopping_list.Add(newSl).Entity; db.SaveChanges(); var soldOut = db.item.Where(i => i.sold_out).ToList(); foreach (var i in soldOut) { db.item.Remove(i); db.SaveChanges(); i.sold_out = false; i.slid = result.slid; db.item.Add(i); } db.SaveChanges(); return(Task.FromResult(result)); } return(null); }
public Task <shopping_list> DeleteAsync(Guid token, shopping_list sl) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { if (db.item.Any(i => i.slid == sl.slid)) { foreach (var i in db.item.Where(i => i.slid == sl.slid).ToList()) { db.item.Remove(i); } } var result = db.shopping_list.Remove(sl).Entity; db.SaveChanges(); return(Task.FromResult(result)); } return(null); }