Пример #1
0
        private void ButtonExit_Click(object sender, EventArgs e)
        {
            using (var context = new VisitorContext())
            {
                var visitor = context.Visitors.ToList()
                              .Where(v => v.PassportNumber == DataGridViewVisitors.SelectedRows[0].Cells["PassportNumber"].Value.ToString())
                              .FirstOrDefault();

                if (DataGridViewVisitors.SelectedRows.Count > 0 && visitor.DateTimeOut == null)
                {
                    visitor.DateTimeOut = DateTime.Now;
                    context.SaveChanges();

                    LoadDataGridViewVisitors();
                }
            }
        }
Пример #2
0
        private void DataGridViewVisitorsSelectionChanged(object sender, EventArgs e)
        {
            richTextBox1.Clear();

            if (DataGridViewVisitors.SelectedRows.Count > 0)
            {
                using (var context = new VisitorContext())
                {
                    var visitors = context.Visitors.ToList().Where(v => v.PassportNumber == DataGridViewVisitors.SelectedRows[0].Cells["PassportNumber"].Value.ToString()).FirstOrDefault();

                    if (visitors != null)
                    {
                        richTextBox1.Text = visitors.PurposeOfVisit;
                    }
                }
            }
        }
Пример #3
0
        private void ButtonAddVisitorClick(object sender, EventArgs e)
        {
            FormAddVisitor formAddVisitor = new FormAddVisitor();
            DialogResult   result         = formAddVisitor.ShowDialog(this);

            if (result == DialogResult.Cancel)
            {
                return;
            }

            Visitor visitor = new Visitor();

            using (var context = new VisitorContext())
            {
                if (formAddVisitor.TextBoxName.Text.Length < 1)
                {
                    MessageBox.Show("Вы не ввели имя посетителя");
                    return;
                }
                if (formAddVisitor.TextBoxPassportNumber.Text.Length < 1)
                {
                    MessageBox.Show("Вы не ввели номер удостака");
                    return;
                }
                bool isVisitorNotExists = context.Visitors.ToList().Where(n => n.PassportNumber == formAddVisitor.TextBoxPassportNumber.Text).FirstOrDefault() == null;
                if (!isVisitorNotExists)
                {
                    MessageBox.Show("Этот чел уже заходил");
                    return;
                }
                if (formAddVisitor.RichTextBoxPurposeOfVisit.Text.Length < 1)
                {
                    MessageBox.Show("Вы не ввели цель визита");
                    return;
                }
                visitor.Name           = formAddVisitor.TextBoxName.Text;
                visitor.PassportNumber = formAddVisitor.TextBoxPassportNumber.Text;
                visitor.PurposeOfVisit = formAddVisitor.RichTextBoxPurposeOfVisit.Text;
                visitor.DateTimeIn     = DateTime.Now;

                context.Visitors.Add(visitor);
                context.SaveChanges();
                LoadDataGridViewVisitors();
            }
        }