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"));
}
