public AssessorEmailResponse RemoverListaAssessorEmail(AssessorEmailRequest request) { AssessorEmailResponse response = new AssessorEmailResponse(); response.Retorno = AssessorEmailResponse.RETORNO_ERRO; AcessaDados lAcessaDados = new AcessaDados(); try { lAcessaDados.ConnectionStringName = gNomeConexaoSQL; foreach (AssessorEmailInfo item in request.Lista) { using (DbCommand lDbCommand = lAcessaDados.CreateCommand(CommandType.StoredProcedure, "prc_del_assessoremail")) { lAcessaDados.AddInParameter(lDbCommand, "@idAssessor", DbType.Int32, item.IdAssessor); object result = lAcessaDados.ExecuteScalar(lDbCommand); } } response.Retorno = AssessorEmailResponse.RETORNO_OK; } catch (Exception ex) { logger.Error("RemoverListaAssessorEmail(): Ocorreu um erro ao acessar o banco de dados: " + ex.Message); } return(response); }
public AssessorEmailResponse ObterListaAssessorEmail() { AcessaDados lAcessaDados = new AcessaDados(); AssessorEmailResponse response = new AssessorEmailResponse(); response.Lista = new List <AssessorEmailInfo>(); response.Retorno = AssessorEmailResponse.RETORNO_ERRO; try { lAcessaDados.ConnectionStringName = gNomeConexaoSQL; using (DbCommand lDbCommand = lAcessaDados.CreateCommand(CommandType.StoredProcedure, "prc_lst_assessor_email")) { DataTable lDataTable = lAcessaDados.ExecuteDbDataTable(lDbCommand); if (null != lDataTable && lDataTable.Rows.Count > 0) { for (int i = 0; i <= lDataTable.Rows.Count - 1; i++) { AssessorEmailInfo info = new AssessorEmailInfo(); info.IdAssessor = (lDataTable.Rows[i]["idAssessor"]).DBToInt32(); info.IdEmail = (lDataTable.Rows[i]["idEmail"]).DBToInt32(); info.DataAtualizacao = (lDataTable.Rows[i]["dtAtualizacao"]).DBToDateTime(); response.Lista.Add(info); } } } response.Retorno = AssessorEmailResponse.RETORNO_OK; } catch (Exception ex) { logger.Error("ObterListaAssessorEmail(): 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); } }