public bool EditGymEquipment(EditGymEquipment equipment)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE gym_equipment " +
"SET name = @name, usage = @usage, photo_path = @photo_path " +
"WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@name", equipment.Name);
cmd.Parameters.AddWithValue("@usage", equipment.ProperUsage);
cmd.Parameters.AddWithValue("@photo_path", equipment.PhotoPath);
cmd.Parameters.AddWithValue("@id", equipment.Id);
cmd.ExecuteNonQuery();
return(true);
}
}
catch (SqlException ex)
{
return(false);
throw;
}
}
public IActionResult EditGymEquipment(EditGymEquipment model)
{
if (ModelState.IsValid)
{
gymDAL.EditGymEquipment(model);
return(RedirectToAction(nameof(ViewEquipments)));
}
return(View(model));
}
