public ActionResult TeachersContent(int school, int year)
{
// get subjects
var subjects = repository.GetSchoolSubjects(school).OrderBy(x => x.name);
var viewmodel = new List <SubjectTeacher>();
foreach (var entry in subjects)
{
var subject = entry;
var subjectTeacher = db.subject_teachers.Where(x => x.year == year && x.subjectid == subject.id);
var model = new SubjectTeacher()
{
subjectid = subject.id,
subjectname = subject.name
};
foreach (var teacher in subjectTeacher.GroupBy(x => x.user))
{
var subjectentry = new SubjectTeacherEntry();
subjectentry.teachername = teacher.Key.ToName();
foreach (var klass in teacher.OrderBy(x => x.school_class.name))
{
subjectentry.AllocatedClasses.Add(new IdName(klass.classid, klass.school_class.name));
}
model.teachers.Add(subjectentry);
}
viewmodel.Add(model);
}
return(View(viewmodel));
}
public JsonResult UpdateTeacherProfile(EditProfileTeacher Data)
{
ResultInfo <string> ResultInfo = new ResultInfo <string>()
{
Status = false,
Description = "Failed|Login"
};
if (Data != null)
{
SubjectTeacher PageObj = new SubjectTeacher();
// Data.JoiningDate = Convert.ToDateTime(Data.JoiningDate);
ResultInfo.Info = PageObj.UpdateTeacherProfile(Data);
if (ResultInfo.Info.Split('!')[0] == "Success")
{
ResultInfo.Description = "Success!Update Successfull";
ResultInfo.Status = true;
}
else
{
ResultInfo.Description = "Failed!Process Failed";
ResultInfo.Status = false;
}
}
return(Json(ResultInfo, JsonRequestBehavior.AllowGet));
}
protected void setData()
{
if (!this.boxFirstName.IsEmptyOrWhiteSpace)
{
this.TheTeacher.FirstName = this.boxFirstName.Text;
}
if (!this.boxLastName.IsEmptyOrWhiteSpace)
{
this.TheTeacher.LastName = this.boxLastName.Text;
}
if (this.times != null)
{
for (int i = 0; i < this.TheTeacher.TimeTeachers.Count; i++)
{
this.TheTeacher.TimeTeachers[i].Active = false;
}
foreach (UniversityHoldingTime uht in this.times)
{
if (this.TheTeacher.TimeTeachers.Where(t => t.UniversityHoldingTime.HoldingTimeID ==
uht.HoldingTimeID).Count() == 0)
{
TimeTeacher tt = new TimeTeacher();
tt.Teacher = this.TheTeacher;
tt.UniversityHoldingTime = taali.UniversityHoldingTimes.Where(t =>
t.HoldingTimeID == uht.HoldingTimeID).Single();
tt.Active = true;
this.TheTeacher.TimeTeachers.Add(tt);
}
else
{
this.TheTeacher.TimeTeachers.Where(t => t.UniversityHoldingTime.HoldingTimeID ==
uht.HoldingTimeID).First().Active = true;
}
}
}
if (this.times != null)
{
for (int i = 0; i < this.TheTeacher.SubjectTeachers.Count; i++)
{
this.TheTeacher.SubjectTeachers[i].Active = false;
}
foreach (Subject s in this.subjects)
{
if (this.TheTeacher.SubjectTeachers.Where(ss => ss.Subject.SubjectID ==
s.SubjectID).Count() == 0)
{
SubjectTeacher st = new SubjectTeacher();
st.Teacher = this.TheTeacher;
st.Subject = taali.Subjects.Where(ss => ss.SubjectID == s.SubjectID).Single();
st.Active = true;
this.TheTeacher.SubjectTeachers.Add(st);
}
else
{
this.TheTeacher.SubjectTeachers.Where(ss => ss.Subject.SubjectID ==
s.SubjectID).First().Active = true;
}
}
}
}
private void BTNDelete_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("سوف يتم مسح هذاالعنصر؟", "تأكيد الحذف ", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
try
{
SubjectTeacher subjectTeacher = DGPlanShow.SelectedItem as SubjectTeacher;
SubjectTeacher subject = (from p in context.SubjectTeachers
where p.Id == subjectTeacher.Id
select p).Single();
context.SubjectTeachers.Remove(subject);
context.SaveChanges();
loadData();
}
catch (Exception)
{
MessageBox.Show("يوجد خطأ تأكد من البيانات و حاول مرة اخري");
}
}
else
{
MessageBox.Show("لاتقلق لم تمسح اي بيانات");
}
}
public async Task <ActionResult <SubjectTeacher> > AddSubjectTeacher(SubjectTeacher subjectTeacher)
{
if (ModelState.IsValid)
{
var ET = await _teacherRepo.AddSubjectTeacher(subjectTeacher);
if (ET != null)
{
return(Ok(ET));
}
}
return(NotFound());
}
public async Task <Unit> Handle(SubjectTeacherCreateCommand request, CancellationToken cancellationToken)
{
var subjectTeacher = new SubjectTeacher
{
SubjectId = request.SubjectId,
TeacherId = request.TeacherId
};
context.SubjectTeachers.Add(subjectTeacher);
await context.SaveChangesAsync(cancellationToken);
return(Unit.Value);
}
private void BTNEdit_Click(object sender, RoutedEventArgs e)
{
try
{
SubjectTeacher subjectTeacher = DGPlanShow.SelectedItem as SubjectTeacher;
SubjectTeacher subject = (from p in context.SubjectTeachers
where p.Id == subjectTeacher.Id
select p).Single();
context.SaveChanges();
loadData();
}
catch (Exception)
{
MessageBox.Show("يوجد خطأ تأكد من البيانات و حاول مرة اخري");
};
}
public JsonResult EditProfile(long TID)
{
ResultInfo <EditProfileTeacher> ResultInfo = new ResultInfo <EditProfileTeacher>()
{
Status = false,
Description = "Failed|Login"
};
SubjectTeacher PageObj = new SubjectTeacher();
ResultInfo.Info = PageObj.EditProfile(TID);
if (ResultInfo.Info != null)
{
ResultInfo.Description = "Success| Get Details ";
ResultInfo.Status = true;
}
return(Json(ResultInfo, JsonRequestBehavior.AllowGet));
}
public ActionResult TeachersEdit(long subject, int year, int school)
{
// get active teachers
var teachers = repository.GetUsers()
.Where(x => (x.usergroup == (int)UserGroup.TEACHER || x.usergroup == (int)UserGroup.HEAD) &&
x.schoolid.HasValue && x.schoolid.Value == school &&
x.employments.Count != 0 &&
x.employments.Any(y => y.start_date.HasValue && y.start_date.Value.Year <= year &&
(!y.end_date.HasValue || y.end_date.Value.Year >= year)))
.OrderBy(x => x.name)
.Select(x => new IdName()
{
id = x.id.ToString(),
name = x.ToName(false)
});
var s = repository.GetSchoolSubject(subject);
var viewmodel = new SubjectTeacher();
viewmodel.subjectid = s.id;
viewmodel.subjectname = s.name;
var subjects = db.subject_teachers.Where(x => x.subjectid == subject);
if (!subjects.Any())
{
// nothing
var subjectentry = new SubjectTeacherEntry();
subjectentry.teachers = teachers.Select(x => new SelectListItem()
{
Text = x.name,
Value = x.id
});
subjectentry.classes = db.school_classes
.Where(x => x.schoolid == school)
.OrderBy(x => x.name)
.Select(x => new SelectListItem()
{
Text = x.name,
Value = x.id.ToString()
});
viewmodel.teachers.Add(subjectentry);
}
else
{
foreach (var teacher in subjects.GroupBy(x => x.user))
{
var subjectentry = new SubjectTeacherEntry();
subjectentry.classes = db.school_classes
.Where(x => x.schoolid == school)
.OrderBy(x => x.name)
.Select(x => new SelectListItem()
{
Text = x.name,
Value = x.id.ToString()
});
IGrouping <user, subject_teacher> teacher1 = teacher;
subjectentry.teachers = teachers.Select(x => new SelectListItem()
{
Text = x.name,
Value = x.id,
Selected = x.id == teacher1.Key.id.ToString()
});
foreach (var klass in teacher.OrderBy(x => x.school_class.name))
{
subjectentry.AllocatedClasses.Add(new IdName(klass.classid, klass.school_class.name));
}
viewmodel.teachers.Add(subjectentry);
}
}
return(View(viewmodel));
}
protected override void Seed(MyDatabase context)
{
// Μain Entities Seeding
#region Courses' seeding ==========================
Course c1 = new Course()
{
Title = "BootCamp 1", Description = "C#", Type = Entities.Type.Part_Time, StartDate = new DateTime(2019, 11, 11), EndDate = new DateTime(2020, 06, 11), Fee = 900D
};
Course c2 = new Course()
{
Title = "BootCamp 2", Description = "Java", Type = Entities.Type.Full_Time, StartDate = new DateTime(2019, 11, 11), EndDate = new DateTime(2020, 03, 11), Fee = 900D
};
Course c3 = new Course()
{
Title = "BootCamp 3", Description = "Python", Type = Entities.Type.Full_Time, StartDate = new DateTime(2020, 1, 1), EndDate = new DateTime(2020, 06, 1), Fee = 1500D
};
#endregion
#region Subjects' seeding ==========================
Subject su1 = new Subject()
{
Title = "HTML & C#", PhotoURL = "#", CourseId = 1
};
Subject su2 = new Subject()
{
Title = "JS & C#", PhotoURL = "#", CourseId = 1
};
Subject su3 = new Subject()
{
Title = "C# Architecture", PhotoURL = "#", CourseId = 1
};
Subject su4 = new Subject()
{
Title = "Java Architecture", PhotoURL = "#", CourseId = 2
};
Subject su5 = new Subject()
{
Title = "Python Architecture", PhotoURL = "#", CourseId = 3
};
Subject su6 = new Subject()
{
Title = "HTML & java", PhotoURL = "#", CourseId = 2
};
Subject su7 = new Subject()
{
Title = "JS & java", PhotoURL = "#", CourseId = 2
};
Subject su8 = new Subject()
{
Title = "C# Entity", PhotoURL = "#", CourseId = 1
};
Subject su9 = new Subject()
{
Title = "Java & Algorithms", PhotoURL = "#", CourseId = 2
};
Subject su10 = new Subject()
{
Title = "C# - MVC", PhotoURL = "#", CourseId = 1
};
Subject su11 = new Subject()
{
Title = "Java - A full java system", PhotoURL = "#", CourseId = 2
};
Subject su12 = new Subject()
{
Title = "Python - A full application", PhotoURL = "#", CourseId = 3
};
//////// Subject.Cource=Course;
//////su1.Course = c1;
//////su2.Course = c1;
//////su3.Course = c1;
//////su8.Course = c1;
//////su10.Course = c1;
//////su4.Course = c2;
//////su6.Course = c2;
//////su7.Course = c2;
//////su9.Course = c2;
//////su11.Course = c2;
//////su5.Course = c3;
//////su12.Course = c3;
#endregion
#region Teachers' seeding ==========================
Teacher t1 = new Teacher()
{
LastName = "Gatsos", FirstName = "Hektor", Email = "*****@*****.**", Salary = 50000, Telephone = "1234567891"
};
Teacher t2 = new Teacher()
{
LastName = "Pasparakis", FirstName = "Giorgos", Email = "*****@*****.**", Salary = 90000, Telephone = "1234567892"
};
Teacher t3 = new Teacher()
{
LastName = "Tzelepidis", FirstName = "Basilis", Email = "*****@*****.**", Salary = 30000, Telephone = "1234567893"
};
Teacher t4 = new Teacher()
{
LastName = "Panou", FirstName = "Panos", Email = "*****@*****.**", Salary = 40000, Telephone = "1234567894"
};
Teacher t5 = new Teacher()
{
LastName = "Minaidis", FirstName = "Georgios", Email = "*****@*****.**", Salary = 45000, Telephone = "1234567895"
};
#endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#region SubjectTeachers=======================
SubjectTeacher suT1 = new SubjectTeacher()
{
Subject = su1, Teacher = t1
};
SubjectTeacher suT2 = new SubjectTeacher()
{
Subject = su2, Teacher = t1
};
SubjectTeacher suT3 = new SubjectTeacher()
{
Subject = su3, Teacher = t1
};
SubjectTeacher suT8 = new SubjectTeacher()
{
Subject = su8, Teacher = t1
};
SubjectTeacher suT10 = new SubjectTeacher()
{
Subject = su10, Teacher = t1
};
t1.SubjectTeachers = new List <SubjectTeacher>()
{
suT1, suT2, suT3, suT8, suT10
};
SubjectTeacher suT4 = new SubjectTeacher()
{
Subject = su4, Teacher = t2
};
SubjectTeacher suT6 = new SubjectTeacher()
{
Subject = su6, Teacher = t2
};
SubjectTeacher suT7 = new SubjectTeacher()
{
Subject = su7, Teacher = t2
};
SubjectTeacher suT9 = new SubjectTeacher()
{
Subject = su9, Teacher = t2
};
SubjectTeacher suT11 = new SubjectTeacher()
{
Subject = su11, Teacher = t2
};
t2.SubjectTeachers = new List <SubjectTeacher>()
{
suT4, suT6, suT7, suT9, suT11
};
SubjectTeacher suT5 = new SubjectTeacher()
{
Subject = su5, Teacher = t3
};
SubjectTeacher suT12 = new SubjectTeacher()
{
Subject = su12, Teacher = t3
};
t3.SubjectTeachers = new List <SubjectTeacher>()
{
suT5, suT12
};
SubjectTeacher suT13 = new SubjectTeacher()
{
Subject = su5, Teacher = t4
};
SubjectTeacher suT14 = new SubjectTeacher()
{
Subject = su12, Teacher = t4
};
t4.SubjectTeachers = new List <SubjectTeacher>()
{
suT13, suT14
};
SubjectTeacher suT15 = new SubjectTeacher()
{
Subject = su1, Teacher = t5
};
SubjectTeacher suT16 = new SubjectTeacher()
{
Subject = su2, Teacher = t5
};
t5.SubjectTeachers = new List <SubjectTeacher>()
{
suT15, suT16
};
////su1.Teachers = new List<Teacher>() { t1, t2, t3, t4, t5 };
#endregion
#region Students' seeding ==========================
Student s1 = new Student()
{
LastName = "Parisi", FirstName = "Eleni", Email = "*****@*****.**", Telephone = "1234567810"
};
Student s2 = new Student()
{
LastName = "Periklidis", FirstName = "Mixalis", Email = "*****@*****.**", Telephone = "1234567811"
};
Student s3 = new Student()
{
LastName = "Papadopoulos", FirstName = "Vaso", Email = "*****@*****.**", Telephone = "1234567812"
};
Student s4 = new Student()
{
LastName = "Kanellis", FirstName = "Stathis", Email = "*****@*****.**", Telephone = "1234567813"
};
Student s5 = new Student()
{
LastName = "katrakis", FirstName = "Thanos", Email = "*****@*****.**", Telephone = "1234567814"
};
Student s6 = new Student()
{
LastName = "Veggos", FirstName = "Thanasis", Email = "*****@*****.**", Telephone = "1234567815"
};
Student s7 = new Student()
{
LastName = "Papatrexas", FirstName = "Athanasios", Email = "*****@*****.**", Telephone = "1234567816"
};
Student s8 = new Student()
{
LastName = "Elefsiniotis", FirstName = "Giannis", Email = "*****@*****.**", Telephone = "1234567817"
};
Student s9 = new Student()
{
LastName = "Saris", FirstName = "Ioannis", Email = "*****@*****.**", Telephone = "1234567818"
};
Student s10 = new Student()
{
LastName = "Poulakos", FirstName = "Giorgos", Email = "*****@*****.**", Telephone = "1234567819"
};
Student s11 = new Student()
{
LastName = "Vlaxogiannis", FirstName = "Xenofontas", Email = "*****@*****.**", Telephone = "1234567820"
};
Student s12 = new Student()
{
LastName = "Sakarakas", FirstName = "Panagiotis", Email = "*****@*****.**", Telephone = "1234567821"
};
Student s13 = new Student()
{
LastName = "Karowich", FirstName = "Karolos", Email = "*****@*****.**", Telephone = "1234567822"
};
Student s14 = new Student()
{
LastName = "Kuriakou", FirstName = "Adam", Email = "*****@*****.**", Telephone = "1234567823"
};
Student s15 = new Student()
{
LastName = "Papandreou", FirstName = "Albi", Email = "*****@*****.**", Telephone = "1234567824"
};
Student s16 = new Student()
{
LastName = "Perikleoys", FirstName = "Alex", Email = "*****@*****.**", Telephone = "1234567825"
};
Student s17 = new Student()
{
LastName = "Kontodimas", FirstName = "Bagggelis", Email = "*****@*****.**", Telephone = "1234567826"
};
Student s18 = new Student()
{
LastName = "Makrys", FirstName = "Xristos", Email = "*****@*****.**", Telephone = "1234567827"
};
Student s19 = new Student()
{
LastName = "Sxoinas", FirstName = "Dionusis", Email = "*****@*****.**", Telephone = "1234567828"
};
Student s20 = new Student()
{
LastName = "Xatzixristou", FirstName = "Maria", Email = "*****@*****.**", Telephone = "1234567829"
};
Student s21 = new Student()
{
LastName = "Fotiou", FirstName = "Fotis", Email = "*****@*****.**", Telephone = "1234567830"
};
Student s22 = new Student()
{
LastName = "Karampas", FirstName = "Takis", Email = "*****@*****.**", Telephone = "1234567831"
};
Student s23 = new Student()
{
LastName = "Telopoulos", FirstName = "Periklis", Email = "*****@*****.**", Telephone = "1234567832"
};
Student s24 = new Student()
{
LastName = "Katsaros", FirstName = "Kosta", Email = "*****@*****.**", Telephone = "1234567833"
};
Student s25 = new Student()
{
LastName = "Dimitriou", FirstName = "Dimitris", Email = "*****@*****.**", Telephone = "1234567834"
};
Student s26 = new Student()
{
LastName = "Katerinaki", FirstName = "Katerina", Email = "*****@*****.**", Telephone = "1234567835"
};
Student s27 = new Student()
{
LastName = "Sofianou", FirstName = "Sofia", Email = "*****@*****.**", Telephone = "1234567836"
};
Student s28 = new Student()
{
LastName = "Karakosta", FirstName = "Mairi", Email = "*****@*****.**", Telephone = "1234567837"
};
Student s29 = new Student()
{
LastName = "Marikaki", FirstName = "Meni", Email = "*****@*****.**", Telephone = "1234567838"
};
Student s30 = new Student()
{
LastName = "Lyraki", FirstName = "Lina", Email = "*****@*****.**", Telephone = "1234567839"
};
#endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#region StudentCourses==============================
CourseStudent cs1 = new CourseStudent()
{
Course = c1, Student = s1, IsFeePayed = true
};
CourseStudent cs2 = new CourseStudent()
{
Course = c1, Student = s2, IsFeePayed = true
};
CourseStudent cs3 = new CourseStudent()
{
Course = c1, Student = s3, IsFeePayed = true
};
CourseStudent cs4 = new CourseStudent()
{
Course = c1, Student = s4, IsFeePayed = true
};
CourseStudent cs5 = new CourseStudent()
{
Course = c1, Student = s5, IsFeePayed = false
};
CourseStudent cs6 = new CourseStudent()
{
Course = c1, Student = s6, IsFeePayed = true
};
CourseStudent cs7 = new CourseStudent()
{
Course = c1, Student = s7, IsFeePayed = false
};
CourseStudent cs8 = new CourseStudent()
{
Course = c1, Student = s8, IsFeePayed = true
};
CourseStudent cs9 = new CourseStudent()
{
Course = c1, Student = s9, IsFeePayed = false
};
CourseStudent cs10 = new CourseStudent()
{
Course = c1, Student = s10, IsFeePayed = false
};
CourseStudent cs11 = new CourseStudent()
{
Course = c1, Student = s11, IsFeePayed = false
};
CourseStudent cs12 = new CourseStudent()
{
Course = c1, Student = s12, IsFeePayed = false
};
CourseStudent cs13 = new CourseStudent()
{
Course = c1, Student = s13, IsFeePayed = true
};
CourseStudent cs14 = new CourseStudent()
{
Course = c1, Student = s14, IsFeePayed = true
};
CourseStudent cs15 = new CourseStudent()
{
Course = c1, Student = s15, IsFeePayed = false
};
CourseStudent cs16 = new CourseStudent()
{
Course = c1, Student = s16, IsFeePayed = true
};
CourseStudent cs17 = new CourseStudent()
{
Course = c1, Student = s17, IsFeePayed = false
};
CourseStudent cs18 = new CourseStudent()
{
Course = c1, Student = s18, IsFeePayed = true
};
CourseStudent cs19 = new CourseStudent()
{
Course = c1, Student = s19, IsFeePayed = false
};
CourseStudent cs20 = new CourseStudent()
{
Course = c1, Student = s20, IsFeePayed = false
};
CourseStudent cs21 = new CourseStudent()
{
Course = c1, Student = s21, IsFeePayed = false
};
CourseStudent cs22 = new CourseStudent()
{
Course = c1, Student = s22, IsFeePayed = false
};
CourseStudent cs23 = new CourseStudent()
{
Course = c1, Student = s23, IsFeePayed = true
};
CourseStudent cs24 = new CourseStudent()
{
Course = c1, Student = s24, IsFeePayed = true
};
CourseStudent cs25 = new CourseStudent()
{
Course = c1, Student = s25, IsFeePayed = false
};
CourseStudent cs26 = new CourseStudent()
{
Course = c1, Student = s26, IsFeePayed = true
};
CourseStudent cs27 = new CourseStudent()
{
Course = c1, Student = s27, IsFeePayed = false
};
CourseStudent cs28 = new CourseStudent()
{
Course = c1, Student = s28, IsFeePayed = true
};
CourseStudent cs29 = new CourseStudent()
{
Course = c1, Student = s29, IsFeePayed = false
};
c1.CourseStudents = new List <CourseStudent>()
{
cs1, cs2, cs3, cs4, cs5, cs6, cs7, cs8, cs9, cs10, cs11, cs12, cs13, cs14, cs15, cs16, cs17, cs18, cs19, cs20, cs21, cs22, cs23, cs24, cs25, cs26, cs27, cs28, cs29
};
CourseStudent cs31 = new CourseStudent()
{
Course = c2, Student = s2, IsFeePayed = true
};
CourseStudent cs32 = new CourseStudent()
{
Course = c2, Student = s3, IsFeePayed = false
};
CourseStudent cs33 = new CourseStudent()
{
Course = c2, Student = s12, IsFeePayed = true
};
CourseStudent cs34 = new CourseStudent()
{
Course = c2, Student = s13, IsFeePayed = true
};
CourseStudent cs35 = new CourseStudent()
{
Course = c2, Student = s22, IsFeePayed = false
};
CourseStudent cs36 = new CourseStudent()
{
Course = c2, Student = s23, IsFeePayed = true
};
c2.CourseStudents = new List <CourseStudent>()
{
cs31, cs32, cs33, cs34, cs35, cs36
};
CourseStudent cs30 = new CourseStudent()
{
Course = c3, Student = s9, IsFeePayed = false
};
CourseStudent cs37 = new CourseStudent()
{
Course = c3, Student = s3, IsFeePayed = false
};
CourseStudent cs38 = new CourseStudent()
{
Course = c3, Student = s13, IsFeePayed = true
};
CourseStudent cs39 = new CourseStudent()
{
Course = c3, Student = s23, IsFeePayed = true
};
c3.CourseStudents = new List <CourseStudent>()
{
cs30, cs37, cs38, cs39
};
// s1.Courses = new List<Course>() { c1 };
//s2.Courses = new List<Course>() { c1, c2 };
//s3.Courses = new List<Course>() { c1, c2, c3 };
//s4.Courses = new List<Course>() { c1 };
//s5.Courses = new List<Course>() { c1 };
//s6.Courses = new List<Course>() { c1 };
//s7.Courses = new List<Course>() { c1 };
//s8.Courses = new List<Course>() { c1 };
//s9.Courses = new List<Course>() { c1 };
//s10.Courses = new List<Course>() { c1 };
//s11.Courses = new List<Course>() { c1 };
//s12.Courses = new List<Course>() { c1, c2 };
//s13.Courses = new List<Course>() { c1, c2, c3 };
//s14.Courses = new List<Course>() { c1 };
//s15.Courses = new List<Course>() { c1 };
//s16.Courses = new List<Course>() { c1 };
//s17.Courses = new List<Course>() { c1 };
//s18.Courses = new List<Course>() { c1 };
//s19.Courses = new List<Course>() { c1 };
//s20.Courses = new List<Course>() { c3 };
//s21.Courses = new List<Course>() { c1 };
//s22.Courses = new List<Course>() { c1, c2 };
//s23.Courses = new List<Course>() { c1, c2, c3 };
//s24.Courses = new List<Course>() { c1 };
//s25.Courses = new List<Course>() { c1 };
//s26.Courses = new List<Course>() { c1 };
//s27.Courses = new List<Course>() { c1 };
//s28.Courses = new List<Course>() { c1 };
//s29.Courses = new List<Course>() { c1 };
//s30.Courses = new List<Course>() { c3 };
#endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//TO BEA ADDED
#region Assignments' seeding ==========================
//Assignment a1 = new Assignment() { Title = "First C# Assignment", SubDate = new DateTime(2020, 04, 02) };
//Assignment a2 = new Assignment() { Title = "First Java Assignment" };
//Assignment a3 = new Assignment() { Title = "First Python Assignment" };
//Assignment a4 = new Assignment() { Title = "Functionlity to HTML" };
//Assignment a5 = new Assignment() { Title = "Provide Structure to WebSites" };
//Assignment a6 = new Assignment() { Title = "Well presented data with Java" };
//Assignment a7 = new Assignment() { Title = "Java & Javascript" };
//Assignment a8 = new Assignment() { Title = "Entity Assignment" };
//Assignment a9 = new Assignment() { Title = "Assignment - Java & Algorithms" };
//Assignment a10 = new Assignment() { Title = "MVC project" };
//Assignment a11 = new Assignment() { Title = " Java Team Project" };
//Assignment a12 = new Assignment() { Title = "Python - Team Project" };
//a1.Subject = su3;
//a2.Subject = su4;
#endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#region Marks' seeding ======================
////Για το assignment 1 (tou c1, s3 pou to exoun oloi oi mathites)
//Mark m1 = new Mark() {StudentId = 1, AssignmentMark = 60 };
//Mark m2 = new Mark() {StudentId = 2, AssignmentMark = 61 };
//Mark m3 = new Mark() {StudentId = 3, AssignmentMark = 62 };
//Mark m4 = new Mark() {StudentId = 4, AssignmentMark = 63 };
//Mark m5 = new Mark() {StudentId = 5, AssignmentMark = 64 };
//Mark m6 = new Mark() {StudentId = 6, AssignmentMark = 65 };
//Mark m7 = new Mark() {StudentId = 7, AssignmentMark = 66 };
//Mark m8 = new Mark() {StudentId = 8, AssignmentMark = 67 };
//Mark m9 = new Mark() {StudentId = 9, AssignmentMark = 68 };
//Mark m10 = new Mark() {StudentId = 10 , AssignmentMark = 60 };
//Mark m11 = new Mark() {StudentId = 11 , AssignmentMark = 60 };
//Mark m12 = new Mark() {StudentId = 12 , AssignmentMark = 60 };
//Mark m13 = new Mark() {StudentId = 13 , AssignmentMark = 60 };
//Mark m14 = new Mark() {StudentId = 14 , AssignmentMark = 60 };
//Mark m15 = new Mark() {StudentId = 15 , AssignmentMark = 60 };
//Mark m16 = new Mark() {StudentId = 16 , AssignmentMark = 60 };
//Mark m17 = new Mark() {StudentId = 17 , AssignmentMark = 60 };
//Mark m18 = new Mark() {StudentId = 18 , AssignmentMark = 60 };
//Mark m19 = new Mark() {StudentId = 19 , AssignmentMark = 60 };
//Mark m20 = new Mark() {StudentId = 20 , AssignmentMark = 60 };
//Mark m21 = new Mark() {StudentId = 21 , AssignmentMark = 60 };
//Mark m22 = new Mark() {StudentId = 22 , AssignmentMark = 60 };
//Mark m23 = new Mark() {StudentId = 23 , AssignmentMark = 60 };
//Mark m24 = new Mark() {StudentId = 24 , AssignmentMark = 60 };
//Mark m25 = new Mark() {StudentId = 25 , AssignmentMark = 60 };
//Mark m26 = new Mark() {StudentId = 26 , AssignmentMark = 60 };
//Mark m27 = new Mark() {StudentId = 27 , AssignmentMark = 60 };
//Mark m28 = new Mark() {StudentId = 28 , AssignmentMark = 60 };
//Mark m29 = new Mark() {StudentId = 29 , AssignmentMark = 60 };
//Mark m30 = new Mark() {StudentId = 30 , AssignmentMark = 60 };
////Για το assignment 2 (tou c2, s4 pou to exoun 6 mathites)
//Mark m31 = new Mark() {StudentId = 2, AssignmentMark = 70 };
//Mark m32 = new Mark() {StudentId = 3, AssignmentMark = 71 };
//Mark m33 = new Mark() {StudentId = 12, AssignmentMark = 82 };
//Mark m34 = new Mark() {StudentId = 13, AssignmentMark = 83 };
//Mark m35 = new Mark() {StudentId = 22, AssignmentMark = 84 };
//Mark m36 = new Mark() {StudentId = 23, AssignmentMark = 85 };
////Για το assignment 3 (tou c3, s5 pou to exoun 3 mathites)
//Mark m37 = new Mark() {StudentId = 3, AssignmentMark = 66 };
//Mark m38 = new Mark() {StudentId = 13, AssignmentMark = 67 };
//Mark m39 = new Mark() {StudentId = 23, AssignmentMark = 68 };
////Για το assignment 4 (tou c1, s2 pou to exoun oloi oi mathites)
//Mark m40 = new Mark() {StudentId = 1 , AssignmentMark = 70 };
//Mark m41 = new Mark() {StudentId = 2 , AssignmentMark = 74 };
//Mark m42 = new Mark() {StudentId = 3 , AssignmentMark = 74 };
//Mark m43 = new Mark() {StudentId = 4 , AssignmentMark = 74 };
//Mark m44 = new Mark() {StudentId = 5 , AssignmentMark = 74 };
//Mark m45 = new Mark() {StudentId = 6 , AssignmentMark = 74 };
//Mark m46 = new Mark() {StudentId = 7 , AssignmentMark = 99 };
//Mark m47 = new Mark() {StudentId = 8 , AssignmentMark = 99 };
//Mark m48 = new Mark() {StudentId = 9 , AssignmentMark = 99 };
//Mark m49 = new Mark() {StudentId = 10 , AssignmentMark = 78 };
//Mark m50 = new Mark() {StudentId = 11 , AssignmentMark = 78 };
//Mark m51 = new Mark() {StudentId = 12 , AssignmentMark = 78 };
//Mark m52 = new Mark() {StudentId = 13 , AssignmentMark = 90 };
//Mark m53 = new Mark() {StudentId = 14 , AssignmentMark = 90 };
//Mark m54 = new Mark() {StudentId = 15 , AssignmentMark = 90 };
//Mark m55 = new Mark() {StudentId = 16 , AssignmentMark = 90 };
//Mark m56 = new Mark() {StudentId = 17 , AssignmentMark = 96 };
//Mark m57 = new Mark() {StudentId = 18 , AssignmentMark = 96 };
//Mark m58 = new Mark() {StudentId = 19 , AssignmentMark = 64 };
//Mark m59 = new Mark() {StudentId = 20 , AssignmentMark = 74 };
//Mark m60 = new Mark() {StudentId = 21 , AssignmentMark = 74 };
//Mark m61 = new Mark() {StudentId = 22 , AssignmentMark = 74 };
//Mark m62 = new Mark() {StudentId = 23 , AssignmentMark = 74 };
//Mark m63 = new Mark() {StudentId = 24 , AssignmentMark = 64 };
//Mark m64 = new Mark() {StudentId = 25 , AssignmentMark = 64 };
//Mark m65 = new Mark() {StudentId = 26 , AssignmentMark = 70 };
//Mark m66 = new Mark() {StudentId = 27 , AssignmentMark = 80 };
//Mark m67 = new Mark() {StudentId = 28 , AssignmentMark = 70 };
//Mark m68 = new Mark() {StudentId = 29 , AssignmentMark = 100 };
//Mark m69 = new Mark() {StudentId = 30 , AssignmentMark = 70 };
#endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#region Συσχετισεις============================
////ASSIGNMENT'S NAVIGATION RELATED PROPERTIES
//a1.Marks = new List<Mark>() { m1, m2, m3, m4, m5, m6, m7, m8, m9, m10, m11, m12, m13, m14, m15, m16, m17, m18, m19, m20, m21, m22, m23, m24, m25, m26, m27, m28, m29, m30 };
//a2.Marks = new List<Mark>() { m31, m32, m33, m34, m35, m36 };
//a3.Marks = new List<Mark>() { m37, m38, m39 };
//a4.Marks = new List<Mark>() { m40, m41, m42, m43, m44, m45, m46, m47, m48, m49, m50, m51, m52, m53, m54, m55, m56, m57, m58, m59, m60, m61, m62, m63, m64, m65, m66, m67, m68, m69 };
//// to be continued-----!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1!!!!!!!!!!!!!!!!!!!!!
////a5.Marks =
////a6.Marks =
////a7.Marks =
////a8.Marks =
////a9.Marks =
////a10.Marks =
////a11.Marks =
////a12.Marks =
//a1.Subject = su3;
//a2.Subject = su4;
//a3.Subject = su5;
//a4.Subject = su2;
//a5.Subject = su1;
//a6.Subject = su6;
//a7.Subject = su7;
//a8.Subject = su8;
//a9.Subject = su9;
//a10.Subject = su10;
//a11.Subject = su11;
//a12.Subject = su12;
//// Subject.Assignment=Assignment;
//su1.Assignment = a5;
// su2.Assignment = a4;
// su3.Assignment = a1;
// su4.Assignment = a2;
// su5.Assignment = a3;
//su6.Assignment = a6;
//su7.Assignment = a7;
//su8.Assignment = a8;
//su9.Assignment = a9;
//su10.Assignment = a10;
//su11.Assignment = a11;
//su12.Assignment = a12;
#endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
context.Courses.AddOrUpdate(x => x.Title, c1, c2, c3);
context.Subjects.AddOrUpdate(x => x.Title, su1, su2, su3, su4, su5, su6, su7, su8, su9, su10, su11, su12);
context.Teachers.AddOrUpdate(x => x.FirstName, t1, t2, t3, t4, t5);
context.Students.AddOrUpdate(x => x.LastName, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16, s17, s18, s19, s20, s21, s22, s23, s24, s25, s26, s27, s28, s29, s30);
//context.Assignments.AddOrUpdate(x => x.Title, a1);
//context.Assignments.AddOrUpdate(x => x.Title, a1, a2, a3, a4, a5, a6, a7, a8, a8, a9, a10, a11, a12);
context.SaveChanges();
}
