public int MarkFavourite(AddToLikeCart recipe, int userId)
{
using (var cmd = new SqlCommand("AddToCart", _sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@RecipeId", System.Data.SqlDbType.Int).Value = recipe.recipeId;
cmd.Parameters.Add("@UserId", System.Data.SqlDbType.TinyInt).Value = userId;
cmd.Parameters.Add("@Image", System.Data.SqlDbType.NVarChar).Value = recipe.Image;
cmd.Parameters.Add("@Summary", System.Data.SqlDbType.VarChar).Value = recipe.Summary;
cmd.Parameters.Add("@Title", System.Data.SqlDbType.VarChar).Value = recipe.Title;
cmd.Parameters.Add("@Servings", System.Data.SqlDbType.SmallInt).Value = recipe.Servings;
cmd.Parameters.Add("@Price", System.Data.SqlDbType.SmallInt).Value = recipe.Price;
cmd.Parameters.Add("@Score", System.Data.SqlDbType.TinyInt).Value = recipe.Score;
cmd.Parameters.Add("@Time", System.Data.SqlDbType.VarChar).Value = recipe.Time;
cmd.Parameters.Add("@cartId", System.Data.SqlDbType.SmallInt).Direction = System.Data.ParameterDirection.Output;
_sqlConn.Open();
cmd.ExecuteNonQuery();
if (cmd.Parameters["@cartId"].Value == DBNull.Value)
{
return(-1);
}
var cartId = Convert.ToInt32(cmd.Parameters["@cartId"].Value);
_sqlConn.Close();
return(cartId);
}
}
public ActionResult AddToCart(AddToLikeCart recipe)
{
var userInfo = Session["userLogInStatus"] as LoginVIewModel;
var userId = userInfo.UserId;
var manager = new DBManager("SpoonacularDB");
var cartId = manager.MarkFavourite(recipe, userId);
return(Content(cartId.ToString()));
}
public ActionResult PurchaseIngredients(AddToLikeCart recipe)
{
var extendedIngredientsJarray = (JArray)JsonConvert.DeserializeObject(recipe.jsonExtendedIngredientsArray);
var extendedIngredients = extendedIngredientsJarray.Select(x => new Ingredient()
{
Amount = (short)x["amount"],
IngredientId = (int)x["id"],
Name = (string)x["name"],
Image = (string)x["image"],
Unit = (string)x["unit"]
}).ToList();
var userInfo = Session["userLogInStatus"] as LoginVIewModel;
var userId = userInfo.UserId;
var manager = new DBManager("SpoonacularDB");
manager.PurchaseIngredients(extendedIngredients, userId, recipe);
return(Content("asd"));
}
public int PurchaseIngredients(List <Ingredient> ingredientsList, int userId, AddToLikeCart recipe)
{
MarkFavourite(recipe, userId);
using (var cmd = new SqlCommand("PurchaseIngredients", _sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (_sqlConn.State != System.Data.ConnectionState.Open)
{
_sqlConn.Open();
}
foreach (var ingredient in ingredientsList)
{
cmd.Parameters.Clear();
cmd.Parameters.Add("@cartId", System.Data.SqlDbType.SmallInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add("@UserId", System.Data.SqlDbType.TinyInt).Value = userId;
cmd.Parameters.Add("@IngredientId", System.Data.SqlDbType.Int).Value = ingredient.IngredientId;
cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar).Value = ingredient.Name;
cmd.Parameters.Add("@Image", System.Data.SqlDbType.VarChar).Value = ingredient.Image;
cmd.Parameters.Add("@Unit", System.Data.SqlDbType.VarChar).Value = ingredient.Unit;
cmd.Parameters.Add("@Amount", System.Data.SqlDbType.SmallInt).Value = ingredient.Amount;
cmd.Parameters.Add("@recipeId", System.Data.SqlDbType.Int).Value = recipe.recipeId;
cmd.ExecuteNonQuery();
}
_sqlConn.Close();
return(0);
}
}
