private bool AddMail() { try { Registration_Mail Dialog = new Registration_Mail(); DateTime DateCreate = DateTime.Now; Dialog.DataReg_TB.Text = DateCreate.ToShortDateString(); if (Dialog.ShowDialog() == DialogResult.OK) { Int64 Index = -1; using (var Connect = new NpgsqlConnection(SystemArgs.DataBase.ToString())) { Connect.Open(); using (var Command = new NpgsqlCommand($"SELECT last_value FROM \"AllMail_ID_seq\"", Connect)) { using (var Reader = Command.ExecuteReader()) { while (Reader.Read()) { Index = Reader.GetInt64(0); } } } } Mail Temp = new Mail(Index + 1, Dialog.Name_TB.Text, Dialog.MiddleName_TB.Text, Dialog.Surname_TB.Text, DateCreate, Dialog.AddressMail_TB.Text); if (SystemArgs.Request.AddMail(Temp)) { SystemArgs.Mails.Add(Temp); return(true); } else { return(false); } } else { return(false); } } catch (Exception E) { MessageBox.Show(E.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private bool ChangeMail() { try { if (Mails_DGV.CurrentCell.RowIndex >= 0) { Mail Temp = (Mail)View[Mails_DGV.CurrentCell.RowIndex]; Registration_Mail Dialog = new Registration_Mail(); Dialog.label1.Text = "Изменение адреса электронной почты"; Dialog.DataReg_TB.Text = Temp.DateCreate.ToShortDateString(); Dialog.Name_TB.Text = Temp.Name; Dialog.MiddleName_TB.Text = Temp.MiddleName; Dialog.Surname_TB.Text = Temp.Surname; Dialog.AddressMail_TB.Text = Temp.MailAddress; if (Dialog.ShowDialog() == DialogResult.OK) { Mail NewMail = new Mail(Temp.ID, Dialog.Name_TB.Text, Dialog.MiddleName_TB.Text, Dialog.Surname_TB.Text, Temp.DateCreate, Dialog.AddressMail_TB.Text); if (SystemArgs.Request.ChangeMail(NewMail)) { SystemArgs.Mails.Remove(Temp); SystemArgs.Mails.Add(NewMail); return(true); } else { return(false); } } else { return(false); } } else { throw new Exception("Необходимо выбрать объект"); } } catch (Exception E) { MessageBox.Show(E.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }