/// <summary>
/// Handles BtnSignUp click event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSignUp_Click(object sender, EventArgs e)
{
string username = mTxtUsername.Text.Trim();
string fullname = mTxtFullName.Text.Trim();
string email = mTxtEmail.Text.Trim();
#region Input validation
if (username.Length < 1 || fullname.Length < 1 || email.Length < 1 || mTxtDOB.Text.Length < 1 ||
mTxtPwd.Text.Length < 1 || mTxtConfPwd.Text.Length < 1)
{
string error = "Please fill all the fields.";
AlertGenerator.ShowError(error, this);
return;
}
else if (mTxtPwd.Text.Length < 8)
{
string error = "Password must contain at least 8 characters.";
AlertGenerator.ShowError(error, this);
return;
}
else if (mTxtPwd.Text != mTxtConfPwd.Text)
{
string error = "Password and Confirm Password do not match.";
AlertGenerator.ShowError(error, this);
return;
}
#endregion
// Disabling controls while saving the record
DisableEnableControls(false);
Task.Factory.StartNew(() =>
{
if (DbConnector.OpenSQLConnection())
{
// Connection opened
UserDA userDA = new UserDA();
if (userDA.IsUsernameExists(username))
{
string error = "The Username entered already exist.";
RunOnUiThread(() =>
{
//Enabling the controls back
DisableEnableControls(true);
AlertGenerator.ShowError(error, this);
});
}
else
{
byte[] imgBytes = null;
if (mUserImg != null)
{
// Converting the bitmap into a byte array
MemoryStream memStream = new MemoryStream();
mUserImg.Compress(Bitmap.CompressFormat.Webp, 100, memStream);
imgBytes = memStream.ToArray();
}
User user = new User()
{
Username = username,
FullName = fullname,
Email = email,
DOB = DateTime.Parse(mTxtDOB.Text),
Password = CryptoHasher.Hash(mTxtPwd.Text),
Pic = imgBytes
};
DbConnector.CloseSQLConnection(); // Close connection to the database
if (DbConnector.OpenSQLConnection())
{
if (userDA.InsertUser(user))
{
// User was added successfully
// Add a record to leaderboard
PlayerStats stats = new PlayerStats()
{
Username = username,
XP = 0,
SR = 0,
PlayTime = TimeSpan.FromSeconds(0),
Golds = 0,
Silvers = 0,
Bronzes = 0
};
DbConnector.CloseSQLConnection(); // Close connection to the database
PlayerStatsDA statsDA = new PlayerStatsDA();
if (DbConnector.OpenSQLConnection())
{
if (!statsDA.InsertStats(stats))
{
string error = "There was a problem updating your stats.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
// Add achievements
List <AchievementsCompleted> achievementsCompleted = new List <AchievementsCompleted>();
for (int i = 1; i < 20; i++)
{
achievementsCompleted.Add(new AchievementsCompleted()
{
Username = username,
Progress = 0,
Status = false
});
}
DbConnector.CloseSQLConnection(); // Close connection to the database
if (DbConnector.OpenSQLConnection())
{
AchievementsDA achievementsDA = new AchievementsDA();
if (!achievementsDA.InsertAchievements(achievementsCompleted))
{
string error = "There was a problem updating your stats.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
// Navigate to Login activity
Intent intent = new Intent(this, typeof(LoginActivity));
StartActivity(intent);
OverridePendingTransition(Resource.Animation.slide_in_left, Resource.Animation.slide_out_right);
Finish(); // Close this activity
}
else
{
string error = "There was a problem saving the record.";
RunOnUiThread(() =>
{
//Enabling the controls back
DisableEnableControls(true);
AlertGenerator.ShowError(error, this);
});
}
}
else
{
// Connection could not be opened
string error = "Connection to the database could not be established.";
RunOnUiThread(() =>
{
//Enabling the controls back
DisableEnableControls(true);
AlertGenerator.ShowError(error, this);
});
}
}
}
else
{
// Connection could not be opened
string error = "Connection to the database could not be established.";
RunOnUiThread(() =>
{
//Enabling the controls back
DisableEnableControls(true);
AlertGenerator.ShowError(error, this);
});
}
DbConnector.CloseSQLConnection(); // Close connection to the database
});
}
/// <summary>
/// Method for updating player stats and achievements once a puzzle is fixed
/// </summary>
/// <param name="scores"></param>
private void UpdatePlayerStats(PlayerStats scores)
{
if (mUsername != String.Empty)
{
Task.Factory.StartNew(() =>
{
PlayerStats stats = new PlayerStats();
#region Update Player Stats
if (DbConnector.OpenSQLConnection())
{
// Connection opened
PlayerStatsDA statsDA = new PlayerStatsDA();
if (statsDA.IsStatsExist(mUsername))
{
// Stats exist, therefore update
stats = statsDA.FindStats(mUsername);
stats.XP += scores.XP;
stats.SR += scores.SR;
stats.PlayTime += TimeSpan.FromSeconds(mTimeInSeconds);
stats.Golds += scores.Golds;
stats.Silvers += scores.Silvers;
stats.Bronzes += scores.Bronzes;
DbConnector.CloseSQLConnection(); // Close connection to the database
if (DbConnector.OpenSQLConnection())
{
if (!statsDA.UpdateStats(stats))
{
string error = "There was a problem updating your stats.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
else
{
// Connection could not be opened
string error = "Connection to the database could not be established.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
else
{
// Stats does not exist, therefore insert
stats.Username = mUsername;
stats.XP = scores.XP;
stats.SR = scores.SR;
stats.PlayTime = TimeSpan.FromSeconds(mTimeInSeconds);
stats.Golds = scores.Golds;
stats.Silvers = scores.Silvers;
stats.Bronzes = scores.Bronzes;
if (!statsDA.InsertStats(stats))
{
string error = "There was a problem updating your stats.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
}
else
{
// Connection could not be opened
string error = "Connection to the database could not be established.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
DbConnector.CloseSQLConnection(); // Close connection to the database
#endregion
#region Update Achievements
if (DbConnector.OpenSQLConnection())
{
// Connection opened
AchievementsDA achievementsDA = new AchievementsDA();
List <AchievementsCompleted> achievementsCompleted = new List <AchievementsCompleted>();
achievementsCompleted = achievementsDA.GetAllAchievements(mUsername);
DbConnector.CloseSQLConnection(); // Close connection to the database
if (achievementsCompleted != null)
{
// Achievements exist, therefore update
achievementsCompleted = AchievementsTracker.UpdateAchievements(achievementsCompleted, mUsername, stats, mCurrentMode, sCurrentLvl);
for (int i = 0; i < 19; i++)
{
if (achievementsCompleted[i].Title != String.Empty)
{
string title = achievementsCompleted[i].Title;
string description = achievementsCompleted[i].Description;
string image = achievementsCompleted[i].Image;
// Pull up Achievement dialog
FragmentTransaction transaction = FragmentManager.BeginTransaction();
AchDialog dialogFrag = new AchDialog(title, description, image);
dialogFrag.Show(transaction, "dialog fragment");
}
}
if (DbConnector.OpenSQLConnection())
{
if (!achievementsDA.UpdateAchievements(achievementsCompleted))
{
string error = "There was a problem updating your stats.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
else
{
// Connection could not be opened
string error = "Connection to the database could not be established.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
else
{
// Achievements do not exist, therefore insert
achievementsCompleted = AchievementsTracker.InsertAchievements(achievementsCompleted, mUsername, mCurrentMode);
if (DbConnector.OpenSQLConnection())
{
if (!achievementsDA.InsertAchievements(achievementsCompleted))
{
string error = "There was a problem updating your stats.";
RunOnUiThread(() =>
{
AlertGenerator.ShowError(error, this);
});
}
}
}
}
else
{
// Connection could not be opened
string error = "Connection to the database could not be established.";
RunOnUiThread(() =>
{
//Enabling the controls back
AlertGenerator.ShowError(error, this);
});
}
DbConnector.CloseSQLConnection(); // Close connection to the database
#endregion
});
}
}