public EntEmail ObterPorId(Int32 IdEmail)
{
EntEmail objEmail = new EntEmail();
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
objEmail = dalEmail.ObterPorId(IdEmail, transaction, db);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(objEmail);
}
public EntEmail Remover(EntEmail objEmail, Int32 IdUsuario)
{
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
objEmail.Ativo = !objEmail.Ativo;
dalEmail.Remover(objEmail, transaction, db);
SaveLog(IdUsuario, EntLog.LOG_REMOVER, "E-mail", objEmail.IdEmail, objEmail, transaction, db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
SaveLog(IdUsuario, EntLog.LOG_ERRO, "E-mail", objEmail.IdEmail, objEmail, ex.Message, db, connection);
throw;
}
finally
{
connection.Close();
}
}
return(objEmail);
}
private List <EntEmail> Popular(DbDataReader dtrDados)
{
List <EntEmail> listEntReturn = new List <EntEmail>();
EntEmail entReturn;
try
{
while (dtrDados.Read())
{
entReturn = new EntEmail();
entReturn.IdEmail = ObjectUtils.ToInt(dtrDados["CDA_EMAIL"]);
entReturn.Email = ObjectUtils.ToString(dtrDados["TX_EMAIL"]);
entReturn.Titulo = ObjectUtils.ToString(dtrDados["TX_TITULO"]);
entReturn.Mensagem = ObjectUtils.ToString(dtrDados["TX_MENSAGEM"]);
entReturn.DataEnvio = ObjectUtils.ToDate(dtrDados["DT_DATA_ENVIO"]);
entReturn.IsEnvioSucesso = ObjectUtils.ToBoolean(dtrDados["FL_IS_ENVIO_SUCESSO"]);
entReturn.Ativo = ObjectUtils.ToBoolean(dtrDados["FL_ATIVO"]);
listEntReturn.Add(entReturn);
}
dtrDados.Close();
}
catch (Exception ex)
{
throw ex;
}
return(listEntReturn);
}
public void Remover(EntEmail objEmail, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_EmailRemover");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddInParameter(dbCommand, "@CDA_EMAIL", DbType.Int32, objEmail.IdEmail);
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objEmail.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
}
public static Boolean EnviaEmail(String sPara, String sAssunto, String sbMensagem)
{
EntEmail objEmail = new EntEmail();
objEmail.Ativo = true;
objEmail.DataEnvio = DateTime.Now;
objEmail.Email = sPara;
objEmail.Mensagem = sbMensagem;
objEmail.Titulo = sAssunto;
Boolean res = false;
try
{
String email_send = ConfigurationManager.AppSettings["SmtpRemetente"].ToString();
String email_port = ConfigurationManager.AppSettings["SmtpPorta"].ToString();
// String email_smtp = "smtp.gmail.com";
String email_smtp = ConfigurationManager.AppSettings["SmtpServer"].ToString();
Boolean email_autenticado = StringUtils.ToBoolean(ConfigurationManager.AppSettings["SmtpAutenticado"].ToString());
String email_imap_usuario = ConfigurationManager.AppSettings["SmtpRemetente"].ToString();
String email_imap_senha = ConfigurationManager.AppSettings["SmtpSenha"].ToString();
SmtpClient client = new SmtpClient();
MailAddress de = new MailAddress(email_send);
MailAddress para = new MailAddress(sPara);
MailMessage mailMessage = new MailMessage(de, para);
mailMessage.IsBodyHtml = true;
mailMessage.Subject = sAssunto;
mailMessage.Body = sbMensagem.ToString();
SmtpClient smtpClient = new SmtpClient(email_smtp, Int32.Parse(email_port));
if (email_autenticado)
{
smtpClient.UseDefaultCredentials = false;
NetworkCredential Credentials = new NetworkCredential(email_imap_usuario, email_imap_senha);
smtpClient.Credentials = Credentials;
smtpClient.EnableSsl = true;
}
smtpClient.Send(mailMessage);
objEmail.IsEnvioSucesso = true;
res = true;
}
catch (Exception ex)
{
}
new BllEmail().Inserir(objEmail, EntUsuario.USUARIO_PADRAO);
return(res);
}
public void Alterar(EntEmail objEmail, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_EmailAlterar");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddInParameter(dbCommand, "@CDA_EMAIL", DbType.Int32, objEmail.IdEmail);
db.AddInParameter(dbCommand, "@TX_EMAIL", DbType.String, objEmail.Email);
db.AddInParameter(dbCommand, "@TX_TITULO", DbType.String, objEmail.Titulo);
db.AddInParameter(dbCommand, "@TX_MENSAGEM", DbType.String, objEmail.Mensagem);
db.AddInParameter(dbCommand, "@DT_DATA_ENVIO", DbType.DateTime, objEmail.DataEnvio);
db.AddInParameter(dbCommand, "@FL_IS_ENVIO_SUCESSO", DbType.Boolean, objEmail.IsEnvioSucesso);
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objEmail.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
}
public void Alterar(EntEmail objEmail, Int32 IdUsuario)
{
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
dalEmail.Alterar(objEmail, transaction, db);
SaveLog(IdUsuario, EntLog.LOG_EDITAR, "E-mail", objEmail.IdEmail, objEmail, transaction, db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
SaveLog(IdUsuario, EntLog.LOG_ERRO, "E-mail", objEmail.IdEmail, objEmail, ex.Message, db, connection);
throw;
}
finally
{
connection.Close();
}
}
}
