public List <Details> GetCustomers() { using (TestDBEntities1 md = new TestDBEntities1()) { return(md.Tables.Select(pe => new Details { Id = pe.Id, Name = pe.Name, Address = pe.Address, Phone = (int)pe.Phone }).ToList()); } }
public ActionResult Upload(HttpPostedFileBase xmlFile) { if (xmlFile.ContentType.Equals("application/xml") || xmlFile.ContentType.Equals("text/xml")) { var xmlPath = Server.MapPath("~/FileUpload" + xmlFile.FileName); xmlFile.SaveAs(xmlPath); XDocument xDoc = XDocument.Load(xmlPath); List <Product> productList = xDoc.Descendants("product").Select (product => new Product { Id = Convert.ToInt32(product.Element("id").Value), Name = product.Element("name").Value, Price = Convert.ToInt32(product.Element("price").Value), Quantity = Convert.ToInt32(product.Element("quantity").Value) }).ToList(); using (TestDBEntities1 db = new TestDBEntities1()) { foreach (var i in productList) { var v = db.Products.Where(a => a.Id.Equals(i.Id)).FirstOrDefault(); if (v != null) { v.Id = i.Id; v.Name = i.Name; v.Price = i.Price; v.Quantity = i.Quantity; } else { db.Products.Add(i); } db.SaveChanges(); } } ViewBag.Success = "File uploaded successfully.."; } return(View("Index")); }