private void DeleteRecipeExecute()
{
try
{
MessageBoxResult result = MessageBox.Show("Are you sure?", "Confirm Deleting", MessageBoxButton.YesNo);
switch (result)
{
case MessageBoxResult.Yes:
using (RecipeDatabaseEntities db = new RecipeDatabaseEntities())
{
tblRecipe deleteRecipe = new tblRecipe();
deleteRecipe = db.tblRecipes.Where(r => r.RecipeID == Recipe.RecipeID).FirstOrDefault();
db.tblRecipes.Remove(deleteRecipe);
db.SaveChanges();
}
MessageBox.Show("Recipe Deleted Successfully!");
AllRecipes = GetAllRecipes();
break;
case MessageBoxResult.No:
break;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
int LastInsertedRecipeId, LastInsertedIngredientId;
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
recipe rObj = new recipe();
rObj.name = txtTitle.Text;
rObj.category = txtCategory.Text;
rObj.submitted_by = txtSubmitted.Text;
rObj.cooking_time = txtCookingTime.Text;
rObj.servings = txtNumServ.Text;
rObj.Description = txtDescription.InnerText;
rObj.MemberId = MemberId;
rdbEnty.recipes.AddObject(rObj);
rdbEnty.SaveChanges();
LastInsertedRecipeId = rObj.id;
int num = 0;
if (Request.Form["hdnIngridient"] != null)
{
int.TryParse(Convert.ToString(Request.Form["hdnIngridient"]), out num);
}
if (num > 0)
{
saveIngridients(LastInsertedRecipeId, num);
}
rdbEnty.SaveChanges();
Response.Redirect("Recipe.aspx");
}
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 SaveExecute()
{
try
{
Ingredients = GetAllIngredients();
using (RecipeDatabaseEntities db = new RecipeDatabaseEntities())
{
tblRecipe oldRecipe = new tblRecipe();
oldRecipe = db.tblRecipes.Where(r => r.RecipeID == Recipe.RecipeID).FirstOrDefault();
oldRecipe.RecipeName = Recipe.RecipeName;
oldRecipe.Portions = Recipe.Portions;
oldRecipe.RecipeType = Type;
oldRecipe.RecipeDateOfCreation = DateTime.Now;
oldRecipe.RecipeText = AllIngredientsToString(Ingredients);
if (oldRecipe.RecipeText == "")
{
MessageBox.Show("Please choose ingredients.");
return;
}
else
{
if (User.UserName == "Admin")
{
oldRecipe.UserID = User.UserID;
}
if (Ingredients != null)
{
foreach (tblIngredient ingredient in Ingredients)
{
tblRecipeIngredient recipeIngredient = new tblRecipeIngredient();
recipeIngredient.RecipeID = Recipe.RecipeID;
recipeIngredient.IngredientID = ingredient.IngredientID;
db.tblRecipeIngredients.Add(recipeIngredient);
}
}
db.SaveChanges();
}
}
MessageBox.Show("Recipe Updated Successfully!");
updateView.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
protected void DelRecipe(object sender, EventArgs e)
{
int ReqRecipe = Convert.ToInt32(Request.QueryString["recipe"]);
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
recipe robj = new recipe()
{
id = ReqRecipe
};
rdbEnty.recipes.Attach(robj);
rdbEnty.recipes.DeleteObject(robj);
rdbEnty.SaveChanges();
Response.Redirect("Recipe.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
select p);
IEnumerable <recipe> recipeList = query.ToList();
string elts;
elts = "";
foreach (var recipe1 in recipeList)
{
elts = elts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'><span>" + recipe1.id.ToString() + ". " + recipe1.name + "</span></a></p>";
}
multiRecipe.InnerHtml = elts;
}
protected void EditRecipe(object sender, EventArgs e)
{
int ReqRecipe = Convert.ToInt32(Request.QueryString["recipe"]);
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
where p.id == ReqRecipe
select p);
IEnumerable <recipe> recipeList = query.ToList();
string elts;
elts = "";
foreach (var recipe1 in recipeList)
{
elts = "?recipe=" + recipe1.id.ToString();
}
Response.Redirect("Update.aspx" + elts);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//fill category drop down list
int ReqRecipe = Convert.ToInt32(Request.QueryString["recipe"]);
if (ReqRecipe > 0)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
where p.id == ReqRecipe
select p);
IEnumerable <recipe> recipeEditList = query.ToList();
foreach (var recipe1 in recipeEditList)
{
txtTitle.Text = recipe1.name;
txtCategory.Text = recipe1.category;
txtCookingTime.Text = recipe1.cooking_time;
txtNumServ.Text = recipe1.servings;
txtSubmitted.Text = recipe1.submitted_by;
txtDescription.InnerText = recipe1.Description;
}
//Get More ingridient list.
var moreIngridientResult = (from ri in rdbEnty.recipe_ingredients
join r in rdbEnty.recipes on ri.recipe_id equals r.id
join i in rdbEnty.ingredients on ri.ingredient_id equals i.id
where ri.recipe_id == ReqRecipe
select new IngredientRecipeResult
{
recipe_ingredientsid = ri.id,
recipe_id = ri.recipe_id,
ingredient_id = ri.ingredient_id,
ingredientname = i.name,
unit = ri.unit,
quantity = ri.quantity
});
moreIngridientList = moreIngridientResult.ToList();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int ReqRecipe = Convert.ToInt32(Request.QueryString["recipe"]);
if (ReqRecipe > 0)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
where p.id == ReqRecipe
select p);
IEnumerable <recipe> recipeEditList = query.ToList();
foreach (var recipe1 in recipeEditList)
{
///recipeName.InnerText = recipe1.name;
//update recipe data
recipe1.name = txtTitle.Text;
recipe1.category = txtCategory.Text;
recipe1.cooking_time = txtCookingTime.Text;
recipe1.servings = txtNumServ.Text;
recipe1.Description = txtDescription.InnerText;
rdbEnty.SaveChanges();
}
int num = 0;
if (Request.Form["hdnIngridient"] != null)
{
int.TryParse(Convert.ToString(Request.Form["hdnIngridient"]), out num);
}
if (num > 0)
{
updateIngridients(ReqRecipe, num);
}
//Redirect to recipe edit details page.
Response.Redirect("RecipeDetails.aspx?recipe=" + ReqRecipe);
}
}
private List <tblRecipe> GetAllRecipes()
{
List <tblRecipe> recipes = new List <tblRecipe>();
try
{
using (RecipeDatabaseEntities db = new RecipeDatabaseEntities())
{
foreach (tblRecipe recipe in db.tblRecipes)
{
recipes.Add(recipe);
}
}
return(recipes);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(null);
}
}
private List <tblIngredient> GetAllIngredients()
{
List <string> allIngredients = new List <string>();
string _location = @"~/../../../ingredients.txt";
try
{
if (File.Exists(_location))
{
string[] allLines = File.ReadAllLines(_location);
foreach (string line in allLines)
{
if (line == "")
{
continue;
}
allIngredients.Add(line);
}
}
List <tblIngredient> realIngredients = new List <tblIngredient>();
using (RecipeDatabaseEntities db = new RecipeDatabaseEntities())
{
foreach (string ing in allIngredients)
{
tblIngredient i = new tblIngredient();
i = db.tblIngredients.Where(ingr => ingr.IngredientName == ing).FirstOrDefault();
realIngredients.Add(i);
}
}
return(realIngredients);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["MemberId"] != null && Convert.ToInt32(Session["MemberId"]) > 0)
{
//Set true if session contains MemberId.
gblBlnIsMemberLogin = true;
MemberId = Convert.ToInt32(Session["MemberId"]);
MemberUserName = Convert.ToString(Session["UserName"]);
}
int ReqRecipe = Convert.ToInt32(Request.QueryString["recipe"]);
if (ReqRecipe > 0)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
where p.id == ReqRecipe
select p);
IEnumerable <recipe> recipeList = query.ToList();
foreach (var recipe1 in recipeList)
{
recipeName.InnerText = recipe1.name;
submitted_by.InnerText = recipe1.submitted_by;
cookingt.InnerText = recipe1.cooking_time + " minutes";
servings.InnerText = recipe1.servings;
direction.InnerText = recipe1.Description;
var query1 = (from p1 in rdbEnty.recipe_ingredients where p1.recipe_id == recipe1.id select p1);
IEnumerable <recipe_ingredients> recipeList1 = query1.ToList();
string ri_items = "";
foreach (recipe_ingredients recipe11 in recipeList1)
{
ri_items += "<p class='item-sub'>" + recipe11.ingredient_id + ")." + recipe11.name + " : " + recipe11.quantity + " " + recipe11.unit + "</p>";
}
Ingredient.InnerHtml = ri_items;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
select p);
IEnumerable <recipe> recipeList = query.ToList();
foreach (var recipe1 in recipeList)
{
ddRecipeName.Items.Add(new ListItem(recipe1.name, recipe1.id.ToString()));
ddRecipeCreator.Items.Add(new ListItem(recipe1.submitted_by, recipe1.id.ToString()));
}
var query1 = (from i1 in rdbEnty.ingredients
select i1);
IEnumerable <ingredient> incList = query1.ToList();
foreach (var inc1 in incList)
{
ddInc.Items.Add(new ListItem(inc1.name, inc1.id.ToString()));
}
}
}
private void SaveExecute()
{
try
{
Ingredients = GetAllIngredients();
Recipe.RecipeType = Type;
Recipe.RecipeDateOfCreation = DateTime.Now;
Recipe.RecipeText = AllIngredientsToString(Ingredients);
if (Recipe.RecipeText == "")
{
MessageBox.Show("Please choose ingredients.");
return;
}
using (RecipeDatabaseEntities db = new RecipeDatabaseEntities())
{
Recipe.UserID = User.UserID;
db.tblRecipes.Add(Recipe);
db.SaveChanges();
foreach (tblIngredient ingredient in Ingredients)
{
tblRecipeIngredient recipeIngredient = new tblRecipeIngredient();
recipeIngredient.RecipeID = Recipe.RecipeID;
recipeIngredient.IngredientID = ingredient.IngredientID;
db.tblRecipeIngredients.Add(recipeIngredient);
}
db.SaveChanges();
}
MessageBox.Show("Recipe Created Successfully!");
addRecipe.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
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();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["MemberId"] != null && Convert.ToInt32(Session["MemberId"]) > 0)
{
//Set true if session contains MemberId.
gblBlnIsMemberLogin = true;
MemberId = Convert.ToInt32(Session["MemberId"]);
MemberUserName = Convert.ToString(Session["UserName"]);
}
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
select p);
IEnumerable <recipe> recipeList = query.ToList();
string menuItems;
menuItems = "";
foreach (var recipe1 in recipeList)
{
menuItems = menuItems + "<li><a href='recipeDetails.aspx?recipe=" + recipe1.id + "'>" + recipe1.name + " </a></li>";
}
//RecipeMenu.InnerHtml = menuItems;
}
private void updateIngridients(int recipeId, int totalIngridients)
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
string name = ""; int Q = 0; string unit = ""; string qty = "";
int recipe_ingredientsid = 0;
for (int i = 1; i <= totalIngridients; i++)
{
name = "";
qty = "";
unit = "";
Q = 0;
//Get recipe_ingredientsid.
if (Request.Form["hdnRecipeIngridientsId" + i] != null && !string.IsNullOrWhiteSpace(Request.Form["hdnRecipeIngridientsId" + i]))
{
int.TryParse(Convert.ToString(Request.Form["hdnRecipeIngridientsId" + i]), out recipe_ingredientsid);
}
//Get Ingridients.
if (Request.Form["txtIngridients" + i] != null && !string.IsNullOrWhiteSpace(Request.Form["txtIngridients" + i]))
{
name = Convert.ToString(Request.Form["txtIngridients" + i]);
}
//Get Quantity.
if (Request.Form["txtQuantity" + i] != null && !string.IsNullOrWhiteSpace(Request.Form["txtQuantity" + i]))
{
qty = Convert.ToString(Request.Form["txtQuantity" + i]);
//Parse the string variable qty have valid interger value and store into Q (int) variable. Otherwise it will store 0.
int.TryParse(qty, out Q);
}
//Get Unit Name.
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)
{
var ingridientResult = (from ri in rdbEnty.recipe_ingredients
join r in rdbEnty.recipes on ri.recipe_id equals r.id
join ing in rdbEnty.ingredients on ri.ingredient_id equals ing.id
where ri.recipe_id == recipeId && ri.id == recipe_ingredientsid
select ing);
//Update ingridient.
IEnumerable <ingredient> ingredientEditList = ingridientResult.ToList();
foreach (var ingredient in ingredientEditList)
{
ingredient.name = name;
ingredient.MemberId = MemberId;
rdbEnty.SaveChanges();
}
var recipe_ingridientResult = (from ri in rdbEnty.recipe_ingredients
join r in rdbEnty.recipes on ri.recipe_id equals r.id
join ing in rdbEnty.ingredients on ri.ingredient_id equals ing.id
where ri.recipe_id == recipeId && ri.id == recipe_ingredientsid
select ri);
//Update recipe_ingridient.
IEnumerable <recipe_ingredients> recipe_ingredientsEditList = recipe_ingridientResult.ToList();
foreach (var recipe_ingredients in recipe_ingredientsEditList)
{
recipe_ingredients.ingredient_id = ingredientEditList.ToList()[0].id;
recipe_ingredients.recipe_id = recipeId;
recipe_ingredients.unit = unit;
recipe_ingredients.quantity = Q;
recipe_ingredients.MemberId = MemberId;
rdbEnty.SaveChanges();
}
}
}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
int IncVal = Convert.ToInt32(ddInc.SelectedValue);
int RecVal = Convert.ToInt32(ddRecipeName.SelectedValue);
if (IncVal > 0 && RecVal > 0 && ddRecipeCreator.SelectedItem.Text != "All")
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
from ri in rdbEnty.recipe_ingredients
join i in rdbEnty.ingredients on ri.ingredient_id equals i.id
where p.id == RecVal && i.id == IncVal && p.submitted_by == ddRecipeCreator.SelectedItem.Text
select p);
IEnumerable <recipe> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int ii;
ii = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
ii++;
}
searchedItemsCount.InnerHtml = (ii).ToString();
searchedItems.InnerHtml = htmlElts;
}
else if (IncVal > 0 && RecVal > 0 && ddRecipeCreator.SelectedItem.Text == "All")
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes from ri in rdbEnty.recipe_ingredients join i in rdbEnty.ingredients on ri.ingredient_id equals i.id where p.id == RecVal && i.id == IncVal select p);
IEnumerable <recipe> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int ii;
ii = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
ii++;
}
searchedItemsCount.InnerHtml = (ii).ToString();
searchedItems.InnerHtml = htmlElts;
}
else if (IncVal == 0 && RecVal > 0 && ddRecipeCreator.SelectedItem.Text != "All")
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes where p.id == RecVal && p.submitted_by == ddRecipeCreator.SelectedItem.Text select p);
IEnumerable <recipe> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int ii;
ii = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
ii++;
}
searchedItemsCount.InnerHtml = (ii).ToString();
searchedItems.InnerHtml = htmlElts;
}
else if (IncVal == 0 && RecVal > 0 && ddRecipeCreator.SelectedItem.Text == "All")
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes where p.id == RecVal select p);
IEnumerable <recipe> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int ii;
ii = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
ii++;
}
searchedItemsCount.InnerHtml = (ii).ToString();
searchedItems.InnerHtml = htmlElts;
}
else if (IncVal > 0 && RecVal == 0 && ddRecipeCreator.SelectedItem.Text == "All")
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from i in rdbEnty.ingredients where i.name == ddInc.SelectedItem.Text select i);
IEnumerable <ingredient> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int ii;
ii = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
ii++;
}
searchedItemsCount.InnerHtml = (ii).ToString();
searchedItems.InnerHtml = htmlElts;
}
else if (IncVal == 0 && RecVal == 0 && ddRecipeCreator.SelectedItem.Text != "All")
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from r in rdbEnty.recipes where r.submitted_by == ddRecipeCreator.SelectedItem.Text select r);
IEnumerable <recipe> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int ii;
ii = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
ii++;
}
searchedItemsCount.InnerHtml = (ii).ToString();
searchedItems.InnerHtml = htmlElts;
}
else
{
RecipeDatabaseEntities rdbEnty = new RecipeDatabaseEntities();
var query = (from p in rdbEnty.recipes
select p);
IEnumerable <recipe> recipeList = query.ToList();
string htmlElts;
htmlElts = "";
int i;
i = 0;
foreach (var recipe1 in recipeList)
{
htmlElts = htmlElts + "<p class='item'><a href='RecipeDetails.aspx?recipe=" + recipe1.id.ToString() + "'>" + recipe1.name + "</a></p>";
i++;
}
searchedItemsCount.InnerHtml = (i - 1).ToString();
searchedItems.InnerHtml = htmlElts;
}
}
