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