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