/// <summary>
/// Checks if user has the given Role
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public bool ContainsRole(RolesEnum role)
{
return(Roles != null &&
Roles.Count > 0 &&
(Roles.Contains(role) ||
Roles.Contains(RolesEnum.ADMIN)));
}
public async Task <List <User> > GetUsersByRole(RolesEnum rolesEnum)
{
IDbBase dbBase = null;
List <User> users = null;
try
{
var parameters = new List <TimescaleParameter>
{
new TimescaleParameter
{
NpgsqlValue = (short)rolesEnum,
ParameterName = _dataManagersHelpers.CreateParameterName(ConstantsTs.ROLE_ID),
NpgsqlDbType = NpgsqlDbType.Smallint
}
};
dbBase = _dbFactory.GetDbBase();
await dbBase.ConnectAsync();
using (var reader = await dbBase.ExecuteReaderFunctionAsync(GET_USERS_BY_ROLE_FNC_NAME, parameters))
{
if (reader.HasRows)
{
users = new List <User>();
while (reader.Read())
{
var email = reader[_dataManagersHelpers.CreateSelectPropertyName(ConstantsTs.EMAIL)];
var firstName = reader[_dataManagersHelpers.CreateSelectPropertyName(ConstantsTs.FIRST_NAME)];
var lastName = reader[_dataManagersHelpers.CreateSelectPropertyName(ConstantsTs.LAST_NAME)];
users.Add(
new User
{
UserId = Convert.ToInt64(_dataManagersHelpers.CreateSelectPropertyName(ConstantsTs.USER_ID)),
Email = email is DBNull ? null : email.ToString(),
FirstName = firstName is DBNull ? null : firstName.ToString(),
LastName = lastName is DBNull ? null : lastName.ToString()
}
);
}
}
}
return(users);
}
catch (Exception ex)
{
await _logsManager.ErrorAsync(new ErrorLogStructure(ex).WithErrorSource());
throw new HandledException(ex);
}
finally
{
await dbBase?.DisconnectAsync();
}
}
protected Employee(string fName, string lName, RolesEnum role, double sal)
{
FirstName = fName;
LastName = lName;
Role = role;
Salary = sal;
}
/// <summary>
/// Allows to register new user
/// </summary>
/// <param name="request">New user add request</param>
/// <param name="role">Role new user will have</param>
/// <returns>Created user base info</returns>
public async Task <UserBaseInfo> Register(RegisterRequest request, RolesEnum role)
{
var userToCreate = Mapper.Map <RegisterRequest, User>(request);
userToCreate.UserName = request.Email;
return(await Register(userToCreate, request.Password, role));
}
public void LoadEmployees()
{
Worksheet sheet = workBook.Worksheets[0];
int rowIndex = 1;
int colIndex = 3;
employees.Clear();
List <string> Roles = new List <string>();
rolesDict.Clear();
while (sheet.Cells.GetRow(rowIndex).GetCell(colIndex).StringValue != "")
{
Employee emp = new Employee();
emp.EID = sheet.Cells.GetRow(rowIndex).GetCell(colIndex).StringValue.Trim();
emp.FirstName = new CultureInfo("en-US").TextInfo.ToTitleCase(sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 2).StringValue.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries)[1].Trim().ToLower());
emp.LastName = new CultureInfo("en-US").TextInfo.ToTitleCase(sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 2).StringValue.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries)[0].Trim().ToLower());
emp.FullNameUk = new CultureInfo("en-US").TextInfo.ToTitleCase(sheet.Cells.GetRow(rowIndex).GetCell(colIndex - 2).StringValue.Trim());
string dateOfEmployment = sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 6).StringValue.Trim(new char[] { '\n' });
if (dateOfEmployment != "")
{
emp.DateEmployed = DateTime.FromOADate(Int32.Parse(dateOfEmployment));
}
string dateOfBirth = sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 3).StringValue;
if (dateOfBirth != "")
{
emp.BirthDay = DateTime.FromOADate(Int32.Parse(dateOfBirth));
}
string dateOfDismissal = sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 9).StringValue;
if (dateOfDismissal != "")
{
emp.DateDismissed = DateTime.FromOADate(Int32.Parse(dateOfDismissal));
}
emp.Department = new Department {
DepartmentName = (from d in departments where d.DepartmentName == sheet.Cells.GetRow(rowIndex).GetCell(colIndex - 1).StringValue.Trim() select d.DepartmentName).FirstOrDefault()
};
emp.Position = new Position {
TitleUk = (from p in positions where p.TitleUk == sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 7).StringValue.Trim() select p.TitleUk).FirstOrDefault()
};
emp.IsManager = sheet.Cells.GetRow(rowIndex).GetCell(colIndex + 17).StringValue.Trim() != "" ? true : false;
employees.Add(emp);
for (int i = 10; i <= 16; i++)
{
string role = sheet.Cells.GetRow(rowIndex).GetCell(colIndex + i).StringValue.Trim();
if (role != "")
{
RolesEnum r = (RolesEnum)(i - 10);
Roles.Add(r.ToString());
}
}
rolesDict.Add(emp.EID, Roles.ToArray <string>());
Roles.Clear();
rowIndex++;
}
}
public bool CheckRole(string token, RolesEnum role)
{
var rolesRepository = new RolesRepository();
var id = rolesRepository.FindByName(role.ToString()).Id;
var decodedToken = Decode(token);
var tokenId = int.Parse(decodedToken["role"].ToString());
return(id == tokenId);
}
protected bool HasRole(RolesEnum role)
{
if (Request.Cookies.TryGetValue(IssuedTokenName, out string jwt))
{
return(_tokenService.GetAllClaims(jwt)
.Any(claim => claim.Type == "role" && claim.Value == role.ToString()));
}
return(false);
}
public MenuLinkItem()
{
Area = "";
CSS = "";
Class = "";
IsDisplayed = true;
ShowChildItems = true;
Roles = new RolesEnum[0];
//Tasks = new TasksEnum[0];
ChildItems = new MenuLinkItem[0];
}
protected string GetUsersHtml(RolesEnum role)
{
List <UsersEntity> listAll = GetAllSunnetUsers().FindAll(u => u.Role != RolesEnum.CLIENT);
List <UsersEntity> listtarget = listAll.FindAll(u => u.Role == role && u.Status != "INACTIVE");
StringBuilder htmls = new StringBuilder();
foreach (UsersEntity user in listtarget)
{
htmls.AppendFormat("<li userid='{0}'>{1}</li>", user.ID, user.FirstName);
}
return(htmls.ToString());
}
public SqlConnection GetConnection(RolesEnum role)
{
switch (role)
{
case RolesEnum.Admin:
return(AdminConnection);
case RolesEnum.Normal:
return(NormalConnection);
default:
return(AnonymousConnection);
}
}
public User(tbl_User u)
{
this.ID = u.ID;
this.Username = u.Username;
this.Password = u.Password;
this.FName = u.FName;
this.SName = u.SName;
this.Birthdate = u.Birthdate;
this.Address = u.Address;
this.Email = u.Email;
this.PhoneNumber = u.PhoneNumber;
this.NationalID = u.NationalID;
this.Rolename = (RolesEnum)Enum.Parse(typeof(RolesEnum), u.RoleName);
}
public Boolean CheckRole(RolesEnum role)
{
if (CharacterRoles == null)
{
return(false);
}
if (CharacterRoles.Roles.Contains(role))
{
return(true);
}
return(false);
}
public void AddRole(User user, RolesEnum role)
{
if (user != null)
{
if (user.Roles == null)
{
user.Roles = new List <RolesEnum>();
}
user.Roles.Add(role);
userRepository.Save(user);
}
}
private TicketUsersType MapRoleToTicketUserType(RolesEnum role)
{
switch (role)
{
case RolesEnum.PM:
return(TicketUsersType.PM);
case RolesEnum.DEV:
return(TicketUsersType.Dev);
case RolesEnum.QA:
return(TicketUsersType.QA);
default: return(TicketUsersType.Other);
}
}
protected TicketUsersType MapRoleToTicketUserType(RolesEnum role)
{
switch (role)
{
case RolesEnum.PM:
return(TicketUsersType.PM);
case RolesEnum.DEV:
case RolesEnum.Leader:
return(TicketUsersType.Dev);
case RolesEnum.QA:
return(TicketUsersType.QA);
default: return(TicketUsersType.Other);
}
}
public IActionResult ChangeRole(long id, [FromBody] RolesEnum role)
{
_logger.LogInformation(LoggingEvents.UpdateItem, "Update User Role ", id);
var user = _userRepository.Users.FirstOrDefault(u => u.Id == id);
if (user == null)
{
_logger.LogWarning(LoggingEvents.UpdateItemNotFound, "Update Item Not Found ", id);
return(NotFound());
}
user.Role = role;
_userRepository.SaveUser(user);
return(new NoContentResult());
}
public string FeedBackMessage(object ticketID, RolesEnum role)
{
FeedBackMessagesEntity tmpEntity = _listFbms.Find(r => r.TicketID == (int)ticketID);
if (tmpEntity != null)
{
if ((role == RolesEnum.PM && tmpEntity.WaitPMFeedback > 0) ||
(role == RolesEnum.CLIENT && tmpEntity.WaitClientFeedback > 0))
{
int fid = role == RolesEnum.PM ? tmpEntity.WaitPMFeedback : tmpEntity.WaitClientFeedback;
return(string.Format("<a href=\"#\" onclick=\"OpenReplyFeedBackDialog({0},{1})\" id=\"feedback{1}\" title=\"Reply FeedBack\"><img src=\"/icons/25.gif\" alt=\"Reply Feedback\" /></a>"
, fid, tmpEntity.TicketID));
}
else
{
return(string.Format("<a href=\"#\" onclick=\"OpenTicketDetail({0},'f')\" title=\"Feedback\"><img src=\"/icons/ticket_status.gif\" alt=\"Feedback\" /></a>"
, tmpEntity.TicketID));
}
}
return("");
}
// Authorise a user
public bool Authorise(RolesEnum role, BookingDBContext context)
{
// If there isn't a role
if (_httpContextAccessor.HttpContext.Session.GetString("Role") == null || _httpContextAccessor.HttpContext.Session.GetString("Role") == "")
{
return(false);
}
// Get the current role from the session
var currentRole = _httpContextAccessor.HttpContext.Session.GetString("Role");
// Convert the role enum to and int and check if it's higher or equal than the minimum
if ((int)role >= context.Roles.First(n => n.RoleName == currentRole).RoleId)
{
return(false);
}
else
{
return(true);
}
}
public string GetSunnetStatusNameByStatus(object status, RolesEnum userRole)
{
var ticketStatus = (TicketsState)status;
if (userRole == RolesEnum.PM || userRole == RolesEnum.ADMIN || userRole == RolesEnum.Sales)
{
if (ticketStatus == TicketsState.Wait_Client_Feedback ||
ticketStatus == TicketsState.Wait_PM_Feedback ||
ticketStatus == TicketsState.Wait_Sunnet_Feedback)
{
return("<span style='color:red;'>" + ticketStatus.ToText() + "</span>");
}
else
{
return(ticketStatus.ToText());
}
}
else
{
return(ticketStatus.ToText());
}
}
/// <summary>
/// Allows to register new user
/// </summary>
/// <param name="user">New User (Entity)</param>
/// <param name="password">New User password</param>
/// <param name="role">Role new user will have</param>
/// <returns></returns>
public async Task <UserBaseInfo> Register(User user, string password, RolesEnum role)
{
var created = await UserManager.CreateAsync(user, password);
if (!created.Succeeded)
{
return(null);
}
var roleAdded = await UserManager.AddToRoleAsync(user, role.ToString());
if (!roleAdded.Succeeded)
{
await UserManager.DeleteAsync(user);
return(null);
}
var baseUserInfo = await UsersService.GetUserBaseInfo(user.Id);
return(baseUserInfo);
}
protected void Page_Load(object sender, EventArgs e)
{
if (ChangeStatusTicketsEntityInfo == null)//validate
{
return;
}
#region set value
status = Convert.ToInt32(ChangeStatusTicketsEntityInfo.Status);
IsEst = ChangeStatusTicketsEntityInfo.IsEstimates;
IsInternal = ChangeStatusTicketsEntityInfo.IsInternal;
FinalEsTime = ChangeStatusTicketsEntityInfo.FinalTime;
EsUserID = ChangeStatusTicketsEntityInfo.EsUserID;
ticketCreatedUserRole = userApplication.GetUser(ChangeStatusTicketsEntityInfo.CreatedBy).Role;
#endregion
if (UserInfo.Role != RolesEnum.Sales && status != (int)TicketsState.Completed && IsTicketUser())
{
ShowStatusByUserRoleAndUserType();
}
}
public async Task <IEnumerable <UsersMinimalDomain> > GetUsers(RolesEnum rolesType)
{
var roleId = await _databaseContext.Roles
.Where(r => r.Name.Equals(rolesType.GetDisplayName()))
.Select(r => r.Id)
.FirstOrDefaultAsync();
return(await _databaseContext.Roles
.Join(_databaseContext.UserRoles,
role => role.Id,
userRole => userRole.RoleId,
(role, userRole) => new { RoleId = role.Id, userRole.UserId })
.Join(_databaseContext.Users,
userRole => userRole.UserId,
user => user.Id,
(userRole, user) => new { userRole.RoleId, user.Name, user.Id })
.Where(userInfo => userInfo.RoleId == roleId)
.Select(userInfo => new UsersMinimalDomain {
Id = userInfo.Id, UserName = userInfo.Name
})
.ToListAsync().ConfigureAwait(false));
}
protected string GetUsersHtml(RolesEnum role)
{
StringBuilder htmls = new StringBuilder();
GetProjectIdAndUserIDResponse response = ticketApp.GetProjectIdAndUserID(QS("tid", 0));
List <ProjectUsersEntity> projectUsers = projectApp.GetProjectSunnetUserList(response.ProjectId);
ProjectsEntity projectsEntity = projectApp.Get(response.ProjectId);
if (projectUsers != null && projectUsers.Count > 0)
{
bool isHasUser = false;
foreach (ProjectUsersEntity projectUser in projectUsers)
{
UsersEntity user = userApp.GetUser(projectUser.UserID);
if (user != null && user.Status.Trim() != "INACTIVE")
{
if (user.Role != RolesEnum.CLIENT && user.Role == role)
{
if (ticketEntity.CreatedBy != user.UserID)
{
htmls.AppendFormat("<li userid='{0}' data-role=" + (int)MapRoleToTicketUserType(role) + ">{1}</li>", user.ID, user.FirstName);
}
else
{
htmls.AppendFormat("<li userid='{0}' data-isCreate='true' data-role=" + (int)MapRoleToTicketUserType(role) + ">{1}</li>", user.ID, user.FirstName);
}
isHasUser = true;
}
}
}
if (!isHasUser)
{
htmls.AppendFormat("<li style='{0}'></li>", "visibility:hidden;");
}
}
return(htmls.ToString());
}
/// <summary>
/// Saves a user in Repository
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="role"></param>
/// <returns></returns>
public bool Save(string userName, string password, RolesEnum role)
{
bool response = false;
if (IsValid(userName, password, role))
{
if (!userGetService.Exists(userName))
{
User user = new User()
{
UserName = userName,
Password = password,
Roles = new List <RolesEnum> {
role
}
};
userRepository.Save(user);
response = true;
}
}
return(response);
}
protected bool IsInRole(RolesEnum role)
{
return SecurityToken.IsInRole(role);
}
public static string ConvertEnumToAttribute(RolesEnum role)
{
switch (role)
{
case RolesEnum.Adapter:
return "adp";
case RolesEnum.Annotator:
return "ann";
case RolesEnum.Arranger:
return "arr";
case RolesEnum.Artist:
return "art";
case RolesEnum.AssociatedName:
return "asn";
case RolesEnum.Author:
return "aut";
case RolesEnum.AuthorInQuotationsOrTextExtracts:
return "aqt";
case RolesEnum.AuthorOfAfterwordColophonEtc:
return "aft";
case RolesEnum.AuthorOfIntroductionEtc:
return "aui";
case RolesEnum.BibliographicAntecedent:
return "ant";
case RolesEnum.BookProducer:
return "bkp";
case RolesEnum.Collaborator:
return "clb";
case RolesEnum.Commentator:
return "cmm";
case RolesEnum.Compiler:
return "com";
case RolesEnum.Designer:
return "dsr";
case RolesEnum.Editor:
return "edt";
case RolesEnum.Illustrator:
return "ill";
case RolesEnum.Lyricist:
return "lyr";
case RolesEnum.MetadataContact:
return "mdc";
case RolesEnum.Musician:
return "mus";
case RolesEnum.Narrator:
return "nrt";
case RolesEnum.Other:
return "oth";
case RolesEnum.Photographer:
return "pht";
case RolesEnum.Printer:
return "prt";
case RolesEnum.Redactor:
return "red";
case RolesEnum.Reviewer:
return "rev";
case RolesEnum.Sponsor:
return "spn";
case RolesEnum.ThesisAdvisor:
return "ths";
case RolesEnum.Transcriber:
return "trc";
case RolesEnum.Translator:
return "trl";
}
return "oth";
}
public List <WeekPlanEntity> GetList(int userId, DateTime startDate, DateTime endDate, RolesEnum role, int pageNo, int pageSize, out int recordCount)
{
recordCount = 0;
List <WeekPlanEntity> list = new List <WeekPlanEntity>();
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetStoredProcCommand("WeekPlan_GetList"))
{
db.AddInParameter(dbCommand, "@UserId", DbType.Int32, userId);
db.AddInParameter(dbCommand, "@StartDate", DbType.DateTime, startDate);
db.AddInParameter(dbCommand, "@EndDate", DbType.DateTime, endDate);
db.AddInParameter(dbCommand, "@PageNo", DbType.Int32, pageNo);
db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCommand, "@Role", DbType.Int32, (int)role);
db.AddOutParameter(dbCommand, "@RecordCount", DbType.Int32, 4);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
list.Add(new WeekPlanEntity(dataReader, true));
}
}
recordCount = (int)db.GetParameterValue(dbCommand, "RecordCount");
}
return(list);
}
public bool IsInRole(RolesEnum roleID)
{
return IsInRole(roleID.ToString());
}
/// <summary>
/// 日历模块显示数据，获取数据源
/// </summary>
public List <EventCalendar> GetEventCalendar(int currentUserId, DateTime date, int userId, string allUser, RolesEnum role, int projectID, int dateCount = 4)
{
DateTime startDate = DateTime.Parse(string.Format("{0}/1/{1}", date.Month, date.Year));
//开始时间往前推一周，结束时间往后推一周
List <EventEntity> list = mgr.GetEvents(currentUserId, startDate.AddDays(-7), startDate.AddMonths(1).AddDays(7), userId, allUser, projectID);
return(GetList(list, date, userId, dateCount));
}
public List <WeekPlanEntity> GetList(int userid, DateTime startDate, DateTime endDate, RolesEnum role, int pageNo, int pageSize, out int recordCount)
{
return(repository.GetList(userid, startDate, endDate, role, pageNo, pageSize, out recordCount));
}
public bool IsInRole(RolesEnum role)
{
return (this.role == role);
}
public async Task <IEnumerable <UsersMinimalResponse> > GetUsersWithRole(RolesEnum rolesEnum)
{
var result = await _usersGateway.GetUsers(rolesEnum);
return(result.ToResponse());
}
public bool IsCurrentUserInRole(RolesEnum role)
{
return(UserService.CurrentUserRole == role);
}
/// <summary>
/// Saves a user in Repository
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="role"></param>
/// <returns></returns>
public bool Save(string userName, string password, RolesEnum role)
{
return(saveService.Save(userName, password, role));
}
