public TextoEmailResponse GravarListaTextoEmail(TextoEmailRequest request)
{
TextoEmailResponse response = new TextoEmailResponse();
response.Retorno = TextoEmailResponse.RETORNO_ERRO;
AcessaDados lAcessaDados = new AcessaDados();
try
{
lAcessaDados.ConnectionStringName = gNomeConexaoSQL;
foreach (TextoEmailInfo item in request.Lista)
{
using (DbCommand lDbCommand = lAcessaDados.CreateCommand(CommandType.StoredProcedure, "prc_ins_textoemail"))
{
lAcessaDados.AddInParameter(lDbCommand, "@idTextoEmail", DbType.Int32, item.Id);
lAcessaDados.AddInParameter(lDbCommand, "@dsConteudo", DbType.String, item.Texto);
lAcessaDados.AddInParameter(lDbCommand, "@dtAtualizacao", DbType.DateTime, item.DataAtualizacao);
object result = lAcessaDados.ExecuteNonQuery(lDbCommand);
}
}
response.Retorno = TextoEmailResponse.RETORNO_OK;
}
catch (Exception ex)
{
logger.Error("GravarListaTextoEmail(): Ocorreu um erro ao acessar o banco de dados: " + ex.Message);
throw (ex);
}
return(response);
}
public TextoEmailResponse ObterListaTextoEmail()
{
AcessaDados lAcessaDados = new AcessaDados();
TextoEmailResponse response = new TextoEmailResponse();
response.Lista = new Dictionary <int, TextoEmailInfo>();
response.Retorno = TextoEmailResponse.RETORNO_ERRO;
try
{
lAcessaDados.ConnectionStringName = gNomeConexaoSQL;
using (DbCommand lDbCommand = lAcessaDados.CreateCommand(CommandType.StoredProcedure, "prc_lst_textoemail"))
{
DataTable lDataTable = lAcessaDados.ExecuteDbDataTable(lDbCommand);
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i <= lDataTable.Rows.Count - 1; i++)
{
TextoEmailInfo textoEmail = new TextoEmailInfo();
textoEmail.Id = (lDataTable.Rows[i]["idTextoEmail"]).DBToInt32();
textoEmail.Texto = (lDataTable.Rows[i]["dsConteudo"]).DBToString();
textoEmail.DataAtualizacao = (lDataTable.Rows[i]["dtAtualizacao"]).DBToDateTime();
response.Lista.Add(textoEmail.Id, textoEmail);
}
}
}
response.Retorno = TextoEmailResponse.RETORNO_OK;
}
catch (Exception ex)
{
logger.Error("ObterListaTextoEmail(): Ocorreu um erro ao acessar o banco de dados: " + ex.Message);
}
return(response);
}
private void btnSalvarConfiguracoes_Click(object sender, EventArgs e)
{
try
{
TextoEmailRequest textoEmailRequest = new TextoEmailRequest();
textoEmailRequest.Lista = new List <TextoEmailInfo>();
foreach (DataGridViewRow item in grdTextoEmail.Rows)
{
TextoEmailInfo info = new TextoEmailInfo();
info.Id = Convert.ToInt32(item.Cells["IdTextoEmail"].Value);
info.Texto = (item.Cells["TextoEmail"].Value == null ? "" : item.Cells["TextoEmail"].Value.ToString());
info.DataAtualizacao = Convert.ToDateTime(item.Cells["DataAtualizacao"].Value);
textoEmailRequest.Lista.Add(info);
}
ISaldoDevedor serv = Ativador.Get <ISaldoDevedor>();
TextoEmailResponse respTextoEmail = serv.GravarListaTextoEmail(textoEmailRequest);
if (respTextoEmail.Retorno == TextoEmailResponse.RETORNO_OK)
{
EmailRequest emailRequest = new EmailRequest();
emailRequest.Lista = new List <EmailInfo>();
foreach (DataGridViewRow item in grdEmail.Rows)
{
EmailInfo info = new EmailInfo();
info.Id = Convert.ToInt32(item.Cells["IdEmail"].Value);
info.Descricao = (item.Cells["Descricao"].Value == null ? "" : item.Cells["Descricao"].Value.ToString());
info.Titulo = (item.Cells["Titulo"].Value == null ? "" : item.Cells["Titulo"].Value.ToString());
info.Assunto = (item.Cells["Assunto"].Value == null ? "" : item.Cells["Assunto"].Value.ToString());
info.EmailPara = (item.Cells["Para"].Value == null ? "" : item.Cells["Para"].Value.ToString());
info.EmailCopia = (item.Cells["Copia"].Value == null ? "" : item.Cells["Copia"].Value.ToString());
info.EmailCopiaOculta = (item.Cells["CopiaOculta"].Value == null ? "" : item.Cells["CopiaOculta"].Value.ToString());
info.IdTextoEmail = Convert.ToInt32(item.Cells["IdTextoEmail"].Value);
info.DataAtualizacao = Convert.ToDateTime(item.Cells["DataAtualizacao"].Value);
emailRequest.Lista.Add(info);
}
EmailResponse respEmail = serv.GravarListaEmail(emailRequest);
if (respEmail.Retorno == EmailResponse.RETORNO_OK)
{
AssessorEmailRequest assessorEmailRequest = new AssessorEmailRequest();
assessorEmailRequest.Lista = new List <AssessorEmailInfo>();
foreach (int item in ListaAssessorEmailExcluido)
{
AssessorEmailInfo info = new AssessorEmailInfo();
info.IdAssessor = item;
assessorEmailRequest.Lista.Add(info);
}
AssessorEmailResponse respDelAssessorEmail = serv.RemoverListaAssessorEmail(assessorEmailRequest);
if (respDelAssessorEmail.Retorno == AssessorEmailResponse.RETORNO_OK)
{
assessorEmailRequest.Lista.Clear();
foreach (DataGridViewRow item in grdAssessorEmail.Rows)
{
AssessorEmailInfo info = new AssessorEmailInfo();
info.IdAssessor = Convert.ToInt32(item.Cells["CodigoAssessor"].Value);
info.IdEmail = Convert.ToInt32(item.Cells["DescricaoEmail"].Value);
info.DataAtualizacao = Convert.ToDateTime(item.Cells["DataAtualizacao"].Value);
assessorEmailRequest.Lista.Add(info);
}
AssessorEmailResponse respAssessorEmail = serv.GravarListaAssessorEmail(assessorEmailRequest);
if (respAssessorEmail.Retorno == AssessorEmailResponse.RETORNO_OK)
{
MessageBox.Show("Configuração de E-mail gravada com sucesso!", "Configuração",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("FALHA NA GRAVAÇÃO DE ASSESSORES QUE RECEBEM E-MAIL!", "Configuração",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("FALHA NA EXCLUSÃO DE ASSESSORES QUE RECEBEM E-MAIL!", "Configuração",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("FALHA NA GRAVAÇÃO DOS E-MAILS!", "Configuração",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("FALHA NA GRAVAÇÃO DOS TEXTOS DE E-MAIL!", "Configuração",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
string msg = "Salvar Configurações: " + ex.Message;
MessageBox.Show(msg, "Configuração E-mail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
OnGravaConfigEmail();
this.Close();
}
private void ObterParametros()
{
try
{
grdTextoEmail.CellValueChanged -= new DataGridViewCellEventHandler(grdTextoEmail_CellValueChanged);
grdAssessorEmail.CellValueChanged -= new DataGridViewCellEventHandler(grdAssessorEmail_CellValueChanged);
grdEmail.CellValueChanged -= new DataGridViewCellEventHandler(grdEmail_CellValueChanged);
ISaldoDevedor serv = Ativador.Get <ISaldoDevedor>();
TextoEmailResponse listaTextoEmail = serv.ObterListaTextoEmail();
grdTextoEmail.Rows.Clear();
ComboIdTextoEmail.Clear();
foreach (KeyValuePair <int, TextoEmailInfo> item in listaTextoEmail.Lista)
{
grdTextoEmail.Rows.Add(item.Value.Id, item.Value.Texto, item.Value.DataAtualizacao);
ComboIdTextoEmail.Rows.Add(item.Value.Id.ToString(), item.Value.Id.ToString());
}
EmailResponse listaEmail = serv.ObterListaDetalheEmail();
grdEmail.Rows.Clear();
ComboDescricaoEmail.Clear();
foreach (KeyValuePair <int, EmailInfo> item in listaEmail.Lista)
{
int reg = grdEmail.Rows.Add(new DataGridViewRow());
grdEmail.Rows[reg].Cells["IdEmail"].Value = item.Value.Id;
grdEmail.Rows[reg].Cells["Descricao"].Value = item.Value.Descricao;
grdEmail.Rows[reg].Cells["Titulo"].Value = item.Value.Titulo;
grdEmail.Rows[reg].Cells["Assunto"].Value = item.Value.Assunto;
grdEmail.Rows[reg].Cells["Para"].Value = item.Value.EmailPara;
grdEmail.Rows[reg].Cells["Copia"].Value = item.Value.EmailCopia;
grdEmail.Rows[reg].Cells["CopiaOculta"].Value = item.Value.EmailCopiaOculta;
grdEmail.Rows[reg].Cells["IdTextoEmail"].Value = item.Value.IdTextoEmail.ToString();
grdEmail.Rows[reg].Cells["DataAtualizacao"].Value = item.Value.DataAtualizacao;
ComboDescricaoEmail.Rows.Add(item.Value.Id, item.Value.Descricao);
}
AssessorEmailResponse listaAssessorEmail = serv.ObterListaAssessorEmail();
grdAssessorEmail.Rows.Clear();
foreach (AssessorEmailInfo item in listaAssessorEmail.Lista)
{
if (item.IdAssessor == 0)
{
continue;
}
int reg = grdAssessorEmail.Rows.Add(new DataGridViewRow());
grdAssessorEmail.Rows[reg].Cells["CodigoAssessor"].Value = item.IdAssessor;
grdAssessorEmail.Rows[reg].Cells["DescricaoEmail"].Value = item.IdEmail.ToString();
grdAssessorEmail.Rows[reg].Cells["DataAtualizacao"].Value = item.DataAtualizacao;
}
grdTextoEmail.CellValueChanged += new DataGridViewCellEventHandler(grdTextoEmail_CellValueChanged);
grdAssessorEmail.CellValueChanged += new DataGridViewCellEventHandler(grdAssessorEmail_CellValueChanged);
grdEmail.CellValueChanged += new DataGridViewCellEventHandler(grdEmail_CellValueChanged);
}
catch (Exception ex)
{
string msg = "Obter Parâmetros: " + ex.Message;
MessageBox.Show(msg, "Configuração E-mail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
