private void button2_Click(object sender, EventArgs e) { using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString())) { ZakonoproektForm addForm = new ZakonoproektForm(); List <Deputaty> deps = db.Deputaties.ToList(); addForm.comboBox1.DataSource = deps; addForm.comboBox1.ValueMember = "Partiyniy_bilet"; addForm.comboBox1.DisplayMember = "Familiya"; DialogResult result = addForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Zakonoproekt zak = new Zakonoproekt(); zak.Naimenovanie = addForm.textBox1.Text; zak.Opisanie = addForm.richTextBox1.Text; zak.Deputaty = (Deputaty)addForm.comboBox1.SelectedItem; zak.Vnesen = (int)addForm.comboBox1.SelectedValue; using (var transaction = db.Database.BeginTransaction()) { try { db.Zakonoproekts.Add(zak); try { db.SaveChanges(); } catch (DbUpdateException ex) { MessageBox.Show("Ошибка добавления : " + ex.ToString()); } transaction.Commit(); } catch (Exception ex) { MessageBox.Show("Ошибка добавления : " + ex.ToString()); try { transaction.Rollback(); } catch (Exception ex2) { MessageBox.Show("Ошибка отката : " + ex2.ToString()); } } } RefreshData(); } }
private void button3_Click(object sender, EventArgs e) { using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString())) { if (dataGridView1.SelectedRows.Count < 1) { return; } int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } Zakonoproekt zak = db.Zakonoproekts.Find(id); ZakonoproektForm addForm = new ZakonoproektForm(); addForm.textBox1.Text = zak.Naimenovanie; addForm.richTextBox1.Text = zak.Opisanie; List <Deputaty> deps = db.Deputaties.ToList(); addForm.comboBox1.DataSource = deps; addForm.comboBox1.ValueMember = "Partiyniy_bilet"; addForm.comboBox1.DisplayMember = "Familiya"; addForm.comboBox1.SelectedItem = zak.Deputaty; DialogResult result = addForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } zak.Naimenovanie = addForm.textBox1.Text; zak.Opisanie = addForm.richTextBox1.Text; zak.Deputaty = (Deputaty)addForm.comboBox1.SelectedItem; zak.Vnesen = (int)addForm.comboBox1.SelectedValue; using (var transaction = db.Database.BeginTransaction()) { try { db.Entry(zak).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { MessageBox.Show("Ошибка обновления : " + ex.ToString()); } transaction.Commit(); } catch (Exception ex) { MessageBox.Show("Ошибка обновления : " + ex.ToString()); try { transaction.Rollback(); } catch (Exception ex2) { MessageBox.Show("Ошибка отката : " + ex2.ToString()); } } } RefreshData(); } }