public int Delete(int id) { using (CafeinatorDBEntities dbCtx = new CafeinatorDBEntities()) { return(dbCtx.DeleteUser(id)); } }
/// <summary> /// Save user last choice /// </summary> /// <param name="drink"></param> /// <param name="usrID"></param> /// <returns></returns> // POST api/Drink public int Post(Menu menu) { using (CafeinatorDBEntities CafeinatorDBEntities = new CafeinatorDBEntities()) { return(CafeinatorDBEntities.SaveUserLastChoice(menu.UsrID, menu.Drink.DrkID, menu.Drink.SugarQty)); } }
// GET api/Drink public List <Drink> Get() { using (CafeinatorDBEntities dbCtx = new CafeinatorDBEntities()) { var drinks = dbCtx.GetAllDrinkType(); return(convertTDrinkTypeToDrinks(drinks)); } }
// GET api/<controller> public User Get(string bCode) { using (CafeinatorDBEntities dbCtx = new CafeinatorDBEntities()) { var u = dbCtx.GetUser(bCode); return(u.Select(x => { return new User { BCode = x?.BCode, UsrID = (int)x?.usrID, UsrName = x?.usrName }; }).FirstOrDefault()); } }
// POST api/<controller> public User Post(User user) { using (CafeinatorDBEntities dbCtx = new CafeinatorDBEntities()) { return(dbCtx.AddNewUser(user.BCode, user.UsrName).Select(x => { return new User { BCode = x?.BCode, UsrID = (int)x?.usrID, UsrName = x?.usrName }; }).FirstOrDefault()); } }
public Drink GetUserLastChoce(int usrID) { using (CafeinatorDBEntities dbCtx = new CafeinatorDBEntities()) { return(dbCtx.GetUserLastChoice(usrID).Select(x => { return new Drink { DrkID = (int)x?.drkID, DrkLabel = x?.drkLabel, SugarQty = (int)x?.sugarQty }; }).FirstOrDefault()); } }