public void InserirDestinatarios(HabilEmailDestinatario p) { try { AbrirConexao(); strSQL = "insert into [HABIL_EMAIL_DESTINATARIO] " + " (CD_INDEX, CD_EMAIL_DESTINATARIO, TP_DESTINATARIO, NM_DESTINATARIO, TX_EMAIL) " + " values ( @v1, @v2, @v3, @v4, @v5);"; Cmd = new SqlCommand(strSQL, Con); Cmd.Parameters.AddWithValue("@v1", p.CD_INDEX); Cmd.Parameters.AddWithValue("@v2", p.CD_EMAIL_DESTINATARIO); Cmd.Parameters.AddWithValue("@v3", p.TP_DESTINATARIO); Cmd.Parameters.AddWithValue("@v4", p.NM_DESTINATARIO); Cmd.Parameters.AddWithValue("@v5", p.TX_EMAIL); Cmd.ExecuteNonQuery(); } catch (SqlException ex) { if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error { switch (ex.Errors[0].Number) { case 2601: // Primary key violation throw new DuplicateNameException("Inclusão não Permitida!!! Chave já consta no Banco de Dados. Mensagem :" + ex.Message.ToString(), ex); case 2627: // Primary key violation throw new DuplicateNameException("Inclusão não Permitida!!! Chave já consta no Banco de Dados. Mensagem :" + ex.Message.ToString(), ex); default: throw new Exception("Erro ao incluir Habil Email Destnatario: " + ex.Message.ToString()); } } } catch (Exception ex) { throw new Exception("Erro ao gravar Destinatarios: " + ex.Message.ToString()); } finally { FecharConexao(); } }
public List <HabilEmailDestinatario> ListarDestinatarioPara(long CD_Index) { List <HabilEmailDestinatario> lista = new List <HabilEmailDestinatario>(); try { AbrirConexao(); string strSQL = "Select * from [Habil_Email_Destinatario] Where cd_index = @v1 and TP_DESTINATARIO = 1 "; Cmd = new SqlCommand(strSQL, Con); Cmd.Parameters.AddWithValue("@v1", CD_Index); Dr = Cmd.ExecuteReader(); while (Dr.Read()) { HabilEmailDestinatario p = new HabilEmailDestinatario(); p.CD_INDEX = Convert.ToInt64(Dr["CD_INDEX"]); p.CD_EMAIL_DESTINATARIO = Convert.ToInt32(Dr["CD_EMAIL_DESTINATARIO"]); p.NM_DESTINATARIO = Convert.ToString(Dr["NM_DESTINATARIO"]); p.TX_EMAIL = Convert.ToString(Dr["TX_EMAIL"]); p.TP_DESTINATARIO = 1; lista.Add(p); } return(lista); } catch (Exception ex) { throw new Exception("Erro ao Listar Todos Emails: " + ex.Message.ToString()); } finally { FecharConexao(); } }