private void BtnSave_Click(object sender, EventArgs e)
{
if (CustomValidation())
{
ValidatedSuccesFully();
Course.Course = TxtName.Text;
Course.ContactPerson = TxtContactPerson.Text;
Course.CourseInstitution = TxtInstitution.Text;
Course.OeNumber = Convert.ToInt32(TxtOeNumber.Text);
Course.CourseCode = Convert.ToInt32(TxtCourseCode.Text);
Course.EndDate = DTPEndDate.Value;
Course.StartDate = DTPStartDate.Value;
Course.Location = TxtLocation.Text;
using (AttendanceListDbEntities context = new AttendanceListDbEntities())
{
if (NewEntry)
{
context.CourseInfoes.Add(Course);
}
else
{
context.CourseInfoes.Where(x => x.ID == Course.ID).ToList()[0] = Course;
}
context.SaveChanges();
}
this.Close();
}
}
private void RefreshTeachers()
{
LstTeachers.Items.Clear();
using (AttendanceListDbEntities context = new AttendanceListDbEntities())
{
foreach (var item in context.Teachers_Courses.Where(x => x.CourseID == Course.ID))
{
var teacher = context.Teachers.Where(x => x.ID == item.TeacherID).FirstOrDefault();
LstTeachers.Items.Add(teacher);
}
}
}
private void RefreshParticipants()
{
LstParticipants.Items.Clear();
using (AttendanceListDbEntities context = new AttendanceListDbEntities())
{
foreach (var item in context.Participants_Courses.Where(x => x.CourseID == Course.ID))
{
var participant = context.Participants.Where(x => x.ID == item.ParticipantID).FirstOrDefault();
LstParticipants.Items.Add(participant);
}
}
}
private void BtnRemoveTeacher_Click(object sender, EventArgs e)
{
if (LstTeachers.SelectedItem != null)
{
var tempTeacher = (Teacher)LstTeachers.SelectedItem;
var sure = MessageBox.Show($"Are you sure you want to remove {tempTeacher.Name} from {Course.Course}?", $"Removing {tempTeacher.Name}", MessageBoxButtons.YesNo);
if (sure == DialogResult.Yes)
{
using (AttendanceListDbEntities context = new AttendanceListDbEntities())
{
var tobeRemoved = (Teachers_Courses)context.Teachers_Courses.Where(x => x.CourseID == Course.ID && x.TeacherID == tempTeacher.ID).FirstOrDefault();
context.Teachers_Courses.Remove(tobeRemoved);
context.SaveChanges();
}
RefreshTeachers();
}
}
}
