public int Update() { // Create result variable for this method (int) int result = 0; try { // Using statement for connection string, and create a new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // If a specific user is selected, update the user information. Otherwise, throw an exception. tblMeasure Measure = dc.tblMeasures.Where(i => i.ms_Id == this.Id).FirstOrDefault(); if (Measure != null) { Measure.ms_Description = this.Description; result = dc.SaveChanges(); } } return(result); } catch (Exception e) { throw e; } }
public int Delete(int id) { // Create result variable for this method (int) int result = 0; try { // Using statement for connection string, and create a new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) // If Measure is selected, delete measure from tblMeasures and its Id number. Otherwise, throw exception { tblMeasure Measure = dc.tblMeasures.Where(i => i.ms_Id == id).FirstOrDefault(); if (Measure != null) { dc.tblMeasures.Remove(Measure); result = dc.SaveChanges(); } } return(result); } catch (Exception e) { throw e; } }
public int Insert() { // Create result variable for this method (int) int result = 0; try { // Using statement for connection string, and create a new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // Create new instance of tblMeasure called Measure tblMeasure measure = new tblMeasure(); // Insert new user into tblMeasures by adding new Id number, otherwise throw exception measure.ms_Id = 1; if (dc.tblMeasures.Any()) { measure.ms_Id = dc.tblMeasures.Max(i => i.ms_Id) + 1; } this.Id = measure.ms_Id; measure.ms_Description = this.Description; dc.tblMeasures.Add(measure); result = dc.SaveChanges(); return(result); } } catch (Exception e) { throw e; } }
public int Insert() { // Create result variable for this method (int) int result = 0; try { //Using connection string statement and creating new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // Create new instance of tblIngredient tblIngredient ingredient = new tblIngredient(); ingredient.in_Id = 1; if (dc.tblIngredients.Any()) { ingredient.in_Id = dc.tblIngredients.Max(i => i.in_Id) + 1; } this.Id = ingredient.in_Id; ingredient.in_Description = this.Description; dc.tblIngredients.Add(ingredient); result = dc.SaveChanges(); return(result); } } catch (Exception e) { throw e; } }
public int Update() { // Create result variable for this method(int) int result = 0; try { //Using connection string statement and creating new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // If ingredient is selected, update the description. Otherwise, throw an exception. tblIngredient ingredient = dc.tblIngredients.Where(i => i.in_Id == this.Id).FirstOrDefault(); if (ingredient != null) { ingredient.in_Description = this.Description; result = dc.SaveChanges(); } } return(result); } catch (Exception e) { throw e; } }
public int Update() { int result = 0; try { using (ChefsCornerEntities dc = new ChefsCornerEntities()) { tblRecipe recipe = dc.tblRecipes.Where(r => r.rc_Id == this.Id).FirstOrDefault(); if (recipe != null) { recipe.rc_Name = this.Name; recipe.rc_Description = this.Description; recipe.rc_Directions = this.Directions; recipe.rc_Image = ConvertImage(this.Image); recipe.rc_Ingredients = this.Ingredients; result = dc.SaveChanges(); } } return(result); } catch (Exception e) { return(0); throw e; } }
public int Delete(int id) { // Create result variable for this method(int) int result = 0; try { //Using connection string statement and creating new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // If ingredient is selected, delete the ingredient along with the Id associated with it. Otherwise, throw an exception. tblIngredient ingredient = dc.tblIngredients.Where(i => i.in_Id == id).FirstOrDefault(); if (ingredient != null) { dc.tblIngredients.Remove(ingredient); result = dc.SaveChanges(); } } return(result); } catch (Exception e) { throw e; } }
public int Insert() { // Declare result variable for this method (int) int result = 0; try { // Using statement for connection string, and create a new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // Create new instance of tblRecipe called recipe tblRecipe recipe = new tblRecipe(); recipe.rc_Id = 1; if (dc.tblRecipes.Any()) { recipe.rc_Id = dc.tblRecipes.Max(r => r.rc_Id) + 1; } this.Id = recipe.rc_Id; recipe.rc_Name = this.Name; recipe.rc_Description = this.Description; recipe.rc_Directions = this.Directions; recipe.rc_Image = ConvertImage(this.Image); recipe.us_Id = this.UserId; recipe.rc_Ingredients = this.Ingredients; dc.tblRecipes.Add(recipe); result = dc.SaveChanges(); } return(result); } catch (Exception e) { throw e; } }
public static void Delete(int recipeid, int ingredientid, int measureid) { try { // Create new instance of ChefsCornerEntities/ Connection string ChefsCornerEntities dc = new ChefsCornerEntities(); tblRecipeIngredient rin = dc.tblRecipeIngredients.FirstOrDefault(rci => rci.rc_Id == recipeid && rci.in_Id == ingredientid && rci.ms_Id == measureid); if (rin != null) { dc.tblRecipeIngredients.Remove(rin); dc.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Delete(int id) { try { // Using statement for connection string, and create a new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // If user with a specific id is selected, delete the user and the Id associated with it. Otherwise, throw an exception. tblUser user = dc.tblUsers.Where(u => u.us_Id == id).FirstOrDefault(); if (user != null) { dc.tblUsers.Remove(user); dc.SaveChanges(); } } } catch (Exception e) { throw e; } }
public void Insert() { try { // Create new instance of ChefsCornerEntities/ Connection string using (ChefsCornerEntities dc = new ChefsCornerEntities()) { // Create new instance of tblUser called user tblUser user = new tblUser(); // Insert new user into tblUsers by adding new Id number, otherwise throw exception Id = dc.tblUsers.Any() ? dc.tblUsers.Max(u => u.us_Id) + 1 : 1; Map(user); dc.tblUsers.Add(user); dc.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Update() { try { // Using statement for connection string, and create a new instance of it using (ChefsCornerEntities dc = new ChefsCornerEntities()) { tblUser user = dc.tblUsers.Where(u => u.us_Id == this.Id).FirstOrDefault(); // If a user is selected, update the user info. Otherwise, throw an exception. if (user != null) { Map(user); dc.SaveChanges(); } } } catch (Exception e) { throw e; } }
public static void Add(int recipeid, int ingredientid, int measureid) { try { // Create new instance of ChefsCornerEntities ChefsCornerEntities dc = new ChefsCornerEntities(); // Create new instance of tblRecipeIngredient tblRecipeIngredient rin = new tblRecipeIngredient(); // Add new Ids for recipes, ingredients, and measures to tblRecipeIngredients. Otherwise, throw an exception. rin.ri_Id = dc.tblRecipeIngredients.Any() ? dc.tblRecipeIngredients.Max(r => r.ri_Id) + 1 : 1; rin.in_Id = ingredientid; rin.rc_Id = recipeid; rin.ms_Id = measureid; dc.tblRecipeIngredients.Add(rin); dc.SaveChanges(); } catch (Exception e) { throw e; } }
public int Delete(int id) { int result = 0; try { using (ChefsCornerEntities dc = new ChefsCornerEntities()) { tblRecipe recipe = dc.tblRecipes.Where(r => r.rc_Id == id).FirstOrDefault(); if (recipe != null) { dc.tblRecipes.Remove(recipe); result = dc.SaveChanges(); } } return(result); } catch (Exception e) { return(0); throw e; } }