public ActionResult Edit([Bind(Include = "TrainingID,Name,TrainingDate,Location,TrainingEnd,NumberOfMeetings,Duration,ExpireDate,ExpirationDate,QualificationID")] Training training, int[] subsectors)
{
if (ModelState.IsValid)
{
db.Entry(training).State = EntityState.Modified;
// training.TrainingSubSectors.Clear();
var SubSectorToTrainingList = db.TrainingSubSectors.Where(t => t.TrainingID == training.TrainingID).ToList();
foreach (var train in SubSectorToTrainingList)
{
db.TrainingSubSectors.Remove(train);
}
foreach (var id in subsectors)
{
SubSector sub = db.SubSectors.Find(id);
training.AddSubSector(sub);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
var sectorlist = (from s in training.TrainingSubSectors
select s.SubSector.SectorID).ToArray();
var subsectorlist = (from s in training.TrainingSubSectors
select s.SubSectorID).ToArray();
ViewBag.Sectors = new MultiSelectList(db.Sectors, "SectorID", "SectorType", sectorlist);
ViewBag.subSectors = new MultiSelectList(db.SubSectors, "SubSectorID", "SubSectortype", subsectorlist);
ViewBag.QualificationID = new MultiSelectList(db.Qualification, "QualificationID", "Name");
return(View(training));
}
public ActionResult Create([Bind(Include = "TrainingID,Name,TrainingDate,Location,TrainingEnd,NumberOfMeetings,Duration,ExpireDate,ExpirationDate,QualificationID")] Training training, int[] subsectors)
{
if (ModelState.IsValid)
{
foreach (var id in subsectors)
{
SubSector subsector = db.SubSectors.Find(id);
training.AddSubSector(subsector);
}
db.Trainings.Add(training);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Sectors = new MultiSelectList(db.Sectors, "SectorID", "SectorType");
ViewBag.subSectors = new MultiSelectList(db.SubSectors, "SubSectorID", "SubSectortype");
ViewBag.QualificationID = new SelectList(db.Qualification, "QualificationID", "Name");
return(View(training));
}