// добавление
private void button2_Click(object sender, EventArgs e)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
SozyvForm addForm = new SozyvForm();
List <Deputaty> deps = db.Deputaties.ToList();
addForm.listBox1.DataSource = deps;
addForm.listBox1.ValueMember = "Partiyniy_bilet";
addForm.listBox1.DisplayMember = "Familiya";
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
Sozyvy sozyv = new Sozyvy();
sozyv.Nomer = 0;
sozyv.Data_nachala = DateTime.Parse(addForm.maskedTextBox1.Text);
sozyv.Data_konca = DateTime.Parse(addForm.maskedTextBox2.Text);
deps.Clear(); // очищаем список и заново заполняем его выделенными элементами
foreach (var dep in addForm.listBox1.SelectedItems)
{
deps.Add((Deputaty)dep);
}
sozyv.Deputaties = deps;
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Sozyvies.Add(sozyv);
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();
}
}
public ProcedureForm3()
{
InitializeComponent();
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
try
{
var proc = db.GetSozyvyStatus();
dataGridView1.DataSource = proc;
int best_soz = -1;
decimal best_results = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if ((decimal)dataGridView1[4, i].Value > best_results)
{
best_results = (decimal)dataGridView1[4, i].Value;
best_soz = (int)dataGridView1[0, i].Value;
}
}
label1.Text = "Самый результативный созыв : " + best_soz;
}
catch
{
MessageBox.Show("У вас нет прав для использования процедуры");
}
}
}
private void button2_Click(object sender, EventArgs e)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
FrakciyaForm addForm = new FrakciyaForm();
List <Deputaty> deps = db.Deputaties.ToList();
for (int i = deps.Count - 1; i >= 0; i--)
{
var dep = deps[i];
if (dep.Frakciya != null)
{
deps.RemoveAt(i);
}
}
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
Frakciya frak = new Frakciya();
frak.Naimenovanie = addForm.textBox1.Text;
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Frakciyas.Add(frak);
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 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();
}
}
public ProcedureForm2()
{
InitializeComponent();
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
List <Sozyvy> sozes = db.Sozyvies.ToList();
comboBox1.DataSource = sozes;
comboBox1.ValueMember = "Nomer";
comboBox1.DisplayMember = "Nomer";
}
}
private void button4_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
var confirmResult = MessageBox.Show("Вы уверены, что хотите удалить запись?",
"Подтвердить удаление",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
if (converted == false)
{
return;
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
var frak = db.Frakciyas
.FirstOrDefault(b => b.ID == id);
db.Frakciyas.Remove(frak);
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();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
try
{
dataGridView1.DataSource = db.FactionsPercentage((int)comboBox1.SelectedValue);
}
catch
{
MessageBox.Show("У вас нет прав для использования процедуры");
}
}
}
public void RefreshData()
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
try
{
menu.frakciyaData = db.Frakciyas.Select(p => new { p.ID, p.Naimenovanie, p.Kolichestvo_deputatov, p.Deputaty }).ToList();
}
catch
{
MessageBox.Show("У вас нет прав для просмотра таблицы");
}
}
dataGridView1.DataSource = menu.frakciyaData;
}
public void RefreshData()
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
try
{
menu.deputatyData = db.Deputaties.Select(p => new { p.Partiyniy_bilet, p.Familiya, p.Imya, p.Otchestovo, p.Region_vyborov, p.Data_rozhdeniya, p.Frakciya, p.Komitet }).ToList();
}
catch
{
MessageBox.Show("У вас нет прав для просмотра таблицы");
}
}
dataGridView1.DataSource = menu.deputatyData;
}
public void RefreshData()
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
try
{
menu.sozyvData = db.Sozyvies.Select(p => new { p.Nomer, p.Frakciya, p.Data_nachala, p.Data_konca }).ToList();
}
catch
{
MessageBox.Show("У вас нет прав для просмотра таблицы");
}
}
dataGridView1.DataSource = menu.sozyvData;
}
private void button1_Click(object sender, EventArgs e)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
if (dataGridView1.SelectedRows.Count > 0)
{
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
if (converted == false)
{
return;
}
Frakciya frak = db.Frakciyas.Find(id);
listBox1.DataSource = frak.Deputaties.ToList();
listBox1.DisplayMember = "Familiya";
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DBUtils.setLoginPassword(textBox1.Text, textBox2.Text); //
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
DbConnection conn = db.Database.Connection;
try
{
conn.Open(); // проверка соединения
Console.WriteLine("Connection success");
this.Hide();
var form1 = new MenuForm();
form1.Closed += (s, args) => this.Close();
form1.Show();
}
catch // ошибка соединения
{
Console.WriteLine("Сonnection failed");
MessageBox.Show("Неправильная пара логин-пароль");
textBox2.Text = "";
}
}
}
public void RefreshData()
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
try
{
db.UpdateSessionStatus();
}
catch
{
MessageBox.Show("У вас нет прав для обновления статуса заседаний");
}
try
{
menu.zasedaniyaData = db.Zasedanies.Select(p => new { p.Nomer, p.Naimenovanie, p.Tip, p.Nomer_sozyva, p.Data_provedeniya, p.Vremya_nachala, p.Vremya_konca, p.Status_zasedaniya, p.Mesto_provedeniya1 }).ToList();
}
catch
{
MessageBox.Show("У вас нет прав для просмотра таблицы");
}
}
dataGridView1.DataSource = menu.zasedaniyaData;
}
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;
}
Deputaty dep = db.Deputaties.Find(id);
DeputatyForm addForm = new DeputatyForm();
addForm.numericUpDown1.Value = dep.Partiyniy_bilet;
addForm.textBox2.Text = dep.Familiya;
addForm.textBox1.Text = dep.Imya;
addForm.textBox3.Text = dep.Otchestovo;
addForm.textBox4.Text = dep.Region_vyborov;
addForm.maskedTextBox1.Text = dep.Data_rozhdeniya.ToString();
// получаем список команд
List <Sozyvy> sozes = db.Sozyvies.ToList();
addForm.listBox1.DataSource = sozes;
addForm.listBox1.ValueMember = "Nomer";
addForm.listBox1.DisplayMember = "Nomer";
List <Frakciya> frakces = db.Frakciyas.ToList();
addForm.comboBox1.DataSource = frakces;
addForm.comboBox1.ValueMember = "ID";
addForm.comboBox1.DisplayMember = "Naimenovanie";
List <Komitet> kometes = db.Komitets.ToList();
addForm.comboBox2.DataSource = kometes;
addForm.comboBox2.ValueMember = "ID";
addForm.comboBox2.DisplayMember = "Naimenovanie";
foreach (Sozyvy s in dep.Sozyvies)
{
addForm.listBox1.SelectedItem = s;
}
addForm.comboBox1.SelectedItem = dep.Frakciya;
addForm.comboBox2.SelectedItem = dep.Komitet;
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
dep.Partiyniy_bilet = (int)addForm.numericUpDown1.Value;
dep.Familiya = addForm.textBox2.Text;
dep.Imya = addForm.textBox1.Text;
dep.Otchestovo = addForm.textBox3.Text;
dep.Region_vyborov = addForm.textBox4.Text;
dep.Data_rozhdeniya = DateTime.Parse(addForm.maskedTextBox1.Text);
sozes.Clear(); // очищаем список и заново заполняем его выделенными элементами
foreach (var soz in addForm.listBox1.SelectedItems)
{
sozes.Add((Sozyvy)soz);
}
dep.Sozyvies = sozes;
foreach (var s in sozes)
{
if (addForm.listBox1.SelectedItems.Contains(s))
{
if (!dep.Sozyvies.Contains(s))
{
dep.Sozyvies.Add(s);
}
}
else
{
if (dep.Sozyvies.Contains(s))
{
dep.Sozyvies.Remove(s);
}
}
}
dep.Frakciya = (Frakciya)addForm.comboBox1.SelectedItem;
dep.ID_frakcii = (int)addForm.comboBox1.SelectedValue;
dep.Komitet = (Komitet)addForm.comboBox2.SelectedItem;
dep.ID_komiteta = (int)addForm.comboBox2.SelectedValue;
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Entry(dep).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();
}
}
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;
}
Frakciya frak = db.Frakciyas.Find(id);
FrakciyaForm addForm = new FrakciyaForm();
addForm.textBox1.Text = frak.Naimenovanie;
List <Deputaty> deps = db.Deputaties.ToList();
for (int i = deps.Count - 1; i >= 0; i--)
{
if (deps[i].ID_frakcii != id)
{
deps.RemoveAt(i);
}
}
addForm.comboBox1.DataSource = deps;
addForm.comboBox1.ValueMember = "Partiyniy_bilet";
addForm.comboBox1.DisplayMember = "Familiya";
addForm.comboBox1.SelectedItem = frak.Lider_frakcii;
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
frak.Naimenovanie = addForm.textBox1.Text;
if (addForm.comboBox1.SelectedItem != null)
{
frak.Deputaty = (Deputaty)addForm.comboBox1.SelectedItem;
}
else
{
frak.Deputaty = null;
}
if (addForm.comboBox1.SelectedValue != null)
{
frak.Lider_frakcii = (int)addForm.comboBox1.SelectedValue;
}
else
{
frak.Lider_frakcii = null;
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Entry(frak).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();
}
}
private void button2_Click(object sender, EventArgs e)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
DeputatyForm addForm = new DeputatyForm();
List <Sozyvy> sozes = db.Sozyvies.ToList();
addForm.listBox1.DataSource = sozes;
addForm.listBox1.ValueMember = "Nomer";
addForm.listBox1.DisplayMember = "Nomer";
List <Frakciya> frakces = db.Frakciyas.ToList();
addForm.comboBox1.DataSource = frakces;
addForm.comboBox1.ValueMember = "ID";
addForm.comboBox1.DisplayMember = "Naimenovanie";
List <Komitet> kometes = db.Komitets.ToList();
addForm.comboBox2.DataSource = kometes;
addForm.comboBox2.ValueMember = "ID";
addForm.comboBox2.DisplayMember = "Naimenovanie";
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
Deputaty dep = new Deputaty();
dep.Partiyniy_bilet = (int)addForm.numericUpDown1.Value;
dep.Familiya = addForm.textBox2.Text;
dep.Imya = addForm.textBox1.Text;
dep.Otchestovo = addForm.textBox3.Text;
dep.Region_vyborov = addForm.textBox4.Text;
dep.Data_rozhdeniya = DateTime.Parse(addForm.maskedTextBox1.Text);
sozes.Clear(); // очищаем список и заново заполняем его выделенными элементами
foreach (var soz in addForm.listBox1.SelectedItems)
{
sozes.Add((Sozyvy)soz);
}
dep.Sozyvies = sozes;
dep.Frakciya = (Frakciya)addForm.comboBox1.SelectedItem;
dep.ID_frakcii = (int)addForm.comboBox1.SelectedValue;
dep.Komitet = (Komitet)addForm.comboBox2.SelectedItem;
dep.ID_komiteta = (int)addForm.comboBox2.SelectedValue;
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Deputaties.Add(dep);
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();
}
}
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;
}
Sozyvy sozyv = db.Sozyvies.Find(id);
SozyvForm addForm = new SozyvForm();
addForm.maskedTextBox1.Text = sozyv.Data_nachala.ToString();
addForm.maskedTextBox2.Text = sozyv.Data_konca.ToString();
// получаем список команд
List <Deputaty> deps = db.Deputaties.ToList();
addForm.listBox1.DataSource = deps;
addForm.listBox1.ValueMember = "Partiyniy_bilet";
addForm.listBox1.DisplayMember = "Familiya";
foreach (Deputaty d in sozyv.Deputaties)
{
addForm.listBox1.SelectedItem = d;
}
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
sozyv.Data_nachala = DateTime.Parse(addForm.maskedTextBox1.Text);
sozyv.Data_konca = DateTime.Parse(addForm.maskedTextBox2.Text);
deps.Clear(); // очищаем список и заново заполняем его выделенными элементами
foreach (var dep in addForm.listBox1.SelectedItems)
{
deps.Add((Deputaty)dep);
}
sozyv.Deputaties = deps;
foreach (var d in deps)
{
if (addForm.listBox1.SelectedItems.Contains(d))
{
if (!sozyv.Deputaties.Contains(d))
{
sozyv.Deputaties.Add(d);
}
}
else
{
if (sozyv.Deputaties.Contains(d))
{
sozyv.Deputaties.Remove(d);
}
}
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Entry(sozyv).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();
}
}
private void button2_Click(object sender, EventArgs e)
{
using (The_State_Duma_Entities db = new The_State_Duma_Entities(DBUtils.getConnString()))
{
ZasedaniyaForm addForm = new ZasedaniyaForm();
List <Sozyvy> sozes = db.Sozyvies.ToList();
addForm.comboBox1.DataSource = sozes;
addForm.comboBox1.ValueMember = "Nomer";
addForm.comboBox1.DisplayMember = "Nomer";
List <Mesto_provedeniya> mesta = db.Mesto_provedeniya.ToList();
addForm.comboBox2.DataSource = mesta;
addForm.comboBox2.ValueMember = "ID";
addForm.comboBox2.DisplayMember = "Ulica";
addForm.radioButton1.Checked = true;
addForm.radioButton2.Checked = false;
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
Zasedanie zased = new Zasedanie();
zased.Nomer = 0;
zased.Naimenovanie = addForm.textBox1.Text;
zased.Data_provedeniya = DateTime.Parse(addForm.maskedTextBox1.Text);
zased.Vremya_nachala = TimeSpan.Parse(addForm.maskedTextBox2.Text);
zased.Vremya_konca = TimeSpan.Parse(addForm.maskedTextBox3.Text);
if (addForm.radioButton1.Checked)
{
zased.Tip = addForm.radioButton1.Text;
}
else
{
zased.Tip = addForm.radioButton2.Text;
}
zased.Nomer_sozyva = (int)addForm.comboBox1.SelectedValue;
zased.Sozyvy = (Sozyvy)addForm.comboBox1.SelectedItem;
zased.Mesto_provedeniya = (int)addForm.comboBox2.SelectedValue;
zased.Mesto_provedeniya1 = (Mesto_provedeniya)addForm.comboBox2.SelectedItem;
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Zasedanies.Add(zased);
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;
}
Zasedanie zased = db.Zasedanies.Find(id);
ZasedaniyaForm addForm = new ZasedaniyaForm();
addForm.textBox1.Text = zased.Naimenovanie;
addForm.maskedTextBox1.Text = zased.Data_provedeniya.ToString();
addForm.maskedTextBox2.Text = zased.Vremya_nachala.ToString();
addForm.maskedTextBox3.Text = zased.Vremya_konca.ToString();
List <Sozyvy> sozes = db.Sozyvies.ToList();
addForm.comboBox1.DataSource = sozes;
addForm.comboBox1.ValueMember = "Nomer";
addForm.comboBox1.DisplayMember = "Nomer";
List <Mesto_provedeniya> mesta = db.Mesto_provedeniya.ToList();
addForm.comboBox2.DataSource = mesta;
addForm.comboBox2.ValueMember = "ID";
addForm.comboBox2.DisplayMember = "Ulica";
addForm.comboBox1.SelectedItem = zased.Sozyvy;
addForm.comboBox2.SelectedItem = zased.Mesto_provedeniya1;
if (zased.Tip == "Plenarnoe Zasedanie" || zased.Tip == "Пленарное заседание")
{
addForm.radioButton1.Checked = true;
}
else if (zased.Tip == "Заседание совета ГД")
{
addForm.radioButton2.Checked = true;
}
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
zased.Naimenovanie = addForm.textBox1.Text;
zased.Data_provedeniya = DateTime.Parse(addForm.maskedTextBox1.Text);
zased.Vremya_nachala = TimeSpan.Parse(addForm.maskedTextBox2.Text);
zased.Vremya_konca = TimeSpan.Parse(addForm.maskedTextBox3.Text);
if (addForm.radioButton1.Checked)
{
zased.Tip = addForm.radioButton1.Text;
}
else
{
zased.Tip = addForm.radioButton2.Text;
}
zased.Nomer_sozyva = (int)addForm.comboBox1.SelectedValue;
zased.Sozyvy = (Sozyvy)addForm.comboBox1.SelectedItem;
zased.Mesto_provedeniya = (int)addForm.comboBox2.SelectedValue;
zased.Mesto_provedeniya1 = (Mesto_provedeniya)addForm.comboBox2.SelectedItem;
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Entry(zased).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();
}
}