Exemple #1
0
        private void CommissionAddToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            var form = new CommissionForm();

            if (form.ShowDialog() == DialogResult.OK)
            {
                db.Commissions.Add(form.Commission);
                db.SaveChanges();
            }
        }
Exemple #2
0
        private void Change_Click(object sender, EventArgs e)
        {
            if (dataGridView.SelectedCells.Count == 0)
            {
                MessageBox.Show("Виберіть хочаб одну строку в таблиці", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            // идентификатор записи
            // вызываем форму таблиц и редактируем выделенную строку
            var id = dataGridView.SelectedRows[0].Cells[0].Value;
            List <Commission> commissions = db.Commissions.ToList(); //принимаем данные с таблицы комиссии
            List <Subjects>   subjects    = db.Subjects.ToList();    //принимаем данные с таблицы предметов


            if (typeof(T) == typeof(Subjects))
            {
                var subject = set.Find(id) as Subjects;
                if (subject != null)
                {
                    var form = new SubjectForm(subject);

                    if (form.ShowDialog() == DialogResult.OK)
                    {
                        subject = form.Subject;
                        db.SaveChanges();
                        dataGridView.Refresh();
                    }
                }
            }
            else if (typeof(T) == typeof(Teacher))
            {
                var teacher = set.Find(id) as Teacher;
                if (teacher != null)
                {
                    TeacherForm teacherForm = new TeacherForm(teacher);
                    //подключаем данные и выводим список комиссий в comboBox1
                    teacherForm.comboBox1.DataSource    = commissions;
                    teacherForm.comboBox1.ValueMember   = "ComId";
                    teacherForm.comboBox1.DisplayMember = "ComName";

                    //подключаем данные и выводим список предметов в comboBox2
                    teacherForm.comboBox2.DataSource    = subjects;
                    teacherForm.comboBox2.ValueMember   = "SubjId";
                    teacherForm.comboBox2.DisplayMember = "ShortName";
                    if (teacherForm.ShowDialog() == DialogResult.OK)
                    {
                        teacher = teacherForm.Teacher;
                        db.SaveChanges();
                        dataGridView.Refresh();
                    }
                }
            }
            else if (typeof(T) == typeof(Groups))
            {
                var groups = set.Find(id) as Groups;
                if (groups != null)
                {
                    GroupForm groupForm = new GroupForm();

                    groupForm.comboBox1.DataSource    = commissions;
                    groupForm.comboBox1.ValueMember   = "ComId";
                    groupForm.comboBox1.DisplayMember = "ComName";

                    if (groupForm.ShowDialog() == DialogResult.OK)
                    {
                        groups = groupForm.Groups;
                        db.SaveChanges();
                        dataGridView.Refresh();
                    }
                }
            }
            else if (typeof(T) == typeof(Commission))
            {
                var commission = set.Find(id) as Commission;
                if (commission != null)
                {
                    var form = new CommissionForm(commission);

                    if (form.ShowDialog() == DialogResult.OK)
                    {
                        commission = form.Commission;
                        db.SaveChanges();
                        dataGridView.Refresh();
                    }
                }
            }
        }