public ServiceResponse <HeadstoneUserRole> Find(Expression <Func <HeadstoneUserRole, bool> > predicate)
{
using (var bo = new UserRoleDAO())
{
HeadstoneUserRole result = bo.Find(predicate) as HeadstoneUserRole;
if (result != null)
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
result
}
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL
});
}
}
}
public bool GetByIdUsuarioAndIdRole(int usuarioId, int roleId, Connection conn, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(conn))
{
return(dao.GetByIdUsuarioAndIdRole(this, usuarioId, roleId));
}
}
public static IList <string> GetNormalizedNameRolesByIdUsuario(int usuarioId, Connection conn, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(conn))
{
return(dao.GetNormalizedNameRolesByIdUsuario(usuarioId, null));
}
}
public ServiceResponse <HeadstoneUserRole> GetAllIncluding(params object[] includes)
{
using (var bo = new UserRoleDAO())
{
var result = bo.GetAll(includes).ToList();
if (result.Any())
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = result as List <HeadstoneUserRole>,
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>(),
});
}
}
}
public ServiceResponse <HeadstoneUserRole> Delete(Expression <Func <HeadstoneUserRole, bool> > predicate)
{
using (var bo = new UserRoleDAO())
{
var model = bo.Find(predicate);
bool isDeleted = bo.Delete(model as HeadstoneUserRole, true);
if (isDeleted)
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
model
}
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
model
}
});
}
}
}
public ServiceResponse <HeadstoneUserRole> Delete(HeadstoneUserRole model)
{
using (var bo = new UserRoleDAO())
{
bool isDeleted = bo.Delete(model as HeadstoneUserRole, true);
if (isDeleted)
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
model
}
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
model
}
});
}
}
}
public ServiceResponse <HeadstoneUserRole> Update(HeadstoneUserRole model)
{
using (var bo = new UserRoleDAO())
{
int result = bo.Update(model as HeadstoneUserRole);
if (result > 0)
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
model
}
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
model
}
});
}
}
}
public static UserRole FindByUserIdAndRoleId(int userId, int roleId, Connection connection, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(connection))
{
return(dao.FindByUserIdAndRoleId(userId, roleId));
}
}
public void Delete(Connection connection, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(connection))
{
dao.Remove(this, transaction);
}
}
public static IList <string> FindRoleNormalizedNameByUserId(int userId, Connection connection, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(connection))
{
return(dao.FindRoleNormalizedNameByUserId(userId, null));
}
}
public static bool ExistsUserInRole(int usuarioId, int roleId, Connection connection, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(connection))
{
return(dao.ExistsUserInRole(usuarioId, roleId, transaction));
}
}
public static bool ExistsUserInRole(int usuarioId, string normalizedRoleName, Connection connection, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(connection))
{
return(dao.ExistsUserInRole(usuarioId, normalizedRoleName, transaction));
}
}
public ServiceResponse <HeadstoneUserRole> GetIncluding(Expression <Func <HeadstoneUserRole, bool> > predicate, params object[] includes)
{
using (var bo = new UserRoleDAO())
{
var results = bo.GetList(predicate, includes);
if (results != null && results.Any())
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = results
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
});
}
}
}
public ServiceResponse <HeadstoneUserRole> FindIncluding(Expression <Func <HeadstoneUserRole, bool> > predicate, params Expression <Func <HeadstoneUserRole, object> >[] includes)
{
using (var bo = new UserRoleDAO())
{
var result = bo.Find(predicate, includes);
if (result != null)
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
result
}
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL,
Result = new List <HeadstoneUserRole>()
{
}
});
}
}
}
private void InitDataGridView()
{
DataTable dt = UserRoleDAO.GetDatasByUserId(this.userId);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView, dt);
}
public override void RemoveUsersFromRoles(string[] userNames, string[] roleNames)
{
UserRoleDAO roleDao = new UserRoleDAO();
foreach (string username in userNames)
{
foreach (string rolename in roleNames)
{
roleDao.DeleteFromNames(username, rolename);
}
}
}
public override void AddUsersToRoles(string[] userNames, string[] roleNames)
{
UserRoleDAO roleDao = new UserRoleDAO();
foreach (string username in userNames)
{
foreach (string rolename in roleNames)
{
roleDao.AddFromNames(username, rolename);
}
}
}
/// <summary>
/// Check is exist in the list
/// </summary>
/// <param name="lst">The list.</param>
/// <param name="value">The value.</param>
/// <returns></returns>
public static bool IsExist(this List <UserRole> lst, UserRoleDAO value)
{
foreach (var inner in lst)
{
if (long.Equals(inner.User?.Id, value?.Id))
{
return(true);
}
}
return(false);
}
/// <summary>
/// Initializes a new instance of the <see cref="T:LoginBLL"/> class.
/// </summary>
/// <param name="connectionName">Name of the connection.</param>
private LoginBLL(string connectionName)
{
userDao = UserDAO.GetInstance(connectionName);
userOrgDao = UserOrgDAO.GetInstance(connectionName);
userRoleDao = UserRoleDAO.GetInstance(connectionName);
userRegionDao = UserRegionDAO.GetInstance(connectionName);
userRegionRangeDao = UserRegionRangeDAO.GetInstance(connectionName);
userOrgRoleDAO = UserOrgRoleDAO.GetInstance(connectionName);
userSystemDao = UserSystemDAO.GetInstance(connectionName);
}
/// <summary>
/// Initializes a new instance of the <see cref="T:LoginBLL"/> class.
/// </summary>
private LoginBLL()
{
userDao = UserDAO.GetInstance();
userRoleDao = UserRoleDAO.GetInstance();
userOrgDao = UserOrgDAO.GetInstance();
userRegionDao = UserRegionDAO.GetInstance();
userRegionRangeDao = UserRegionRangeDAO.GetInstance();
userOrgRoleDAO = UserOrgRoleDAO.GetInstance();
userAreaDAO = UserAreaDAO.GetInstance();
userSystemDao = UserSystemDAO.GetInstance();
}
public override void AddUsersToRoles(string[] userNames, string[] roleNames)
{
UserRoleDAO roleDao = new UserRoleDAO();
foreach (string username in userNames)
{
foreach (string rolename in roleNames)
{
roleDao.AddFromNames(username, rolename);
}
}
}
public override void RemoveUsersFromRoles(string[] userNames, string[] roleNames)
{
UserRoleDAO roleDao = new UserRoleDAO();
foreach (string username in userNames)
{
foreach (string rolename in roleNames)
{
roleDao.DeleteFromNames(username, rolename);
}
}
}
public List <Role> GetUserRoles(int UserId)
{
UserRoleDAO userRoleDAO = new UserRoleDAO();
RoleDAO roleDao = new RoleDAO();
List <Role> roles = new List <Role>();
foreach (UserRole ur in userRoleDAO.GetAllFiltered("UserId", UserId.ToString()))
{
roles.Add(roleDao.GetByID(ur.RoleID));
}
return(roles);
}
public void Save(Connection connection, MySqlTransaction transaction = null)
{
using (var dao = new UserRoleDAO(connection))
{
if (Id == 0)
{
dao.Insert(this, transaction);
}
else
{
dao.Update(this, transaction);
}
}
}
public ServiceResponse <HeadstoneUserRole> GetAll()
{
using (var bo = new UserRoleDAO())
{
List <HeadstoneUserRole> result = bo.GetAll().ToList();
if (result.Any())
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Success,
Source = ServiceResponseSources.MsSQL,
Result = result as List <HeadstoneUserRole>,
});
}
else
{
return(new ServiceResponse <HeadstoneUserRole>()
{
Type = ServiceResponseTypes.Error,
Source = ServiceResponseSources.MsSQL
});
}
}
}
/// <summary> Retrieves Entity rows in a datatable which match the specified filter. It will always create a new connection to the database.</summary>
/// <param name="selectFilter">A predicate or predicate expression which should be used as filter for the entities to retrieve.</param>
/// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param>
/// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param>
/// <param name="relations">The set of relations to walk to construct to total query.</param>
/// <param name="pageNumber">The page number to retrieve.</param>
/// <param name="pageSize">The page size of the page to retrieve.</param>
/// <returns>DataTable with the rows requested.</returns>
public static DataTable GetMultiAsDataTable(IPredicate selectFilter, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, int pageNumber, int pageSize)
{
UserRoleDAO dao = DAOFactory.CreateUserRoleDAO();
return(dao.GetMultiAsDataTable(maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, pageNumber, pageSize));
}
public RegisterUserResponse Register(string Email, string UserName, string Password, string ConfirmPassword)
{
if (CheckIfUserExists(Email, UserName))
{
return(new RegisterUserResponse()
{
Success = false,
FailReason = UserInsertFailReason.UserOrEmailExists
});
}
if (!Password.Equals(ConfirmPassword))
{
return(new RegisterUserResponse()
{
Success = false,
FailReason = UserInsertFailReason.PasswordsDontMatch
});
}
// Hash the password
string passwordHash = BCrypt.Net.BCrypt.HashPassword(Password);
User newUser = new User()
{
Email = Email,
UserName = UserName,
PasswordHash = passwordHash
};
try
{
// Insert the user
UserDAO userDao = new UserDAO();
ulong userId = userDao.Insert(newUser);
// Connect the user to a role
UserRole userRole = new UserRole()
{
UserID = (int)userId,
RoleID = 3 // Role of ordinary user is 3
};
UserRoleDAO dao = new UserRoleDAO();
dao.Insert(userRole);
}
catch (Exception e)
{
return(new RegisterUserResponse()
{
Success = false,
FailReason = UserInsertFailReason.DatabaseInsertionError,
ErrorMessage = e.Message
});
}
return(new RegisterUserResponse()
{
Success = true,
FailReason = UserInsertFailReason.Success,
ErrorMessage = null
});
}
public UserRoleBAL()
{
dao = new UserRoleDAO();
}
public override bool Action()
{
dao = new UserRoleDAO();
return(isCan);
}
/// <summary>
/// Default constructor
/// </summary>
private UserRoleMgr()
{
this.DAO = new UserRoleDAO();
}
