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