public Response <ProjectRole> GetUserProjectRole(GetUserProjectRoleRequest request)
{
Response <ProjectRole> response = new Response <ProjectRole>();
if (request == null || request.UserID == 0)
{
ArgumentNullException ex = new ArgumentNullException("GetUserProjectRole request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor accessor = new RoleAccessor();
response.Result = accessor.GetUserProjectRole(request.UserID, request.ProjectID);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public Response <int> AddOrUpdateRoles(AddOrUpdateRoleRequest request)
{
Response <int> response = new Response <int>();
if (request == null || request.RoleCollection == null || !request.RoleCollection.Any())
{
ArgumentNullException ex = new ArgumentNullException("AddOrUpdateRole request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor accessor = new RoleAccessor();
response.Result = accessor.AddOrUpdateRoles(request.RoleCollection);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public Response <bool> SetProjectRole(SetProjectRoleRequest request)
{
Response <bool> response = new Response <bool>();
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("SetProjectRole request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor accessor = new RoleAccessor();
response.Result = accessor.SetProjectRole(request.ProjectID, request.RoleIDs);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
public Response <Role> GetRoleInfo(GetObjectByIDRequest request)
{
Response <Role> response = new Response <Role>();
if (request == null || request.ID == 0)
{
ArgumentNullException ex = new ArgumentNullException("GetRoleByID request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor accessor = new RoleAccessor();
response.Result = accessor.GetRoleByID(request.ID);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public Response <IEnumerable <ProjectRole> > GetProjectRoles(GetRoleByProjectIDRequest request)
{
Response <IEnumerable <ProjectRole> > response = new Response <IEnumerable <ProjectRole> >();
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetProjectRoles request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor accessor = new RoleAccessor();
response.Result = accessor.GetRoleByProjectID(request.ProjectID, request.GetAll);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public bool AddNewRole(string roleId,
string description,
int createdBy,
DateTime createdDate)
{
try
{
var role = new Role()
{
RoleID = roleId,
Description = description,
CreatedBy = createdBy,
CreatedDate = createdDate
};
if (RoleAccessor.CreateRole(role) == 1)
{
return(true);
}
}
catch (Exception)
{
throw;
}
return(false);
}
public int GetRoleCount()
{
try
{
return(RoleAccessor.RetrieveRoleCount());
}
catch (Exception)
{
throw;
}
}
public static Role UpdateSelct(int id)
{
try
{
RoleAccessor r = new RoleAccessor();
return(r.UpdateSelect(id));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Gets the role list.
/// </summary>
/// <returns>List;Roles;.</returns>
/// <exception cref="System.ApplicationException">There were no records found.</exception>
public List <Roles> GetRoleList()
{
var userRoleList = RoleAccessor.GetRolesList();
if (userRoleList.Count > 0)
{
return(userRoleList);
}
else
{
throw new ApplicationException("There were no records found.");
}
}
/// <summary>
/// 验证公司编号 唯一性
/// </summary>
/// <param name="Name"></param>
/// <returns></returns>
public string CheckNameIsExist(string Name, int?Id, string ProjectID, bool IsEdit)
{
RoleAccessor accessor = new RoleAccessor();
string ReturnValue = string.Empty;
try
{
if (!accessor.CheckNameIsExist(Name, Id, ProjectID, IsEdit))
{
ReturnValue = "该角色名称已存在！";
}
}
catch (Exception ex)
{
ReturnValue = ex.Message;
LogError(ex);
}
return(ReturnValue);
}
public Response <IEnumerable <ProjectRole> > GetAllProjectRoles()
{
Response <IEnumerable <ProjectRole> > response = new Response <IEnumerable <ProjectRole> >();
try
{
RoleAccessor accessor = new RoleAccessor();
response.Result = accessor.GetAllProjectRoles();
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
/// <summary>
/// 获取crm信息
/// </summary>
/// <param name="Sqlwhere"></param>
/// <returns></returns>
public Response <RoleRequestAndResponse> GetRolesByCondition(RoleRequestAndResponse request)
{
Response <RoleRequestAndResponse> response = new Response <RoleRequestAndResponse>()
{
Result = new RoleRequestAndResponse()
};
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetCRMInfoByID request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor Roleccessor = new RoleAccessor();
int Rowcount;
response.Result.RoleCollection = Roleccessor.GetRolesByCondition(request.Role, request.PageIndex, request.PageSize, out Rowcount);
response.Result.PageIndex = request.PageIndex;
response.Result.TotalCount = Rowcount;
response.Result.PageCount = Rowcount % request.PageSize == 0 ? Rowcount / request.PageSize : Rowcount / request.PageSize + 1;
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.Exception = ex;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
/// <summary>
/// Author: Ibrahim Abuzaid
/// Data Transfer Object to represent a User from the
/// Database
///
/// Added 3/4 By Ibarahim
/// </summary>
public List <Role> GetRoleList()
{
try
{
var roleList = RoleAccessor.RetrieveRoleList();
if (roleList.Count > 0)
{
return(roleList);
}
else
{
throw new ApplicationException("There were no records found.");
}
}
catch (Exception)
{
// *** we should sort the possible exceptions and return friendly messages for each
Console.Out.WriteLine("Exception Handler on Role manager Class...");
throw;
}
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="paremIds"></param>
/// <returns></returns>
public Response <bool> DeleteRole(RoleRequest request)
{
RoleAccessor ra = new RoleAccessor();
Response <bool> response = new Response <bool>();
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("SetProjectRole request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
string paremIds = request.Name.ToString();
if (paremIds.IndexOf(",") > -1)
{
ra.DeleteRole(paremIds.Substring(1), "1", request.ProjectId); //批量删除
}
else
{
ra.DeleteRole(paremIds, "0", request.ProjectId); //单个删除
}
response.IsSuccess = true;
response.SuccessMessage = "删除成功！";
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
response.SuccessMessage = "删除失败！" + ex;
}
return(response);
}
/// <summary>
/// 获取role信息
/// </summary>
/// <param name="Sqlwhere"></param>
/// <returns></returns>
public Response <RoleRequest> GetRoleInfo(RoleRequest request)
{
Response <RoleRequest> response = new Response <RoleRequest>()
{
Result = new RoleRequest()
};
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetRoleInfoByID request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
RoleAccessor Roleccessor = new RoleAccessor();
int Rowcount;
response.Result.IEnumerableRole = Roleccessor.GetRole(request.Role, request.PageIndex, request.PageSize, request.ProjectId, request.Satate.ToString(), out Rowcount);
response.Result.PageIndex = request.PageIndex;
response.Result.PageCount = Rowcount % request.PageSize == 0 ? Rowcount / request.PageSize : Rowcount / request.PageSize + 1;
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.Exception = ex;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public static int RoleUpdate(RoleRequest r)
{
return(RoleAccessor.RoleUpdate(r));
}
/// <summary>
/// 检查角色是否已存在
/// </summary>
/// <param name="r"></param>
/// <returns> -1 表示已存在 否则返回即将产生的ID</returns>
public static string CheckInput(RoleRequest r)
{
return(RoleAccessor.CheckIput(r));
}
/// <summary>
/// 角色新增
/// </summary>
/// <param name="r"></param>
/// <returns></returns>
public static int roleinsert(RoleRequest r)
{
return(RoleAccessor.RolePod(r));
}
