public ActionResult UpdateProducto()
{
Product producto;
int id = int.Parse(HttpContext.Request.Params["ProductID"]);
using (AdventureWorks2014Entities contexto = new AdventureWorks2014Entities())
{
var productos = from p in contexto.Product
where p.ProductID == id
select p;
producto = productos.First();
producto.Name = HttpContext.Request.Params["Name"];
producto.ProductNumber = HttpContext.Request.Params["ProductNumber"];
producto.MakeFlag = bool.Parse(HttpContext.Request.Params["MakeFlag"]);
producto.Color = HttpContext.Request.Params["Color"];
producto.SafetyStockLevel = short.Parse(HttpContext.Request.Params["SafetyStockLevel"]);
producto.Size = HttpContext.Request.Params["Size"];
producto.ProductSubcategoryID = int.Parse(HttpContext.Request.Params["ProductSubcategoryID"]);
//producto.SellStartDate = DateTime.Parse(HttpContext.Request.Params["SellStartDate"]);
// producto.SellEndDate = DateTime.Parse(HttpContext.Request.Params["SellEndDate"]);
try
{
contexto.SaveChanges();
ViewBag.Error = false;
}
catch (Exception)
{
ViewBag.Error = true;
producto = (from p in contexto.Product
where p.ProductID == id
select p).First();
}
}
return View("ModificarProducto", producto);
}
public ActionResult UpdateProveedor()
{
Person persona;
int id = int.Parse(HttpContext.Request.Params["BusinessEntityID"]);
using (AdventureWorks2014Entities contexto = new AdventureWorks2014Entities())
{
var proveedor = from prov in contexto.Person
where prov.BusinessEntityID == id
select prov;
persona = proveedor.First();
persona.PersonType = HttpContext.Request.Params["PersonType"];
persona.NameStyle = bool.Parse(HttpContext.Request.Params["NameStyle"]);
persona.Title = HttpContext.Request.Params["Title"];
persona.FirstName = HttpContext.Request.Params["FirstName"];
persona.LastName = HttpContext.Request.Params["LastName"];
persona.MiddleName = HttpContext.Request.Params["MiddleName"];
persona.Suffix = HttpContext.Request.Params["Suffix"];
persona.EmailPromotion = int.Parse(HttpContext.Request.Params["EmailPromotion"]);
persona.AdditionalContactInfo = HttpContext.Request.Params["AdditionalContactInfo"];
persona.ModifiedDate = DateTime.Now;
try
{
contexto.SaveChanges();
ViewBag.error = false;
}
catch(Exception e)
{
ViewBag.error = true;
persona = (from prov in contexto.Person
where prov.BusinessEntityID == id
select prov).First();
}
}
return View("ModificarProveedor", persona);
}
