/// <summary>
/// Update the lesson
/// </summary>
private void UpdateLesson()
{
//Make new instance of DB Class
DBRepository DB = DBRepository.GetInstance();
//Make a new lesson object
Lesson L = new Lesson(TB_Title.Text, LessonToEditID, CB_Lesson_Status.SelectedItem.ToString(), TB_Desc.Text, TB_Subject.Text, 0);
//Update the lesson using the object
DB.UpdateLesson(L);
//Get Group Information
var Groups = DB.FindGroupData();
int Group_ID = 0;
//For every group in the list of groups
foreach (var SGroup in Groups)
{
if (SGroup.GetGroupName() == CB_Classes.SelectedItem.ToString())
{
//If groupname equals the selected group (add id)
Group_ID = SGroup.Get_Group_ID();
}
}
//Delete previous groups that had this lesson
DB.DeleteLessonAtGroupsByID(LessonToEditID);
DB.DeleteImageFromLessonByID(LessonToEditID);
DB.DeleteArtObjFromLessonByID(LessonToEditID);
//Add this lesson to the groups that currently have this lesson
if (CB_Classes.SelectedItem.ToString() == "All")
{
DB.InsertLessonForGroups(LessonToEditID, 0);
//Inserting Images into Lesson
Saving_Images_To_Lesson(LessonToEditID);
//Inserting Art into Lesson
Saving_Artobjects_To_Lesson(LessonToEditID);
}
else
{
DB.InsertLessonForGroups(LessonToEditID, Group_ID);
//Inserting Images into Lesson
Saving_Images_To_Lesson(LessonToEditID);
//Inserting Art into Lesson
Saving_Artobjects_To_Lesson(LessonToEditID);
}
MessageBox.Show("Lesson Updated");
}
