public void DeleteUser(User user)
{
using (var transaction = _dbContext.Database.BeginTransaction())
{
try
{
var userPermission = _dbContext.UserPermissions.Where(it => it.UserID == user.UserID).FirstOrDefault();
_dbContext.UserPermissions.Remove(userPermission);
_dbContext.SaveChanges();
var accountUser = _dbContext.AccountUsers.Where(it => it.UserID == user.UserID).FirstOrDefault();
_dbContext.AccountUsers.Remove(accountUser);
_dbContext.SaveChanges();
_dbContext.Users.Remove(user);
_dbContext.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw;
}
}
}
public void Add(TEntity entity)
{
_dbContext.Set <TEntity>().Add(entity);
_dbContext.SaveChanges();
}