public static int UpdateExistingRole(Role role) { string query = string.Format(QUERY_UPDATE, role.RoleDescription, role.RoleID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int DeleteOrderMeal(int orderMealID) { string query = string.Format(QUERY_DELETE_MEAL_FROM_ORDER, orderMealID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertNewRole(Role role) { string query = string.Format(QUERY_INSERT, role.RoleDescription); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int UpdateExistingIngredient(Ingredient ingredient) { string query = string.Format(QUERY_UPDATE, ingredient.IngredientName, ingredient.IngredientPrice, ingredient.IngredientID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertOrderMeal(int orderID, int mealID, int quantity, decimal price) { string query = string.Format(QUERY_INSERT_OM, orderID, mealID, quantity, price); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int UpdateExistingMeal(Meal meal) { string query = string.Format(QUERY_UPDATE, meal.MealName, meal.MealDescription, meal.MealID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertNewIngredient(Ingredient ingredient) { string query = string.Format(QUERY_INSERT, ingredient.IngredientName, ingredient.IngredientPrice, ingredient.IngredientID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertNewOrder(Order order) { string query = string.Format(QUERY_INSERT, order.OrderCustomer, order.OrderDate); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertNewMeal(Meal meal) { string query = string.Format(QUERY_INSERT, meal.MealName, meal.MealDescription); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int UpdateExistingOrder(Order order) { string query = string.Format(QUERY_UPDATE, order.OrderCustomer, order.OrderDate, order.OrderID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int DeleteUserRole(int userRoleID) { string query = string.Format(QUERY_DELETE_ROLE_FROM_USER, userRoleID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertUserRole(int userID, int roleID) { string query = string.Format(QUERY_INSERT_UR, userID, roleID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int DeleteMealIngredient(int mealIngredientID) { string query = string.Format(QUERY_DELETE_INGREDIENT_FROM_MEAL, mealIngredientID); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }
public static int InsertMealIngredient(int mealID, int IngredientID, int quantity, decimal price) { string query = string.Format(QUERY_INSERT_MI, mealID, IngredientID, quantity, price); int results = DatabaseManager.ExecuteNonQuery(query); return(results); }