public static void SavePCICardToDB(string partid) { JObject chosenpart = GetPartData(partid); Entities ORM = new Entities(); PCICard tempObj = new PCICard(chosenpart["title"].ToString()); List <PCICard> z = new List <PCICard>(); z = ORM.PCICards.Where(x => x.ProductID == partid).ToList(); if (z.Count < 1) { tempObj.ProductID = chosenpart["product_id"].ToString(); tempObj.Description = "x"; tempObj.Brand = chosenpart["brand"].ToString(); tempObj.Price = int.Parse(chosenpart["price"].ToString()); tempObj.Stars = float.Parse(chosenpart["stars"].ToString()); tempObj.ImageLink = chosenpart["main_image"].ToString(); tempObj.Manufacturer = "x"; ORM.PCICards.Add(tempObj); ORM.SaveChanges(); } }
public static void SavePCICardsToDB() { List <JObject> searchedparts = new List <JObject>(); searchedparts = GetPartData(GetParts("PCI+Card")); Entities ORM = new Entities(); foreach (JObject part in searchedparts) { string y = part["product_id"].ToString(); PCICard tempObj = new PCICard(part["title"].ToString()); List <PCICard> z = new List <PCICard>(); z = ORM.PCICards.Where(x => x.ProductID == y).ToList(); if (z.Count < 1) { tempObj.ProductID = part["product_id"].ToString(); tempObj.Description = "x";//part["product_description"].ToString(); tempObj.Brand = part["brand"].ToString(); tempObj.Price = int.Parse(part["price"].ToString()); tempObj.Stars = float.Parse(part["stars"].ToString()); tempObj.ImageLink = part["main_image"].ToString(); tempObj.Manufacturer = "x"; ORM.PCICards.Add(tempObj); ORM.SaveChanges(); } } }