public ActionResult Edit(string name) { if (name == null) { name = string.Empty; } SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = new SqlCommand("select * from Cat where name = @name", connection); command.Parameters.AddWithValue("@name", name); SqlDataReader dataReader = command.ExecuteReader(); CatEditModel model = new CatEditModel(); if (dataReader.Read()) { model.Id = (int)dataReader["Id"]; model.Name = (string)dataReader["Name"]; model.Owner = (string)dataReader["Owner"]; } dataReader.Close(); connection.Close(); return(View(model)); }
public ActionResult Edit(CatEditModel model) { using (var context = new MyContext(connectionString)) { if (model.Id > 0) { var cat = context.Cats.SingleOrDefault(c => c.Id == model.Id); cat.Name = model.Name; cat.Owner = model.Owner; context.SaveChanges(); } else { var cat = new Cat(); cat.Name = model.Name; cat.Owner = model.Owner; context.Cats.Add(cat); context.SaveChanges(); } } return(View()); }