private void saveIngridients(int recipeId, int totalIngridients)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
string name = ""; int Q = 0; string unit = ""; string qty = "";
for (int i = 1; i <= totalIngridients; i++)
{
name = "";
qty = "";
unit = "";
Q = 0;
if (Request.Form["txtIngridients" + i] != null && !string.IsNullOrWhiteSpace(Request.Form["txtIngridients" + i]))
{
name = Convert.ToString(Request.Form["txtIngridients" + i]);
}
if (Request.Form["txtQuantity" + i] != null && !string.IsNullOrWhiteSpace(Request.Form["txtQuantity" + i]))
{
qty = Convert.ToString(Request.Form["txtQuantity" + i]);
int.TryParse(qty, out Q);
}
if (Request.Form["ddlUnit" + i] != null && !string.IsNullOrWhiteSpace(Request.Form["ddlUnit" + i]))
{
unit = Convert.ToString(Request.Form["ddlUnit" + i]);
}
if (!string.IsNullOrWhiteSpace(name) && !string.IsNullOrWhiteSpace(unit) && Q > 0)
{
ingredient iObj = new ingredient();
iObj.name = name;
iObj.MemberId = MemberId;
rdbEnty.ingredients.AddObject(iObj);
rdbEnty.SaveChanges();
int LastInsertedIngredientId = iObj.id;
recipe_ingredients riObj = new recipe_ingredients();
riObj.ingredient_id = LastInsertedIngredientId;
riObj.recipe_id = recipeId;
riObj.name = name;
riObj.unit = unit;
riObj.quantity = Q;
riObj.MemberId = MemberId;
rdbEnty.recipe_ingredients.AddObject(riObj);
rdbEnty.SaveChanges();
}
}
}
private void addMoreIngridients(int recipeId)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
int ind = int.Parse(Session["ind"].ToString());
string name = ""; int Q = 0; string unit = "";
for (int i = 1; i < ind; i++)
{
if (Panel1.Controls[i] is TextBox && Panel1.Controls[i].ID.EndsWith("Q"))
{
Q = int.Parse(((TextBox)(Panel1.Controls[ind])).Text);
}
else if (Panel1.Controls[i] is TextBox)
{
name = ((TextBox)(Panel1.Controls[i])).Text;
}
else if (Panel1.Controls[i] is DropDownList)
{
unit = ((DropDownList)Panel1.Controls[i]).Text;
ingredient iObj = new ingredient();
iObj.name = name;
iObj.MemberId = MemberId;
rdbEnty.ingredients.AddObject(iObj);
rdbEnty.SaveChanges();
int LastInsertedIngredientId = iObj.id;
recipe_ingredients riObj = new recipe_ingredients();
riObj.ingredient_id = LastInsertedIngredientId;
riObj.recipe_id = recipeId;
riObj.unit = unit;
riObj.quantity = Q;
riObj.MemberId = MemberId;
rdbEnty.recipe_ingredients.AddObject(riObj);
rdbEnty.SaveChanges();
}
}
}
