private async Task <bool> ImportOficiosAsync() { var dao = new OficiosDAO(); dao.OpenDatabase(); try { var rstMain = dao.GetRecordSet(); var processDataList = new List <ProcessData>(); var uploadFileList = new List <string>(); while (!rstMain.EOF) { processDataList.Add(OficiosHelper.CreateAsuntoDataField(rstMain.Fields["ASUNTO"].Value.ToString())); processDataList.Add(OficiosHelper.CreateDenominacionSocialDataField(rstMain.Fields["DENOMINACIÓN SOCIAL/NOMBRE, APELLIDOS ARRENDATARIO"].Value.ToString())); processDataList.Add(OficiosHelper.CreateMatriculaVehiculoDataField(rstMain.Fields["MATRÍCULA VEHÍCULO"].Value.ToString())); processDataList.Add(OficiosHelper.CreateNumeroContratoDataField(rstMain.Fields["NÚMERO DE CONTRATO"].Value.ToString())); processDataList.Add(OficiosHelper.CreateEntidadSolicitanteDataField(rstMain.Fields["ENTIDAD SOLICITANTE DE LOS DATOS/OFICIOS"].Value.ToString())); processDataList.Add(OficiosHelper.CreateLocalidadDataField(rstMain.Fields["LOCALIDAD/PROVINCIA SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreateDireccionSolicitanteDataField(rstMain.Fields["DIRECCION SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreateCodigoPostalDataField(rstMain.Fields["CÓDIGO POSTAL SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreateTelefonoDataField(rstMain.Fields["TELÉFONO SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreateFaxDataField(rstMain.Fields["FAX SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreateCorreoElectronicoDataField(rstMain.Fields["CORREO ELECTRÓNICO SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreatePersonaContactoDataField(rstMain.Fields["PERSONA DE CONTACTO SOLICITANTE"].Value.ToString())); processDataList.Add(OficiosHelper.CreateFechaYMedioDataField(rstMain.Fields["FECHA Y MEDIO A TRAVÉS DEL CUAL HA LLEGADO LA SOLICITUD"].Value.ToString())); processDataList.Add(OficiosHelper.CreateFechaRespuestaCxrDataField(rstMain.Fields["FECHA DE RESPUESTA DE CXR Y A TRAVÉS DE QUE MEDIO"].Value.ToString())); processDataList.Add(OficiosHelper.CreateComentario1DataField(rstMain.Fields["COMENTARIOS (I)"].Value.ToString())); processDataList.Add(OficiosHelper.CreateComentario2DataField(rstMain.Fields["COMENTARIOS (II)"].Value.ToString())); processDataList.Add(OficiosHelper.CreateComentario3DataField(rstMain.Fields["COMENTARIOS (III)"].Value.ToString())); processDataList.Add(OficiosHelper.CreateLugarExpedienteDataField(rstMain.Fields["LUGAR EN EL QUE SE ENCUENTRA EL EXPEDIENTE FISICO"].Value.ToString())); var dataId = string.Empty; try { dataId = await AddOficiosProcessData(token, processDataList.ToArray()); } catch (RestResponseException ex) { LogFactory.CreateLog().LogError(ex); continue; } // Export files from first column var rstAttach = RecordsetHelper.GetRecordset2("DATOS ADJUNTOS (I)", rstMain); try { uploadFileList.AddRange(ExportFilesFromRecordset(rstAttach)); } finally { rstAttach.Close(); } // Export files from second column rstAttach = RecordsetHelper.GetRecordset2("DATOS ADJUNTOS (II)", rstMain); try { uploadFileList.AddRange(ExportFilesFromRecordset(rstAttach)); } finally { rstAttach.Close(); } // Export files from third column rstAttach = RecordsetHelper.GetRecordset2("DATOS ADJUNTOS (III)", rstMain); try { uploadFileList.AddRange(ExportFilesFromRecordset(rstAttach)); } finally { rstAttach.Close(); } foreach (var fileName in uploadFileList) { try { await AddOficiosProcessFiles(token, dataId, new FileInfo(fileName)); } catch (RestResponseException ex) { LogFactory.CreateLog().LogError(ex); continue; } } processDataList.Clear(); uploadFileList.Clear(); rstMain.MoveNext(); } } finally { dao.CloseDatabase(); dao = null; } return(true); }
private async Task <bool> ImportContratosAsync() { var dao = new ContratosDAO(); dao.OpenDatabase(); try { var rstMain = dao.GetRecordSet(); var processDataList = new List <ProcessData>(); var uploadFileList = new List <string>(); while (!rstMain.EOF) { processDataList.Add(ContratosHelper.CreateClienteDataField(rstMain.Fields["Cliente"].Value.ToString())); processDataList.Add(ContratosHelper.CreateTipoContratoDataField(rstMain.Fields["Tipo de contrato"].Value.ToString())); processDataList.Add(ContratosHelper.CreateNIFDataField(rstMain.Fields["NIF"].Value.ToString())); processDataList.Add(ContratosHelper.CreateNumeroContratoDataField(rstMain.Fields["Número crto"].Value.ToString())); processDataList.Add(ContratosHelper.CreateUbicacionDataField(rstMain.Fields["Ubicación"].Value.ToString())); var dataId = string.Empty; try { dataId = await AddContratosProcessData(token, processDataList.ToArray()); } catch (RestResponseException ex) { LogFactory.CreateLog().LogError(ex); continue; } // Export files from first column var rstAttach = RecordsetHelper.GetRecordset2("Datos adjuntos", rstMain); try { uploadFileList.AddRange(ExportFilesFromRecordset(rstAttach)); } finally { rstAttach.Close(); } foreach (var fileName in uploadFileList) { try { await AddContratosProcessFiles(token, dataId, new FileInfo(fileName)); } catch (RestResponseException ex) { LogFactory.CreateLog().LogError(ex); continue; } } processDataList.Clear(); uploadFileList.Clear(); rstMain.MoveNext(); } } finally { dao.CloseDatabase(); dao = null; } return(true); }
private async Task <bool> ImportBuroFaxesAsync() { var dao = new BuroFaxesDAO(); dao.OpenDatabase(); try { var rstMain = dao.GetRecordSet(); var processDataList = new List <ProcessData>(); var uploadFileList = new List <string>(); while (!rstMain.EOF) { processDataList.Add(BuroFaxesHelper.CreateFechaEmisionDataField(rstMain.Fields["FECHA DE EMISIÓN"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateFechaLlegadaDataField(rstMain.Fields["FECHA DE LLEGADA A CAIXARENTING"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateFechaEntregaDataField(rstMain.Fields["FECHA EN LA QUE SE ENTREGA AL DEPARTAMENTO CORRESPONDIENTE"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateFechaRespuestaDataField(rstMain.Fields["FECHA DE RESPUESTA POR PARTE DEL DEPARTAMENTO CORRESPONDIENTE"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateClienteDataField(rstMain.Fields["CLIENTE"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateAsuntoDataField(rstMain.Fields["ASUNTO"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateDepartamentoDataField(rstMain.Fields["DEPARTAMENTO AL QUE PERTENECE"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateRespuestaEmitidaDataField(rstMain.Fields["RESPUESTA EMITIDA (ASUNTO-TEMA)"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateComentario1DataField(rstMain.Fields["COMENTARIO (I)"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateComentario2DataField(rstMain.Fields["COMENTARIO (II)"].Value.ToString())); processDataList.Add(BuroFaxesHelper.CreateComentario3DataField(rstMain.Fields["COMENTARIO (III)"].Value.ToString())); var dataId = string.Empty; try { dataId = await AddBuroFaxesProcessData(token, processDataList.ToArray()); } catch (RestResponseException ex) { LogFactory.CreateLog().LogError(ex); continue; } // Export files from first column var rstAttach = RecordsetHelper.GetRecordset2("DOCUMENTO ADJUNTO (I)", rstMain); try { uploadFileList.AddRange(ExportFilesFromRecordset(rstAttach)); } finally { rstAttach.Close(); } // Export files from second column rstAttach = RecordsetHelper.GetRecordset2("DOCUMENTO ADJUNTO (II)", rstMain); try { uploadFileList.AddRange(ExportFilesFromRecordset(rstAttach)); } finally { rstAttach.Close(); } foreach (var fileName in uploadFileList) { try { await AddBuroFaxesProcessFiles(token, dataId, new FileInfo(fileName)); } catch (RestResponseException ex) { LogFactory.CreateLog().LogError(ex); continue; } } processDataList.Clear(); uploadFileList.Clear(); rstMain.MoveNext(); } } finally { dao.CloseDatabase(); dao = null; } return(true); }