public ContingentMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <ContingentInfo> (pluralize: false));
            HasKey(m => m.ContingentId);

            Property(m => m.AvgAdmScore).IsOptional();

            Property(m => m.AdmittedFB).IsOptional();
            Property(m => m.AdmittedRB).IsOptional();
            Property(m => m.AdmittedMB).IsOptional();
            Property(m => m.AdmittedBC).IsOptional();

            Property(m => m.ActualFB).IsOptional();
            Property(m => m.ActualRB).IsOptional();
            Property(m => m.ActualMB).IsOptional();
            Property(m => m.ActualBC).IsOptional();

            Property(m => m.VacantFB).IsOptional();
            Property(m => m.VacantRB).IsOptional();
            Property(m => m.VacantMB).IsOptional();
            Property(m => m.VacantBC).IsOptional();

            Property(m => m.MovedIn).IsOptional();
            Property(m => m.MovedOut).IsOptional();
            Property(m => m.Restored).IsOptional();
            Property(m => m.Expelled).IsOptional();

            HasRequired(m => m.EduProgramProfileFormYear).WithOptional(x => x.Contingent);
        }
        public EduProgramProfileMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EduProgramProfileInfo> ());
            HasKey(m => m.EduProgramProfileID);
            Property(m => m.EduProgramProfileID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.EduProgramID).IsRequired();
            Property(m => m.EduLevelId).IsRequired();
            Property(m => m.ProfileCode).IsOptional();
            Property(m => m.ProfileTitle).IsOptional();
            Property(m => m.Languages).IsOptional();
            Property(m => m.IsAdopted).IsRequired();
            Property(m => m.ELearning).IsRequired();
            Property(m => m.DistanceEducation).IsRequired();
            Property(m => m.AccreditedToDate).IsOptional();
            Property(m => m.CommunityAccreditedToDate).IsOptional();

            Property(m => m.StartDate).IsOptional();
            Property(m => m.EndDate).IsOptional();

            Property(m => m.LastModifiedByUserId);
            Property(m => m.LastModifiedOnDate);
            Property(m => m.CreatedByUserId);
            Property(m => m.CreatedOnDate);

            HasRequired(m => m.EduProgram).WithMany().HasForeignKey(m => m.EduProgramID);
            HasRequired(m => m.EduLevel).WithMany().HasForeignKey(m => m.EduLevelId);
            HasMany(m => m.Documents).WithOptional().HasForeignKey(d => d.EduProgramProfileId);
            HasMany(m => m.EduProgramProfileFormYears).WithRequired().HasForeignKey(eppfy => eppfy.EduProgramProfileId);
        }
 public EduFormMapping()
 {
     ToTable(UniversityMappingHelper.GetTableName <EduFormInfo> ());
     HasKey(m => m.EduFormID);
     Property(m => m.EduFormID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
     Property(m => m.IsSystem).IsRequired();
     Property(m => m.Title).IsRequired();
     Property(m => m.ShortTitle).IsOptional();
 }
Exemplo n.º 4
0
        public YearMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <YearInfo> ());
            HasKey(m => m.YearId);
            Property(m => m.YearId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            Property(m => m.Year).IsRequired();
            Property(m => m.AdmissionIsOpen).IsRequired();
        }
Exemplo n.º 5
0
 public AchievementTypeMapping()
 {
     ToTable(UniversityMappingHelper.GetTableName <AchievementTypeInfo> ());
     HasKey(m => m.AchievementTypeId);
     Property(m => m.AchievementTypeId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
     Property(m => m.Type).IsRequired();
     Property(m => m.Description).IsOptional();
     Property(m => m.IsSystem).IsRequired();
 }
Exemplo n.º 6
0
 public PositionMapping()
 {
     ToTable(UniversityMappingHelper.GetTableName <PositionInfo> ());
     HasKey(m => m.PositionID);
     Property(m => m.PositionID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
     Property(m => m.Title).IsRequired();
     Property(m => m.ShortTitle).IsOptional();
     Property(m => m.Weight).IsRequired();
     Property(m => m.IsTeacher).IsRequired();
 }
Exemplo n.º 7
0
 public DocumentTypeMapping()
 {
     ToTable(UniversityMappingHelper.GetTableName <DocumentTypeInfo> ());
     HasKey(m => m.DocumentTypeID);
     Property(m => m.DocumentTypeID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
     Property(m => m.Type).IsRequired();
     Property(m => m.Description).IsOptional();
     Property(m => m.IsSystem).IsRequired();
     Property(m => m.FilenameFormat).IsOptional();
 }
Exemplo n.º 8
0
        public AchievementMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <AchievementInfo> ());
            HasKey(m => m.AchievementID);
            Property(m => m.AchievementID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.AchievementTypeId).IsOptional();
            Property(m => m.Title).IsRequired();
            Property(m => m.ShortTitle).IsOptional();

            HasOptional(m => m.AchievementType).WithMany().HasForeignKey(m => m.AchievementTypeId);
        }
Exemplo n.º 9
0
 public EduLevelMapping()
 {
     ToTable(UniversityMappingHelper.GetTableName <EduLevelInfo> ());
     HasKey(m => m.EduLevelID);
     Property(m => m.EduLevelID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
     Property(m => m.Title).IsRequired();
     Property(m => m.ShortTitle).IsOptional();
     Property(m => m.SortIndex).IsRequired();
     Property(m => m.ParentEduLevelId);
     HasOptional(m => m.ParentEduLevel).WithMany().HasForeignKey(m => m.ParentEduLevelId);
 }
        public EmployeeDisciplineMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EmployeeDisciplineInfo> ());
            HasKey(m => m.EmployeeDisciplineID);
            Property(m => m.EmployeeDisciplineID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.EmployeeID).IsRequired();
            Property(m => m.EduProgramProfileID).IsRequired();
            Property(m => m.Disciplines).IsOptional();

            HasRequired(m => m.Employee).WithMany(e => e.Disciplines).HasForeignKey(m => m.EmployeeID);
            HasRequired(m => m.EduProgramProfile).WithMany().HasForeignKey(m => m.EduProgramProfileID);
        }
 public ScienceRecordTypeMapping()
 {
     ToTable(UniversityMappingHelper.GetTableName <ScienceRecordTypeInfo> ());
     HasKey(m => m.ScienceRecordTypeId);
     Property(m => m.ScienceRecordTypeId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
     Property(m => m.Type).IsRequired();
     Property(m => m.IsSystem).IsRequired();
     Property(m => m.DescriptionIsRequired).IsRequired();
     Property(m => m.NumOfValues).IsRequired();
     Property(m => m.TypeOfValues).IsRequired();
     Property(m => m.SortIndex).IsRequired();
 }
        public EduProgramProfileFormMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EduProgramProfileFormInfo> ());
            HasKey(m => m.EduProgramProfileFormID);
            Property(m => m.EduProgramProfileFormID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.EduProgramProfileID).IsRequired();
            Property(m => m.EduFormID).IsRequired();
            Property(m => m.TimeToLearn).IsRequired();
            Property(m => m.TimeToLearnHours).IsRequired();
            Property(m => m.IsAdmissive).IsRequired();

            HasRequired(m => m.EduForm).WithMany().HasForeignKey(m => m.EduFormID);
        }
        public EduProgramDivisionMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EduProgramDivisionInfo> ());
            HasKey(m => m.EduProgramDivisionId);
            Property(m => m.EduProgramDivisionId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            Property(m => m.DivisionId).IsRequired();
            Property(m => m.EduProgramId).IsOptional();
            Property(m => m.EduProgramProfileId).IsOptional();
            Property(m => m.DivisionRole).IsOptional();

            HasRequired(m => m.Division).WithMany().HasForeignKey(m => m.DivisionId);
        }
        public ScienceRecordMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <ScienceRecordInfo> ());
            HasKey(m => m.ScienceRecordId);
            Property(m => m.ScienceRecordId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.ScienceRecordId).IsRequired();
            Property(m => m.ScienceRecordTypeId).IsRequired();
            Property(m => m.EduProgramId).IsRequired();
            Property(m => m.Description).IsOptional();
            Property(m => m.Value1).IsOptional();
            Property(m => m.Value2).IsOptional();

            HasRequired(m => m.ScienceRecordType).WithMany().HasForeignKey(m => m.ScienceRecordTypeId);
        }
Exemplo n.º 15
0
        public DocumentMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <DocumentInfo> ());
            HasKey(m => m.DocumentID);
            Property(m => m.DocumentID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.DocumentTypeID).IsRequired();
            Property(m => m.EduProgramId).IsOptional();
            Property(m => m.EduProgramProfileId).IsOptional();
            Property(m => m.Title).IsOptional();
            Property(m => m.Group).IsOptional();
            Property(m => m.Url).IsOptional();
            Property(m => m.SortIndex).IsRequired();
            Property(m => m.StartDate).IsOptional();
            Property(m => m.EndDate).IsOptional();

            HasRequired(m => m.DocumentType).WithMany().HasForeignKey(m => m.DocumentTypeID);
        }
Exemplo n.º 16
0
        public OccupiedPositionMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <OccupiedPositionInfo> ());
            HasKey(m => m.OccupiedPositionID);
            Property(m => m.OccupiedPositionID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            Property(m => m.PositionID).IsRequired();
            Property(m => m.DivisionID).IsRequired();
            Property(m => m.EmployeeID).IsRequired();

            HasRequired <PositionInfo> (m => m.Position).WithMany().HasForeignKey(m => m.PositionID);
            HasRequired <DivisionInfo> (m => m.Division).WithMany().HasForeignKey(m => m.DivisionID);
            HasRequired <EmployeeInfo> (m => m.Employee).WithMany().HasForeignKey(m => m.EmployeeID);

            Property(m => m.IsPrime);
            Property(m => m.TitleSuffix);
        }
        public EmployeeAchievementMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EmployeeAchievementInfo> ());
            HasKey(m => m.EmployeeAchievementID);
            Property(m => m.EmployeeAchievementID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.AchievementID).IsOptional();
            Property(m => m.AchievementTypeId).IsOptional();
            Property(m => m.Description).IsOptional();
            Property(m => m.Title).IsOptional();
            Property(m => m.ShortTitle).IsOptional();
            Property(m => m.YearBegin).IsOptional();
            Property(m => m.YearEnd).IsOptional();
            Property(m => m.IsTitle).IsRequired();
            Property(m => m.DocumentURL).IsRequired();
            Property(m => m.TitleSuffix).IsOptional();

            HasOptional(m => m.Achievement).WithMany().HasForeignKey(m => m.AchievementID);
            HasOptional(m => m.AchievementType).WithMany().HasForeignKey(m => m.AchievementTypeId);
        }
Exemplo n.º 18
0
        public DivisionMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <DivisionInfo> ());
            HasKey(m => m.DivisionID);
            Property(m => m.DivisionID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            Property(m => m.ParentDivisionID).IsOptional();
            Property(m => m.DivisionTermID).IsOptional();
            Property(m => m.HeadPositionID).IsOptional();

            Property(m => m.Title).IsRequired();
            Property(m => m.ShortTitle);

            Property(m => m.HomePage);
            Property(m => m.WebSite);
            Property(m => m.WebSiteLabel);

            Property(m => m.Phone);
            Property(m => m.Fax);
            Property(m => m.Email);
            Property(m => m.SecondaryEmail);
            Property(m => m.Address);
            Property(m => m.Location);
            Property(m => m.WorkingHours);
            Property(m => m.DocumentUrl);
            Property(m => m.IsSingleEntity);
            Property(m => m.IsInformal);
            Property(m => m.IsGoverning);

            Property(m => m.StartDate).IsOptional();
            Property(m => m.EndDate).IsOptional();

            Property(m => m.LastModifiedByUserID);
            Property(m => m.LastModifiedOnDate);
            Property(m => m.CreatedByUserID);
            Property(m => m.CreatedOnDate);

            Ignore(m => m.Level);
            Ignore(m => m.Path);

            HasMany(m => m.SubDivisions).WithRequired().HasForeignKey(sd => sd.ParentDivisionID);
            HasMany(m => m.OccupiedPositions).WithRequired().HasForeignKey(op => op.DivisionID);
        }
        public EduProgramProfileFormYearMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EduProgramProfileFormYearInfo> ());
            HasKey(m => m.EduProgramProfileFormYearId);
            Property(m => m.EduProgramProfileFormYearId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            Property(m => m.EduProgramProfileId).IsRequired();
            Property(m => m.EduFormId).IsRequired();
            Property(m => m.YearId).IsRequired();

            Property(m => m.StartDate).IsOptional();
            Property(m => m.EndDate).IsOptional();

            HasRequired(m => m.EduProgramProfile).WithMany(x => x.EduProgramProfileFormYears).HasForeignKey(m => m.EduProgramProfileId);
            HasRequired(m => m.EduForm).WithMany().HasForeignKey(m => m.EduFormId);
            HasRequired(m => m.Year).WithMany().HasForeignKey(m => m.YearId);

            HasOptional(m => m.EduVolume).WithRequired(x => x.EduProgramProfileFormYear);
            HasOptional(m => m.Contingent).WithRequired(x => x.EduProgramProfileFormYear);
        }
Exemplo n.º 20
0
        public EduVolumeMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EduVolumeInfo> (pluralize: false));
            HasKey(m => m.EduVolumeId);

            Property(m => m.TimeToLearnHours).IsRequired();
            Property(m => m.TimeToLearnMonths).IsRequired();

            Property(m => m.Year1Cu).IsOptional();
            Property(m => m.Year2Cu).IsOptional();
            Property(m => m.Year3Cu).IsOptional();
            Property(m => m.Year4Cu).IsOptional();
            Property(m => m.Year5Cu).IsOptional();
            Property(m => m.Year6Cu).IsOptional();

            Property(m => m.PracticeType1Cu).IsOptional();
            Property(m => m.PracticeType2Cu).IsOptional();
            Property(m => m.PracticeType3Cu).IsOptional();

            HasRequired(m => m.EduProgramProfileFormYear).WithOptional(x => x.EduVolume);
        }
Exemplo n.º 21
0
        public ScienceMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <ScienceInfo> (pluralize: false));

            HasKey(m => m.ScienceId);

            Property(m => m.Directions).IsOptional();
            Property(m => m.Base).IsOptional();
            Property(m => m.Scientists).IsOptional();
            Property(m => m.Students).IsOptional();
            Property(m => m.Monographs).IsOptional();
            Property(m => m.Articles).IsOptional();
            Property(m => m.ArticlesForeign).IsOptional();
            Property(m => m.Patents).IsOptional();
            Property(m => m.PatentsForeign).IsOptional();
            Property(m => m.Certificates).IsOptional();
            Property(m => m.CertificatesForeign).IsOptional();
            Property(m => m.FinancingByScientist).HasPrecision(18, 3).IsOptional();

            HasRequired(m => m.EduProgram).WithOptional(x => x.Science);
        }
Exemplo n.º 22
0
        public EmployeeMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EmployeeInfo> ());
            HasKey(m => m.EmployeeID);
            Property(m => m.EmployeeID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.UserID).IsOptional();
            Property(m => m.PhotoFileID).IsOptional();
            Property(m => m.LastName).IsRequired();
            Property(m => m.FirstName).IsRequired();
            Property(m => m.OtherName);

            Property(m => m.Phone);
            Property(m => m.CellPhone);
            Property(m => m.Fax);
            Property(m => m.Email);
            Property(m => m.SecondaryEmail);
            Property(m => m.WebSite);
            Property(m => m.WebSiteLabel);
            Property(m => m.Messenger);
            Property(m => m.Biography);

            Property(m => m.WorkingPlace);
            Property(m => m.WorkingHours);
            Property(m => m.ExperienceYears).IsOptional();
            Property(m => m.ExperienceYearsBySpec).IsOptional();

            Property(m => m.StartDate).IsOptional();
            Property(m => m.EndDate).IsOptional();

            Property(m => m.LastModifiedByUserId);
            Property(m => m.LastModifiedOnDate);
            Property(m => m.CreatedByUserId);
            Property(m => m.CreatedOnDate);

            Property(m => m.ShowBarcode);

            HasMany(m => m.Positions).WithRequired().HasForeignKey(x => x.EmployeeID);
            HasMany(m => m.Disciplines).WithRequired(ed => ed.Employee).HasForeignKey(x => x.EmployeeID);
            HasMany(m => m.Achievements).WithRequired().HasForeignKey(x => x.EmployeeID);
        }
Exemplo n.º 23
0
        public EduProgramMapping()
        {
            ToTable(UniversityMappingHelper.GetTableName <EduProgramInfo> ());
            HasKey(m => m.EduProgramID);
            Property(m => m.EduProgramID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
            Property(m => m.EduLevelID).IsRequired();
            Property(m => m.Code).IsRequired();
            Property(m => m.Title).IsRequired();
            Property(m => m.Generation).IsOptional();
            Property(m => m.HomePage).IsOptional();

            Property(m => m.StartDate).IsOptional();
            Property(m => m.EndDate).IsOptional();

            Property(m => m.LastModifiedByUserId);
            Property(m => m.LastModifiedOnDate);
            Property(m => m.CreatedByUserId);
            Property(m => m.CreatedOnDate);

            HasRequired(m => m.EduLevel).WithMany().HasForeignKey(m => m.EduLevelID);
            HasMany(m => m.Documents).WithOptional().HasForeignKey(x => x.EduProgramId);
            HasMany(m => m.EduProgramProfiles).WithRequired(epp => epp.EduProgram).HasForeignKey(epp => epp.EduProgramID);
        }