public ActionResult Details(int?RecipeID)
{
if (RecipeID == null)
{
return(RedirectToAction("Index"));
}
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
/*Added*/
string query = @"SELECT r.RecipeID, r.RecipeName, r.Description, r.Ingredients, r.Instructions,
d.Difficulty, c.Cuisine , cr.MealCourse, m.MeatType, u.FirstName, u.LastName , r.Image, r.DateAdded, r.DateModified
FROM Recipes r
INNER JOIN Cuisine c ON r.CuisineID= c.CuisineID
INNER JOIN Difficulty d ON r.DiffID = d.DiffID
INNER JOIN Course cr ON r.CourseID = cr.CourseID
INNER JOIN Meat m ON r.MeatID = m.MeatID
INNER JOIN Users u ON r.UserID = u.userID WHERE r.RecipeID = @RecipeID";
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@RecipeID", RecipeID);
using (SqlDataReader data = cmd.ExecuteReader())
{
if (data.HasRows)
{
RecipesModels recipe = new RecipesModels();
while (data.Read())
{
recipe.RecipeID = Convert.ToInt32(data["RecipeID"].ToString());
recipe.RecipeName = data["RecipeName"].ToString();
recipe.MealCourse = data["MealCourse"].ToString();
recipe.MeatType = data["MeatType"].ToString();
recipe.Difficulty = int.Parse(data["Difficulty"].ToString());
recipe.FirstName = data["FirstName"].ToString();
recipe.Lastname = data["LastName"].ToString();
recipe.Cuisine = data["Cuisine"].ToString();
recipe.Description = data["Description"].ToString();
recipe.Ingredients = data["Ingredients"].ToString();
recipe.Instructions = data["Instructions"].ToString();
recipe.Difficulty = Convert.ToInt32(data["Difficulty"].ToString());
recipe.DateAdded = DateTime.Parse(data["DateAdded"].ToString());
recipe.DateModified = DateTime.Parse(data["DateModified"].ToString());
recipe.Image = data["Image"].ToString();
}
return(View(recipe));
// ViewBag.Pic = " <a href='Index'><img src='../Images/foodies2.png' width='125'/></a>";
}
else
{
return(RedirectToAction("Index"));
}
}
}
}
}
public ActionResult Add()
{
RecipesModels recipe = new RecipesModels();
recipe.Cuisines = GetCuisinesAdd();
recipe.Courses = GetCoursesAdd();
recipe.Meats = GetMeatsAdd();
recipe.Difficulties = GetDifficultiesAdd();
return(View(recipe));
}
public ActionResult Add(RecipesModels recipe, UsersModel user, HttpPostedFileBase image)
{
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
string query = @"INSERT INTO Recipes VALUES (@RecipeName, @Description, @Ingredients, @Instructions, @DiffID,
@CuisineID, @CourseID ,@MeatID,@UserID, @image,@DateAdded,@DateModified) ";
using (SqlCommand cmd = new SqlCommand(query, con))
{
string imageFile = recipe.Image;
cmd.Parameters.AddWithValue("@RecipeName", recipe.RecipeName);
cmd.Parameters.AddWithValue("@Description", recipe.Description);
cmd.Parameters.AddWithValue("@Ingredients", recipe.Ingredients);
cmd.Parameters.AddWithValue("@Instructions", recipe.Instructions);
cmd.Parameters.AddWithValue("@DiffID", recipe.DiffID);
cmd.Parameters.AddWithValue("@CuisineID", recipe.CuisineID);
cmd.Parameters.AddWithValue("@CourseID", recipe.CourseID);
cmd.Parameters.AddWithValue("@MeatID", recipe.MeatID);
cmd.Parameters.AddWithValue("@UserID", UserLogin.UserID);
cmd.Parameters.AddWithValue("@DateAdded", DateTime.Now);
cmd.Parameters.AddWithValue("@DateModified", DateTime.Now);
double a;
string c = imageFile;
if (imageFile != null)
{
imageFile = DateTime.Now.ToString("yyyyMMddHHmmss-") + image.FileName;
cmd.Parameters.AddWithValue("@image", imageFile);
image.SaveAs(Server.MapPath("~/Images/Users/" + imageFile));
}
else
{
imageFile = "user-default.png";
cmd.Parameters.AddWithValue("@image", imageFile);
}
cmd.ExecuteNonQuery();
return(RedirectToAction("Index", "Recipe"));
}
}
}
