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