private void dataGridViewStudents_CellClick(object sender, DataGridViewCellEventArgs e) { if (cu.is_out_of_dataGridView_range(e.RowIndex, e.ColumnIndex, cu.get_dgv_last_row(dataGridViewStudents))) { dataGridViewStudents.ClearSelection(); return; } cu.clean_dataGridView(dataGridViewStudents); cu.paint_chosen_row(e.RowIndex, dataGridViewStudents); Lessons ls = new Lessons(); dataGridViewLessonsPast.DataSource = cu.change_keys_to_values(ls.GetLessonsByStudentId(cu.GetID(dataGridViewStudents)), "past"); dataGridViewLessonsFuture.DataSource = cu.change_keys_to_values(ls.GetLessonsByStudentId(cu.GetID(dataGridViewStudents))); dataGridViewLessonsPast.ClearSelection(); dataGridViewLessonsFuture.ClearSelection(); }
private void btnDelete_Click(object sender, EventArgs e) { if (!cu.is_dataGridView_colored(dataGridViewLessons)) { MessageBox.Show("Please choose lesson"); return; } string id = cu.GetID(dataGridViewLessons); Lessons les = new Lessons(); les.Delete(id); cu.charge_data_grid_view(cu.change_keys_to_values(les.GetLessonsByStudentId(cu.GetID(dataGridViewStudents))), dataGridViewLessons); dataGridViewLessons.ClearSelection(); }
public void create_lessons() { kita kit = new kita(); levels level = new levels(); MikP mik = new MikP(); BigForm bf = new BigForm(); Student st = new Student(); PanuiProject pp = new PanuiProject(); Lessons les = new Lessons(); DataTable kitot = kit.GetKita(); DataTable ramot = level.GetLevels(); DataTable mikzoot = mik.GetMikzoot(); Random ran = new Random(); int top_kitot = kitot.Rows.Count; int top_ramot = ramot.Rows.Count; int top_mikzoot = mikzoot.Rows.Count; for (int i = 0; i < 800; i++) { int kitot_row = ran.Next(0, top_kitot); int ramot_row = ran.Next(0, top_ramot); int mikzoot_row = ran.Next(0, top_mikzoot); string code_kita = kitot.Rows[kitot_row]["Code"].ToString(); string code_level = ramot.Rows[ramot_row]["code"].ToString(); string mik_code = mikzoot.Rows[mikzoot_row]["mikCode"].ToString(); DataTable morim = bf.GetMorim(int.Parse(mik_code), int.Parse(code_level), int.Parse(code_kita)); if (morim.Rows.Count == 0) { continue; } int teacher_index = ran.Next(0, morim.Rows.Count); string teacher_id = morim.Rows[teacher_index]["id"].ToString(); DataTable students = st.GetStudents(); int student_index = ran.Next(0, students.Rows.Count); string student_id = students.Rows[student_index]["tz"].ToString(); int mon = ran.Next(4, 8); int day = ran.Next(1, 30); string yom, hod; if (day < 10) { yom = "0" + day.ToString(); } else { yom = day.ToString(); } if (mon < 10) { hod = "0" + mon.ToString(); } else { hod = mon.ToString(); } string due = yom + "/" + hod + "/2016"; int in_week = (int)(DateTime.ParseExact(due, "d/M/yyyy", null).DayOfWeek) + 1; DataTable panui = pp.GetPanuiForDay(in_week, teacher_id); if (panui.Rows.Count == 0) { continue; } int panui_index = ran.Next(0, panui.Rows.Count); int start = int.Parse(panui.Rows[panui_index]["shaa"].ToString()); int end = start; int counter = 0; while (counter < panui.Rows.Count) { if (int.Parse(panui.Rows[counter]["shaa"].ToString()) - 1 == end) { end++; } counter++; } DataTable lessons_for_teacher = bf.GetLessonTimeDetailsForTeacher(teacher_id); DataTable lessons_for_student = les.GetLessonsByStudentId(student_id); bool flag = true; if (lessons_for_teacher.Rows.Count != 0) { foreach (DataRow dr in lessons_for_teacher.Rows) { if (dr["due_date"].ToString().Equals(due) && dr["start_time"].ToString().Equals(start) && dr["end_time"].ToString().Equals(end)) { flag = false; } } } if (lessons_for_student.Rows.Count != 0) { foreach (DataRow dr in lessons_for_student.Rows) { if (dr["due_date"].ToString().Equals(due) && dr["start_time"].ToString().Equals(start) && dr["end_time"].ToString().Equals(end)) { flag = false; } } } if (!flag) { continue; } les.AddLessons(teacher_id, student_id, int.Parse(mik_code), int.Parse(code_kita), int.Parse(code_level), due, start, end, ""); } }