public IHttpActionResult PutProductdetail(int id, Productdetail productdetail)
{
if (id != productdetail.id)
{
return(BadRequest());
}
db.Entry(productdetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductdetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
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"));
}
