private EmployeeModel ReadEmployeeModel(CustomReader reader)
        {
            IDictionaryDAO dict = new DictionaryDAO();

            return(new EmployeeModel()
            {
                IdEmployee = reader.GetLong("IdEmployee"),
                IdPosition = reader.GetLong("IdPosition"),
                FirstName = reader.GetString("FirstName"),
                Surname = reader.GetString("Surname"),
                Pesel = reader.GetString("Pesel"),
                Sex = reader.GetString("Sex"),
                Street = reader.GetString("Street"),
                HouseNumber = reader.GetString("HouseNumber"),
                City = reader.GetString("City"),
                PostalCode = reader.GetString("PostalCode"),
                Country = reader.GetString("Country"),
                Phone = reader.GetString("Phone"),
                Email = reader.GetNullableString("Email"),
                DateOfEmployment = reader.GetDate("DateOfEmployment"),
                DateOfLaying = reader.GetNullableDate("DateOfLaying"),
                LicenseNumber = reader.GetNullableString("LicenseNumber"),
                Ward = dict.ReadDictionaryById(DictionaryTypesEnum.Ward, reader.GetNullableLong("IdWard"), "pl")
            });
        }
        private StudyModel ReadStudyModel(CustomReader reader)
        {
            IDictionaryDAO dict     = new DictionaryDAO();
            IEmployeesDAO  employee = new EmployeesDAO();
            IProfilesDAO   profile  = new ProfilesDAO();
            IOrdersDAO     order    = new OrdersDAO();
            ITestsDAO      test     = new TestsDAO();

            return(new StudyModel()
            {
                IdStudy = reader.GetLong("IdStudy"),
                IdProfile = reader.GetLong("IdProfile"),
                IdEmployee = reader.GetLong("IdEmployee"),
                IdOrder = reader.GetLong("IdOrder"),
                IdStatus = reader.GetLong("IdStatus"),
                DateOfStudy = reader.GetDate("DateOfStudy")
            });
        }