/// <summary>
/// Fill the saved lesson data (If editing a lesson)
/// </summary>
/// <param name="Lesson_ID">ID of the lesson to edit</param>
private void Fill_Saved_Lesson_Data(int Lesson_ID)
{
//Open instance
DBRepository DB = DBRepository.GetInstance();
//Get lesson object by the ID
var Lesson = DB.GetLessonDataByID(Lesson_ID);
LessonToEditID = Lesson_ID;
try
{
//Get data
string subject = Lesson.GetLessonSubject();
string title = Lesson.GetLessonName();
int Teacher_ID = Lesson.GetTeacherID();
string desc = Lesson.GetLessonDesc();
string status = Lesson.LessonStatus;
//Fill the boxes with received DB data
TB_Title.Text = title;
TB_Subject.Text = subject;
TB_Desc.Text = desc;
TB_Made_By.Text = DB.FindTeacherName(Teacher_ID).GetTeacherName();
CB_Lesson_Status.SelectedItem = status;
//Get Group ID
if (DB.FindGroupIDBasedOnLessonID(Lesson_ID).Get_Group_ID() != 0)
{
int groupid = DB.FindGroupIDBasedOnLessonID(Lesson_ID).Get_Group_ID();
string groupname = DB.FindGroupDataBasedOnGroupID(groupid).GetGroupName();
CB_Classes.SelectedItem = groupname;
}
else
{
CB_Classes.SelectedItem = "All";
}
//Get Images in Lesson
var images = DB.ReceiveImagesInLesson(Lesson);
foreach (var image in images)
{
LB_Images.Items.Add(image.ReturnFileName());
}
//Get Art objects in lesson
var Art = DB.ReceiveArtObjInLesson(Lesson);
foreach (var Single_Art in Art)
{
LB_Art_Items.Items.Add(Single_Art.ReturnArtTitle());
}
}
catch (NullReferenceException)
{
//Do nothing
}
}
private void GetArt()
{
//New instance of DB
DBRepository DB = DBRepository.GetInstance();
//Get all the classes from the DB
var Art = DB.FindArtData();
//Foreach class in classes
foreach (var Single_Art in Art)
{
//Add items to class list
CB_Art.Items.Add(Single_Art.ReturnArtTitle());
}
}
