private void Apply_Click(object sender, RoutedEventArgs e)
{
db.CurrentUsers.Load();
db.TutorCourses.Load();
db.Tutees.Load();
db.Tutors.Load();
db.Courses.Load();
db.TutorConfirmationRequests.Load();
TutoringDB.Tutee temp = new TutoringDB.Tutee();
TutoringDB.Tutor temp2 = new TutoringDB.Tutor();
TutoringDB.Cours tempcs = new TutoringDB.Cours();
TutoringDB.TutorConfirmationRequest temptcs = new TutoringDB.TutorConfirmationRequest();
if (db.CurrentUsers.FirstOrDefault().Type == "tutee")
{
foreach (var tte in db.Tutees)
{
if (db.CurrentUsers.FirstOrDefault().UserName == tte.Username)
{
temp = tte;
}
}
temp2.FirstName = temp.FirstName;
temp2.LastName = temp.LastName;
temp2.Password = temp.Password;
temp2.UserName = temp.Username;
temp2.Year = temp.Year;
temp2.Email = temp.Email;
//temp2.Id = db.Tutors.Count();
//K:LWEKFN:OINF:EWIOLFNSMDNF:OILEKNF:SOIDLKFNEOIL?JFEWFDSFS
db.Tutors.Add(temp2);
//db.Tutees.Remove(temp);
//FKLJFEPLDKSFNPNEIKNELFPDIMOS:LDKFN:OEIJS
db.SaveChanges();
}
foreach (var tut in db.Tutors)
{
if (db.CurrentUsers.FirstOrDefault().UserName == tut.UserName)
{
temp2 = tut;
}
}
foreach (var cs in db.Courses)
{
if (cs.CourseName == CourseList.SelectedItem.ToString())
{
tempcs = cs;
temptcs.Cours = tempcs;
temptcs.Tutor = temp2;
}
}
db.TutorConfirmationRequests.Add(temptcs);
db.SaveChanges();
this.Close();
}
private void fillFacultyButton_Click(object sender, EventArgs e)
{
TutoringDB.TutorDatabaseEntities db = new TutoringDB.TutorDatabaseEntities();
db.Faculties.Load();
db.Courses.Load();
db.FacultyCourses.Load();
//Clear database first
foreach (TutoringDB.FacultyCours f in db.FacultyCourses)
{
db.FacultyCourses.Remove(f);
}
foreach (TutoringDB.Cours fc in db.Courses)
{
db.Courses.Remove(fc);
}
foreach (TutoringDB.Faculty f in db.Faculties)
{
db.Faculties.Remove(f);
}
db.SaveChanges();
TutoringDB.Faculty tempFaculty = new TutoringDB.Faculty();
TutoringDB.Cours tempCourse = new TutoringDB.Cours();
TutoringDB.FacultyCours tempFacultyCourse = new TutoringDB.FacultyCours();
//Read file line-by-line and load into database
foreach (string line in File.ReadLines(@"courses-fall16.txt"))
{
db.Faculties.Load();
//Fill Course Fields
var pieces = line.Split('\t');
tempCourse.CourseNumber = pieces[0];
tempCourse.CourseName = pieces[1];
var code = pieces[0].Split(' ');
tempCourse.Department = code[0];
db.Courses.Add(tempCourse);
//Fill Faculty Fields
tempFaculty.Username = tempFaculty.First_Name = pieces[2];
tempFaculty.Password = tempFaculty.LastName = pieces[3];
tempFaculty.Email = pieces[2] + pieces[3] + "@coe.edu";
var temps = db.Faculties.Where(i => i.First_Name == tempFaculty.First_Name && i.LastName == tempFaculty.LastName);
if (temps.Count() == 0)
{
db.Faculties.Add(tempFaculty);
tempFacultyCourse.Faculty = tempFaculty;
tempFacultyCourse.Cours = tempCourse;
db.FacultyCourses.Add(tempFacultyCourse);
db.SaveChanges();
}
else
{
var first = from i in db.Faculties
where i.Email == tempFaculty.Email
select i;
tempFacultyCourse.FacultyId = first.FirstOrDefault().Id;
tempFacultyCourse.Cours = tempCourse;
db.FacultyCourses.Add(tempFacultyCourse);
db.SaveChanges();
}
}
MessageBox.Show("Successfully Loaded.");
}
