public Employee(String firstname, String lastname, EmployeeGender gender, Department department)
{
Id = 0;
Firstname = firstname;
Lastname = lastname;
Gender = gender;
Department = department;
}
/**
* Parses the EmployeeDto object from the SQL reader cache.
*
*/
EmployeeDto ParseFromReaderCache(MySqlDataReader dataReader)
{
// id
int id = 0;
try { id = dataReader.GetInt32(0); }
catch (SqlNullValueException) { /* log the error */ }
// first name
string firstName = "N/A";
try { firstName = dataReader.GetString(1); }
catch (SqlNullValueException) { /* log the error */ }
// last name
string lastName = "N/A";
try { lastName = dataReader.GetString(2); }
catch (SqlNullValueException) { /* log the error */ }
// birth place
string birthPlace = "N/A";
try { birthPlace = dataReader.GetString(3); }
catch (SqlNullValueException) { /* log the error */ }
// current place
string currentPlace = "N/A";
try { currentPlace = dataReader.GetString(4); }
catch (SqlNullValueException) { /* log the error */ }
// gender
EmployeeGender gender = EmployeeGender.UNDEFINED;
try { gender = EmployeeGenderExtensions.GetEnumValue(dataReader.GetInt32(5)); }
catch (SqlNullValueException) { /* log the error */ }
// department
DepartmentCode departmentCode = DepartmentCode.UNKNOWN;
try { departmentCode = DepartmentCodeExtensions.GetEnumValue(dataReader.GetString(6)); }
catch (SqlNullValueException) { /* log the error */ }
// oib
string OIB = "N/A";
try { OIB = dataReader.GetString(7); }
catch (SqlNullValueException) { /* log the error */ }
return((EmployeeDto)
new Employee(id, firstName, lastName, birthPlace, currentPlace, gender, departmentCode, OIB).ToDto());
}
public static int GetIntValue(this EmployeeGender gender)
{
switch (gender)
{
case EmployeeGender.F:
return(0);
case EmployeeGender.M:
return(1);
default:
return(2);
}
}
public static string GetStringValue(this EmployeeGender gender)
{
switch (gender)
{
case EmployeeGender.F:
return(F);
case EmployeeGender.M:
return(M);
default:
return(UNDEFINED);
}
}
/*
* Public constructor.
*/
public Employee(int id,
string firstName, string lastName,
string birthPlace, string currentPlace,
EmployeeGender gender,
DepartmentCode department,
string oib)
{
Id = id;
FirstName = firstName;
LastName = lastName;
BirthPlace = birthPlace;
CurrentPlace = currentPlace;
Gender = gender;
Department = department;
OIB = ValidateOib(oib);
}
