public bool Save(dto.Employee employee)
{
using (var connection = new MySqlConnection(_connectionString))
{
connection.Open();
var cmd = new SaveEmployeeCommand(employee, connection);
cmd.Execute();
connection.Close();
return(cmd.IsSuccess);
}
}
public static dto.Employee ReadEmployee(this MySqlDataReader dataReader)
{
if (dataReader.HasRows == false)
{
return(null);
}
var mySqlUuid = dataReader[Employee.cId] as byte[];
var result = new dto.Employee
{
Id = mySqlUuid.CreateGuidFromMySqlByteOrder(),
Name = dataReader[Employee.cName].ToString(),
Rate = Decimal.ToDouble(Decimal.Parse(dataReader[Salary.cRate].ToString())),
Kind = dataReader[Salary.cKind].ToString()
};
return(result);
}
public override void Execute()
{
/*
* SELECT e.id, e.name, s.kind, max(s.rate)
* FROM salary s, employee e
* WHERE e.id = s.employee_id and s.kind = 'hourly';
*/
base.Execute();
using (var cmd = _connection.CreateCommand())
{
Initialize(cmd);
using (var dataReader = cmd.ExecuteReader())
{
dataReader.Read();
_employee = dataReader.ReadEmployee();
}
}
}
public SaveEmployeeCommand(salary.dto.Employee employee, MySqlConnection connection) : base(connection)
{
_employee = employee;
}
