//update Contact Persons
public bool UpdateContactPerson(UpdateContactPersonViewModel vm)
{
connection();
SqlCommand com = new SqlCommand("UPDATE ContactPersons SET FirstName=@FirstName, LastName=@LastName, Email=@Email, Telephone=@Telephone WHERE Id = @Id", _con);
com.CommandType = CommandType.Text;
com.Parameters.AddWithValue("@Id", vm.Id);
com.Parameters.AddWithValue("@FirstName", vm.FirstName);
com.Parameters.AddWithValue("@LastName", vm.LastName);
com.Parameters.AddWithValue("@Email", vm.Email);
com.Parameters.AddWithValue("@Telephone", vm.Telephone);
_con.Open();
int i = com.ExecuteNonQuery();
_con.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Edit(int id, UpdateContactPersonViewModel vm)
{
DataManager dm = new DataManager();
try
{
dm.UpdateContactPerson(vm);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
