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 <List <item> > GetItemsAsync(Guid token, int slid) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { return(Task.FromResult(db.item.Where(i => i.slid == slid).ToList())); } return(null); }
public Task <List <shopping_list> > GetShoppingListsAsync(Guid token) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { return(Task.FromResult(db.shopping_list.ToList())); } return(null); }
public Task <item> DeleteAsync(Guid token, item item) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { var result = db.item.Remove(item).Entity; db.SaveChanges(); return(Task.FromResult(result)); } return(null); }
public Task <item> UpdateAsync(Guid token, item item) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { db.Entry(item).State = EntityState.Modified; db.SaveChanges(); return(Task.FromResult(item)); } return(null); }
public Task <Guid> AuthenticateAsync(string username, string pw) { using var db = new ShoppingdbContext(); bool valid = db.user_.Any <user_>(u => u.uname == username && u.passw == pw); if (valid) { int uid = db.user_.Where(u => u.uname == username).First().uid; return(Task.FromResult(db.auth_token.Where(t => t.user == uid).First().token)); } 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); }
public Task <item> AddAsync(Guid token, item item) { using var db = new ShoppingdbContext(); if (AuthenticationService.ValidateAsync(token).Result) { var newItem = new item { slid = item.slid, iname = item.iname, ammount = item.ammount, added_by = item.added_by, sold_out = item.sold_out }; var result = db.item.Add(newItem).Entity; db.SaveChanges(); return(Task.FromResult(result)); } return(null); }
public Task <bool> ValidateAsync(Guid token) { using var db = new ShoppingdbContext(); return(Task.FromResult(db.auth_token.Any(t => t.token == token))); }