public HttpResponseMessage DeleteRecipe(int id)
{
using (CookBookEntities cookbook = new CookBookEntities())
{
cookbook.Ingredients.Remove(cookbook.Ingredients.SingleOrDefault(r => r.Id == id));
cookbook.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Get(int id)
{
var RecipeTest = new RecipeDTO();
using (CookBookEntities cookbook = new CookBookEntities())
{
RecipeTest = cookbook.Recipes.ToList().Where(r => r.Id == id).Select(r => new RecipeDTO()
{
Name = r.Name, Id = r.Id
}).SingleOrDefault();
}
return(Request.CreateResponse(HttpStatusCode.OK, RecipeTest));
}
public HttpResponseMessage GetIngredients(int id)
{
var listIngredient = new List <IngredientDTO>();
using (CookBookEntities cookbook = new CookBookEntities())
{
listIngredient = cookbook.RecipeIngredients.Include(nameof(Ingredient)).ToList().Where(r => r.RecipeId == id).Select(r => new IngredientDTO()
{
Name = r.Ingredient.Name, Id = r.Ingredient.Id
}).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK, listIngredient));
}
public HttpResponseMessage Get()
{
var List = new List <UserDTO>();
using (CookBookEntities cookbook = new CookBookEntities())
{
var Ressource = cookbook.ApplicationUsers.ToList();
List.AddRange(Ressource.Select(r => new UserDTO()
{
ApplicationRoleId = r.ApplicationRoleId, ApplicationUserId = r.ApplicationUserId, Email = r.Email, FirstName = r.FirstName, LastName = r.LastName, Password = r.Password
}));
}
return(Request.CreateResponse(HttpStatusCode.OK, List));
}
public HttpResponseMessage Get()
{
var List = new List <RecipeDTO>();
using (CookBookEntities cookbook = new CookBookEntities())
{
var Ressource = cookbook.Recipes.ToList();
List.AddRange(Ressource.Select(r => new RecipeDTO()
{
Name = r.Name, Id = r.Id, CountOfPeople = r.CountofPeople, Description = r.Description, Level = r.Level, TimeToCook = r.TimeToCook
}));
}
return(Request.CreateResponse(HttpStatusCode.OK, List));
}
public HttpResponseMessage AllRecipesIngredients()
{
var List = new List <RecipeIngredientDTO>();
using (CookBookEntities cookbook = new CookBookEntities())
{
var Ressource = cookbook.RecipeIngredients.ToList();
List.AddRange(Ressource.Select(r => new RecipeIngredientDTO()
{
RecipeId = r.RecipeId, IngredientId = r.IngredientId, Quantity = r.Quantity
}));
}
return(Request.CreateResponse(HttpStatusCode.OK, List));
}
public HttpResponseMessage AddIngredient([FromBody] IngredientDTO ingredient)
{
var ingredientEDMX = new Ingredient()
{
Name = ingredient.Name,
UnitId = 1
};
using (CookBookEntities cookbook = new CookBookEntities())
{
cookbook.Ingredients.Add(ingredientEDMX);
cookbook.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, ingredient));
}
public HttpResponseMessage isValidUser([FromBody] UserQueryDTO vm)
{
CookBookEntities entities = new CookBookEntities();
UserResponseDTO response = new UserResponseDTO();
response.isValid = (entities.ApplicationUsers.SingleOrDefault(obj => obj.Email == vm.Email && obj.Password == vm.Password) != null) ? true : false;
if (response.isValid == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, response));
}
}
public HttpResponseMessage UpdateRecipe([FromBody] RecipeDTO recipeDTO)
{
using (CookBookEntities cookbook = new CookBookEntities())
{
var recipe = cookbook.Recipes.SingleOrDefault(r => r.Id == recipeDTO.Id);
recipe.Name = recipeDTO.Name;
recipe.Level = recipeDTO.Level;
recipe.TimeToCook = recipeDTO.TimeToCook;
recipe.CountofPeople = recipeDTO.CountOfPeople;
recipe.Description = recipeDTO.Description;
cookbook.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, recipeDTO));
}
public HttpResponseMessage AddIngredientRecipes([FromBody] RecipeIngredientDTO ing)
{
var ingredient = new RecipeIngredient()
{
IngredientId = ing.IngredientId,
RecipeId = ing.RecipeId,
Quantity = ing.Quantity
};
using (CookBookEntities cookbook = new CookBookEntities())
{
cookbook.RecipeIngredients.Add(ingredient);
cookbook.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, ingredient));
}
public HttpResponseMessage AllIngredients()
{
var List = new List <IngredientDTO>();
using (CookBookEntities cookbook = new CookBookEntities())
{
var Ressource = cookbook.Ingredients.ToList();
List.AddRange(Ressource.Select(r => new IngredientDTO()
{
Name = r.Name, Id = r.Id
}));
}
return(Request.CreateResponse(HttpStatusCode.OK, List));
}
public HttpResponseMessage CreateRecipe([FromBody] RecipeDTO vm)
{
var recipe = new Recipe()
{
Name = vm.Name,
Level = vm.Level,
TimeToCook = vm.TimeToCook,
CountofPeople = vm.CountOfPeople,
Description = vm.Description
};
using (CookBookEntities cookbook = new CookBookEntities())
{
cookbook.Recipes.Add(recipe);
cookbook.SaveChanges();
}
//Recipe recipe = new Recipe { Name = vm.Name, Level = "c", TimeToCook = new DateTime(}
return(Request.CreateResponse(HttpStatusCode.Created, recipe));
}
