public void Configure(EntityTypeBuilder <EduProgramProfileInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduProgramProfileInfo> ("University", t => "EduProgramProfiles"));
entityBuilder.HasKey(m => m.EduProgramProfileID);
entityBuilder.Property(m => m.EduProgramProfileID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.EduProgramID).IsRequired();
entityBuilder.Property(m => m.EduLevelId).IsRequired();
entityBuilder.Property(m => m.ProfileCode).IsRequired(false);
entityBuilder.Property(m => m.ProfileTitle).IsRequired(false);
entityBuilder.Property(m => m.Languages).IsRequired(false);
entityBuilder.Property(m => m.IsAdopted).IsRequired();
entityBuilder.Property(m => m.ELearning).IsRequired();
entityBuilder.Property(m => m.DistanceEducation).IsRequired();
entityBuilder.Property(m => m.AccreditedToDate).IsRequired(false);
entityBuilder.Property(m => m.CommunityAccreditedToDate).IsRequired(false);
entityBuilder.Property(m => m.StartDate).IsRequired(false);
entityBuilder.Property(m => m.EndDate).IsRequired(false);
entityBuilder.Property(m => m.LastModifiedByUserId).IsRequired();
entityBuilder.Property(m => m.LastModifiedOnDate).IsRequired();
entityBuilder.Property(m => m.CreatedByUserId).IsRequired();
entityBuilder.Property(m => m.CreatedOnDate).IsRequired();
entityBuilder.HasOne(m => m.EduProgram).WithMany(ep => ep.EduProgramProfiles).HasForeignKey(m => m.EduProgramID);
entityBuilder.HasOne(m => m.EduLevel).WithMany().HasForeignKey(m => m.EduLevelId);
entityBuilder.HasMany(m => m.Documents).WithOne().HasForeignKey(d => d.EduProgramProfileId);
entityBuilder.HasMany(m => m.EduProgramProfileFormYears).WithOne().HasForeignKey(eppfy => eppfy.EduProgramProfileId);
}
public void Configure(EntityTypeBuilder <DivisionInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <DivisionInfo> ("University", t => "Divisions"));
entityBuilder.HasKey(m => m.DivisionID);
entityBuilder.Property(m => m.DivisionID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.ParentDivisionID).IsRequired(false);
entityBuilder.Property(m => m.DivisionTermID).IsRequired(false);
entityBuilder.Property(m => m.HeadPositionID).IsRequired(false);
entityBuilder.Property(m => m.Title).IsRequired();
entityBuilder.Property(m => m.ShortTitle);
entityBuilder.Property(m => m.HomePage);
entityBuilder.Property(m => m.WebSite);
entityBuilder.Property(m => m.WebSiteLabel);
entityBuilder.Property(m => m.Phone);
entityBuilder.Property(m => m.Fax);
entityBuilder.Property(m => m.Email);
entityBuilder.Property(m => m.SecondaryEmail);
entityBuilder.Property(m => m.Address);
entityBuilder.Property(m => m.Location);
entityBuilder.Property(m => m.WorkingHours);
entityBuilder.Property(m => m.DocumentUrl);
entityBuilder.Property(m => m.IsSingleEntity);
entityBuilder.Property(m => m.IsInformal);
entityBuilder.Property(m => m.IsGoverning);
entityBuilder.Property(m => m.StartDate).IsRequired(false);
entityBuilder.Property(m => m.EndDate).IsRequired(false);
entityBuilder.Property(m => m.LastModifiedByUserId);
entityBuilder.Property(m => m.LastModifiedOnDate);
entityBuilder.Property(m => m.CreatedByUserId);
entityBuilder.Property(m => m.CreatedOnDate);
entityBuilder.Ignore(m => m.Level);
entityBuilder.Ignore(m => m.Path);
entityBuilder.HasMany(m => m.SubDivisions).WithOne().HasForeignKey(sd => sd.ParentDivisionID);
entityBuilder.HasMany(m => m.OccupiedPositions).WithOne().HasForeignKey(op => op.DivisionID);
}
public void Configure(EntityTypeBuilder <ContingentInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <ContingentInfo> ("University", t => "Contingent"));
entityBuilder.HasKey(m => m.ContingentId);
entityBuilder.Property(m => m.AvgAdmScore).HasColumnType("decimal(18,3)").IsRequired(false);
entityBuilder.Property(m => m.AdmittedFB).IsRequired(false);
entityBuilder.Property(m => m.AdmittedRB).IsRequired(false);
entityBuilder.Property(m => m.AdmittedMB).IsRequired(false);
entityBuilder.Property(m => m.AdmittedBC).IsRequired(false);
entityBuilder.Property(m => m.ActualFB).IsRequired(false);
entityBuilder.Property(m => m.ActualRB).IsRequired(false);
entityBuilder.Property(m => m.ActualMB).IsRequired(false);
entityBuilder.Property(m => m.ActualBC).IsRequired(false);
entityBuilder.Property(m => m.ActualForeign).IsRequired(false);
entityBuilder.Property(m => m.VacantFB).IsRequired(false);
entityBuilder.Property(m => m.VacantRB).IsRequired(false);
entityBuilder.Property(m => m.VacantMB).IsRequired(false);
entityBuilder.Property(m => m.VacantBC).IsRequired(false);
entityBuilder.Property(m => m.MovedIn).IsRequired(false);
entityBuilder.Property(m => m.MovedOut).IsRequired(false);
entityBuilder.Property(m => m.Restored).IsRequired(false);
entityBuilder.Property(m => m.Expelled).IsRequired(false);
entityBuilder.HasOne(m => m.EduProgramProfileFormYear).WithOne(eppfy => eppfy.Contingent).HasForeignKey <ContingentInfo> (m => m.ContingentId);
}
public void Configure(EntityTypeBuilder <YearInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <YearInfo> ("University", t => "Years"));
entityBuilder.HasKey(m => m.YearId);
entityBuilder.Property(m => m.YearId).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.Year).IsRequired();
entityBuilder.Property(m => m.AdmissionIsOpen).IsRequired();
}
public void Configure(EntityTypeBuilder <AchievementTypeInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <AchievementTypeInfo> ("University", t => "AchievementTypes"));
entityBuilder.HasKey(m => m.AchievementTypeId);
entityBuilder.Property(m => m.AchievementTypeId).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.Type).IsRequired();
entityBuilder.Property(m => m.Description).IsRequired(false);
entityBuilder.Property(m => m.IsSystem).IsRequired();
}
public void Configure(EntityTypeBuilder <PositionInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <PositionInfo> ("University", t => "Positions"));
entityBuilder.HasKey(m => m.PositionID);
entityBuilder.Property(m => m.PositionID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.Title).IsRequired();
entityBuilder.Property(m => m.ShortTitle).IsRequired(false);
entityBuilder.Property(m => m.Weight).IsRequired();
entityBuilder.Property(m => m.IsTeacher).IsRequired();
}
public void Configure(EntityTypeBuilder <AchievementInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <AchievementInfo> ("University", t => "Achievements"));
entityBuilder.HasKey(m => m.AchievementID);
entityBuilder.Property(m => m.AchievementID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.AchievementTypeId).IsRequired(false);
entityBuilder.Property(m => m.Title).IsRequired();
entityBuilder.Property(m => m.ShortTitle).IsRequired(false);
entityBuilder.HasOne(m => m.AchievementType).WithMany().HasForeignKey(m => m.AchievementTypeId);
}
public void Configure(EntityTypeBuilder <EduFormInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduFormInfo> ("University", t => "EduForms"));
entityBuilder.HasKey(m => m.EduFormID);
entityBuilder.Property(m => m.EduFormID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.IsSystem).IsRequired();
entityBuilder.Property(m => m.Title).IsRequired();
entityBuilder.Property(m => m.ShortTitle).IsRequired(false);
entityBuilder.Property(m => m.SortIndex).IsRequired();
}
public void Configure(EntityTypeBuilder <EduLevelInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduLevelInfo> ("University", t => "EduLevels"));
entityBuilder.HasKey(m => m.EduLevelID);
entityBuilder.Property(m => m.EduLevelID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.Title).IsRequired();
entityBuilder.Property(m => m.ShortTitle).IsRequired(false);
entityBuilder.Property(m => m.SortIndex).IsRequired();
entityBuilder.Property(m => m.ParentEduLevelId);
entityBuilder.HasOne(m => m.ParentEduLevel).WithMany().HasForeignKey(m => m.ParentEduLevelId);
}
public void Configure(EntityTypeBuilder <EduProgramDivisionInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduProgramDivisionInfo> ("University", t => "EduProgramDivisions"));
entityBuilder.HasKey(m => m.EduProgramDivisionId);
entityBuilder.Property(m => m.EduProgramDivisionId).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.DivisionId).IsRequired();
entityBuilder.Property(m => m.EduProgramId).IsRequired(false);
entityBuilder.Property(m => m.EduProgramProfileId).IsRequired(false);
entityBuilder.Property(m => m.DivisionRole).IsRequired(false);
entityBuilder.HasOne(m => m.Division).WithMany().HasForeignKey(m => m.DivisionId);
}
public void Configure(EntityTypeBuilder <EmployeeDisciplineInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EmployeeDisciplineInfo> ("University", t => "EmployeeDisciplines"));
entityBuilder.HasKey(m => m.EmployeeDisciplineID);
entityBuilder.Property(m => m.EmployeeDisciplineID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.EmployeeID).IsRequired();
entityBuilder.Property(m => m.EduProgramProfileID).IsRequired();
entityBuilder.Property(m => m.Disciplines).IsRequired(false);
entityBuilder.HasOne(m => m.Employee).WithMany(e => e.Disciplines).HasForeignKey(m => m.EmployeeID);
entityBuilder.HasOne(m => m.EduProgramProfile).WithMany().HasForeignKey(m => m.EduProgramProfileID);
}
public void Configure(EntityTypeBuilder <EduProgramProfileFormInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduProgramProfileFormInfo> ("University", t => "EduProgramProfileForms"));
entityBuilder.HasKey(m => m.EduProgramProfileFormID);
entityBuilder.Property(m => m.EduProgramProfileFormID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.EduProgramProfileID).IsRequired();
entityBuilder.Property(m => m.EduFormID).IsRequired();
entityBuilder.Property(m => m.TimeToLearn).IsRequired();
entityBuilder.Property(m => m.TimeToLearnHours).IsRequired();
entityBuilder.Property(m => m.IsAdmissive).IsRequired();
entityBuilder.HasOne(m => m.EduForm).WithMany().HasForeignKey(m => m.EduFormID);
}
public void Configure(EntityTypeBuilder <OccupiedPositionInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <OccupiedPositionInfo> ("University", t => "OccupiedPositions"));
entityBuilder.HasKey(m => m.OccupiedPositionID);
entityBuilder.Property(m => m.OccupiedPositionID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.PositionID).IsRequired();
entityBuilder.Property(m => m.DivisionID).IsRequired();
entityBuilder.Property(m => m.EmployeeID).IsRequired();
entityBuilder.HasOne(m => m.Position).WithMany().HasForeignKey(m => m.PositionID);
entityBuilder.HasOne(m => m.Division).WithMany(d => d.OccupiedPositions).HasForeignKey(m => m.DivisionID);
entityBuilder.HasOne(m => m.Employee).WithMany(e => e.Positions).HasForeignKey(m => m.EmployeeID);
entityBuilder.Property(m => m.IsPrime);
entityBuilder.Property(m => m.TitleSuffix);
}
public void Configure(EntityTypeBuilder <EduProgramProfileFormYearInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduProgramProfileFormYearInfo> ("University", t => "EduProgramProfileFormYears"));
entityBuilder.HasKey(m => m.EduProgramProfileFormYearId);
entityBuilder.Property(m => m.EduProgramProfileFormYearId).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.EduProgramProfileId).IsRequired();
entityBuilder.Property(m => m.EduFormId).IsRequired();
entityBuilder.Property(m => m.YearId).IsRequired(false);
entityBuilder.Property(m => m.StartDate).IsRequired(false);
entityBuilder.Property(m => m.EndDate).IsRequired(false);
entityBuilder.HasOne(m => m.EduProgramProfile).WithMany(x => x.EduProgramProfileFormYears).HasForeignKey(m => m.EduProgramProfileId);
entityBuilder.HasOne(m => m.EduForm).WithMany().HasForeignKey(m => m.EduFormId);
entityBuilder.HasOne(m => m.Year).WithMany().HasForeignKey(m => m.YearId);
entityBuilder.HasOne(m => m.EduVolume).WithOne(x => x.EduProgramProfileFormYear).HasForeignKey <EduVolumeInfo> (ev => ev.EduVolumeId);
entityBuilder.HasOne(m => m.Contingent).WithOne(eppfy => eppfy.EduProgramProfileFormYear).HasForeignKey <ContingentInfo> (c => c.ContingentId);
}
public void Configure(EntityTypeBuilder <EduVolumeInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduVolumeInfo> ("University", t => "EduVolume"));
entityBuilder.HasKey(m => m.EduVolumeId);
entityBuilder.Property(m => m.TimeToLearnHours).IsRequired();
entityBuilder.Property(m => m.TimeToLearnMonths).IsRequired();
entityBuilder.Property(m => m.Year1Cu).IsRequired(false);
entityBuilder.Property(m => m.Year2Cu).IsRequired(false);
entityBuilder.Property(m => m.Year3Cu).IsRequired(false);
entityBuilder.Property(m => m.Year4Cu).IsRequired(false);
entityBuilder.Property(m => m.Year5Cu).IsRequired(false);
entityBuilder.Property(m => m.Year6Cu).IsRequired(false);
entityBuilder.Property(m => m.PracticeType1Cu).IsRequired(false);
entityBuilder.Property(m => m.PracticeType2Cu).IsRequired(false);
entityBuilder.Property(m => m.PracticeType3Cu).IsRequired(false);
entityBuilder.HasOne(m => m.EduProgramProfileFormYear).WithOne(eppfy => eppfy.EduVolume).HasForeignKey <EduVolumeInfo> (ev => ev.EduVolumeId);
}
public void Configure(EntityTypeBuilder <ScienceInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <ScienceInfo> ("University", t => "Science"));
entityBuilder.HasKey(m => m.ScienceId);
entityBuilder.Property(m => m.Directions).IsRequired(false);
entityBuilder.Property(m => m.Base).IsRequired(false);
entityBuilder.Property(m => m.Scientists).IsRequired(false);
entityBuilder.Property(m => m.Students).IsRequired(false);
entityBuilder.Property(m => m.Monographs).IsRequired(false);
entityBuilder.Property(m => m.Articles).IsRequired(false);
entityBuilder.Property(m => m.ArticlesForeign).IsRequired(false);
entityBuilder.Property(m => m.Patents).IsRequired(false);
entityBuilder.Property(m => m.PatentsForeign).IsRequired(false);
entityBuilder.Property(m => m.Certificates).IsRequired(false);
entityBuilder.Property(m => m.CertificatesForeign).IsRequired(false);
entityBuilder.Property(m => m.FinancingByScientist).HasColumnType("decimal(18,3)").IsRequired(false);
//entityBuilder.HasOne (m => m.EduProgram).WithOne (ep => ep.Science).HasForeignKey<ScienceInfo> (m => m.ScienceId);
}
public void Configure(EntityTypeBuilder <EmployeeAchievementInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EmployeeAchievementInfo> ("University", t => "EmployeeAchievements"));
entityBuilder.HasKey(m => m.EmployeeAchievementID);
entityBuilder.Property(m => m.EmployeeAchievementID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.AchievementID).IsRequired(false);
entityBuilder.Property(m => m.AchievementTypeId).IsRequired(false);
entityBuilder.Property(m => m.Description).IsRequired(false);
entityBuilder.Property(m => m.Title).IsRequired(false);
entityBuilder.Property(m => m.ShortTitle).IsRequired(false);
entityBuilder.Property(m => m.YearBegin).IsRequired(false);
entityBuilder.Property(m => m.YearEnd).IsRequired(false);
entityBuilder.Property(m => m.IsTitle).IsRequired();
entityBuilder.Property(m => m.DocumentURL).IsRequired();
entityBuilder.Property(m => m.TitleSuffix).IsRequired(false);
//entityBuilder.HasOptional (m => m.Achievement).WithMany ().HasForeignKey (m => m.AchievementID);
//entityBuilder.HasOptional (m => m.AchievementType).WithMany ().HasForeignKey (m => m.AchievementTypeId);
}
public void Configure(EntityTypeBuilder <DocumentInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <DocumentInfo> ("University", t => "Documents"));
entityBuilder.HasKey(m => m.DocumentID);
entityBuilder.Property(m => m.DocumentID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.DocumentTypeID).IsRequired();
entityBuilder.Property(m => m.EduProgramId).IsRequired(false);
entityBuilder.Property(m => m.EduProgramProfileId).IsRequired(false);
entityBuilder.Property(m => m.Title).IsRequired(false);
entityBuilder.Property(m => m.Group).IsRequired(false);
entityBuilder.Property(m => m.Url).IsRequired(false);
entityBuilder.Property(m => m.SortIndex).IsRequired();
entityBuilder.Property(m => m.StartDate).IsRequired(false);
entityBuilder.Property(m => m.EndDate).IsRequired(false);
entityBuilder.Property(m => m.CreatedOnDate).IsRequired();
entityBuilder.Property(m => m.LastModifiedOnDate).IsRequired();
entityBuilder.Property(m => m.CreatedByUserId).IsRequired();
entityBuilder.Property(m => m.LastModifiedByUserId).IsRequired();
entityBuilder.HasOne(m => m.DocumentType).WithMany().HasForeignKey(m => m.DocumentTypeID);
}
public void Configure(EntityTypeBuilder <EduProgramInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EduProgramInfo> ("University", t => "EduPrograms"));
entityBuilder.HasKey(m => m.EduProgramID);
entityBuilder.Property(m => m.EduProgramID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.EduLevelID).IsRequired();
entityBuilder.Property(m => m.Code).IsRequired();
entityBuilder.Property(m => m.Title).IsRequired();
entityBuilder.Property(m => m.Generation).IsRequired(false);
entityBuilder.Property(m => m.HomePage).IsRequired(false);
entityBuilder.Property(m => m.StartDate).IsRequired(false);
entityBuilder.Property(m => m.EndDate).IsRequired(false);
entityBuilder.Property(m => m.LastModifiedByUserId).IsRequired();
entityBuilder.Property(m => m.LastModifiedOnDate).IsRequired();
entityBuilder.Property(m => m.CreatedByUserId).IsRequired();
entityBuilder.Property(m => m.CreatedOnDate).IsRequired();
entityBuilder.HasOne(m => m.EduLevel).WithMany().HasForeignKey(m => m.EduLevelID);
entityBuilder.HasOne(m => m.Science).WithOne(ep => ep.EduProgram).HasForeignKey <ScienceInfo> (s => s.ScienceId);
entityBuilder.HasMany(m => m.Documents).WithOne().HasForeignKey(d => d.EduProgramId);
entityBuilder.HasMany(m => m.EduProgramProfiles).WithOne(epp => epp.EduProgram).HasForeignKey(epp => epp.EduProgramID);
}
public void Configure(EntityTypeBuilder <EmployeeInfo> entityBuilder)
{
entityBuilder.ToTable(DnnTableMappingHelper.GetTableName <EmployeeInfo> ("University", t => "Employees"));
entityBuilder.HasKey(m => m.EmployeeID);
entityBuilder.Property(m => m.EmployeeID).ValueGeneratedOnAdd();
entityBuilder.Property(m => m.UserID).IsRequired(false);
entityBuilder.Property(m => m.PhotoFileID).IsRequired(false);
entityBuilder.Property(m => m.AltPhotoFileId).IsRequired(false);
entityBuilder.Property(m => m.LastName).IsRequired();
entityBuilder.Property(m => m.FirstName).IsRequired();
entityBuilder.Property(m => m.OtherName);
entityBuilder.Property(m => m.Phone);
entityBuilder.Property(m => m.CellPhone);
entityBuilder.Property(m => m.Fax);
entityBuilder.Property(m => m.Email);
entityBuilder.Property(m => m.SecondaryEmail);
entityBuilder.Property(m => m.WebSite);
entityBuilder.Property(m => m.WebSiteLabel);
entityBuilder.Property(m => m.Messenger);
entityBuilder.Property(m => m.Biography);
entityBuilder.Property(m => m.WorkingPlace);
entityBuilder.Property(m => m.WorkingHours);
entityBuilder.Property(m => m.ExperienceYears).IsRequired(false);
entityBuilder.Property(m => m.ExperienceYearsBySpec).IsRequired(false);
entityBuilder.Property(m => m.StartDate).IsRequired(false);
entityBuilder.Property(m => m.EndDate).IsRequired(false);
entityBuilder.Property(m => m.LastModifiedByUserId);
entityBuilder.Property(m => m.LastModifiedOnDate);
entityBuilder.Property(m => m.CreatedByUserId);
entityBuilder.Property(m => m.CreatedOnDate);
entityBuilder.Property(m => m.ShowBarcode);
entityBuilder.Property(m => m.ScienceIndexAuthorId);
entityBuilder.HasMany(m => m.Positions).WithOne().HasForeignKey(x => x.EmployeeID);
entityBuilder.HasMany(m => m.Disciplines).WithOne(ed => ed.Employee).HasForeignKey(x => x.EmployeeID);
entityBuilder.HasMany(m => m.Achievements).WithOne().HasForeignKey(x => x.EmployeeID);
}
