public FormsPage(int CountryId, MajorDiscipline SelectedMajor)
{
InitializeComponent();
this.CountryId = CountryId;
this.SelectedMajor = SelectedMajor;
Title = "Votre Filière: " + SelectedMajor.Name;
}
public MorocViewModel(MajorDiscipline SelectedMajor)
{
GroupedSubjectCoeffs = new ObservableCollection <GroupedSubjectCoeff>();
noteDeBacGroup = new GroupedSubjectCoeff()
{
LongName = "Saisir votre Note de BAC", ShortName = "S"
};
PopulateList(SelectedMajor);
GroupedSubjectCoeffs.Add(noteDeBacGroup);
}
public void PopulateList(MajorDiscipline majorDiscipline)
{
if (majorDiscipline.CountryId == 2)
{
switch (majorDiscipline.Id)
{
case 1:
#region Case اللغة العربية
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 1,
Name = "علوم اللغة",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 1,
Name = "الأدب",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 1,
Name = "التفسير والحديث",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 1,
Name = "اللغة الأجنبية الثانية",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 1,
Name = "الفلسفة",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 2:
#region Case العلوم الشرعية
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 2,
Name = "الأدب",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 2,
Name = "التفسير والحديث",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 2,
Name = "الفقه والأصول",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 2,
Name = "اللغة الأجنبية الثانية",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 2,
Name = "الفلسفة",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 3:
#region Case الٱداب
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 3,
Name = "اللغة العربية",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 3,
Name = "اللغة الأجنبية",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 3,
Name = "التاريخ والجغرافيا",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 3,
Name = "الفلسفة",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
#endregion
break;
case 4:
#region Case العلوم الإنسانية
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 4,
Name = "اللغة العربية",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 4,
Name = "اللغة الأجنبية",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 4,
Name = "التاريخ و الجغرافيا",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 4,
Name = "الفلسفة",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
#endregion
break;
case 5:
#region Case Sciences Physiques
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 5,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 5,
Name = "Physiques/Chimie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 5,
Name = "Sciences de la vie et de la terre",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 5,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 5,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 6:
#region Case Sciences Agronomiques
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 6,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 6,
Name = "Physiques/Chimie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 6,
Name = "Sciences de la vie et de la terre",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 6,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 6,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 6,
CategoryId = 1,
MajorDisciplineId = 6,
Name = "Sciences des Plantes et Animaux",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
#endregion
break;
case 7:
#region Case Sciences Mathématiques
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 7,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 9,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 7,
Name = "Physiques/Chimie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 7,
Name = "SVI ou SI",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 7,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 7,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 8:
#region Case Sciences Economiques
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 8,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 8,
Name = "Comptabilité et mathématiques financières",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 8,
Name = "Economie générale et statistiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 6,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 8,
Name = "Economie et organisation des entreprises",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 8,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 6,
CategoryId = 1,
MajorDisciplineId = 8,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 9:
#region Case Gestion et Comptabilité
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 9,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 4,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 9,
Name = "Comptabilité et mathématiques financières",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 6,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 9,
Name = "Economie générale et statistiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 3,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 9,
Name = "Economie et organisation des entreprises",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 6,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 9,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 6,
CategoryId = 1,
MajorDisciplineId = 9,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 10:
#region Case Sciences et Technologies
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 10,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 10,
Name = "Physiques/Chimie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 10,
Name = "Sciences de l’ingénieur",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 8,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 10,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 10,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 11:
#region Case Arts Appliqués
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 11,
Name = "Arts et conception de la communication",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 8,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 11,
Name = "Art conception de l’environnement",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 11,
Name = "Art et conception des produits",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 11,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 11,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
case 12:
#region SWT
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 1,
CategoryId = 1,
MajorDisciplineId = 12,
Name = "Mathématiques",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 2,
CategoryId = 1,
MajorDisciplineId = 12,
Name = "Physiques/Chimie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 5,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 3,
CategoryId = 1,
MajorDisciplineId = 12,
Name = "Sciences de la vie et de la terre",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 7,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 4,
CategoryId = 1,
MajorDisciplineId = 12,
Name = "Philosophie",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
noteDeBacGroup.Add(new SubjectCoeff()
{
Id = 5,
CategoryId = 1,
MajorDisciplineId = 12,
Name = "Langue étrangère",
Type = "Écrit",
SwitchToGetCoeff = true,
Coefficient = 2,
CoefficientChangeable = false
});
#endregion
break;
default:
break;
}
}
}
private static void SeedCampusCollegesAndCourses(Tsu.DataAccess.TsuContext context)
{
// Campuses
var mainCampus = new Campus {
Id = 1, Name = "Main Campus", Code = "MC"
};
var lucindaCampus = new Campus {
Id = 2, Name = "Lucinda Campus", Code = "LC"
};
var sanIsidroCampus = new Campus {
Id = 3, Name = "San Isidro Campus", Code = "SIC"
};
context.Campuses.AddOrUpdate(mainCampus);
context.Campuses.AddOrUpdate(lucindaCampus);
context.Campuses.AddOrUpdate(sanIsidroCampus);
#region Colleges Stub
// Main Campus
var cass = new College {
Id = 1, Name = "College of Arts and Social Science", Code = "CASS", CampusId = 1
};
var chk = new College {
Id = 2, Name = "College of Human Kinetics", Code = "CHK", CampusId = 1
};
var cba = new College {
Id = 3, Name = "College of Business and Accountancy", Code = "CBA", CampusId = 1
};
var coeng = new College {
Id = 4, Name = "College of Engineering", Code = "COE", CampusId = 1
};
var ccs = new College {
Id = 5, Name = "College of Computer Studies", Code = "CCS", CampusId = 1
};
var cos = new College {
Id = 6, Name = "College of Science", Code = "COS", CampusId = 1
};
var cpa = new College {
Id = 7, Name = "College of Public Administration", Code = "CPA", CampusId = 1
};
// Lucinda Campus
var con = new College {
Id = 8, Name = "College of Nursing", Code = "CON", CampusId = 2
};
var coed = new College {
Id = 9, Name = "College of Education", Code = "CoED", CampusId = 2
};
// San Isidro Campus
var ct = new College {
Id = 10, Name = "College of Technology", Code = "CT", CampusId = 3
};
var cafa = new College {
Id = 11, Name = "College of Architecture and Fine Arts", Code = "CAFA", CampusId = 3
};
// Insert Colleges
context.Colleges.AddOrUpdate(cass);
context.Colleges.AddOrUpdate(chk);
context.Colleges.AddOrUpdate(cba);
context.Colleges.AddOrUpdate(ccs);
context.Colleges.AddOrUpdate(cpa);
context.Colleges.AddOrUpdate(coeng);
context.Colleges.AddOrUpdate(cos);
context.Colleges.AddOrUpdate(con);
context.Colleges.AddOrUpdate(coed);
context.Colleges.AddOrUpdate(ct);
context.Colleges.AddOrUpdate(cafa);
#endregion
#region Main Campus Courses
// CASS
var abComArts = new Course
{
Id = 1,
Name = "Bachelor of Arts in Communication Arts",
Code = "AB Com Arts",
AdmissionCode = "1101",
CollegeId = cass.Id,
};
var abEng = new Course
{
Id = 2,
Name = "Bachelor of Arts in English",
AdmissionCode = "1102",
Code = "AB Eng",
CollegeId = cass.Id,
};
var abPsych = new Course
{
Id = 3,
Name = "Bachelor of Arts in Psychology",
AdmissionCode = "1103",
Code = "AB Psych",
CollegeId = cass.Id
};
var bsCrim = new Course
{
Id = 4,
Name = "Bachelor of Science in Criminology",
AdmissionCode = "1104",
Code = "BS Crim",
CollegeId = cass.Id,
};
// CHK
var bpe = new Course
{
Id = 5,
Name = "Bachelor of Physical Education",
AdmissionCode = "1501",
Code = "BPE",
CollegeId = chk.Id,
};
// CBA
var bsa = new Course
{
Id = 6,
Name = "Bachelor of Science in Accountancy",
AdmissionCode = "1201",
Code = "BSA",
CollegeId = cba.Id,
};
var bsAct = new Course
{
Id = 7,
Name = "Bachelor of Science in Accounting Technology",
AdmissionCode = "1202",
Code = "BSACT",
CollegeId = cba.Id,
};
var bsEntrep = new Course
{
Id = 8,
Name = "Bachelor of Science in Entrepreneurship",
AdmissionCode = "1203",
Code = "BS Entrep",
CollegeId = cba.Id,
};
var bsHrm = new Course
{
Id = 9,
Name = "Bachelor of Science in Hotel and Restaurant Management",
AdmissionCode = "1204",
Code = "BSHRM",
CollegeId = cba.Id,
};
var bsba = new Course
{
Id = 10,
Name = "Bachelor of Science in Business Administration",
AdmissionCode = null,
Code = "BSBA",
CollegeId = cba.Id,
Majors = new List <MajorDiscipline>(),
};
// BSBA Majors
var fma = new MajorDiscipline {
Name = "Financial Management", AdmissionCode = "1205", CourseId = bsba.Id
};
var be = new MajorDiscipline {
Name = "Business Economics", AdmissionCode = "1206", CourseId = bsba.Id
};
var mm = new MajorDiscipline {
Name = "Marketing Management", AdmissionCode = "1207", CourseId = bsba.Id
};
context.MajorDisciplines.AddOrUpdate(fma);
context.MajorDisciplines.AddOrUpdate(be);
context.MajorDisciplines.AddOrUpdate(mm);
// CoE
var coengCE = new Course {
Id = 11, Name = "Bachelor of Science in Civil Engineering", AdmissionCode = "1401", CollegeId = coeng.Id
};
var coengEE = new Course {
Id = 12, Name = "Bachelor of Science in Electrical Engineering", AdmissionCode = "1402", CollegeId = coeng.Id
};
var coengElec = new Course {
Id = 13, Name = "Bachelor of Science in Electronics Engineering", AdmissionCode = "1403", CollegeId = coeng.Id
};
var coengIE = new Course {
Id = 14, Name = "Bachelor of Science in Industrial Engineering", AdmissionCode = "1404", CollegeId = coeng.Id
};
var coengME = new Course {
Id = 15, Name = "Bachelor of Science in Mechanical Engineering", AdmissionCode = "1405", CollegeId = coeng.Id
};
// CCS
var bscs = new Course {
Id = 16, Name = "Bachelor of Science in Computer Science", AdmissionCode = "1301", CollegeId = ccs.Id
};
var bsis = new Course {
Id = 17, Name = "Bachelor of Science in Information Systems", AdmissionCode = "1302", CollegeId = ccs.Id
};
var bsit = new Course {
Id = 18, Name = "Bachelor of Science in Information Technology", AdmissionCode = "1303", CollegeId = ccs.Id
};
var ait = new Course {
Id = 19, Name = "Associate in Information System", AdmissionCode = "1304", CollegeId = ccs.Id
};
// CPA
var bpa = new Course {
Id = 20, Name = "Bachelor in Public Administration", AdmissionCode = "1601", CollegeId = cpa.Id
};
// COS
var bsChem = new Course {
Id = 21, Name = "Bachelor of Science in Chemistry", AdmissionCode = "1701", CollegeId = cos.Id
};
var bsMath = new Course {
Id = 22, Name = "Bachelor of Science in Mathematics", AdmissionCode = "1702", CollegeId = cos.Id
};
// Insert Courses
// CASS
context.Courses.AddOrUpdate(abComArts);
context.Courses.AddOrUpdate(abEng);
context.Courses.AddOrUpdate(abPsych);
context.Courses.AddOrUpdate(bsCrim);
//CHK
context.Courses.AddOrUpdate(bpe);
// CBA
context.Courses.AddOrUpdate(bsa);
context.Courses.AddOrUpdate(bsAct);
context.Courses.AddOrUpdate(bsba);
context.Courses.AddOrUpdate(bsHrm);
context.Courses.AddOrUpdate(bsEntrep);
// CoE
context.Courses.AddOrUpdate(coengCE);
context.Courses.AddOrUpdate(coengIE);
context.Courses.AddOrUpdate(coengME);
context.Courses.AddOrUpdate(coengElec);
context.Courses.AddOrUpdate(coengEE);
// CCS
context.Courses.AddOrUpdate(bsis);
context.Courses.AddOrUpdate(bsit);
context.Courses.AddOrUpdate(bscs);
// CPA
context.Courses.AddOrUpdate(bpa);
// COS
context.Courses.AddOrUpdate(bsChem);
context.Courses.AddOrUpdate(bsMath);
#endregion
#region Lucinda Campus Courses
// CON
var nursing = new Course {
Id = 23, Name = "Bachelor of Science in Nursing", AdmissionCode = "2201", CollegeId = con.Id
};
// CoEd
var eeGen = new Course {
Id = 24, Name = "Bachelor of Science in Elementary Education Specialized in General Curriculum", AdmissionCode = "2101", CollegeId = coed.Id
};
var eePre = new Course {
Id = 25, Name = "Bachelor of Science in Elementary Education Specialized in Pre-School Education", AdmissionCode = "2102", CollegeId = coed.Id
};
var ie = new Course {
Id = 26, Name = "Bachelor of Science in Industrial Education Major in Industrial Arts", AdmissionCode = "2103", CollegeId = coed.Id
};
var secondaryEduc = new Course {
Id = 27, Name = "Bachelor of Science in Secondary Education", AdmissionCode = null, CollegeId = coed.Id
};
//Coed SEcondary Education Majors
var english = new MajorDiscipline {
Name = "English", AdmissionCode = "2104", CourseId = coed.Id
};
var filipino = new MajorDiscipline {
Name = "Filipino", AdmissionCode = "2105", CourseId = coed.Id
};
var mathematics = new MajorDiscipline {
Name = "Mathematics", AdmissionCode = "2106", CourseId = coed.Id
};
var mape = new MajorDiscipline {
Name = "Music, Arts, Physical Education & Health", AdmissionCode = "2107", CourseId = coed.Id
};
var ps = new MajorDiscipline {
Name = "Physical Science", AdmissionCode = "2108", CourseId = coed.Id
};
var SocSci = new MajorDiscipline {
Name = "Social Studies", AdmissionCode = "2109", CourseId = coed.Id
};
//.AddOrUpdate Secondary Educ Majors
context.MajorDisciplines.AddOrUpdate(english);
context.MajorDisciplines.AddOrUpdate(filipino);
context.MajorDisciplines.AddOrUpdate(mathematics);
context.MajorDisciplines.AddOrUpdate(mape);
context.MajorDisciplines.AddOrUpdate(ps);
context.MajorDisciplines.AddOrUpdate(SocSci);
// Insert Courses
// CON
context.Courses.AddOrUpdate(nursing);
// CoED
context.Courses.AddOrUpdate(eeGen);
context.Courses.AddOrUpdate(eePre);
context.Courses.AddOrUpdate(ie);
context.Courses.AddOrUpdate(secondaryEduc);
#endregion
#region San Isidro Campus Courses
var cafaFA = new Course {
Id = 28, Name = "Bachelor of Fine Arts major in Advertising", AdmissionCode = "3101", CollegeId = cafa.Id
};
var cafaArchi = new Course {
Id = 29, Name = "Bachelor of Science in Architecture", AdmissionCode = "3102", CollegeId = cafa.Id
};
// CT
var ctFT = new Course {
Id = 30, Name = "Bachelor of Science in Nutrition and Food Technology", AdmissionCode = "3201", CollegeId = ct.Id
};
var ctBIT = new Course {
Id = 31, Name = "Bachelor of Industrial Technology", AdmissionCode = null, CollegeId = ct.Id
};
//BIT Major
var bitAuto = new MajorDiscipline {
Name = "Automotive Technology", AdmissionCode = "3202", CourseId = ctBIT.Id
};
var bitET = new MajorDiscipline {
Name = "Electrical Technology", AdmissionCode = "3203", CourseId = ctBIT.Id
};
context.MajorDisciplines.AddOrUpdate(bitAuto);
context.MajorDisciplines.AddOrUpdate(bitET);
// BSIT
var ctBSIT = new Course {
Id = 32, Name = "Bachelor of Science in Industrial Technology", AdmissionCode = null, CollegeId = ct.Id
};
//BSIT Major
var bsitMT = new MajorDiscipline {
Name = "Mechatronics Technology", AdmissionCode = "3204", CourseId = ctBSIT.Id
};
var bsitEIT = new MajorDiscipline {
Name = "Electronics and Information Technology", AdmissionCode = "3205", CourseId = ctBSIT.Id
};
context.MajorDisciplines.AddOrUpdate(bsitMT);
context.MajorDisciplines.AddOrUpdate(bsitEIT);
// Insert Courses
// CAFA
context.Courses.AddOrUpdate(cafaFA);
context.Courses.AddOrUpdate(cafaArchi);
// CT
context.Courses.AddOrUpdate(ctFT);
context.Courses.AddOrUpdate(ctBIT);
context.Courses.AddOrUpdate(ctBSIT);
#endregion
context.SaveChanges();
}