protected void SendMessage(FileImporterMessage message)
        {
            try
            {
                _busContext.Enqueue <FileImporterMessage>("GE-ImportacaoArquivos", message);
            }

            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #2
0
        public override void Process(DataTable excelSpreadsheet, string fileName)
        {
            int totalFileRows = excelSpreadsheet.Rows.Count;
            int countRows     = 1;

            foreach (DataRow rowColumn in excelSpreadsheet.Rows)
            {
                ClienteSpreadsheetLine clienteSpreadsheetLine = new ClienteSpreadsheetLine();

                if (rowColumn.ItemArray.Count() == 30)
                {
                    clienteSpreadsheetLine.Codigo = rowColumn[0].ToString();

                    if (string.IsNullOrEmpty(clienteSpreadsheetLine.Codigo))
                    {
                        continue;
                    }

                    clienteSpreadsheetLine.Cliente = rowColumn[1].ToString();
                    clienteSpreadsheetLine.Rua     = rowColumn[2].ToString();
                    clienteSpreadsheetLine.Bairro  = rowColumn[3].ToString();
                    clienteSpreadsheetLine.Cidade  = rowColumn[4].ToString();
                    clienteSpreadsheetLine.Estado  = rowColumn[5].ToString();

                    clienteSpreadsheetLine.Tipo               = rowColumn[6].ToString();
                    clienteSpreadsheetLine.PotencialCVA       = rowColumn[7].ToString();
                    clienteSpreadsheetLine.TempoAtendimento   = rowColumn[8].ToString();
                    clienteSpreadsheetLine.TempoTratativa     = rowColumn[9].ToString();
                    clienteSpreadsheetLine.RestricaoDias      = rowColumn[10].ToString();
                    clienteSpreadsheetLine.PrimeiraAbertura   = rowColumn[11].ToString();
                    clienteSpreadsheetLine.PrimeiroFechamento = rowColumn[12].ToString();
                    clienteSpreadsheetLine.SegundaAbertura    = rowColumn[13].ToString();;
                    clienteSpreadsheetLine.SegundoFechamento  = rowColumn[14].ToString();

                    clienteSpreadsheetLine.Contato1          = rowColumn[15].ToString();
                    clienteSpreadsheetLine.TelefoneContato1  = rowColumn[16].ToString();
                    clienteSpreadsheetLine.EnviarSmsContato1 = rowColumn[17].ToString();

                    clienteSpreadsheetLine.Contato2          = rowColumn[18].ToString();
                    clienteSpreadsheetLine.TelefoneContato2  = rowColumn[19].ToString();
                    clienteSpreadsheetLine.EnviarSmsContato2 = rowColumn[20].ToString();

                    clienteSpreadsheetLine.Contato3          = rowColumn[21].ToString();
                    clienteSpreadsheetLine.TelefoneContato3  = rowColumn[22].ToString();
                    clienteSpreadsheetLine.EnviarSmsContato3 = rowColumn[23].ToString();

                    clienteSpreadsheetLine.Contato4          = rowColumn[24].ToString();
                    clienteSpreadsheetLine.TelefoneContato4  = rowColumn[25].ToString();
                    clienteSpreadsheetLine.EnviarSmsContato4 = rowColumn[26].ToString();

                    clienteSpreadsheetLine.Contato5          = rowColumn[27].ToString();
                    clienteSpreadsheetLine.TelefoneContato5  = rowColumn[28].ToString();
                    clienteSpreadsheetLine.EnviarSmsContato5 = rowColumn[29].ToString();

                    FileImporterMessage message = new FileImporterMessage("GE-Clientes-01-", clienteSpreadsheetLine, fileName, countRows, totalFileRows);
                    countRows++;

                    try
                    {
                        SendMessage(message);
                    }

                    catch (Exception ex)
                    {
                        LoggerHelper.Error($"Process => {ex.Message} - INNER EXCEPTION: {ex.GetInnerExceptionMessage()}");
                    }
                }
            }
        }