public override object CommandHandler(SocketMessage socketMessage, string input, CommandArguments arguments)
{
if (string.IsNullOrEmpty(input) || input.Length <= 3)
{
return("Please enter a username to connect to");
}
OsuUser osuUser = OsuApi.GetUser(input);
if (osuUser == null)
{
return("Unable to find any user with this username");
}
InternalUser internalUser = DatabaseManager.Instance.GetUser(socketMessage.Author.Id);
if (string.IsNullOrEmpty(internalUser.OsuUserID))
{
internalUser.OsuUserID = osuUser.ID.ToString();
return("Registered '" + osuUser.Name + "' to your profile, " + socketMessage.Author.Mention);
}
else
{
internalUser.OsuUserID = osuUser.ID.ToString();
return("Changed connection to '" + osuUser.Name + "' on your profile, " + socketMessage.Author.Mention);
}
}
public void AddEditDel_InternalUser(DO_InternalUser objInernalUser, InternalUser flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelInternalUser", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = objInernalUser.UserId;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 200).Value = objInernalUser.FirstName;
cmd.Parameters.Add("@MiddleName", SqlDbType.VarChar, 200).Value = objInernalUser.MiddleName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 200).Value = objInernalUser.LastName;
cmd.Parameters.Add("@Sex", SqlDbType.Bit).Value = objInernalUser.Sex;
cmd.Parameters.Add("@EmailId", SqlDbType.VarChar, 200).Value = objInernalUser.EmailId;
cmd.Parameters.Add("@Password", SqlDbType.VarChar, 200).Value = objInernalUser.Password;
cmd.Parameters.Add("@Address", SqlDbType.VarChar, 500).Value = objInernalUser.Address;
cmd.Parameters.Add("@City", SqlDbType.BigInt).Value = objInernalUser.City;
cmd.Parameters.Add("@State", SqlDbType.BigInt).Value = objInernalUser.State;
cmd.Parameters.Add("@Country", SqlDbType.BigInt).Value = objInernalUser.Country;
cmd.Parameters.Add("@ParentId", SqlDbType.BigInt).Value = objInernalUser.ParentId;
cmd.Parameters.Add("@UserType", SqlDbType.BigInt).Value = objInernalUser.UserType;
cmd.Parameters.Add("@CompanyName", SqlDbType.VarChar, 200).Value = objInernalUser.CompanyName;
cmd.Parameters.Add("@CompannyId", SqlDbType.BigInt).Value = objInernalUser.CompannyId;
cmd.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objInernalUser.AddedBy;
cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar, 50).Value = objInernalUser.IPAddress;
cmd.Parameters.Add("@ZipCode", SqlDbType.VarChar, 50).Value = objInernalUser.ZipCode;
cmd.Parameters.Add("@PhoneNo", SqlDbType.VarChar, 50).Value = objInernalUser.PhoneNo;
cmd.ExecuteNonQuery();
co.CloseConnection(conn);
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new InternalUser
{
UserName = model.Email, Email = model.Email, IfConfirm = false, Name = model.Name, SurName = model.SurName,
RegisterDate = DateTime.Now, EmailAddress = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
return(RedirectToAction("Index", "Advertisements"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
private void SaveUser(InternalUser user)
{
SQLiteConnection conn = GetConnection();
conn.Insert(user);
Close();
}
private async Task AddClaimToUser(IList <Claim> userClaims, Claim claim, InternalUser user)
{
if (!userClaims.Any(c => c.Type == claim.Type && c.Value == claim.Value))
{
await userManager.AddClaimAsync(user.UserId, claim);
}
}
public InternalUserDto Get(string key)
{
InternalUser internalUser = _unitOfWork.InternalUserRepository.FindEntity(x => x.Key == key);
internalUser.ThrowNotFoundIfNull();
return(_mapper.Map <InternalUserDto>(internalUser));
}
public ActionResult Login(LoginCredentials login)
{
/**
* UserGroupId UserGroupName
* 1 Admin
* 2 Parent
* 3 Student
* 4 Teacher
* 5 View
*/
ExternalUserLogin extuser = DA_Login.GetExternalUser(login);
if (extuser != null)
{
if (extuser.Password != login.Password)
{
return(View("Index"));
}
ExternalUserInfo exUserInfo = DA_ExternalUser.GetExternalUserInfo(extuser.ExternalUserInfoID);
Session["CurrentUser"] = exUserInfo;
int userGroupID = DA_ExternalUser.GetExternalUserGroup(extuser.ExternalUserLoginID).UserGroupId;
Session["UserGroupID"] = userGroupID;
if (userGroupID == 3) // student
{
StudentInfo sInfo = DA_Student.GetStudentInfoByLoginID(extuser.ExternalUserLoginID);
return(View("~/Views/Student/Index.cshtml", sInfo));
}
if (userGroupID == 4) // Teacher
{
return(View("~/Views/Teacher/Index.cshtml", exUserInfo));
}
}
else
{
InternalUser interanlUser = DA_Login.GetInternalUser(login);
if (interanlUser != null)
{
if (interanlUser.Password != login.Password)
{
return(View("Index"));
}
Session["CurrentUser"] = interanlUser;
Session["UserGroupID"] = interanlUser.UserGroupId;
}
else
{
return(View("Index"));
}
}
return(View());
}
public InternalUserResponse GetInternalUserInformation(InternalUserLoginRequest internalUserLoginRequest)
{
InternalUser internalUser = _unitOfWork.InternalUserRepository.FindEntity(
x => x.Email == internalUserLoginRequest.Email && x.Password == internalUserLoginRequest.Password);
return(_mapper.Map <InternalUserResponse>(internalUser));
}
public bool IsInRole(string role)
{
UserRoles userRole = role.ParseEnum <UserRoles>(UserRoles.None);
if (IsAuthenticated)
{
return(InternalUser.IsInRole(userRole));
}
return(userRole == UserRoles.None);
}
public static User Map(this InternalUser user)
{
return(new User
{
Department = user.Department,
IsAdmin = user.IsAdmin,
Name = user.Name,
Email = user.Email,
Uid = user.Uid
});
}
public void Delete(InternalUser me, InternalUser followee)
{
var id = $"{me.Id}-{followee.Id}";
if (!IsFollowing(me, followee))
{
throw new ArgumentException("Not following");
}
collection !.Delete(id);
Server.I.UserManager.IncrementFollowingsCount(me, -1);
Server.I.UserManager.IncrementFollowersCount(followee, -1);
}
/// <summary>
/// Saves InternalUser to database
/// </summary>
/// <param name="user"></param>
public void UpdateUser(InternalUser user)
{
if (user.IsNewUser)
{
SaveUser(user);
}
else
{
SQLiteConnection conn = GetConnection();
conn.Update(user);
Close();
}
}
public async Task <Guid> HandleAsync(CreateInternalUser message)
{
var internalUser = new InternalUser(message.UserId,
message.JobTitle,
message.CompetentAuthority,
message.LocalAreaId);
context.InternalUsers.Add(internalUser);
await context.SaveChangesAsync();
return(internalUser.Id);
}
public TicketTests()
{
_nameClientUser = new Name("Felipe", "Machado");
_emailClientUser = new Email("*****@*****.**");
_clientUser = new ClientUser(_nameClientUser, _emailClientUser, 2, "kkhsaoskeeh", "Grupo Mult", "31985988217");
_ticket = new Ticket("00001-0", "title", "Descrição do ticket", ETicketStatusType.Aberta, EPriorityType.Alta, _clientUser);
_nameInternalUser = new Name("Felipe", "Machado");
_emailInternalUser = new Email("*****@*****.**");
_internalUser = new InternalUser(_nameInternalUser, _emailInternalUser, EAccessLevelType.Analista);
_historic = new Historic(_nameInternalUser, _emailInternalUser, "O erro acontece quando eu clino no vai.", EHistoricInteractionType.Interação);
}
public async Task <IActionResult> PostInternalUser([FromBody] InternalUser internalUser)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.InternalUser.Add(internalUser);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetInternalUser", new { id = internalUser.InternalUserId }, internalUser));
}
public IUser Create(InternalUser user)
{
var adb = DatabaseManager.GetDatabaseManager().OpenConnection("sshcity", true);
var rawPassword = user.Password;
user.Password = _passwordHasher.HashPassword(user, rawPassword); // Replace password with hashed version
user.GameId = Guid.NewGuid().ToString(); // Generate a new GameID
user.Token = null; // Ensure null
adb.Document.PostDocumentAsync(
"users",
user
);
return(Authenticate(user.Username, rawPassword));
}
public void Create(string Email, string Password)
{
InternalUser internalUser = _unitOfWork.InternalUserRepository.FindEntity(x => x.Email == Email);
internalUser.ThrowIfNotNull();
var newInternalUser = new InternalUser();
newInternalUser.Password = Password;
newInternalUser.Email = Email;
newInternalUser.IsOrganization = true;
newInternalUser.Status = InternalUserStatus.Enabled;
_unitOfWork.InternalUserRepository.Add(newInternalUser);
_unitOfWork.Complete();
}
public async Task SharedUserNotificationAccess()
{
// Setup.
var notification = NotificationApplicationFactory.Create(Guid.NewGuid(), NotificationType.Recovery,
UKCompetentAuthority.England, 20181);
var aspnetInternalUser = UserFactory.Create(Guid.NewGuid(), "Internal", "Internal Last", "12345",
"*****@*****.**");
var aspnetSharedUser = UserFactory.Create(Guid.NewGuid(), "External", "Shared", "12345",
"*****@*****.**");
var localArea = new LocalArea(Guid.NewGuid(), "Test Area", (int)UKCompetentAuthority.England);
context.NotificationApplications.Add(notification);
context.Users.Add(aspnetInternalUser);
context.Users.Add(aspnetSharedUser);
context.LocalAreas.Add(localArea);
await context.SaveChangesAsync();
var internalUser = new InternalUser(aspnetInternalUser.Id, "test", UKCompetentAuthority.England,
localArea.Id);
var sharedUser = new SharedUser(notification.Id, aspnetSharedUser.Id, DateTimeOffset.Now);
context.InternalUsers.Add(internalUser);
context.SharedUser.Add(sharedUser);
await context.SaveChangesAsync();
// Set the shared user to be the user context.
A.CallTo(() => userContext.UserId).Returns(Guid.Parse(sharedUser.UserId));
var authorization = new NotificationApplicationAuthorization(context, userContext);
// Assert.
// There's no assertion for 'does not throw exception' so just executing it as normal.
await authorization.EnsureAccessAsync(notification.Id);
// Clear data.
context.DeleteOnCommit(internalUser);
context.DeleteOnCommit(sharedUser);
await context.SaveChangesAsync();
context.Entry(aspnetInternalUser).State = EntityState.Deleted;
context.Entry(aspnetSharedUser).State = EntityState.Deleted;
context.Entry(localArea).State = EntityState.Deleted;
await context.SaveChangesAsync();
context.DeleteOnCommit(notification);
await context.SaveChangesAsync();
}
public async Task RandomExternalUserAccessThrowsException()
{
// Setup.
var notification = NotificationApplicationFactory.Create(Guid.NewGuid(), NotificationType.Recovery,
UKCompetentAuthority.England, 20181);
var aspnetInternalUser = UserFactory.Create(Guid.NewGuid(), "Internal", "Internal Last", "12345",
"*****@*****.**");
var aspnetSharedUser = UserFactory.Create(Guid.NewGuid(), "External", "Shared", "12345",
"*****@*****.**");
var localArea = new LocalArea(Guid.NewGuid(), "Test Area", (int)UKCompetentAuthority.England);
context.NotificationApplications.Add(notification);
context.Users.Add(aspnetInternalUser);
context.Users.Add(aspnetSharedUser);
context.LocalAreas.Add(localArea);
await context.SaveChangesAsync();
var internalUser = new InternalUser(aspnetInternalUser.Id, "test", UKCompetentAuthority.England,
localArea.Id);
//Shared user is different to the user context.
var sharedUser = new SharedUser(notification.Id, aspnetSharedUser.Id, DateTimeOffset.Now);
context.SharedUser.Add(sharedUser);
await context.SaveChangesAsync();
context.InternalUsers.Add(internalUser);
await context.SaveChangesAsync();
var authorization = new NotificationApplicationAuthorization(context, userContext);
// Assert.
await Assert.ThrowsAsync <SecurityException>(() => authorization.EnsureAccessAsync(notification.Id));
// Clear data.
context.DeleteOnCommit(internalUser);
context.DeleteOnCommit(sharedUser);
await context.SaveChangesAsync();
context.Entry(aspnetInternalUser).State = EntityState.Deleted;
context.Entry(aspnetSharedUser).State = EntityState.Deleted;
context.Entry(localArea).State = EntityState.Deleted;
await context.SaveChangesAsync();
context.DeleteOnCommit(notification);
await context.SaveChangesAsync();
}
private void SeedUsers(CrudoContext context)
{
if (!context.Users.Any(u => u.UserName == "*****@*****.**"))
{
var store = new UserStore <InternalUser>(context);
var manager = new UserManager <InternalUser>(store);
var user = new InternalUser {
UserName = "******", Name = "Maciek", SurName = "Zietek",
EmailAddress = "*****@*****.**", RegisterDate = DateTime.Now, IfConfirm = true, Email = "*****@*****.**"
};
var adminresult = manager.Create(user, "Maciek12_!");
if (adminresult.Succeeded)
{
manager.AddToRole(user.Id, "Admin");
}
}
}
public ActionResult ScheduledTask(string EntityName, long BizId)
{
var user = new InternalUser();
var MainBiz = new BusinessRule();
List <BusinessRule> businessrules = new List <BusinessRule>();
using (var br = new BusinessRuleContext())
{
var rolebr = br.BusinessRules.Where(p => p.Roles != null && p.Roles.Length > 0 && !p.Disable).ToList();
MainBiz = rolebr.FirstOrDefault(p => p.Id == BizId);
foreach (var rules in rolebr)
{
if (rules.Roles.Split(",".ToCharArray()).Contains("All"))
{
businessrules.Add(rules);
}
}
}
if (MainBiz != null)
{
(user).businessrules = businessrules.ToList();
var database = new ApplicationContext(user, 0);
var myType = Type.GetType("GeneratorBase.MVC.Models." + EntityName + "");
//var data = GetGenericData(database, myType).ToListAsync();
//foreach (var item in data.Result)
var data = GetTableObject(database, EntityName);
var dataList = (IQueryable <object>)data;
foreach (var item in dataList.ToList())
{
if (ApplyRule.CheckRule <object>(item, MainBiz, MainBiz.EntityName))
{
database.Entry(item).State = EntityState.Modified;
database.SaveChanges();
}
}
ScheduledTaskHistoryContext sthcontext = new ScheduledTaskHistoryContext();
var itemhistory = sthcontext.ScheduledTaskHistorys.FirstOrDefault(p => p.BusinessRuleId == MainBiz.Id);
itemhistory.Status = "Processed";
sthcontext.Entry(itemhistory).State = EntityState.Modified;
sthcontext.SaveChanges();
RegisterScheduledTask nexttask = new RegisterScheduledTask();
nexttask.RegisterTask(MainBiz.EntityName, MainBiz.Id);
}
return(Json("Success", "application/json", System.Text.Encoding.UTF8, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> UsernameLogin([FromBody] UsernameLoginDTO userIn)
{
InternalUser result = await authRepo.UsernameLogin(userIn.username, userIn.password);
if (!result.success)
{
return(BadRequest(result));
}
string token = JWTHelper.GenerateToken(result.email, result.username, SECRET_KEY, EXPIRE_TIME);
return(Ok(new UserOutDTO
{
Username = result.username,
Email = result.email,
JwtToken = token,
success = true
}));
}
public async Task <IActionResult> GoogleLogin([FromBody] string token)
{
InternalUser result = await authRepo.GoogleLogin(token);
if (!result.success)
{
return(BadRequest(result));
}
string jwt = JWTHelper.GenerateToken(result.email, result.username, SECRET_KEY, EXPIRE_TIME);
return(Ok(new UserOutDTO
{
Username = result.username,
Email = result.email,
JwtToken = jwt,
success = true
}));
}
public static UserGroup Login(LoginCredentials login)
{
using (var smsDB = new SMSEntities())
{
ExternalUserLogin extuser = smsDB.ExternalUserLogins.FirstOrDefault(m => m.ExternalUserName == login.Username);
if (extuser != null)
{
var tmp = smsDB.ExternalUserLogin_UserGroup_Mapping.FirstOrDefault(m => m.ExternalUserLoginID == extuser.ExternalUserLoginID);
return(tmp.UserGroup);
}
InternalUser interanlUser = smsDB.InternalUsers.FirstOrDefault(m => m.UserName == login.Username);
if (interanlUser != null)
{
return(interanlUser.UserGroup);
}
}
return(null);
}
protected void ApplyPlayer(ulong DiscordID, string input)
{
_osuUser = null;
if (string.IsNullOrEmpty(input))
{
InternalUser internalUser = DatabaseManager.Instance.GetUser(DiscordID);
if (!string.IsNullOrEmpty(internalUser.OsuUserID))
{
_osuUser = OsuApi.GetUser(internalUser.OsuUserID, _osuMode);
}
}
if (_osuUser == null)
{
string username = HttpUtility.HtmlEncode(input); // Test value
_osuUser = OsuApi.GetUser(username, _osuMode);
}
}
public void Create(InternalUser me, InternalUser followee)
{
var id = $"{me.Id}-{followee.Id}";
if (IsFollowing(me, followee))
{
throw new ArgumentException("Already following");
}
collection !.Insert(new Following
{
Id = id,
followerId = me.Id,
followeeId = followee.Id,
});
Server.I.UserManager.IncrementFollowingsCount(me);
Server.I.UserManager.IncrementFollowersCount(followee);
}
public DataTable GetDataTableInternalUser(DO_InternalUser objInernalUser, InternalUser flag)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_AddEditDelInternalUser", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@UserId", SqlDbType.BigInt).Value = objInernalUser.UserId;
da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objInernalUser.AddedBy;
da.SelectCommand.Parameters.Add("@ParentId", SqlDbType.BigInt).Value = objInernalUser.ParentId;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
/// <summary>
/// Gets all the users from the database
/// </summary>
public InternalUser GetUser(ulong DiscordID)
{
InternalUser user = InternalUserManager.Instance.GetUser(DiscordID);
if (user != null)
{
return(user);
}
SQLiteConnection conn = GetConnection();
string query = $"SELECT * FROM users WHERE discord_id=" + DiscordID;
user = QueryFirstResult <InternalUser>(conn, query);
Close();
if (user != null)
{
return(user);
}
return(null);
}
public void SerializeUser()
{
User user = new User
{
UserName = "******",
LinkedId = "535295d3a7981501ccda7aba",
Role = UserRole.PowerUser,
Status = Status.Active,
Password = "******".HashPassword()
};
string serializeObject = JsonConvert.SerializeObject(user);
InternalUser internalUser = new InternalUser
{
CommunicationDetails = new List <CommunicationDetail>
{
new CommunicationDetail
{
CommunicationType = CommunicationType.Email,
IsPreferred = true,
Uri = "*****@*****.**"
},
},
FirstName = "Shanmukhi",
LastName = "Goli",
Salutation = Salutation.Mr,
Status = Status.Active,
};
serializeObject = JsonConvert.SerializeObject(internalUser);
user = new User
{
UserName = "******",
LinkedId = "535295d3a7981501ccda7aba",
Role = UserRole.Marketing,
Status = Status.Active,
Password = "******".HashPassword()
};
serializeObject = JsonConvert.SerializeObject(user);
}
public async Task InternalUserDifferentCompetentAuthorityAccessThrowsException()
{
// Setup.
var notification = NotificationApplicationFactory.Create(Guid.NewGuid(), NotificationType.Recovery,
UKCompetentAuthority.England, 20181);
var aspnetInternalUser = UserFactory.Create(Guid.NewGuid(), "Internal", "Internal Last", "12345",
"*****@*****.**");
var localArea = new LocalArea(Guid.NewGuid(), "Test Area", (int)UKCompetentAuthority.England);
context.NotificationApplications.Add(notification);
context.Users.Add(aspnetInternalUser);
context.LocalAreas.Add(localArea);
await context.SaveChangesAsync();
// Internal user is different UKCA from the notification - should cause the exception.
var internalUser = new InternalUser(aspnetInternalUser.Id, "test", UKCompetentAuthority.Wales,
localArea.Id);
context.InternalUsers.Add(internalUser);
await context.SaveChangesAsync();
A.CallTo(() => userContext.UserId).Returns(Guid.Parse(internalUser.UserId));
var authorization = new NotificationApplicationAuthorization(context, userContext);
// Assert.
await Assert.ThrowsAsync <SecurityException>(() => authorization.EnsureAccessAsync(notification.Id));
// Clear data.
context.DeleteOnCommit(internalUser);
await context.SaveChangesAsync();
context.Entry(aspnetInternalUser).State = EntityState.Deleted;
context.Entry(localArea).State = EntityState.Deleted;
await context.SaveChangesAsync();
context.DeleteOnCommit(notification);
await context.SaveChangesAsync();
}
public void SerializeUser()
{
User user = new User
{
UserName = "******",
LinkedId = "535295d3a7981501ccda7aba",
Role = UserRole.PowerUser,
Status = Status.Active,
Password = "******".HashPassword()
};
string serializeObject = JsonConvert.SerializeObject(user);
InternalUser internalUser = new InternalUser
{
CommunicationDetails = new List<CommunicationDetail>
{
new CommunicationDetail
{
CommunicationType = CommunicationType.Email,
IsPreferred = true,
Uri = "*****@*****.**"
},
},
FirstName = "Shanmukhi",
LastName = "Goli",
Salutation = Salutation.Mr,
Status = Status.Active,
};
serializeObject = JsonConvert.SerializeObject(internalUser);
user = new User
{
UserName = "******",
LinkedId = "535295d3a7981501ccda7aba",
Role = UserRole.Marketing,
Status = Status.Active,
Password = "******".HashPassword()
};
serializeObject = JsonConvert.SerializeObject(user);
}