public bool InserirEmailNotaCorretagem(EmailNotaCorretagemInfo info) { try { SqlConnection sql = _abrirConexaoSql(_strConnectionStringDefault); SqlCommand sqlCommand = new SqlCommand("prc_nota_corretagem_email_ins", sql); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.Add(new SqlParameter("@IdCliente", info.IdCliente)); sqlCommand.Parameters.Add(new SqlParameter("@DtRegistroEmail", info.DtRegistroEmail)); sqlCommand.Parameters.Add(new SqlParameter("@EmailOrigem", info.EmailOrigem)); sqlCommand.Parameters.Add(new SqlParameter("@EmailDest", info.EmailDestinatario)); sqlCommand.Parameters.Add(new SqlParameter("@EmailDestCc", info.EmailDestinatarioCc)); sqlCommand.Parameters.Add(new SqlParameter("@EmailDestCco", info.EmailDestinatarioCco)); sqlCommand.Parameters.Add(new SqlParameter("@Assunto", info.Assunto)); sqlCommand.Parameters.Add(new SqlParameter("@Corpo", info.Body)); sqlCommand.Parameters.Add(new SqlParameter("@ArquivoNC", info.ArquivoNota)); sqlCommand.Parameters.Add(new SqlParameter("@Bolsa", info.Bolsa)); sqlCommand.Parameters.Add(new SqlParameter("@Status", info.Status)); sqlCommand.Parameters.Add(new SqlParameter("@DescStatus", info.DescStatus)); int rows = sqlCommand.ExecuteNonQuery(); _fecharConexao(sql); if (rows > 0) { return(true); } return(false); } catch (Exception ex) { logger.Error("Problemas na insercao do Email Nota de Corretagem: " + ex.Message, ex); return(false); } }
private void _processEmail(TOEmail email) { EmailNotaCorretagemInfo info = new EmailNotaCorretagemInfo(); try { // Inserir no BD info.ArquivoNota = email.Msg.FileAttach; info.Bolsa = email.Exchange; info.DtRegistroEmail = DateTime.Now; info.EmailDestinatario = email.Msg.To; if (!string.IsNullOrEmpty(email.Msg.Cc)) { info.EmailDestinatarioCc = email.Msg.Cc; } if (!string.IsNullOrEmpty(email.Msg.Cco)) { info.EmailDestinatarioCco = email.Msg.Cco; } info.Assunto = email.Msg.Subject; info.Body = email.Msg.Body; info.EmailOrigem = email.Msg.From; info.Status = email.Status; info.DescStatus = email.DescStatus; if (!string.IsNullOrEmpty(email.IdCliente)) { info.IdCliente = Convert.ToInt32(email.IdCliente); } if (!email.Status.Equals(StatusInfo.ERRO) && !string.IsNullOrEmpty(email.Msg.To)) { logger.DebugFormat("===> SendEmail: IDCliente[{0}] Emails:[{1}] Subject:[{2}]", info.IdCliente, email.Msg.To, email.Msg.Subject); SpiderMail.SendEmail(_cfg, email.Msg); } else { logger.DebugFormat("===> SendEmail: Email com ERRO ou destinatario vazio. IDCliente[{0}], Emails:[{1}] Subject:[{2}]", info.IdCliente, email.Msg.To, email.Msg.Subject); } if (_db != null) { _db.InserirEmailNotaCorretagem(info); } } catch (Exception ex) { logger.Error("Erro no envio dos emails: " + ex.Message, ex); info.Status = StatusInfo.ERRO; info.DescStatus = ex.Message; if (_db != null) { _db.InserirEmailNotaCorretagem(info); } } }