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