コード例 #1
0
        private void btnSaveVisit_Click(object sender, EventArgs e)
        {
            string name = tbName.Text + " " + tbLastName.Text + " " + tbMLastName.Text;

            if (!check_fields_visit())
            {
                return;
            }
            var db = new ConnectionDB();
            var visitorDepartment = new Visitors_Department
            {
                department  = tbDepartment.Text,
                reason      = tbReason.Text,
                observation = rtbObservation.Text,
                entry       = DateTime.Now,
                id_visitor  = id_visitor
            };

            db.Visitors_Department.Add(visitorDepartment);
            db.SaveChanges();

            MessageBox.Show("Visita registrada con éxito", "Operador", MessageBoxButtons.OK, MessageBoxIcon.Information);
            print_visitor_info(name, visitorDepartment.department, visitorDepartment.entry);
            clean_fields_visitor();
            clean_fields_visit();
            enable_disable_visitor(false);
            enable_disable_visit(false);

            btnCancel.Visible      = false;
            btnSaveVisitor.Visible = false;
            btnNewVisitor.Visible  = true;
            btnNewVisit.Visible    = false;
            btnSaveVisit.Visible   = false;
            btnEdit.Visible        = false;
        }
コード例 #2
0
        private void btnSaveVisitor_Click(object sender, EventArgs e)
        {
            if (!check_fields_visitor())
            {
                return;
            }

            var    db   = new ConnectionDB();
            string name = tbName.Text + " " + tbLastName.Text + " " + tbMLastName.Text;

            if (btnSaveVisitor.Text == "GUARDAR VISITANTE")
            {
                var visitor = new Visitors
                {
                    name        = tbName.Text,
                    last_name   = tbLastName.Text,
                    m_last_name = tbMLastName.Text,
                    alias       = tbAlias.Text,
                    email       = tbEmail.Text,
                    phone       = tbPhone.Text,
                    address     = tbAddress.Text,
                    status      = 1,
                    image       = ConvertImageToBase64(pbImage.BackgroundImage)
                };

                db.Visitors.Add(visitor);
                db.SaveChanges();

                if (!string.IsNullOrEmpty(tbDepartment.Text))
                {
                    var visitorDepartment = new Visitors_Department
                    {
                        department  = tbDepartment.Text,
                        reason      = tbReason.Text,
                        observation = rtbObservation.Text,
                        entry       = DateTime.Now,
                        id_visitor  = visitor.id
                    };

                    db.Visitors_Department.Add(visitorDepartment);
                    db.SaveChanges();
                    print_visitor_info(name, visitorDepartment.department, visitorDepartment.entry);
                    MessageBox.Show("Registro realizado con éxito", "Operador", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            else
            {
                var visitor_edit = db.Visitors.FirstOrDefault(x => x.id == id_visitor);
                if (visitor_edit != null)
                {
                    visitor_edit.name        = tbName.Text;
                    visitor_edit.last_name   = tbLastName.Text;
                    visitor_edit.m_last_name = tbMLastName.Text;
                    visitor_edit.alias       = tbAlias.Text;
                    visitor_edit.email       = tbEmail.Text;
                    visitor_edit.phone       = tbPhone.Text;
                    visitor_edit.address     = tbAddress.Text;
                    visitor_edit.status      = 1;
                    visitor_edit.image       = ConvertImageToBase64(pbImage.BackgroundImage);

                    if (db.Entry(visitor_edit).State == EntityState.Modified)
                    {
                        db.SaveChanges();
                    }

                    if (!string.IsNullOrEmpty(tbDepartment.Text))
                    {
                        var visitorDepartmentEd = db.Visitors_Department.FirstOrDefault(x => x.id == id_visit);
                        if (visitorDepartmentEd != null)
                        {
                            visitorDepartmentEd.department  = tbDepartment.Text;
                            visitorDepartmentEd.reason      = tbReason.Text;
                            visitorDepartmentEd.observation = rtbObservation.Text;

                            if (db.Entry(visitorDepartmentEd).State == EntityState.Modified)
                            {
                                visitorDepartmentEd.entry           = DateTime.Now;
                                db.Entry(visitorDepartmentEd).State = EntityState.Modified;
                                db.SaveChanges();

                                print_visitor_info(name, visitorDepartmentEd.department, visitorDepartmentEd.entry);
                            }
                        }
                        MessageBox.Show("Registro actualizado con éxito", "Operador", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }

            clean_fields_visitor();
            clean_fields_visit();
            enable_disable_visitor(false);
            enable_disable_visit(false);
            fill_dgv("");

            btnCancel.Visible      = false;
            btnSaveVisitor.Visible = false;
            btnNewVisitor.Visible  = true;
            btnNewVisit.Visible    = false;
            btnSaveVisit.Visible   = false;
            btnEdit.Visible        = false;
        }