public ActionResult Editar(FASV1_GetAllProducts_Result e) { try { using (var db = new DataProductsEntities()) { Products p = db.Products.Find(e.Id); p.Nombre = e.Nombre; p.IdColor = e.IdColor; p.Description = e.Description; p.PriceClient = e.PriceClient; p.IsEnabled = e.IsEnabled; p.DateUpdate = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception) { throw; } }
public ActionResult Agregar(FASV1_GetAllProducts_Result p) { if (!ModelState.IsValid) { return(View()); } try { p.DateUpdate = DateTime.Now; SqlParameter param1 = new SqlParameter("@Title", p.Nombre); SqlParameter param2 = new SqlParameter("@descripcion", p.Description); SqlParameter param3 = new SqlParameter("@price", p.PriceClient); SqlParameter param4 = new SqlParameter("@color", p.IdColor); SqlParameter param5 = new SqlParameter("@date", p.DateUpdate); var db = new DataProductsEntities(); var data = db.Database.ExecuteSqlCommand("FASV1_InsertProduct @Title , @descripcion , @price , @color, @date", param1, param2, param3, param4, param5); return(RedirectToAction("Index")); } catch (Exception) { throw; } }
public ActionResult Delete(int id) { using (var db = new DataProductsEntities()) { FASV1_GetAllProducts_Result Ez = db.FASV1_GetAllProducts().Where(a => a.Id == id).FirstOrDefault(); db.FASV1_DeleteLogic(id); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Editar(int id) { try { using (var db = new DataProductsEntities()) { FASV1_GetAllProducts_Result Ez = db.FASV1_GetAllProducts().Where(a => a.Id == id).FirstOrDefault(); return(View(Ez)); } } catch (Exception) { throw; } }