public Boolean updateEmployee(Employee emp)
{
Boolean FLAG = false;
MySqlTransaction tr = null;
try
{
conn = getConnection();
tr = conn.BeginTransaction();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.Transaction = tr;
cmd.CommandText = "UPDATE GP_EMPLOYEE SET E_NAME=@NAME, E_PHONE=@PHONE, E_EMAIL=@EMAIL, E_BIRTH_DAY=@BIRTHDAY, E_IMAGE=@IMAGE WHERE E_ID = @ID";
cmd.Parameters.AddWithValue("@NAME", emp.getName());
cmd.Parameters.AddWithValue("@PHONE", emp.getPhone());
cmd.Parameters.AddWithValue("@EMAIL", emp.getEmail());
cmd.Parameters.AddWithValue("@BIRTHDAY", emp.getPhone());
cmd.Parameters.AddWithValue("@IMAGE", ConvertUtil.convertFileToBufferData(emp.getImage()));
cmd.Parameters.AddWithValue("@ID", emp.getId());
cmd.ExecuteNonQuery();
tr.Commit();
FLAG = true;
}catch(Exception ex)
{
FLAG = false;
tr.Rollback();
}
finally
{
DBUtil.CloseConnection(conn);
}
return FLAG;
}
public Boolean removeEmployee(Employee emp)
{
Boolean FLAG = false;
MySqlTransaction tr = null;
try
{
conn = getConnection();
tr = conn.BeginTransaction();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.Transaction = tr;
cmd.CommandText = "DELETE FROM GP_EMPLOYEE WHERE E_ID=@ID";
cmd.Parameters.AddWithValue("@ID", emp.getId());
cmd.ExecuteNonQuery();
tr.Commit();
FLAG = true;
}
catch(Exception ex)
{
FLAG = false;
tr.Rollback();
}
finally
{
DBUtil.CloseConnection(conn);
}
return FLAG;
}