/// <summary>
/// This method adds new recipe to DbSet and then saves changes to database.
/// </summary>
/// <param name="recipeToAdd">Recipe to be added.</param>
/// <returns>True if created, false if not.</returns>
public bool CreateRecipe(vwRecipe recipeToAdd, out int recipeId)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblRecipe recipe = new tblRecipe
{
Author = recipeToAdd.Author,
DateOfCreation = DateTime.Now,
Description = recipeToAdd.Description,
NumberOfPersons = recipeToAdd.NumberOfPersons,
RecipeName = recipeToAdd.RecipeName,
Type = recipeToAdd.Type,
UserId = recipeToAdd.UserId
};
context.tblRecipes.Add(recipe);
context.SaveChanges();
recipeId = recipe.RecipeId;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
recipeId = 0;
return(false);
}
}
/// <summary>
/// This method deletes recipe and every ingredient of that recipe from database.
/// </summary>
/// <param name="recipeToDelete">Recipe to be deleted.</param>
/// <returns>True if deleted, false if not.</returns>
public bool DeleteRecipe(vwRecipe recipeToDelete)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
//finding recipe with forwarded id
tblRecipe recipe = context.tblRecipes.Where(x => x.RecipeId == recipeToDelete.RecipeId).FirstOrDefault();
//finding ingredients with forwarded id
List <tblIngredient> ingredients = context.tblIngredients.Where(x => x.RecipeId == recipeToDelete.RecipeId).ToList();
//removing ingredients
foreach (var item in ingredients)
{
context.tblIngredients.Remove(item);
context.SaveChanges();
}
context.tblRecipes.Remove(recipe);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public bool recipeIngredients(object item)
{
recipe = item as vwRecipe;
ingredients = new List <string>();
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
for (int i = 0; i < SearchIngredients.ingredientsToSearch.Count; i++)
{
ingredient = SearchIngredients.ingredientsToSearch[i];
ingredients.Add(ingredient);
}
List <string> ingredientsInRecipe = context.vwIngredients.Where(x => x.RecipeId == recipe.RecipeId).Select(x => x.IngredientName).ToList();
if (ingredients.All((x => ingredientsInRecipe.Contains(x))))
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This method add ingredient of recipe.
/// </summary>
/// <param name="ingredient">Ingredient to be added.</param>
/// <returns>True if created, false if not.</returns>
public bool AddIngredient(vwIngredient ingredientToAdd, out int ingredientId)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblIngredient ingredient = new tblIngredient
{
IngredientName = ingredientToAdd.IngredientName,
Quantity = ingredientToAdd.Quantity,
RecipeId = ingredientToAdd.RecipeId
};
context.tblIngredients.Add(ingredient);
context.SaveChanges();
ingredientId = ingredient.IngredientId;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
ingredientId = 0;
return(false);
}
}
// GET: DB
public ActionResult Index()
{
RecipesDBEntities obj = new RecipesDBEntities();
var mymodel = new RecipeViewModel();
mymodel.Recipsss = obj.RecipeTabs.ToList();
mymodel.Ingresss = obj.IngredientTabs.ToList();
mymodel.RecIngsss = obj.RITabs.ToList();
return(View(mymodel));
}
public static Recipe GetRecipe(int?id)
{
RecipesDBEntities db = new RecipesDBEntities();
// find recipe by id
var recipes = from item in db.Recipes
where id == item.Id
select item;
return(recipes.FirstOrDefault());
}
/// <summary>
/// This method creates a list of ingredients of recipes.
/// </summary>
/// <param name="recipe">Recipe.</param>
/// <returns>List of ingredients.</returns>
public List <vwIngredient> GetRecipeIngredients(vwRecipe recipe)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
return(context.vwIngredients.Where(x => x.RecipeId == recipe.RecipeId).ToList());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// This method creates a list of all recipes.
/// </summary>
/// <returns>List of all recipes.</returns>
public List <vwRecipe> ViewAllRecipes()
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
return(context.vwRecipes.ToList());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// This method finds recipes of forwarder user.
/// </summary>
/// <param name="user">User.</param>
/// <returns>List of recipes.</returns>
public List <vwRecipe> ViewUserRecipes(vwUser user)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
return(context.vwRecipes.Where(x => x.UserId == user.UserId).ToList());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public vwUser FindUser(int id)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
vwUser user = (from e in context.vwUsers where e.UserId == id select e).First();
return(user);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
// Method that reads all Users from database
public List <vwUser> GetAllUsers()
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
List <vwUser> list = new List <vwUser>();
list = (from x in context.vwUsers select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// This method changes time of recept creation and saves changes to database.
/// </summary>
/// <param name="recipe">Recipe.</param>
/// <returns>True if recipe is edited, false if not.</returns>
public bool ConfirmRecipe(vwRecipe recipeToConfirm)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblRecipe recipe = context.tblRecipes.Where(x => x.RecipeId == recipeToConfirm.RecipeId).FirstOrDefault();
recipe.DateOfCreation = DateTime.Now;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This method deletes ingredient.
/// </summary>
/// <param name="ingredient">Ingredient to be deleted.</param>
public bool DeleteIngredient(vwIngredient ingredient)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblIngredient ingredientToDelete = context.tblIngredients.Where(x => x.IngredientId == ingredient.IngredientId).FirstOrDefault();
context.tblIngredients.Remove(ingredientToDelete);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This method edits data of ingredient.
/// </summary>
/// <param name="ingredientToEdit">Ingredient to be edited.</param>
/// <returns>True if edited, false if not.</returns>
public bool EditIngredient(vwIngredient ingredientToEdit)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblIngredient ingredient = context.tblIngredients.Where(x => x.IngredientId == ingredientToEdit.IngredientId).FirstOrDefault();
ingredient.IngredientName = ingredientToEdit.IngredientName;
ingredient.Quantity = ingredientToEdit.Quantity;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public List <string> ViewRecipeIngredients(vwRecipe recipe)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
if (recipe != null)
{
return(context.vwIngredients.Where(x => x.RecipeId == recipe.RecipeId).Select(x => x.IngredientName + " " + x.Quantity).ToList());
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
// Method that add User to database
public bool AddUser(vwUser user)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblUser newUser = new tblUser();
newUser.NameAndSurname = user.NameAndSurname;
newUser.Username = user.Username;
newUser.Password = SecurePasswordHasher.Hash(user.Password);
context.tblUsers.Add(newUser);
context.SaveChanges();
user.UserId = newUser.UserId;
return(true);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
// Methot to check if User username exists in database
public bool IsUser(string username)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
vwUser user = (from e in context.vwUsers where e.Username == username select e).First();
if (user == null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This method edits data of recipe and save changes to database..
/// </summary>
/// <param name="recipeToEdit">Recipe to be edited.</param>
/// <returns>True if edited, false if not.</returns>
public bool EditRecipe(vwRecipe recipeToEdit)
{
try
{
using (RecipesDBEntities context = new RecipesDBEntities())
{
tblRecipe recipe = context.tblRecipes.Where(x => x.RecipeId == recipeToEdit.RecipeId).FirstOrDefault();
recipe.RecipeName = recipeToEdit.RecipeName;
recipe.Author = recipeToEdit.Author;
recipe.DateOfCreation = DateTime.Now;
recipe.Description = recipeToEdit.Description;
recipe.NumberOfPersons = recipeToEdit.NumberOfPersons;
recipe.Type = recipeToEdit.Type;
recipe.UserId = recipeToEdit.UserId;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public RatingRepository()
{
db = new RecipesDBEntities();
}
public UsersRepository()
{
db = new RecipesDBEntities();
}
public InstructionsRepository()
{
db = new RecipesDBEntities();
}
public BaseRepository(RecipesDBEntities context)
{
Context = context;
}
public CategoryRepository()
{
db = new RecipesDBEntities();
}
public GenericRepository()
{
db = new RecipesDBEntities();
table = db.Set <T>();
}
public IngredientRepository()
{
db = new RecipesDBEntities();
}
public CommentsRepository()
{
db = new RecipesDBEntities();
}
