public void Delete(T model)
{
ConnectionFactory.BeginTransaction();
BeforeDelete(model);
GetDAO().Delete(model);
ConnectionFactory.Commit();
SaveLog(model, LogSistemaAcaoEnum.Excluir);
}
public T IdentityInsert(T model)
{
ConnectionFactory.BeginTransaction();
BeforeIdentityInsert(model);
BeforeSave(model, BusinessObjectAcaoEnum.IdentityInsert);
var retorno = GetDAO().IdentityInsert(model);
ConnectionFactory.Commit();
SaveLog(model, LogSistemaAcaoEnum.Inserir);
return(retorno);
}
public T Update(T model)
{
ConnectionFactory.BeginTransaction();
BeforeUpdate(model);
BeforeSave(model, BusinessObjectAcaoEnum.Update);
var retorno = GetDAO().Update(model);
ConnectionFactory.Commit();
SaveLog(model, LogSistemaAcaoEnum.Editar);
return(retorno);
}
public void IdentityInsertImage(T model, HttpFileCollection imagem)
{
ConnectionFactory.BeginTransaction();
BeforeIdentityInsert(model);
BeforeSave(model, BusinessObjectAcaoEnum.IdentityInsert);
foreach (string item in imagem)
{
SalvarImagem(model, imagem[item]);
GetDAO().IdentityInsert(model);
SaveLog(model, LogSistemaAcaoEnum.Inserir);
}
ConnectionFactory.Commit();
}
public T Activate(T model)
{
if (model is IActivableObject)
{
ConnectionFactory.BeginTransaction();
var retorno = GetDAO().Activate(model);
ConnectionFactory.Commit();
SaveLog(model, LogSistemaAcaoEnum.Ativar);
return(retorno);
}
else
{
throw new BrokenRulesException("Objeto não suporta ativação");
}
}
public async Task <bool> DeletarUsuario(Guid id)
{
using (var conn = new ConnectionFactory().GetOpenBDConnection())
{
IDbTransaction trans = conn.BeginTransaction();
try
{
conn.Execute(DELETAR_USUARIO, new { @Id = id }, trans);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
}
return(true);
}
public async Task <bool> EditarUsuario(Usuario usuario)
{
using (var conn = new ConnectionFactory().GetOpenBDConnection())
{
IDbTransaction trans = conn.BeginTransaction();
try
{
conn.Execute(ATUALIZAR_USUARIO, new { usuario.UserName, usuario.PasswordHash, usuario.PasswordSalt, usuario.Id }, trans);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
}
return(true);
}
public virtual long Insert(T entity)
{
using (var conn = new ConnectionFactory().GetConnection(_config.GetConnectionString("DefaultConnection")))
{
using (var transaction = conn.BeginTransaction())
{
try
{
var id = conn.Insert <T>(entity);
transaction.Commit();
return(id);
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
public async Task <Usuario> RegisterUser(Usuario usuario)
{
Usuario user = new Usuario();
using (var conn = new ConnectionFactory().GetOpenBDConnection())
{
IDbTransaction trans = conn.BeginTransaction();
try
{
conn.Execute(SALVAR_USUARIO, new { usuario.Id, usuario.UserName, usuario.PasswordHash, usuario.PasswordSalt, usuario.Email, usuario.EmailConfirmed, @IsEnabled = true }, trans);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
}
return(user);
}
public void IdentityInsertMultipleImage(List <T> models, HttpFileCollection imagem)
{
if (models.Count == imagem.Count)
{
ConnectionFactory.BeginTransaction();
for (int idx = 0; idx < imagem.Count; idx++)
{
BeforeIdentityInsert(models.ElementAt(idx));
BeforeSave(models.ElementAt(idx), BusinessObjectAcaoEnum.IdentityInsert);
SalvarImagem(models.ElementAt(idx), imagem[idx]);
GetDAO().IdentityInsert(models.ElementAt(idx));
SaveLog(models.ElementAt(idx), LogSistemaAcaoEnum.Inserir);
}
ConnectionFactory.Commit();
}
else
{
throw new BrokenRulesException("Não foi possível realizar essa operação!");
}
}
public T UpdateImage(T model, HttpPostedFile imagem)
{
ConnectionFactory.BeginTransaction();
BeforeUpdate(model);
BeforeSave(model, BusinessObjectAcaoEnum.Update);
if (imagem != null)
{
SalvarImagem(model, imagem);
}
else
{
var find = Find((int)ClassManipulation.GetIdentityProp <T>().GetValue(model));
if (find != null)
{
if ((model as IFileUploadObject) != null)
{
(model as IFileUploadObject).Imagem = (find as IFileUploadObject).Imagem;
}
else
{
throw new BrokenRulesException("Não foi possível carregar a imagem cadastrada!");
}
}
else
{
throw new BrokenRulesException("Não foi possível carregar a imagem cadastrada!");
}
}
var retorno = GetDAO().Update(model);
ConnectionFactory.Commit();
SaveLog(model, LogSistemaAcaoEnum.Editar);
return(retorno);
}
public virtual bool Delete(T entity)
{
using (var conn = new ConnectionFactory().GetConnection(_config.GetConnectionString("DefaultConnection")))
{
if (entity.Id == 0)
{
entity.Id = Get(entity.Key)?.Id ?? 0;
}
using (var transaction = conn.BeginTransaction())
{
try
{
bool ret = conn.Delete <T>(entity);
transaction.Commit();
return(ret);
}
catch (Exception ex)
{
transaction.Rollback();
throw;
}
}
}
}
public static void BeginTransaction()
{
ConnectionFactory.ConnectDataBase();
ConnectionFactory.BeginTransaction();
}
