private void editcourse_Click(object sender, RoutedEventArgs e)
{
try
{
corseadd selectedcrs = coursess.SelectedItem as corseadd;
selectedcrs.Name = coursename.Text.ToString();
selectedcrs.MaxDegree = short.Parse(degreee.Text.ToString());
selectedcrs.instructorName = instructorcourse.SelectedItem.ToString();
instructor newins = context3.instructors.Where(em => em.FirstName == selectedcrs.instructorName).FirstOrDefault();
course updatecourse =
(from cr in context3.courses
where cr.Name == selectedcrs.Name && cr.MaxDegree == selectedcrs.MaxDegree
select cr).FirstOrDefault();
updatecourse.Name = coursename.Text.ToString();
updatecourse.MaxDegree = short.Parse(degreee.Text.ToString());
updatecourse.MinDegree = 50;
updatecourse.Description = updatecourse.Name + " is important";
context3.SaveChanges();
rel_instructor_cource updatecourseandinstructor = context3.rel_instructor_cource.Where(em => em.CourseId == updatecourse.CourseId).FirstOrDefault();
updatecourseandinstructor.InsId = newins.InsId;
context3.SaveChanges();
}
catch (Exception k)
{
}
}
private void coursess_Loaded(object sender, RoutedEventArgs e)
{
List <corseadd> newcourse = new List <corseadd>();
var query =
(from q in context3.courses
select q).ToList();
var query2 =
(from c in context3.instructors
select new { c.FirstName, c.InsId }
).ToList();
foreach (var item in query)
{
corseadd addinstance = new corseadd();
addinstance.CourseId = item.CourseId;
addinstance.Name = item.Name;
addinstance.Description = item.Description;
addinstance.MaxDegree = item.MaxDegree;
addinstance.MinDegree = item.MinDegree;
rel_instructor_cource instructorId = context3.rel_instructor_cource.Where(em => em.CourseId == item.CourseId).FirstOrDefault();
foreach (var item2 in query2)
{
if (instructorId.InsId == item2.InsId)
{
addinstance.instructorName = item2.FirstName;
}
}
newcourse.Add(addinstance);
coursess.Items.Add(addinstance);
}
}
private void coursess_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
corseadd selectedcrs = coursess.SelectedItem as corseadd;
coursename.Text = selectedcrs.Name;
degreee.Text = selectedcrs.MaxDegree.ToString();
instructorcourse.SelectedItem = selectedcrs.instructorName;
}
private void courses_Loaded(object sender, RoutedEventArgs e)
{
List <corseadd> newcourse = new List <corseadd>();
var query =
(from q in context3.courses
select q).ToList();
foreach (var item in query)
{
var query2 =
(from c in context3.instructors
join t in context3.rel_instructor_cource
on c.InsId equals t.InsId
where t.CourseId == item.CourseId
select new { c.FirstName, c.InsId }
).FirstOrDefault();
corseadd addinstance = new corseadd();
addinstance.CourseId = item.CourseId;
addinstance.Name = item.Name;
addinstance.Description = item.Description;
addinstance.MaxDegree = item.MaxDegree;
addinstance.MinDegree = item.MinDegree;
//rel_instructor_cource instructorId = context3.rel_instructor_cource.Where(em => em.CourseId == item.CourseId).First();
//foreach (var item2 in query2)
//{
//if (instructorId.InsId == item2.InsId)
// {
if (query2 != null)
{
addinstance.instructorName = query2.FirstName;
}
else
{
addinstance.instructorName = "No Instructor Assigned";
}
//}
// }
newcourse.Add(addinstance);
coursess.Items.Add(addinstance);
}
}
private void addcourse_Click(object sender, RoutedEventArgs e)
{
try
{
corseadd newcourse = new corseadd();
newcourse.Name = coursename.Text.ToString();
newcourse.MaxDegree = 100;
newcourse.instructorName = instructorcourse.SelectedItem.ToString();
instructor newins = context3.instructors.Where(em => em.FirstName == newcourse.instructorName).FirstOrDefault();
rel_instructor_cource newcourseinstructor = new rel_instructor_cource();
course newCourseAdd = new course();
newCourseAdd.Name = coursename.Text.ToString();
newCourseAdd.MinDegree = 50;
newCourseAdd.MaxDegree = 100;
newCourseAdd.Description = coursename.Text.ToString() + "is important";
context3.courses.Add(newCourseAdd);
context3.SaveChanges();
newcourseinstructor.CourseId = newCourseAdd.CourseId;
newcourseinstructor.InsId = newins.InsId;
newcourseinstructor.Year = DateTime.Now;
context3.rel_instructor_cource.Add(newcourseinstructor);
context3.SaveChanges();
coursess.Items.Add(newcourse);
}
catch (Exception f)
{
MessageBox.Show("Invalid Inputs");
}
}