//INSERT NEW ITEM
public int InsertNewItem(Item_InsertRequest model)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["GroceryListConnection"].ConnectionString))
{
con.Open();
var cmd = con.CreateCommand();
cmd.CommandText = "InsertNewItem";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Items", model.Items);
cmd.Parameters.AddWithValue("@Quantity", model.Quantity);
SqlParameter outParams = cmd.Parameters.Add("Id", SqlDbType.Int);
outParams.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return((int)outParams.Value);
}
}
public object InsertNewItem(Item_InsertRequest model)
{
return(groceryListService.InsertNewItem(model)); //best practice to make an itemsresponse object
}
