/// <summary> /// Agrega a la interface el registro de Oracle indicado /// </summary> /// <param name="record">Registro de Oracle a agregar</param> public void AddRecord(OracleRecord record) { try { record.Moneda = record.InvoiceCurr; if (record.InvoiceCurr.Equals("MXN", StringComparison.OrdinalIgnoreCase)) { record.CurrencyRate = "1"; record.TipCamb = "1"; } if (record.Cc.Equals("40.9941.0000.1185.00.000")) { record.TypeTax = "Y"; } string invoiceDate = ""; if (record.InvoiceDate != "") { invoiceDate = ReplaceMonth(record.InvoiceDate); try { invoiceDate = Convert.ToDateTime(invoiceDate).ToString("MM/dd/yyyy"); } catch (Exception ex) { } } var _csvRow = new List <string>() { record.RecordType, record.InvoiceNum, record.SupplierNum, //string.IsNullOrEmpty(record.InvoiceDate)?Convert.ToDateTime(record.InvoiceDate).ToString("MM/dd/yyyy"):record.InvoiceDate, invoiceDate, record.InvoiceCurr, record.CurrencyRate, CerosNull(record.InvoiceAmount, true, false), record.RecordType.Equals("2") ? "Y" : record.NoInvDetail, //record.NoInvDetail, record.Num, !record.NoInvDetail2.Equals("Y") ? record.UuidCfdi : "", !record.RecordType.Equals("1") ? record.SupplierNum2 : "", !record.RecordType.Equals("1") ? CerosNull(record.MontoTotal, true, false) : "", !record.RecordType.Equals("1") && !record.RecordType.Equals("3") && !record.RecordType.Equals("2") ? record.Moneda : "", !record.RecordType.Equals("1") && !record.RecordType.Equals("3") && !record.RecordType.Equals("2") ? record.TipCamb : "", !record.RecordType.Equals("1") ? (record.NoInvDetail2.Equals("Y") ? "Y" : "") : "", !record.RecordType.Equals("1") && !record.RecordType.Equals("3") ? record.TypeTax : "", !record.RecordType.Equals("1") && !record.RecordType.Equals("3") ? record.Cc : "", !record.RecordType.Equals("1") && !record.RecordType.Equals("3") ? CerosNull(record.Amount, true, false) : "" }; _csv.Add(_csvRow); _rowNumber++; } catch (Exception) { _rowNumber--; } }
private List <OracleRecord> Transform(string pathDelFicheroExcel) { var list = new List <OracleRecord>(); using (var package = new ExcelPackage(new FileInfo(pathDelFicheroExcel))) { var workSheet = package.Workbook.Worksheets.First(); var start = workSheet.Dimension.Start; var end = workSheet.Dimension.End; for (var row = (start.Row + 2); row <= end.Row; row++) { try { var record = new OracleRecord { RowNumber = row.ToString(), RecordType = workSheet.Cells[row, 1].Text, InvoiceNum = workSheet.Cells[row, 2].Text, SupplierNum = workSheet.Cells[row, 3].Text, InvoiceDate = workSheet.Cells[row, 4].Text, InvoiceCurr = workSheet.Cells[row, 5].Text, CurrencyRate = workSheet.Cells[row, 6].Text, InvoiceAmount = workSheet.Cells[row, 7].Text.Replace(",", ""), NoInvDetail = workSheet.Cells[row, 8].Text, Num = workSheet.Cells[row, 9].Text, UuidCfdi = workSheet.Cells[row, 10].Text, SupplierNum2 = workSheet.Cells[row, 11].Text, MontoTotal = workSheet.Cells[row, 12].Text.Replace(",", ""), Moneda = workSheet.Cells[row, 13].Text, TipCamb = workSheet.Cells[row, 14].Text, NoInvDetail2 = workSheet.Cells[row, 15].Text, TypeTax = workSheet.Cells[row, 16].Text, Cc = workSheet.Cells[row, 17].Text, Amount = workSheet.Cells[row, 18].Text.Replace(",", "") }; //if (!string.IsNullOrEmpty(record.RecordType) && !string.IsNullOrEmpty(record.InvoiceNum)) //{ list.Add(record); //} } catch (Exception) { // ignored } } } return(list); }
private static bool IsEmpty(OracleRecord record) { var isEmpty = true; isEmpty &= string.IsNullOrEmpty(record.Amount.Trim()); isEmpty &= string.IsNullOrEmpty(record.Cc.Trim()); isEmpty &= string.IsNullOrEmpty(record.CurrencyRate.Trim()); isEmpty &= string.IsNullOrEmpty(record.InvoiceAmount.Trim()); isEmpty &= string.IsNullOrEmpty(record.InvoiceCurr.Trim()); isEmpty &= string.IsNullOrEmpty(record.InvoiceDate.Trim()); isEmpty &= string.IsNullOrEmpty(record.InvoiceNum.Trim()); isEmpty &= string.IsNullOrEmpty(record.Moneda.Trim()); isEmpty &= string.IsNullOrEmpty(record.MontoTotal.Trim()); isEmpty &= string.IsNullOrEmpty(record.NoInvDetail.Trim()); isEmpty &= string.IsNullOrEmpty(record.NoInvDetail2.Trim()); isEmpty &= string.IsNullOrEmpty(record.Num.Trim()); isEmpty &= string.IsNullOrEmpty(record.RecordType.Trim()); isEmpty &= string.IsNullOrEmpty(record.SupplierNum.Trim()); isEmpty &= string.IsNullOrEmpty(record.SupplierNum2.Trim()); isEmpty &= string.IsNullOrEmpty(record.TipCamb.Trim()); isEmpty &= string.IsNullOrEmpty(record.TypeTax.Trim()); isEmpty &= string.IsNullOrEmpty(record.UuidCfdi.Trim()); return(isEmpty); }