public void RefLessons()
{
Main.Lessons.Clear();
lbLessons.Items.Clear();
bg.Open();
OleDbCommand cmd = new OleDbCommand("Select *from Lessons", bg);
OleDbDataReader read = cmd.ExecuteReader();
while (read.Read())
{
int id = Convert.ToInt32(read["ID"]);
string name = read["Lesson_Name"].ToString();
string zoomid = read["Lesson_Zoom_ID"].ToString();
string zoompass = read["Lesson_Zoom_Pass"].ToString();
string teacher = read["Lesson_Teacher"].ToString();
Lssn lesson = new Lssn()
{
ID = id,
Name = name,
ZoomID = zoomid,
ZoomPassword = zoompass,
Teacher = teacher
};
Main.Lessons.Add(lesson);
lbLessons.Items.Add(name);
}
bg.Close();
}
public void AddLessonToProgram(Lssn lesson, int index, int day)
{
bg.Open();
OleDbCommand ole = new OleDbCommand($"Select [ID] From LessonProgram where [Day]={day} AND [Order]={index}", bg);
OleDbDataReader reader = ole.ExecuteReader();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = reader.Read()
? $"UPDATE LessonProgram set Lesson_ID=? where [ID]={reader["ID"]}"
: "INSERT INTO LessonProgram (Lesson_ID,[Day],[Order]) values (?,?,?)";
cmd.Connection = bg;
cmd.Parameters.AddWithValue("?", lesson.ID);
cmd.Parameters.AddWithValue("?", day);
cmd.Parameters.AddWithValue("?", index);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
Main.ShowError(ACCESS_ERROR);
}
bg.Close();
}
