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(); }