private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { learning_program program = new learning_program { name = textbox_lesson_name.Text, year_of_creation = int.Parse(textbox_year_of_creation.Text) }; using (schoolEntities db = new schoolEntities()) { db.learning_program.Add(program); int[] keys = checkedlistbox_subjects.CheckedItems.Cast <subject>().Select(s => s.id).ToArray(); foreach (var key in keys) { subject s = db.subjects.Find(key); if (s != null) { s.learning_program1.Add(program); program.subjects1.Add(s); } } db.SaveChanges(); MessageBox.Show(string.Format("Learning program is added!"), "Success!"); textbox_lesson_name.Clear(); textbox_year_of_creation.Clear(); checkedlistbox_subjects.ClearSelected(); } } }
private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { student_group t = new student_group { name = textbox_group_name.Text, entry_year = int.Parse(textbox_year_of_creation.Text), }; int keyClassroom = ((classroom)listbox_classroom.SelectedItem).id; int keyTeacher = ((teacher)listbox_classroom_teacher.SelectedItem).id; int keyLearning = ((learning_program)listbox_learning_program.SelectedItem).id; int[] keys = checkedLilistbox_students.CheckedItems.Cast <student>().Select(s => s.id).ToArray(); using (schoolEntities db = new schoolEntities()) { t.classroom = db.classrooms.Find(keyClassroom); t.teacher = db.teachers.Find(keyTeacher); t.learning_program = db.learning_program.Find(keyLearning); db.student_group.Add(t); foreach (var key in keys) { student s = db.students.Find(key); if (s != null) { s.student_group = t; } } db.SaveChanges(); MessageBox.Show(string.Format("Student group {0} (Year: {1}) is added!", t.name, t.entry_year), "Success!"); this.textbox_group_name.Clear(); this.textbox_year_of_creation.Clear(); this.listbox_classroom.ClearSelected(); this.listbox_classroom_teacher.ClearSelected(); this.listbox_learning_program.ClearSelected(); this.checkedLilistbox_students.ClearSelected(); } } }
private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { subject c = new subject { name = textbox_lesson_name.Text, quantity = int.Parse(textbox_lesson_quantity.Text), year_of_creation = int.Parse(textbox_year_of_creation.Text) }; using (schoolEntities db = new schoolEntities()) { db.subjects.Add(c); db.SaveChanges(); MessageBox.Show(string.Format("Subject {0} (Y:{2}, Q:{1}) is added!", c.name, c.quantity, c.year_of_creation), "Success!"); } this.textbox_lesson_name.Clear(); this.textbox_year_of_creation.Clear(); this.textbox_lesson_quantity.Clear(); } }
private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { object[] keys = new object[4]; keys[0] = ((object)((lesson_mark)listbox_student.SelectedItem).lesson_timestamp); keys[1] = ((object)((lesson_mark)listbox_student.SelectedItem).student_id); keys[2] = ((object)((lesson_mark)listbox_student.SelectedItem).subject_id); keys[3] = ((object)((lesson_mark)listbox_student.SelectedItem).lesson_number); using (schoolEntities db = new schoolEntities()) { db.lesson_mark.Remove(db.lesson_mark.Find(keys)); db.SaveChanges(); listbox_student.Items.Clear(); listbox_student.Items.AddRange(db.lesson_mark.ToArray()); MessageBox.Show(string.Format("Mark is deleted!"), "Success!"); } } }
private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { classroom c = new classroom { primary_num = int.Parse(textBox1.Text), secondary_num = textBox2.Text, floor = int.Parse(textBox3.Text) }; using (schoolEntities db = new schoolEntities()) { db.classrooms.Add(c); db.SaveChanges(); MessageBox.Show(string.Format("Classroom {0}-{1} on {2} floor is added!", c.primary_num, c.secondary_num, c.floor), "Success!"); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); } } }
private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { student t = new student { first_name = text_box_student_first_name.Text, last_name = text_box_student_last_name.Text, third_name = text_box_student_third_name.Text, student_group_id = -1 }; using (schoolEntities db = new schoolEntities()) { db.students.Add(t); db.SaveChanges(); MessageBox.Show(string.Format("Student {0} {1} {2} is added!", t.first_name, t.last_name, t.third_name), "Success!"); text_box_student_first_name.Clear(); text_box_student_last_name.Clear(); text_box_student_third_name.Clear(); } } }
private void button_confirm_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { teacher t = new teacher { first_name = text_box_teacher_first_name.Text, last_name = text_box_teacher_last_name.Text, third_name = text_box_teacher_third_name.Text, }; using (schoolEntities db = new schoolEntities()) { int[] keys = checkedlistbox_subjects.CheckedItems.Cast <subject>().Select(s => s.id).ToArray(); foreach (var key in keys) { subject s = db.subjects.Find(key); if (s != null) { s.teachers.Add(t); t.subjects.Add(s); } } db.teachers.Add(t); db.SaveChanges(); MessageBox.Show(string.Format("Teacher {0} {1} {2} is added!", t.first_name, t.last_name, t.third_name), "Success!"); } text_box_teacher_first_name.Clear(); text_box_teacher_last_name.Clear(); text_box_teacher_third_name.Clear(); checkedlistbox_subjects.ClearSelected(); } }