public ActionResult AddNew()
{
List <Level> level = new List <Level>
{
new Level()
{
Level_Id = 1, Level_Name = "Łatwy"
},
new Level()
{
Level_Id = 2, Level_Name = "Średni"
},
new Level()
{
Level_Id = 3, Level_Name = "Trudny"
}
};
CategoriesDTO catDTO = new CategoriesDTO();
DirectionsDTO dirDTO = new DirectionsDTO();
DishesDTO disDTO = new DishesDTO();
IngredientsDTO ingDTO = new IngredientsDTO();
AddNewRecipeVM model = new AddNewRecipeVM(catDTO, dirDTO, disDTO, ingDTO);
using (Db db = new Db())
{
model.Dishes.CategoriesSelectList = new SelectList(db.Categories.ToList(), "Id_Category", "Name");
model.LevelList = new SelectList(level, "Level_Id", "Level_Name");
}
return(View(model));
}
public void AddRefer(int idWhere, IngredientsDTO ingredientsDTO)
{
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <IngredientsDTO, Ingredient>().MaxDepth(3)).CreateMapper();
var ingredient = mapper.Map <IngredientsDTO, Ingredient>(ingredientsDTO);
var ingredientFound = Database.Ingredients.Get(ingredient.Id);
if (ingredientFound == null)
{
//проблема тут
Database.Ingredients.Create(ingredient.Name);
Database.Save();
ingredientFound = Database.Ingredients.GetForName(ingredient.Name);
//Database.Ingredients.Create(ingredientFound);
//ingredientFound = Database.Ingredients.Get(ingredientFound.Id);//this mast work uncorrect
//Database.Dishes.AddRefer(idWhere, ingredient.Id);
Database.Dishes.AddRefer(idWhere, ingredientFound.Id);
Database.Save();
}
else
{
Database.Dishes.AddRefer(idWhere, ingredient.Id);
Database.Save();
}
}
public ActionResult Put([FromBody] IngredientsDTO ingredientDto)
{
if (IngredientsDAO.Update(ingredientDto))
{
return(Ok());
}
return(BadRequest());
}
public static IngredientsDTO Post(IngredientsDTO ingredient)
{
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = REQ_POST_INGREDIENT;
command.Parameters.AddWithValue($@"{FIELD_NAME_INGREDIENT}", ingredient.NameIngredient);
ingredient.IdIngredient = (int)command.ExecuteScalar();
}
return(ingredient);
}
public static bool Update(IngredientsDTO ingredient)
{
bool hasBeenChanged = false;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = REQ_UPDATE_INGREDIENT;
command.Parameters.AddWithValue($"{FIELD_NAME_INGREDIENT}", ingredient.NameIngredient);
command.Parameters.AddWithValue($"{FIELD_ID_INGREDIENT}", ingredient.IdIngredient);
hasBeenChanged = command.ExecuteNonQuery() == 1;
}
return(hasBeenChanged);
}
public IngredientsVM(IngredientsDTO row)
{
Id_Ingredient = row.Id_Ingredient;
Ingredient_1 = row.Ingredient_1;
Ingredient_2 = row.Ingredient_2;
Ingredient_3 = row.Ingredient_3;
Ingredient_4 = row.Ingredient_4;
Ingredient_5 = row.Ingredient_5;
Ingredient_6 = row.Ingredient_6;
Ingredient_7 = row.Ingredient_7;
Ingredient_8 = row.Ingredient_8;
Ingredient_9 = row.Ingredient_9;
Ingredient_10 = row.Ingredient_10;
Ingredient_11 = row.Ingredient_11;
Ingredient_12 = row.Ingredient_12;
Ingredient_13 = row.Ingredient_13;
Ingredient_14 = row.Ingredient_14;
Ingredient_15 = row.Ingredient_15;
}
public ActionResult AddIngredient(string ingredientName, int idWhere)
{
//Get ingredient for name
var ingredientsDTO = orderService.GetIngredient(ingredientName);
IngredientsDTO ingredientsDTOFinal = new IngredientsDTO();
//get dish for link in ingredient.Dishes
DishesDTO dishesDTO = orderService.GetDishes(idWhere);
if (ingredientsDTO == null)
{
ingredientsDTOFinal.Id = orderService.GetLastIdIngredient() + 1;
ingredientsDTOFinal.Name = ingredientName;
ingredientsDTOFinal.Dishes.Add(dishesDTO);
orderService.AddRefer(idWhere, ingredientsDTOFinal);
}
else
{
ingredientsDTO.Dishes.Add(dishesDTO);
orderService.AddRefer(idWhere, ingredientsDTO);
}
return(Redirect("/Home/Index"));
}
public AddNewRecipeVM(CategoriesDTO catRow, DirectionsDTO dirRow, DishesDTO disRow, IngredientsDTO ingRow)
{
Categories = new CategoriesVM(catRow);
Directions = new DirectionsVM(dirRow);
Dishes = new DishesVM(disRow);
Ingredients = new IngredientsVM(ingRow);
}
public IngredientsDTO Post([FromBody] IngredientsDTO ingredientDto)
{
return(IngredientsDAO.Post(ingredientDto));
}
public ActionResult AddNew(AddNewRecipeVM model, HttpPostedFileBase file)
{
#region Preparation-List-If-Will-Be-Errors
List <Level> level = new List <Level>();
level.Add(new Level()
{
Level_Id = 1, Level_Name = "Łatwy"
});
level.Add(new Level()
{
Level_Id = 2, Level_Name = "Średni"
});
level.Add(new Level()
{
Level_Id = 3, Level_Name = "Trudny"
});
using (Db db = new Db())
{
model.Dishes.CategoriesSelectList = new SelectList(db.Categories.ToList(), "Id_Category", "Name");
model.LevelList = new SelectList(level, "Level_Id", "Level_Name");
}
#endregion
//Exception Handling:
#region Basic-information
if (model.Dishes.Id_Category == 0)
{
TempData["WarningSection1"] = "Kategoria pozostała pusta. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Name == null)
{
TempData["WarningSection1"] = "Nazwa potrawy pozostała pusta. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Description == null)
{
TempData["WarningSection1"] = "Opis przepisu i potrawy pozostał pusty. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Servings == 0)
{
TempData["WarningSection1"] = "Ilość porcji pozostała pusta. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Time == null || model.Dishes.Time == "0")
{
TempData["WarningSection1"] = "Czas przygotowania pozostał pusty. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Level == 0)
{
TempData["WarningSection1"] = "Poziom trudności pozostał pusty. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Name.Length < 3)
{
TempData["WarningSection1"] = "Nazwa potrawy powinna składać się z co najmniej 3 znaków. Popraw błędy i spróbuj ponownie."; return(View(model));
}
if (model.Dishes.Description.Length < 15)
{
TempData["WarningSection1"] = "Opis potrawy powinna składać się z co najmniej 15 znaków. Popraw błędy i spróbuj ponownie."; return(View(model));
}
#endregion
#region Ingredients-List
if (model.Ingredients.Ingredient_1 == null)
{
TempData["WarningSection2"] = "Musisz dodać co najmniej jeden składnik. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
#endregion
#region Direction-List
if (model.Directions.Step_1_Content == null)
{
TempData["WarningSection3"] = "Musisz dodać co najmniej jeden krok przygotowania. Uzupełnij braki i spróbuj ponownie."; return(View(model));
}
#endregion
//Post Method:
int id;
using (Db db = new Db())
{
#region Add-Ingredients-To-Db
IngredientsDTO ingredients = new IngredientsDTO();
ingredients.Ingredient_1 = model.Ingredients.Ingredient_1;
if (model.Ingredients.Ingredient_2 != null)
{
ingredients.Ingredient_2 = model.Ingredients.Ingredient_2;
}
else
{
ingredients.Ingredient_2 = "";
}
if (model.Ingredients.Ingredient_3 != null)
{
ingredients.Ingredient_3 = model.Ingredients.Ingredient_3;
}
else
{
ingredients.Ingredient_3 = "";
}
if (model.Ingredients.Ingredient_4 != null)
{
ingredients.Ingredient_4 = model.Ingredients.Ingredient_4;
}
else
{
ingredients.Ingredient_4 = "";
}
if (model.Ingredients.Ingredient_5 != null)
{
ingredients.Ingredient_5 = model.Ingredients.Ingredient_5;
}
else
{
ingredients.Ingredient_5 = "";
}
if (model.Ingredients.Ingredient_6 != null)
{
ingredients.Ingredient_6 = model.Ingredients.Ingredient_6;
}
else
{
ingredients.Ingredient_6 = "";
}
if (model.Ingredients.Ingredient_7 != null)
{
ingredients.Ingredient_7 = model.Ingredients.Ingredient_7;
}
else
{
ingredients.Ingredient_7 = "";
}
if (model.Ingredients.Ingredient_8 != null)
{
ingredients.Ingredient_8 = model.Ingredients.Ingredient_8;
}
else
{
ingredients.Ingredient_8 = "";
}
if (model.Ingredients.Ingredient_9 != null)
{
ingredients.Ingredient_9 = model.Ingredients.Ingredient_9;
}
else
{
ingredients.Ingredient_9 = "";
}
if (model.Ingredients.Ingredient_10 != null)
{
ingredients.Ingredient_10 = model.Ingredients.Ingredient_10;
}
else
{
ingredients.Ingredient_10 = "";
}
if (model.Ingredients.Ingredient_11 != null)
{
ingredients.Ingredient_11 = model.Ingredients.Ingredient_11;
}
else
{
ingredients.Ingredient_11 = "";
}
if (model.Ingredients.Ingredient_12 != null)
{
ingredients.Ingredient_12 = model.Ingredients.Ingredient_12;
}
else
{
ingredients.Ingredient_12 = "";
}
if (model.Ingredients.Ingredient_13 != null)
{
ingredients.Ingredient_13 = model.Ingredients.Ingredient_13;
}
else
{
ingredients.Ingredient_13 = "";
}
if (model.Ingredients.Ingredient_14 != null)
{
ingredients.Ingredient_14 = model.Ingredients.Ingredient_14;
}
else
{
ingredients.Ingredient_14 = "";
}
if (model.Ingredients.Ingredient_15 != null)
{
ingredients.Ingredient_15 = model.Ingredients.Ingredient_15;
}
else
{
ingredients.Ingredient_15 = "";
}
db.Ingredients.Add(ingredients);
#endregion
#region Add-Directions-To-Db
DirectionsDTO directions = new DirectionsDTO();
directions.Step_1_Content = model.Directions.Step_1_Content;
if (model.Directions.Step_2_Content != null)
{
directions.Step_2_Content = model.Directions.Step_2_Content;
}
else
{
directions.Step_2_Content = "";
}
if (model.Directions.Step_3_Content != null)
{
directions.Step_3_Content = model.Directions.Step_3_Content;
}
else
{
directions.Step_3_Content = "";
}
if (model.Directions.Step_4_Content != null)
{
directions.Step_4_Content = model.Directions.Step_4_Content;
}
else
{
directions.Step_4_Content = "";
}
if (model.Directions.Step_5_Content != null)
{
directions.Step_5_Content = model.Directions.Step_5_Content;
}
else
{
directions.Step_5_Content = "";
}
if (model.Directions.Step_6_Content != null)
{
directions.Step_6_Content = model.Directions.Step_6_Content;
}
else
{
directions.Step_6_Content = "";
}
if (model.Directions.Step_7_Content != null)
{
directions.Step_7_Content = model.Directions.Step_7_Content;
}
else
{
directions.Step_7_Content = "";
}
if (model.Directions.Step_8_Content != null)
{
directions.Step_8_Content = model.Directions.Step_8_Content;
}
else
{
directions.Step_8_Content = "";
}
if (model.Directions.Step_9_Content != null)
{
directions.Step_9_Content = model.Directions.Step_9_Content;
}
else
{
directions.Step_9_Content = "";
}
if (model.Directions.Step_10_Content != null)
{
directions.Step_10_Content = model.Directions.Step_10_Content;
}
else
{
directions.Step_10_Content = "";
}
db.Directions.Add(directions);
#endregion
db.SaveChanges();
string userName = User.Identity.Name;
UsersDTO user = db.Users.FirstOrDefault(x => x.Login == userName);
DishesDTO dish = new DishesDTO
{
Id_Author = user.Id_User,
Id_Category = model.Dishes.Id_Category,
Id_Direction = directions.Id_Direction,
Id_Ingredient = ingredients.Id_Ingredient,
Name = model.Dishes.Name,
Description = model.Dishes.Description,
Servings = model.Dishes.Servings,
Time = model.Dishes.Time,
Level = model.Dishes.Level,
Date_Added = Convert.ToDateTime(DateTime.Today.ToString("dd-MM-yyyy"))
};
db.Dishes.Add(dish);
db.SaveChanges();
id = dish.Id_Dish;
}
#region Add-Gallery-Path
var originalDirectory = new DirectoryInfo(string.Format("{0}Content\\Images\\Uploads", Server.MapPath(@"\")));
var pathString1 = Path.Combine(originalDirectory.ToString(), "Recipes");
var pathString2 = Path.Combine(originalDirectory.ToString(), "Recipes\\" + id.ToString());
var pathString4 = Path.Combine(originalDirectory.ToString(), "Recipes\\" + id.ToString() + "\\Thumbs");
var pathString3 = Path.Combine(originalDirectory.ToString(), "Recipes\\" + id.ToString() + "\\Gallery");
if (!Directory.Exists(pathString1))
{
Directory.CreateDirectory(pathString1);
}
if (!Directory.Exists(pathString2))
{
Directory.CreateDirectory(pathString2);
}
if (!Directory.Exists(pathString3))
{
Directory.CreateDirectory(pathString3);
}
if (!Directory.Exists(pathString4))
{
Directory.CreateDirectory(pathString4);
}
using (Db db = new Db())
{
DishesDTO dish = new DishesDTO();
dish = db.Dishes.Find(id);
dish.Gallery_Path = pathString4;
db.SaveChanges();
}
#endregion
return(RedirectToAction("AddPhotos", new { id }));
}
