public void AddEmail(ref OperationResult pobjOperationResult, emailDto pobjDtoEntity) { //mon.IsActive = true; int SecuentialId = 0; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); email objEntity = emailAssembler.ToEntity(pobjDtoEntity); SecuentialId = Utils.GetNextSecuentialId(1, 400); objEntity.i_EmailId = SecuentialId; dbContext.AddToemail(objEntity); dbContext.SaveChanges(); pobjOperationResult.Success = 1; return; } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex); return; } }
public emailDto VerificarSiExisteEmail(ref OperationResult pobjOperationResult, string pstrEmail) { try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); emailDto objDtoEntity = null; var objEntity = (from a in dbContext.email where a.v_Email == pstrEmail select a).FirstOrDefault(); if (objEntity != null) { objDtoEntity = emailAssembler.ToDTO(objEntity); } pobjOperationResult.Success = 1; return(objDtoEntity); } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex); return(null); } }
private void btnOK_Click(object sender, EventArgs e) { if (ultraValidator1.Validate(true, false).IsValid) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); backgroundWorker1.RunWorkerAsync(); } }
private void btnOK_Click(object sender, EventArgs e) { var Path1 = Application.StartupPath; if (ultraValidator1.Validate(true, false).IsValid) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); RunWorkerAsyncPackage packageForSave = new RunWorkerAsyncPackage(); packageForSave.NombreEmpresaCliente = _EmpresaCliente; packageForSave.FechaInicio = _FechaInicio; packageForSave.FechaFin = _FechaFin; backgroundWorker1.RunWorkerAsync(packageForSave); } }
private void btnOK_Click(object sender, EventArgs e) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (rbInforme1.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_FICHA_MEDICA_TRABAJADOR + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbInforme2.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_FICHA_MEDICA_TRABAJADOR_2 + ".pdf"; _filesNameToMerge.Add(o); } } var x = _filesNameToMerge.ToList(); _mergeExPDF.FilesName = x; var EmpresaCliente = _EmpresaCliente.Replace("/", "_"); _mergeExPDF.DestinationFile = ruta + "Informes " + EmpresaCliente + ".pdf"; _mergeExPDF.Execute(); EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); RunWorkerAsyncPackage packageForSave = new RunWorkerAsyncPackage(); packageForSave.NombreEmpresaCliente = _EmpresaCliente; packageForSave.FechaInicio = _FechaInicio; packageForSave.FechaFin = _FechaFin; backgroundWorker1.RunWorkerAsync(packageForSave); }
private void btnOK_Click(object sender, EventArgs e) { if (ultraValidator1.Validate(true, false).IsValid) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (rbCotizacion.Checked) { //var frm = new Reports.frmConsolidateCotizacion(_serviceOrderId, _protocolId); //frm.ShowDialog(); } else { //var frm = new Reports.frmConsolidateServiceOrder(_serviceOrderId, _protocolId); //frm.ShowDialog(); } EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); backgroundWorker1.RunWorkerAsync(); } }
private void btnOK_Click(object sender, EventArgs e) { var Path1 = Application.StartupPath; if (ultraValidator1.Validate(true, false).IsValid) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (rbCotizacion.Checked) { ServiceBL oServiceBL = new ServiceBL(); ProtocolBL oProtocolBL = new ProtocolBL(); ReportDocument rp; DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); string ruta = Common.Utils.GetApplicationConfigValue("rutaCotizacion").ToString(); var MedicalCenter = oServiceBL.GetInfoMedicalCenterSede(); DataSet ds = new DataSet(); var Valores = new ServiceBL().ObtenerCabeceraCotizacion(ddlCustomerOrganization.SelectedValue.ToString()); DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(Valores); dt.TableName = "dtCartaCotizacion"; ds.Tables.Add(dt); //Reporte 1 rp = new Reports.crReporteCotizacion01(); rp.SetDataSource(ds); rp.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; rp.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = ruta + "Cotizacion1.pdf"; _filesNameToMerge.Add(objDiskOpt.DiskFileName); rp.ExportOptions.DestinationOptions = objDiskOpt; rp.Export(); rp.Close(); //Reporte 2 rp = new Reports.crReporteCotizacion02(); rp.SetDataSource(ds); rp.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; rp.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = ruta + "Cotizacion2.pdf"; _filesNameToMerge.Add(objDiskOpt.DiskFileName); rp.ExportOptions.DestinationOptions = objDiskOpt; rp.Export(); rp.Close(); //Reporte 3 rp = new Reports.crReporteCotizacion03(); rp.SetDataSource(ds); rp.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; rp.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = ruta + "Cotizacion3.pdf"; _filesNameToMerge.Add(objDiskOpt.DiskFileName); rp.ExportOptions.DestinationOptions = objDiskOpt; rp.Export(); rp.Close(); //Reporte 4 rp = new Reports.crReporteCotizacion04(); rp.SetDataSource(ds); rp.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; rp.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = ruta + "Cotizacion4.pdf"; _filesNameToMerge.Add(objDiskOpt.DiskFileName); rp.ExportOptions.DestinationOptions = objDiskOpt; rp.Export(); rp.Close(); var l = oProtocolBL.CotizacionProtocoloPorEmpresaClienteId(ddlCustomerOrganization.SelectedValue.ToString()); HojaCotizacion.CrearHojaCotizacion(l, ddlCustomerOrganization.Text, MedicalCenter, ruta + ddlCustomerOrganization.Text + ".pdf"); _filesNameToMerge.Add(string.Format("{0}.pdf", Path.Combine(ruta + ddlCustomerOrganization.Text))); _filesNameToMerge.Add(string.Format("{0}.pdf", Path1 + @"\Archivos\Archivo2")); var x = _filesNameToMerge.ToList(); _mergeExPDF.FilesName = x; _mergeExPDF.DestinationFile = ruta + ddlCustomerOrganization.Text + " " + DateTime.Now.Date.ToString("dd MMMM") + ".pdf";; _mergeExPDF.Execute(); } else if (rbCarta.Checked) { string ruta = Common.Utils.GetApplicationConfigValue("rutaCotizacion").ToString(); ReportDocument rp; DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); DataSet ds = new DataSet(); var Valores = new ServiceBL().ObtenerCabeceraCotizacion(ddlCustomerOrganization.SelectedValue.ToString()); DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(Valores); dt.TableName = "dtCartaCotizacion"; ds.Tables.Add(dt); rp = new Reports.crCartaPresentación(); rp.SetDataSource(ds); rp.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; rp.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = ruta + "Carta Presentación " + ddlCustomerOrganization.Text + ".pdf"; _filesNameToMerge.Add(objDiskOpt.DiskFileName); rp.ExportOptions.DestinationOptions = objDiskOpt; rp.Export(); rp.Close(); _filesNameToMerge.Add(string.Format("{0}.pdf", Path1 + @"\Archivos\Archivo1")); var x = _filesNameToMerge.ToList(); _mergeExPDF.FilesName = x; _mergeExPDF.DestinationFile = ruta + "Carta Presentación " + ddlCustomerOrganization.Text + " " + DateTime.Now.Date.ToString("dd MMMM") + ".pdf"; _mergeExPDF.Execute(); } //else if (rbDocumentos.Checked) //{ // List<string> ArchivoAdjunto = new List<string>(); // ArchivoAdjunto.Add(Path1 + @"\Archivos\Acreditacion.pdf"); // ArchivoAdjunto.Add(Path1 + @"\Archivos\Recomendaciones.pdf"); // ArchivoAdjunto.Add(Path1 + @"\Archivos\Informacion.pdf"); // ArchivoAdjunto.Add(Path1 + @"\Archivos\Mapa.pdf"); // ArchivoAdjunto.Add(Path1 + @"\Archivos\PLANTILLA.xlsx"); // ArchivoAdjunto.Add(Path1 + @"\Archivos\FICHA CLIENTE.xlsx"); //} EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); RunWorkerAsyncPackage packageForSave = new RunWorkerAsyncPackage(); packageForSave.NombreEmpresaCliente = ddlCustomerOrganization.Text; backgroundWorker1.RunWorkerAsync(packageForSave); } }
private void btnOK_Click(object sender, EventArgs e) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (rb312.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_CERTIFICADO_APTITUD + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbEmpresarial.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_CERTIFICADO_APTITUD_EMPRESARIAL + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbSinDx.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_CERTIFICADO_APTITUD_SIN_DX + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbToxicologico.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.TOXICOLOGICO_ID + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbAltura18.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.ALTURA_ESTRUCTURAL_ID + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbSomnolencia.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.SOMNOLENCIA_ID + ".pdf"; _filesNameToMerge.Add(o); } } var x = _filesNameToMerge.ToList(); _mergeExPDF.FilesName = x; _mergeExPDF.DestinationFile = ruta + "Consolidado de Formatos" + ".pdf"; _mergeExPDF.Execute(); EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); backgroundWorker1.RunWorkerAsync(); }
private void btnOK_Click(object sender, EventArgs e) { if (txtLabel.Text.Trim() == "") { MessageBox.Show("Por favor ingrese Correo Electrónico.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSubject.Text.Trim() == "") { MessageBox.Show("Por favor ingrese un Asunto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (rb312.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_CERTIFICADO_APTITUD + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbEmpresarial.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_CERTIFICADO_APTITUD_EMPRESARIAL + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbSinDx.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.INFORME_CERTIFICADO_APTITUD_SIN_DX + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbToxicologico.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.TOXICOLOGICO_ID + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbAltura18.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.ALTURA_ESTRUCTURAL_ID + ".pdf"; _filesNameToMerge.Add(o); } } else if (rbSomnolencia.Checked) { foreach (var item in _ListaServicios) { var o = ruta + item.ToString() + "-" + Constants.SOMNOLENCIA_ID + ".pdf"; _filesNameToMerge.Add(o); } } var resultado = MessageBox.Show("¿Desea enviar certificados?", "¡ INFORMACIÓN !", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (resultado == DialogResult.Yes) { foreach (var item in _ListaServicios) { _serviceBL.ActualizarEnvioCertificado(item, 1); } } var x = _filesNameToMerge.ToList(); _mergeExPDF.FilesName = x; var EmpresaCliente = _EmpresaCliente.Replace("/", "_"); _mergeExPDF.DestinationFile = ruta + "Certificados " + EmpresaCliente + " " + _FechaInicio + " " + _FechaFin + ".pdf"; _mergeExPDF.Execute(); EmailBL oEmailBL = new EmailBL(); emailDto oemailDto = new emailDto(); oemailDto.v_Email = txtLabel.Text; OperationResult objOperationResult = new OperationResult(); oEmailBL.AddEmail(ref objOperationResult, oemailDto); this.Enabled = false; _frmWaiting.Show(this); RunWorkerAsyncPackage packageForSave = new RunWorkerAsyncPackage(); packageForSave.NombreEmpresaCliente = _EmpresaCliente; packageForSave.FechaInicio = _FechaInicio; packageForSave.FechaFin = _FechaFin; backgroundWorker1.RunWorkerAsync(packageForSave); }