public bool EditMechanic(int id, Mechanic mechanic) { Employees employees = new Employees(mechanic.LastName, mechanic.FirstName, mechanic.MiddleName, mechanic.Experience, mechanic.Salary); EmployeesDAO employeesDAO = new EmployeesDAO(); bool result = false; if (employeesDAO.EditEmployees(id, employees)) { result = true; Connect(); try { string sql = "UPDATE mechanic " + "SET qualification=@qualification WHERE id=@id"; SqlCommand cmd_SQL = new SqlCommand(sql, Connection); cmd_SQL.Parameters.AddWithValue("@id", id); cmd_SQL.Parameters.AddWithValue("@qualification", mechanic.Qualification); cmd_SQL.ExecuteNonQuery(); } catch (Exception) { result = false; } finally { Disconnect(); } } return(result); }
public bool EditDriver(int id, Driver driver) { Employees employees = new Employees(driver.LastName, driver.FirstName, driver.MiddleName, driver.Experience, driver.Salary); EmployeesDAO employeesDAO = new EmployeesDAO(); bool result = false; if (employeesDAO.EditEmployees(id, employees)) { result = true; Connect(); try { string sql = "UPDATE Driver " + "SET categories=@categories, rightsDate=@rightsDate WHERE id=@id"; SqlCommand cmd_SQL = new SqlCommand(sql, Connection); cmd_SQL.Parameters.Add(new SqlParameter("@id", id)); cmd_SQL.Parameters.AddWithValue("@categories", driver.Categories); cmd_SQL.Parameters.AddWithValue("@rightsDate", driver.RightsDate); cmd_SQL.ExecuteNonQuery(); } catch (Exception) { result = false; } finally { Disconnect(); } } return(result); }