//bool Authorization = false; private void button5_Click(object sender, EventArgs e) { DBGeneral dbG = new DBGeneral(); if (dbG.Login(textBox2.Text, textBox3.Text)) { MessageBox.Show("Авторизация прошла успешно!", "Добро пожаловать", MessageBoxButtons.OK, MessageBoxIcon.Information); F1.EmpID = dbG.EmpID; F1.textBox1.Text = dbG.UserName; this.Close(); } else { MessageBox.Show("Пользователя с таким именем или паролем не существует!", "Неверное имя или пароль!", MessageBoxButtons.OK, MessageBoxIcon.Error); textBox3.Text = ""; } }
private void Log() { DBGeneral dbg = new DBGeneral(); dgvLOG.Columns.Clear(); dgvLOG.AutoGenerateColumns = true; dgvLOG.DataSource = dbg.GetLog(); dgvLOG.Columns["time"].HeaderText = "�����"; dgvLOG.Columns["time"].Width = 80; dgvLOG.Columns["bar"].HeaderText = "��������"; dgvLOG.Columns["bar"].Width = 80; dgvLOG.Columns["tit"].HeaderText = "�������"; dgvLOG.Columns["tit"].Width = 600; dgvLOG.Columns["idr"].HeaderText = "��������"; dgvLOG.Columns["idr"].Width = 80; dgvLOG.Columns["st"].HeaderText = "��������"; dgvLOG.Columns["st"].Width = 100; foreach (DataGridViewColumn c in dgvLOG.Columns) { c.SortMode = DataGridViewColumnSortMode.NotSortable; } }
private void �������������������������������ToolStripMenuItem_Click(object sender, EventArgs e) { if (Statistics.Columns != null) Statistics.Columns.Clear(); DatePeriod f3 = new DatePeriod(); f3.ShowDialog(); label18.Text = ""; label19.Text = ""; label19.Text = "������ �������� ��������� �� ������ � " + f3.StartDate.ToString("dd.MM.yyyy") + " �� " + f3.EndDate.ToString("dd.MM.yyyy") + ": "; DBGeneral dbg = new DBGeneral(); try { Statistics.DataSource = dbg.GetOperatorActions(f3.StartDate, f3.EndDate, EmpID); } catch (Exception ex) { MessageBox.Show(ex.Message); Statistics.Columns.Clear(); return; } autoinc(Statistics); Statistics.Columns[0].HeaderText = "��"; Statistics.Columns[1].Width = 250; Statistics.Columns[1].HeaderText = "��������"; Statistics.Columns[2].HeaderText = "����"; Statistics.Columns[2].Width = 200; autoinc(Statistics); }
public int GetAttendance() { DBGeneral dbg = new DBGeneral(); return(dbg.GetAttendance()); }
public void AddAttendance(ReaderVO reader) { DBGeneral dbg = new DBGeneral(); dbg.AddAttendance(reader); }
public void RecieveBook(int IDEMP) { DBGeneral dbg = new DBGeneral(); dbg.Recieve(ScannedBook, ScannedReader, IDEMP); }
internal int ISSUE(int IDEMP) { DBGeneral dbg = new DBGeneral(); return dbg.ISSUE(ScannedBook, ScannedReader, IDEMP); }
//false - книга, true - читатель private BARTYPE BookOrReader(string data) { var dbg = new DBGeneral(); return dbg.BookOrReader(data); }
internal void RemoveResponsibility(int idiss, int EmpID) { DBGeneral dbg = new DBGeneral(); dbg.RemoveResposibility(idiss, EmpID); return; }
private void button1_Click(object sender, EventArgs e) { button1.Enabled = false; SmtpClient client = new SmtpClient("neos.libfl.ru"); //client.EnableSsl = true; client.Credentials = new NetworkCredential("*****@*****.**", "abonement123"); MailAddress from = new MailAddress("*****@*****.**", "ВГБИЛ", Encoding.UTF8); MailAddress to; MailMessage message = new MailMessage(); message.From = from; message.IsBodyHtml = true; //LiveEmail = "*****@*****.**"; //WorkEmail = "*****@*****.**"; if (Email != "") { to = new MailAddress(Email); message.To.Add(to); } message.Body = htmltext; message.BodyEncoding = Encoding.UTF8; message.Subject = "ВГБИЛ - Абонемент"; message.SubjectEncoding = Encoding.UTF8; try { client.Send(message); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } message.Dispose(); MessageBox.Show("Отправлено успешно!"); DBGeneral dbg = new DBGeneral(); dbg.InsertSendEmailAction(f1.EmpID,reader.ID); Close(); }
private BARTYPE BookOrReader(string data) { var dbg = new DBGeneral(); return(dbg.BookOrReader(data)); }