/// <summary>
///
/// </summary>
/// <param name="facultyId"></param>
/// <returns></returns>
public FacultyDto SelectFacultyById(int facultyId)
{
FacultyDto facultyDto;
try
{
facultyDto = new FacultyDto();
query = SelectFacultyByCodeQuery(facultyId);
OleDbDataReader reader = dbConnect.SelectDataReader(query);
if (reader.Read() && reader.GetValue(0) != DBNull.Value)
{
facultyDto.FacultyId = reader.GetInt32(0);
facultyDto.Office = reader.GetString(1);
facultyDto.Salary = reader.GetInt32(2);
facultyDto.ContactNo = reader.GetInt32(3);
//Person Info
PersonData personData = new PersonData();
PersonDto personDto = personData.SelectPersonById(facultyId);
facultyDto.Person = personDto;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
dbConnect.CloseConnection();
}
return(facultyDto);
}
public PersonDto GetPersonById(int personId)
{
PersonData personData = new PersonData();
return(personData.SelectPersonById(personId));
}
