private void btnLinkModule_Click(object sender, EventArgs e)
{
using (var DbConnection = new MCDEntities())
{
CurriculumCourseModule TDCETM = new CurriculumCourseModule()
{
CurriculumCourseID = this.CurriculumCourseID,
ModuleID = Convert.ToInt32(lstAvailableModules.SelectedValue)
};
DbConnection.CurriculumCourseModules.Add(TDCETM);
DbConnection.SaveChanges();
};
this.populateAvailableModules();
this.populateLinkedModules();
}
private void btnRemoveModule_Click(object sender, EventArgs e)
{
using (var DbConnection = new MCDEntities())
{
int ID = Convert.ToInt32(lstLinkedModules.SelectedValue);
CurriculumCourseModule LinkedModuleToRemove = (from a in DbConnection.CurriculumCourseModules
where a.CurriculumCourseID == this.CurriculumCourseID &&
a.ModuleID == ID
select a).FirstOrDefault <CurriculumCourseModule>();
DbConnection.Entry(LinkedModuleToRemove).State = System.Data.Entity.EntityState.Deleted;
DbConnection.SaveChanges();
};
this.populateAvailableModules();
this.populateLinkedModules();
}
private void btnLinkActivities_Click(object sender, EventArgs e)
{
using (var DbConnection = new MCDEntities())
{
/*
* this steps follow to both entities
*
* 1 - create instance of entity with relative primary key
*
* 2 - add instance to context
*
* 3 - attach instance to context
*/
CurriculumCourseModule ab = (from a in DbConnection.CurriculumCourseModules
where a.ModuleID == this.ModuleID &&
a.CurriculumCourseID == this.CurriculumCourseID
select a).FirstOrDefault<CurriculumCourseModule>();
Activity ActivityObj = (Activity)this.bindingSourceAvailableModuleActivities.Current;
////// 1
Activity ac = new Activity
{
ActivityID = ActivityObj.ActivityID,
};
////// 2
DbConnection.Activities.Add(ac);
////// 3
DbConnection.Activities.Attach(ac);
// like previous method add instance to navigation property
ab.Activities.Add(ac);
// call SaveChanges
DbConnection.SaveChanges();
};
this.populateAvailableModuleActivities();
this.populateLinkedModuleActivities();
this.setAddRemoveControls();
}
