public void cleanForm()
{
ListOfIngr1.Clean();
RecipeNameTextBox.Text = "";
SubmitedByTextBox.Text = "";
CategoryTextBox.Text = "";
CookingTimeTextBox.Text = "";
NumberOfServingsTextBox.Text = "";
RecipeDescriptionTextBox.Text = "";
}
protected void RecipeSave(object sender, EventArgs e)
{
List <Ingredient> ingreList = ListOfIngr.getIngredientsList();
string cs = ConfigurationManager.ConnectionStrings["CookBookConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("insertRecipe", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter retval = new SqlParameter("RetVal", SqlDbType.Int);
retval.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(new SqlParameter("@Recipe_name", RecipeNameTextBox.Text));
cmd.Parameters.Add(new SqlParameter("@Recipe_submited_by", SubmitedByTextBox.Text));
if (CookingTimeTextBox.Text != "" && CookingTimeTextBox.Text != null)
{
cmd.Parameters.Add(new SqlParameter("@Recipe_prep_time", Double.Parse(CookingTimeTextBox.Text)));
}
else
{
cmd.Parameters.Add(new SqlParameter("@Recipe_prep_time", DBNull.Value));
}
cmd.Parameters.Add(new SqlParameter("@Recipe_servings_numb", int.Parse(NumberOfServingsTextBox.Text)));
cmd.Parameters.Add(new SqlParameter("@Recipe_description", RecipeDescriptionTextBox.Text));
if (CategoryTextBox.Text != "" && CategoryTextBox.Text != null)
{
cmd.Parameters.Add(new SqlParameter("@Recipe_category", CategoryTextBox.Text));
}
else
{
cmd.Parameters.Add(new SqlParameter("@Recipe_category", DBNull.Value));
}
cmd.Parameters.Add(retval);
con.Open();
cmd.ExecuteNonQuery();
int recipeId = (int)retval.Value;
for (int i = 0; i < ingreList.Count; i++)
{
Ingredient ingred = ingreList[i];
SqlCommand ingredientSave = new SqlCommand("insert_ingredient", con);
ingredientSave.CommandType = CommandType.StoredProcedure;
ingredientSave.Parameters.Add(new SqlParameter("@Recipe_id", recipeId));
ingredientSave.Parameters.Add(new SqlParameter("@Ingredient_name", ingred.Name));
if (ingred.UnitOfMeasure != "" && ingred.UnitOfMeasure != null)
{
ingredientSave.Parameters.Add(new SqlParameter("@Ingredient_measure", ingred.UnitOfMeasure));
}
else
{
ingredientSave.Parameters.Add(new SqlParameter("@Ingredient_measure", DBNull.Value));
}
ingredientSave.Parameters.Add(new SqlParameter("@Ingredieent_quantity", ingred.Quantity));
ingredientSave.ExecuteNonQuery();
}
con.Close();
}
ListOfIngr1.Clean();
cleanForm();
}
