public ActionResult Delete(int recipeId)
{
SqlConnect deleteSql = new SqlConnect();
//delete ingedrients, favourites and recipe
//deleteSql.cmdExecute("delete from Ingedrients where recipe_id='" + recipeId + "'");
//deleteSql.cmdExecute("delete from Favourites where recipe_id='" + recipeId + "'");
//deleteSql.cmdExecute("delete from Recipe where id='" + recipeId + "'");
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@recipe_id", recipeId));
deleteSql.executeStoredProcedure("DeleteRecipeIngedrients", param);
deleteSql.executeStoredProcedure("DeleteFavouritesByRecipe", param);
deleteSql.executeStoredProcedure("DeleteRecipe", param);
return(RedirectToAction("Index", "Home"));
}
public ActionResult Create(Recipe recipe)
{
//upload image
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file.ContentType.ToLower() != "image/jpg" &&
file.ContentType.ToLower() != "image/jpeg" &&
file.ContentType.ToLower() != "image/pjpeg" &&
file.ContentType.ToLower() != "image/gif" &&
file.ContentType.ToLower() != "image/x-png" &&
file.ContentType.ToLower() != "image/png")
{
ModelState.AddModelError("", "Not a valid image file");
return(View());
}
//string dd = DateTime.Now();
if (file != null && file.ContentLength > 0)
{
var imgName = Path.GetFileName(file.FileName);
var fileName = generateUniqueID() + imgName;
var path = Path.Combine(Server.MapPath("~/Content/Images/"), fileName);
file.SaveAs(path);
recipe.img = fileName; // [IMAGE]
}
}
List <string> ingedrientsList = new List <string>();
//get list of ingedrients
string ingedrients = Request["ingedrients"].ToString();
//System.Diagnostics.Debug.Print(ingedrients);
string[] str = ingedrients.Split(','); //separating ingedrients
foreach (string s in str)
{
if (!string.IsNullOrWhiteSpace(s))
{
ingedrientsList.Add(s); // [INGEDRIENTS]
}
}
//Response.Write("Valid Ingedrients count: " + ingedrientsList.Count);
//recipe.id = HomeController.recipeList.Count + 1; // [ID]
recipe.id = RecipeAccess.getInstance().getNewRecipeId();
recipe.creatorId = UserAccess.getInstance().getUser().id; // [CREATOR ID]
/*************************************/
/*************************************/
//Write to database
//Write recipe to [Recipe]
//SqlConnect sql = new SqlConnect();
//sql.cmdExecute("insert into recipe values ('" + recipe.id + "','" + recipe.creatorId + "','" + recipe.name + "','" + recipe.type + "','" + recipe.img + "','" + recipe.description + "','" + recipe.process + "')");
//Write ingedrients to [Ingedrients]
//foreach (string ingedrient in ingedrientsList)
//{
// sql.cmdExecute("insert into Ingedrients values('" + recipe.id + "','" + ingedrient + "')");
//}
/*************************************/
SqlConnect createSql = new SqlConnect();
System.Diagnostics.Debug.Print("Type: " + recipe.type);
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@id", recipe.id),
new KeyValuePair <string, object>("@creatorId", recipe.creatorId),
new KeyValuePair <string, object>("@name", recipe.name),
new KeyValuePair <string, object>("@type", recipe.type),
new KeyValuePair <string, object>("@img", recipe.img),
new KeyValuePair <string, object>("@description", recipe.description),
new KeyValuePair <string, object>("@process", recipe.process)
};
createSql.executeStoredProcedure("CreateRecipe", param);
foreach (string ingedrient in ingedrientsList)
{
param.Clear();
param.Add(new KeyValuePair <string, object>("@recipe_id", recipe.id));
param.Add(new KeyValuePair <string, object>("@ingedrient", ingedrient));
createSql.executeStoredProcedure("CreateRecipeIngedrients", param);
}
//return View();
//return RedirectToAction("Index", "Home");
return(RedirectToAction("Recipe", "Recipe", new { id = recipe.id }));
}
public ActionResult Edit(Recipe recipe)
{
//update database
//Response.Write("Image: " + recipe.img);
//Response.Write("<script>alert('Image: " + recipe.img + "')</script>");
SqlConnect updateSql = new SqlConnect();
//upload image
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
//if (file.ContentType.ToLower() != "image/jpg" &&
// file.ContentType.ToLower() != "image/jpeg" &&
// file.ContentType.ToLower() != "image/pjpeg" &&
// file.ContentType.ToLower() != "image/gif" &&
// file.ContentType.ToLower() != "image/x-png" &&
// file.ContentType.ToLower() != "image/png")
//{
// ModelState.AddModelError("", "Not a valid image file");
// return View();
//}
if (file != null && file.ContentLength > 0)
{
var imgName = Path.GetFileName(file.FileName);
var fileName = generateUniqueID() + imgName;
var path = Path.Combine(Server.MapPath("~/Content/Images/"), fileName);
file.SaveAs(path);
recipe.img = fileName; // [IMAGE]
//if image file loaded then change otherwise nothing
//updateSql.cmdExecute("update Recipe set img='" + recipe.img + "' where id='" + recipe.id + "'");
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@image", recipe.img),
new KeyValuePair <string, object>("@recipe_id", recipe.id)
};
updateSql.executeStoredProcedure("UpdateImage", param);
}
}
List <string> ingedrientsList = new List <string>();
//get list of ingedrients
string ingedrients = Request["ingedrients"].ToString();
//System.Diagnostics.Debug.Print(ingedrients);
string[] str = ingedrients.Split(','); //separating ingedrients
foreach (string s in str)
{
if (!string.IsNullOrWhiteSpace(s))
{
ingedrientsList.Add(s); // [INGEDRIENTS]
}
}
Response.Write("Valid Ingedrients count: " + ingedrientsList.Count);
//TODO: need to get count from databse directly / or generate a random unique key
//recipe.id = HomeController.recipeList.Count + 1; // [ID]
//System.Diagnostics.Debug.Print("Recipe id: " + recipe.id);
recipe.creatorId = UserAccess.getInstance().getUser().id; // [CREATOR ID]
////Write to database
////Write recipe to [Recipe]
//updateSql.cmdExecute("update Recipe set name='" + recipe.name + "', description='" + recipe.description + "', process='" + recipe.process + "' where id='" + recipe.id + "'");
////clear ingedrients table and repopulate ingedrients table
//updateSql.cmdExecute("delete from Ingedrients where recipe_id='" + recipe.id + "'");
////Write ingedrients to [Ingedrients]
//foreach (string ingedrient in ingedrientsList)
//{
// updateSql.cmdExecute("insert into Ingedrients values('" + recipe.id + "','" + ingedrient + "')");
//}
//Update Recipe
List <KeyValuePair <string, object> > param1 = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@recipe_name", recipe.name),
new KeyValuePair <string, object>("@recipe_description", recipe.description),
new KeyValuePair <string, object>("@recipe_process", recipe.process),
new KeyValuePair <string, object>("@recipe_id", recipe.id)
};
updateSql.executeStoredProcedure("UpdateRecipe", param1);
//Delete Ingedrients
param1.Clear();
param1.Add(new KeyValuePair <string, object>("@recipe_id", recipe.id));
updateSql.executeStoredProcedure("DeleteRecipeIngedrients", param1);
//Add modified Ingedrients
foreach (string ingedrient in ingedrientsList)
{
param1.Clear();
param1.Add(new KeyValuePair <string, object>("@recipe_id", recipe.id));
param1.Add(new KeyValuePair <string, object>("@ingedrient", ingedrient));
updateSql.executeStoredProcedure("CreateRecipeIngedrients", param1);
}
//return RedirectToAction("Index", "Home");
return(RedirectToAction("Recipe", "Recipe", new { id = recipe.id }));
}
