public UsersConnection makeConnection(int Id, int VoicerID, string type)
{
var connection = _usersConnectionRepository.FirstOrDefault(x => x.UserId == Id && x.User1.Id == VoicerID, x => x, null);
if (connection != null)
{
if (connection.Type != type)
{
connection.Type = type;
connection.DateConnected = DateTime.Now;
if (connection.DateRequest == null)
{
connection.DateRequest = DateTime.Now;
}
}
}
else
{
connection = new UsersConnection()
{
UserId = Id,
ConnectedUserId = VoicerID,
DateConnected = DateTime.Now,
DateRequest = DateTime.Now,
Type = type
};
}
return(connection);
}
public bool UnbanUser(UsersConnection usersConnection)
{
UsersConnectionDb usersConnection_newTyped = mapper.Map(usersConnection);
bool isUnbanned = userConnectionsDAO.UnbanUser(usersConnection_newTyped);
return(isUnbanned);
}
public bool Unsubscribe(UsersConnection usersConnection)
{
UsersConnectionDb usersConnection_newTyped = mapper.Map(usersConnection);
bool isUnsubscribed = userConnectionsDAO.Unsubscribe(usersConnection_newTyped);
return(isUnsubscribed);
}
public bool CreateSubscription(UsersConnection userConnections)
{
UsersConnectionDb userConnections_newType = mapper.Map(userConnections);
bool isCreated = (userConnectionsDAO.CreateConnection(userConnections_newType) == true);
return(isCreated);
}
public IActionResult Unsubscribe(long userId)
{
string subscriberToken = Request.GetUserToken();
UsersConnection usersConnection = userConnectionService.CreateConnection(userId, subscriberToken);
bool isUnsubscribed = userConnectionsRepository.Unsubscribe(usersConnection);
return(Ok(isUnsubscribed));
}
/**
* <summary>
* This method gets the users from the database
* </summary>
* @method GetUsers
* @return {void}
* */
protected void GetUsers()
{
using (UsersConnection db = new UsersConnection())
{
var Users = (from users in db.AspNetUsers
select users);
UsersGridView.DataSource = Users.ToList();
UsersGridView.DataBind();
}
}
/**
* <summary>
* This method saves a new user to the database
* </summary>
* @method SaveButton_Click
* @return {void}
* */
protected void SaveButton_Click(object sender, EventArgs e)
{
string UserID = "";
//if updating user
if (Request.QueryString.Count > 0)
{
using (UsersConnection db = new UsersConnection())
{
AspNetUser newUser = new AspNetUser();
UserID = Request.QueryString["Id"].ToString();
newUser = (from users in db.AspNetUsers
where users.Id == UserID
select users).FirstOrDefault();
newUser.UserName = UserNameTextBox.Text;
newUser.PhoneNumber = PhoneNumberTextBox.Text;
newUser.Email = EmailTextBox.Text;
db.SaveChanges();
Response.Redirect("~/Admin/AdminUsers.aspx");
}
}
//if creating a new user
if (UserID == "")
{
// create new userStore and userManager objects
var userStore = new UserStore <IdentityUser>();
var userManager = new UserManager <IdentityUser>(userStore);
//create a new user object
var user = new IdentityUser()
{
UserName = UserNameTextBox.Text,
PhoneNumber = PhoneNumberTextBox.Text,
Email = EmailTextBox.Text
};
//create new user on db and store the result
IdentityResult result = userManager.Create(user, PasswordTextBox.Text);
//check if successfully registered
if (result.Succeeded)
{
Response.Redirect("~/Admin/AdminUsers.aspx");
}
else
{
StatusLabel.Text = result.Errors.FirstOrDefault();
AlertFlash.Visible = true;
}
}
}
public IActionResult Ban(long bannedUserId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string userToken = Request.GetUserToken();
UsersConnection usersConnection = userConnectionService.CreateConnection(userToken, bannedUserId, ban: true);
bool isBanned = userConnectionsRepository.BanUser(usersConnection);
return(Ok(isBanned));
}
public IActionResult Subscribe(long userId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string subscriberToken = Request.GetUserToken();
UsersConnection usersConnection = userConnectionService.CreateConnection(userId, subscriberToken);
bool isSubscribed = userConnectionsRepository.CreateSubscription(usersConnection);
return(Ok(isSubscribed));
}
public UsersConnection CreateConnection(string userToken, long subscriberId, bool ban = false)
{
User subscriber = new User()
{
Id = subscriberId
};
User user = userRepository.GetByJWToken(userToken);
UsersConnection userConnection = new UsersConnection()
{
User1 = user, User2 = subscriber, BlackListed = ban
};
return(userConnection);
}
/**
* <summary>
* This method gets the user from the database
* </summary>
* @method GetUsers
* @return {void}
* */
protected void GetUser()
{
string UserID = Request.QueryString["Id"].ToString();
using (UsersConnection db = new UsersConnection())
{
AspNetUser updatedUser = (from user in db.AspNetUsers
where user.Id == UserID
select user).FirstOrDefault();
if (updatedUser != null)
{
UserNameTextBox.Text = updatedUser.UserName;
PhoneNumberTextBox.Text = updatedUser.PhoneNumber;
EmailTextBox.Text = updatedUser.Email;
}
}
}
/**
* <summary>
* This method gets the user from the database and populates the fields
* </summary>
* @method GetUser
* @return {void}
* */
protected void GetUser()
{
string UserID = (HttpContext.Current.User.Identity.GetUserId().ToString());
using (UsersConnection db = new UsersConnection())
{
AspNetUser updatedUser = (from user in db.AspNetUsers
where user.Id == UserID
select user).FirstOrDefault();
if (updatedUser != null)
{
UserNameTextBox.Text = updatedUser.UserName;
PhoneNumberTextBox.Text = updatedUser.PhoneNumber;
EmailTextBox.Text = updatedUser.Email;
}
}
}
public UsersConnectionDb Map(UsersConnection userConnection)
{
UsersConnectionDb userConnection_newType = new UsersConnectionDb();
#region Transfer main attributes
userConnection_newType.Id = userConnection.Id;
userConnection_newType.IdUser1 = userConnection.User1.Id;
userConnection_newType.IdUser2 = userConnection.User2.Id;
userConnection_newType.AreFriends = userConnection.AreFriends;
userConnection_newType.BlackListed = userConnection.BlackListed;
#endregion
return(userConnection_newType);
}
public async Task Handle(RequestUserConnectionCommand command)
{
await using var context = contextFactory.GetContext();
var requestedUser = await context.Users.SingleOrDefaultAsync(u => u.Username == command.RequestedUsername);
await Validate(command, context, requestedUser);
var connection = new UsersConnection()
{
UserRequestedToConnectId = requestedUser.Id,
UserRequestingConnectionId = command.UserId
};
await context.AddAsync(connection);
await context.SaveChangesAsync();
}
/**
* <summary>
* This method deletes a user from the database
* </summary>
* @method UsersGridView_RowDeleting
* @return {void}
* */
protected void UsersGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int selectedRow = e.RowIndex;
string UserID = UsersGridView.DataKeys[selectedRow].Values["Id"].ToString();
using (UsersConnection db = new UsersConnection())
{
AspNetUser deletedUser = (from users in db.AspNetUsers
where users.Id == UserID
select users).FirstOrDefault();
db.AspNetUsers.Remove(deletedUser);
db.SaveChanges();
}
//refresh user gridview
this.GetUsers();
}
public IActionResult Unban(long bannedUserId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string userToken = Request.GetUserToken();
UsersConnection usersConnection = userConnectionService.CreateConnection(userToken, bannedUserId, ban: false);
if (usersConnection.User1.Id == usersConnection.User2.Id)
{
return(BadRequest());
}
bool isUnbanned = userConnectionsRepository.UnbanUser(usersConnection);
return(Ok(isUnbanned));
}
/**
* <summary>
* This method saves the changed information of the user to the database
* </summary>
* @method SaveButton_Click
* @return {void}
* */
protected void SaveButton_Click(object sender, EventArgs e)
{
string UserID = (HttpContext.Current.User.Identity.GetUserId().ToString());
using (UsersConnection db = new UsersConnection())
{
AspNetUser newUser = new AspNetUser();
newUser = (from users in db.AspNetUsers
where users.Id == UserID
select users).FirstOrDefault();
newUser.UserName = UserNameTextBox.Text;
newUser.PhoneNumber = PhoneNumberTextBox.Text;
newUser.Email = EmailTextBox.Text;
db.SaveChanges();
Response.Redirect("~/Default.aspx");
}
}
public UserService(MySqlConnection conn)
{
_usersConnection = new UsersConnection(conn);
_userAccessConnection = new UserAccessConnection(conn);
}
