private void addRecordButton_Click(object sender, EventArgs e) { try { if (choose == 0) { var editform = new Edit(null, connectionString); editform.FormClosed += Edit_FormClosed; editform.ShowDialog(this); } if (choose == 1) { Author a = null; var form = new Table(a, connectionString); form.FormClosed += Edit_FormClosed; form.ShowDialog(this); choose = 0; } if (choose == 2) { StatusSight a = null; var form = new Table(a, connectionString); form.FormClosed += Edit_FormClosed; form.ShowDialog(this); choose = 0; } if (choose == 3) { TransportStop a = null; var form = new Table(a, connectionString); form.FormClosed += Edit_FormClosed; form.ShowDialog(this); choose = 0; } if (choose == 4) { Category a = null; var form = new Table(a, connectionString); form.FormClosed += Edit_FormClosed; form.ShowDialog(this); choose = 0; } if (choose == 5) { KindOfTransport a = null; var form = new Table(a, connectionString); form.FormClosed += Edit_FormClosed; form.ShowDialog(this); choose = 0; } } catch (DbUpdateException) { MessageBox.Show(text: "У вас нет прав на это действие.", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); } }
public Table(StatusSight ss, string con, bool view = false) { try { if (!view) { if (ss == null) { stsi = new StatusSight(); choose = 2; connectionString = con; InitializeComponent(); this.Text = "Создание"; HeaderLabel.Text = "Статус"; DeleteButton.Visible = false; NoVisible(); } else { stsi = ss; choose = 2; connectionString = con; InitializeComponent(); this.Text = "Изменение"; HeaderLabel.Text = "Статус"; NameTextBox.Text = ss.NameStatus; NoVisible(); } } else { stsi = ss; choose = 2; connectionString = con; InitializeComponent(); this.Text = "Просмотр"; HeaderLabel.Text = "Статус"; NameTextBox.Text = ss.NameStatus; NameTextBox.Enabled = false; DeleteButton.Visible = false; CreateEditButton.Visible = false; NoVisible(); } } catch (DbUpdateException) { MessageBox.Show(text: "У вас нет прав на это действие.", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); } }
private void CreateEditButton_Click(object sender, EventArgs e) { try { using (SightOfOneCityEntities context = new SightOfOneCityEntities(connectionString)) { if (ChekField()) { if (this.Text == "Изменение") { if (choose == 1) { Author a = context.Author.Find(auth.ID); a.FamilyAuthor = FamilyTextBox.Text; a.NameAuthor = NameTextBox.Text; a.PatronymicAuthor = PatronymicTextBox.Text; if (ManCheckBox.Checked) { a.Gender = true; } else { a.Gender = false; } a.DateBirthday = (short)YearNumericUpDown.Value; context.SaveChanges(); this.Close(); } if (choose == 2) { StatusSight ss = context.StatusSight.Find(stsi.ID); ss.NameStatus = NameTextBox.Text; context.SaveChanges(); this.Close(); } if (choose == 3) { TransportStop ts = context.TransportStop.Find(trst.ID); ts.NameStop = NameTextBox.Text; context.SaveChanges(); this.Close(); } if (choose == 4) { Category c = context.Category.Find(cat.ID); c.NameCategory = NameTextBox.Text; context.SaveChanges(); this.Close(); } if (choose == 5) { KindOfTransport kt = context.KindOfTransport.Find(kintr.ID); kt.NameKind = NameTextBox.Text; context.SaveChanges(); this.Close(); } } else { if (choose == 1) { context.Author.Add(new Author(auth.FamilyAuthor, auth.NameAuthor, auth.PatronymicAuthor, auth.Gender, auth.DateBirthday)); context.SaveChanges(); this.Close(); } if (choose == 2) { context.StatusSight.Add(new StatusSight(stsi.NameStatus)); context.SaveChanges(); this.Close(); } if (choose == 3) { context.TransportStop.Add(new TransportStop(trst.NameStop)); context.SaveChanges(); this.Close(); } if (choose == 4) { context.Category.Add(new Category(cat.NameCategory)); context.SaveChanges(); this.Close(); } if (choose == 5) { context.KindOfTransport.Add(new KindOfTransport(kintr.NameKind)); context.SaveChanges(); this.Close(); } } } else { MessageBox.Show("Не все обязательные поля заполнены. Проверьте данные.", "Внимание"); } } } catch (DbUpdateException) { MessageBox.Show(text: "У вас нет прав на это действие.", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); } }