public int Insert(RecipeInsert recipe)
{
using (var con = GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = "RECIPE_INSERT";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@publisher", recipe.Publisher);
cmd.Parameters.AddWithValue("@f2f_url", recipe.F2f_url);
cmd.Parameters.AddWithValue("@title", recipe.Title);
cmd.Parameters.AddWithValue("@source_url", recipe.Source_url);
cmd.Parameters.AddWithValue("@recipe_id", recipe.Recipe_id);
cmd.Parameters.AddWithValue("@image_url", recipe.Image_url);
cmd.Parameters.AddWithValue("@publisher_url", recipe.Publisher_url);
cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@id"].Value);
}
}
public int Insert(RecipeInsert recipe)
{
return(recipeService.Insert(recipe));
}
