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; }
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; }