private void btnLinkVenueCourse_Click(object sender, EventArgs e)
{
if (courseBindingSource.Count > 0)
{
int _CourseID = 0;
int _VenueID = 0;
_CourseID = ((Course)courseBindingSource.Current).CourseID;
_VenueID = ((Venue)venueBindingSource.Current).VenueID;
using (var Dbconnection = new MCDEntities())
{
VenueAssociatedCourse newVenueAssociatedCourse = new VenueAssociatedCourse()
{
CourseID = _CourseID,
VenueID = _VenueID,
VenueMaxCapacity = (int)nudVuenueCapacity.Value
};
Dbconnection.VenueAssociatedCourses.Add(newVenueAssociatedCourse);
Dbconnection.SaveChanges();
};
nudVuenueCapacity.Value = 1;
this.refreshDepartmentCourses();
this.refreshVenueCourses();
}
}
private void coursesDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
switch (e.ColumnIndex)
{
case 0:
if (courseBindingSource.Count > 0)
{
int _CourseID = 0;
int _VenueID = 0;
_CourseID = ((Course)courseBindingSource.Current).CourseID;
_VenueID = ((Venue)venueBindingSource.Current).VenueID;
using (var Dbconnection = new MCDEntities())
{
VenueAssociatedCourse newVenueAssociatedCourse = new VenueAssociatedCourse()
{
CourseID = _CourseID,
VenueID = _VenueID,
VenueMaxCapacity = 0
};
Dbconnection.VenueAssociatedCourses.Add(newVenueAssociatedCourse);
Dbconnection.SaveChanges();
};
// nudVuenueCapacity.Value = 1;
this.refreshDepartmentCourses();
this.refreshVenueCourses();
}
break;
}
}
private void btnREmoveVenueCourse_Click(object sender, EventArgs e)
{
if (venueAssociatedCourseBindingSource.Count > 0)
{
using (var Dbconnection = new MCDEntities())
{
VenueAssociatedCourse VenueAssociatedCourseToRemove = ((VenueAssociatedCourse)venueAssociatedCourseBindingSource.Current);
Dbconnection.Entry(VenueAssociatedCourseToRemove).State = EntityState.Deleted;
Dbconnection.SaveChanges();
};
this.refreshDepartmentCourses();
this.refreshVenueCourses();
}
}
private void venueAssociatedCoursesDataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
//
var gridView = (DataGridView)sender;
foreach (DataGridViewRow row in gridView.Rows)
{
if (!row.IsNewRow)
{
VenueAssociatedCourse VenueAssociatedCourseObj = (VenueAssociatedCourse)row.DataBoundItem;
row.Cells[colCourseName.Index].Value = VenueAssociatedCourseObj.Course.CourseName.ToString();
row.Cells[colDepartment.Index].Value = VenueAssociatedCourseObj.Course.LookupDepartment.DepartmentName.ToString();
}
}
}
