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