public static List <Recipe> GetAllForLst() { List <Recipe> lstRecipe = new List <Recipe>(); var lstXMLNodes = MyProjectXML.ins.db.SelectNodes("root/Recipe"); foreach (XmlElement item in lstXMLNodes) { Recipe recipe = new Recipe(); recipe.ID = Convert.ToInt32(item.GetAttribute("Value")); //GET name recipe.Name = item.ChildNodes[0].InnerText; //GET desc recipe.Descrition = item.ChildNodes[1].InnerText; //GET image foreach (XmlElement elementXML in item.ChildNodes[2].ChildNodes) { recipe.Images.Add(ImagePathDirectory + elementXML.InnerText); } //get Youtube Link recipe.YoutubeLink = item.ChildNodes[3].InnerText; //get shopping list foreach (XmlElement elementXML in item.ChildNodes[4].ChildNodes) { recipe.ShoppingList.Add(new ComponentRecipe() { Name = elementXML.GetAttribute("Name"), Count = elementXML.GetAttribute("Value") }); } //get tutorials foreach (XmlElement elementXML in item.ChildNodes[5].ChildNodes) { CookingStep cookingStep = new CookingStep() { StepNumber = Convert.ToInt32(elementXML.GetAttribute("Value")), StepDerc = elementXML.ChildNodes[1].InnerText }; foreach (XmlElement ImageSourceXML in elementXML.ChildNodes[0]) { cookingStep.StepImages.Add(ImagePathDirectory + ImageSourceXML.InnerText); } recipe.Tutorials.Add(cookingStep); } recipe.rate = Convert.ToInt32((item.ChildNodes[6] as XmlElement).GetAttribute("Value")); recipe.IsFavorite = Convert.ToBoolean((item.ChildNodes[7] as XmlElement).GetAttribute("Value")); lstRecipe.Add(recipe); } return(lstRecipe); }
public static Recipe GetAllInfoByID(int id) { Recipe recipe = new Recipe(); var MyXMLNode = MyProjectXML.ins.db.SelectSingleNode($"root/Recipe [@Value='{id}']"); recipe.ID = id; //GET Name recipe.Name = MyXMLNode.ChildNodes[0].InnerText; //GET desc recipe.Descrition = MyXMLNode.ChildNodes[1].InnerText; //GET image foreach (XmlElement elementXML in MyXMLNode.ChildNodes[2].ChildNodes) { recipe.Images.Add(ImagePathDirectory + elementXML.InnerText); } //get Youtube Link recipe.YoutubeLink = MyXMLNode.ChildNodes[3].InnerText; //get shopping list foreach (XmlElement elementXML in MyXMLNode.ChildNodes[4].ChildNodes) { recipe.ShoppingList.Add(new ComponentRecipe() { Name = elementXML.GetAttribute("Name"), Count = elementXML.GetAttribute("Value") }); } //get tutorials foreach (XmlElement elementXML in MyXMLNode.ChildNodes[5].ChildNodes) { CookingStep cookingStep = new CookingStep() { StepNumber = Convert.ToInt32(elementXML.GetAttribute("Value")), StepDerc = elementXML.ChildNodes[1].InnerText }; foreach (XmlElement ImageSourceXML in elementXML.ChildNodes[0]) { cookingStep.StepImages.Add(ImagePathDirectory + ImageSourceXML.InnerText); } recipe.Tutorials.Add(cookingStep); } recipe.rate = Convert.ToInt32((MyXMLNode.ChildNodes[6] as XmlElement).GetAttribute("Value")); recipe.IsFavorite = Convert.ToBoolean((MyXMLNode.ChildNodes[7] as XmlElement).GetAttribute("Value")); return(recipe); }