public AddOrEditLessonForm(DBManager aDBManager, int aID)
{
InitializeComponent();
mFormState = FormState.Editing;
mDBManager = aDBManager;
mID = aID;
this.Text = FormTitles.LessonForm.Edit;
foreach (var l in mDBManager.Lessons)
{
if (l.ID == aID)
{
mLesson = l;
break;
}
}
addDefaultControlsInformationWhenEditing();
}
private void ImportCurriculum(ref OleDbConnection connection)
{
string CurriculumSelect = @"SELECT cl.[Hours weekly1] AS HoursPerWeek, cl.CurricID AS [CurricID], cl.[Class] AS [Class], cl.Subject AS Subject, cl.[Group] AS [Group], p.[ID number] AS [TeacherID] FROM [CurriculumL] AS [cl] INNER JOIN [CurriculumTeachers] AS [p] ON [cl].[CurricID] = [p].[CurricID] WHERE cl.[Class] IS NOT NULL";
//string CurriculumSelect = "SELECT * FROM CurriculumL "; //+
//"JOIN CurriculumTeachers ct ON ct.CurricID = CurriculumL.CurricID ORDER BY CurricID";
OleDbCommand command = new OleDbCommand(CurriculumSelect, connection);
using (OleDbDataReader CurriculumReader = command.ExecuteReader())
{
while (CurriculumReader.Read())
{
int id = int.Parse(CurriculumReader["CurricID"].ToString());
int classid = int.Parse(CurriculumReader["Class"].ToString());
int groupid = int.Parse(CurriculumReader["Group"].ToString());
int subjectid = int.Parse(CurriculumReader["Subject"].ToString());
int hoursPerWeek = (int)double.Parse(CurriculumReader["HoursPerWeek"].ToString());
long teacherid = long.Parse(CurriculumReader["TeacherID"].ToString());
Class c = this.mClasses.SingleOrDefault(x => x.ID == classid);
ClassDetails group = c.Details.SingleOrDefault(x => x.Group == groupid);
Subject subject = this.mSubjects.SingleOrDefault(x => x.ID == subjectid);
Teacher teacher = this.mTeachers.SingleOrDefault(x => x.ID == teacherid);
Curriculum curric = new Curriculum(id, subject, c, group, teacher, hoursPerWeek);
this.mCurriculums.Add(curric);
}
}
}