/// <summary>
/// Updates a user in the database
/// </summary>
/// <param name="user"></param>
public void updateUser(string str)
{
masterEntities m = ContextSingleton.getContext();
RecipeService recipeclient = new RecipeService();
User user = JsonConvert.DeserializeObject <User>(str, jsettings);
User updateUser = JsonConvert.DeserializeObject <User>(GetUser(user.User_id), jsettings);
updateUser.dairyfree = user.dairyfree;
updateUser.favJokes = user.favJokes;
updateUser.favTrivia = user.favTrivia;
updateUser.favorites = user.favorites;
updateUser.First_name = user.First_name;
updateUser.gender = user.gender;
updateUser.glutenfree = user.glutenfree;
updateUser.height = user.height;
updateUser.Last_name = user.Last_name;
updateUser.password = user.password;
updateUser.userName = user.userName;
updateUser.User_id = user.User_id;
updateUser.vegan = user.vegan;
updateUser.vegetarian = user.vegetarian;
updateUser.weight = user.weight;
m.Entry(updateUser).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
}
/// <summary>
/// Adds a user to the database
/// </summary>
/// <param name="first_name"></param>
/// <param name="last_name"></param>
/// <param name="username"></param>
/// <param name="password"></param>
/// <param name="weight"></param>
/// <param name="height"></param>
/// <param name="vegetarian"></param>
/// <param name="vegan"></param>
/// <param name="dairyfree"></param>
/// <param name="glutenfree"></param>
/// <param name="gender"></param>
public void AddUser(string first_name, string last_name, string username, string password, double?weight, double?height, bool?vegetarian, bool?vegan, bool?dairyfree, bool?glutenfree, bool?gender)
{
masterEntities m = ContextSingleton.getContext();
User newUser = new User();
newUser.First_name = first_name;
newUser.Last_name = last_name;
newUser.userName = username;
newUser.password = password;
newUser.weight = weight;
newUser.height = height;
newUser.vegetarian = vegetarian;
newUser.vegan = vegan;
newUser.dairyfree = dairyfree;
newUser.glutenfree = glutenfree;
newUser.gender = gender;
m.User.Add(newUser);
m.SaveChanges();
}
/// <summary>
/// Adds one recipe to database.
/// </summary>
/// <param name="recipe_id"></param>
/// <param name="recipe_name"></param>
/// <param name="recipe_minutes"></param>
/// <param name="recipe_veg"></param>
/// <param name="recipe_vegan"></param>
/// <param name="cheap"></param>
/// <param name="sustainable"></param>
/// <param name="glutenfree"></param>
/// <param name="dairyfree"></param>
/// <param name="image"></param>
/// <param name="instruction"></param>
/// <param name="imageTyp"></param>
/// <param name="ingredientList"></param>
public void addRecipe(int recipe_id, String recipe_name, int recipe_minutes, Boolean recipe_veg,
Boolean recipe_vegan, Boolean cheap, Boolean sustainable, Boolean glutenfree, Boolean dairyfree,
String image, String instruction, String imageTyp, List <Ingredients> ingredientList)
{
masterEntities m = ContextSingleton.getContext();
Recipe rcp = new Recipe();
rcp.Recipe_id = recipe_id;
rcp.Recipe_name = recipe_name;
rcp.Recipe_minutes = recipe_minutes;
rcp.Recipe_veg = recipe_veg;
rcp.Recipe_vegan = recipe_vegan;
rcp.cheap = cheap;
rcp.sustainable = sustainable;
rcp.glutenfree = glutenfree;
rcp.dairyfree = dairyfree;
rcp.image = image;
rcp.Instructions = instruction;
rcp.imageTyp = imageTyp;
rcp.Ingredients = ingredientList;
m.Recipe.Add(rcp);
m.SaveChanges();
}