// Attempt to add a recruit into tblRecruit
protected void btnAddRecruit_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
// Retrieve data entered by the user into the form inputs
var firstName = txtBoxFirstName.Text.Trim();
var lastName = txtBoxLastName.Text.Trim();
var contactNumber = txtBoxPhoneNumber.Text.Trim();
var emailAddress = txtBoxEmailAddress.Text.Trim();
var birthYear = Convert.ToInt32(txtBoxBirthYear.Text.Trim());
var graduationYear = Convert.ToInt32(txtBoxGradYear.Text.Trim());
var currentTeam = txtBoxCurrentTeam.Text.Trim();
var jerseyNumber = Convert.ToInt32(txtBoxJerseyNumber.Text.Trim());
var position = dropdownPosition.SelectedItem.Text.Trim();
var mothersName = txtBoxMothersName.Text.Trim();
var fathersName = txtBoxFathersName.Text.Trim();
var recruitStatus = dropdownStatus.SelectedItem.Text.Trim();
var dateAdded = Convert.ToString(DateTime.Today);
// Attempt to add a recruit to the database from the data entered by the user into the form
var addRecruit = ConnectionClass.AddRecruit(firstName, lastName, contactNumber, emailAddress, birthYear, graduationYear, currentTeam, jerseyNumber, position, mothersName, fathersName, recruitStatus, dateAdded);
// Display different messages to the user to let them know whether the recruit was added to the database successfully
if (addRecruit)
{
lblAddRecruitError.Text = "Recruit Added Successfuly!";
lblAddRecruitError.Visible = true;
}
else
{
lblAddRecruitError.Visible = true;
}
}
lblAddRecruitError.Visible = true;
}
catch (Exception ex)
{
lblAddRecruitError.Text = ex.Message;
lblAddRecruitError.Visible = true;
}
}
// 11/23/18 Minseok Choi
// retrieve user inputs for adding a scouting report and add a new report in the database
protected void btnAddScoutingReport_Click(object sender, EventArgs e)
{
try
{
// Check to make sure form passes all validation checks
if (Page.IsValid)
{
// get values from session
string recruitId = Request.QueryString["id"];
string accountId = Session["userId"].ToString();
// Retrieve user inputs
string skating = dropdownSkating.SelectedValue;
string individualOffesiveSkills = dropdownIndividualOffesiveSkills.SelectedValue;
string individualDefensiveSkills = dropdownIndividualDefensiveSkills.SelectedValue;
string offensiveTeamPlay = dropdownOffensiveTeamPlay.SelectedValue;
string defensiveTeamPlay = dropdownDefensiveTeamPlay.SelectedValue;
string hockeySense = dropdownHockeySense.SelectedValue;
string strengthPower = dropdownStrengthPower.SelectedValue;
string workEthic = dropdownWorkEthic.Text.Trim();
string overallRanking = dropdownOverallRanking.Text.Trim();
string notes = txtNotes.Text.Trim();
// Connect to the database and attempt to add new scouting report
bool addPlayerScoutingReport = ConnectionClass.AddPlayerScoutingReport(
recruitId, accountId, skating, individualOffesiveSkills, individualDefensiveSkills, offensiveTeamPlay,
defensiveTeamPlay, hockeySense, strengthPower, workEthic, overallRanking, notes);
// If adding a scouting report is successful redirect user to the account list page
if (addPlayerScoutingReport)
{
Response.Redirect("Recruits.aspx"); // todo change temporal url
}
// If adding an scouting report is not successful display failed message to the suer
else
{
lblAddScoutingReportError.Visible = true;
}
}
}
catch (Exception ex)
{
lblAddScoutingReportError.Visible = true;
lblAddScoutingReportError.Text = ex.Message;
}
}
protected void ListViewAccounts_ItemCommand(object sender, ListViewCommandEventArgs e)
{
isAdmin();
string accountID = e.CommandArgument.ToString();
if (e.CommandName == "updateAccount")
{
Session["accountID"] = accountID;
Response.Redirect("UpdateAccount.aspx");
}
else if (e.CommandName == "deleteAccount")
{
ConnectionClass.DeleteAccount(accountID);
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Only work when the page is initialized
if (!IsPostBack)
{
if (Session["username"] == null)
{
Response.Redirect("Default.aspx");
}
lblLoggedInUser.Text = "Welcome, " + Session["username"];
lblEditRecruitError.Visible = false;
lblEditRecruitError.CssClass = "alert alert-danger small font-weight-bold text-center";
int id = Convert.ToInt32(Request.QueryString["id"]);
//load selected recruit information as the hint of the textboxes through a RecruitClass object.
RecruitClass recruit = ConnectionClass.DisplayRecruit(id);
//txtBoxFirstName.Attributes.Add("placeholder",recruit.FirstName);
//txtBoxLastName.Attributes.Add("placeholder", recruit.LastName);
//txtBoxPhoneNumber.Attributes.Add("placeholder", recruit.ContactNumber);
//txtBoxEmailAddress.Attributes.Add("placeholder", recruit.EmailAddress);
//txtBoxBirthYear.Attributes.Add("placeholder", recruit.Birthyear.ToString());
//txtBoxGradYear.Attributes.Add("placeholder", recruit.GraduationYear.ToString());
//txtBoxCurrentTeam.Attributes.Add("placeholder", recruit.CurrentTeam);
//txtBoxJerseyNumber.Attributes.Add("placeholder", recruit.JerseyNumber.ToString());
//txtBoxMothersName.Attributes.Add("placeholder", recruit.MothersName);
//txtBoxFathersName.Attributes.Add("placeholder", recruit.FathersName);
//Added by Ryan Watson 11-22-18
txtBoxFirstName.Text = recruit.FirstName;
txtBoxLastName.Text = recruit.LastName;
txtBoxPhoneNumber.Text = recruit.ContactNumber;
txtBoxEmailAddress.Text = recruit.EmailAddress;
txtBoxBirthYear.Text = recruit.Birthyear.ToString();
txtBoxGradYear.Text = recruit.GraduationYear.ToString();
txtBoxCurrentTeam.Text = recruit.CurrentTeam;
txtBoxJerseyNumber.Text = recruit.JerseyNumber.ToString();
//txtBoxPosition.Text = recruit.Position.ToString();
txtBoxMothersName.Text = recruit.MothersName;
txtBoxFathersName.Text = recruit.FathersName;
//txtBoxStatus.Text = recruit.Status.ToString();
}
}
// 11/23/18 Minseok Choi
// retrieve user inputs for adding a scouting report and add a new report in the database
protected void btnAddScoutingReport_Click(object sender, EventArgs e)
{
try
{
// Check to make sure form passes all validation checks
if (Page.IsValid)
{
// get values from session
string recruitId = Request.QueryString["id"];
string accountId = Session["userId"].ToString();
// Retrieve user inputs
string skating = dropdownSkating.SelectedValue;
string agilitySpeed = dropdownAgilitySpeed.SelectedValue;
string trafficReboundControl = dropdownTrafficReboundControl.SelectedValue;
string hockeySense = dropdownHockeySense.SelectedValue;
string strengthFitness = dropdownStrengthFitness.SelectedValue;
string mentalToughness = dropdownMentalToughness.SelectedValue;
string battleMentality = dropdownBattleMentality.SelectedValue;
string overallRanking = dropdownOverallRanking.Text.Trim();
string notes = txtNotes.Text.Trim();
// Connect to the database and attempt to add new scouting report
bool addGoalieScoutingReport = ConnectionClass.AddGoalieScoutingReport(
recruitId, accountId, skating, agilitySpeed, trafficReboundControl, hockeySense, strengthFitness,
mentalToughness, battleMentality, overallRanking, notes);
// If adding a scouting report is successful redirect user to the account list page
if (addGoalieScoutingReport)
{
Response.Redirect("Recruits.aspx"); // todo change temporal url
}
// If adding an scouting report is not successful display failed message to the suer
else
{
lblAddScoutingReportError.Visible = true;
}
}
}
catch (Exception ex)
{
lblAddScoutingReportError.Visible = true;
lblAddScoutingReportError.Text = ex.Message;
}
}
// 11/08/18_Heeyeong Kim
protected void btnSearch_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var listViewRecruit = ListViewRecruits;
// Retrieve data entered by the user into the form inputs
var name = txtBoxName.Text.Trim();
var birthYear = dropdownBirthYear.SelectedItem.Text.Trim();
var position = dropdownPosition.SelectedItem.Text.Trim();
if (birthYear.Equals("--Select--"))
{
birthYear = null;
}
int birth = Convert.ToInt32(birthYear);
if (!name.Equals("") && !Regex.IsMatch(name, @"^[a-zA-Z]+$"))
{
lblSearchRecruitError.Text = "Uppercase and lowercase letters only";
lblSearchRecruitError.Visible = true;
listViewRecruit.DataSource = null;
listViewRecruit.DataBind();
return;
}
// Call SearchRecruits and retrieve data from database
DataTable dt = ConnectionClass.SearchRecruits(name, birth, position);
// If there is no result, error message shows up
if (dt != null)
{
if (dt.Rows.Count == 0)
{
lblSearchRecruitError.Text = "Recruit Not Found";
lblSearchRecruitError.Visible = true;
}
listViewRecruit.DataSource = dt;
listViewRecruit.DataBind();
}
}
}
protected void BtnEditReport_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
string reportId = Request.QueryString["id"];
// Retrieve user inputs
string skating = dropdownSkating.SelectedValue;
string individualOffesiveSkills = dropdownIndividualOffesiveSkills.SelectedValue;
string individualDefensiveSkills = dropdownIndividualDefensiveSkills.SelectedValue;
string offensiveTeamPlay = dropdownOffensiveTeamPlay.SelectedValue;
string defensiveTeamPlay = dropdownDefensiveTeamPlay.SelectedValue;
string hockeySense = dropdownHockeySense.SelectedValue;
string strengthPower = dropdownStrengthPower.SelectedValue;
string workEthic = dropdownWorkEthic.Text.Trim();
string overallRanking = dropdownOverallRanking.Text.Trim();
string notes = txtNotes.Text.Trim();
bool editPlayerScoutingReport = ConnectionClass.EditPlayerScoutingReport(
reportId, skating, individualOffesiveSkills, individualDefensiveSkills, offensiveTeamPlay,
defensiveTeamPlay, hockeySense, strengthPower, workEthic, overallRanking, notes);
if (editPlayerScoutingReport)
{
lblEditReportError.CssClass = "alert alert-success";
lblEditReportError.Text = "Player Report Edited Successfully!";
lblEditReportError.Visible = true;
}
else
{
lblEditReportError.Visible = true;
}
}
}
catch (Exception ex)
{
lblEditReportError.Text += "\n" + ex.Message;
lblEditReportError.Visible = true;
}
}
//Gabriele 25/11/18
//UPDATE: Gabriele 4/12/18 - to also delete scouting reports for all recruits when applicable
protected void BtnDelete_Click(object sender, EventArgs e)
{
string recruitID = Request.QueryString["id"];
RecruitClass recruit = ConnectionClass.GetRecruit(Convert.ToInt32(recruitID));
string position = recruit.Position;
try
{
ConnectionClass.DeleteReport(recruitID, position);
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionClass.DeleteRecruit(recruitID);
Response.Redirect("Recruits.aspx");
}
}
protected void BtnEditReport_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
string reportId = Request.QueryString["id"];
// Retrieve user inputs
var skating = dropdownSkating.SelectedValue;
var agilitySpeed = dropdownAgilitySpeed.SelectedValue;
var trafficReboundControl = dropdownTrafficReboundControl.SelectedValue;
var hockeySense = dropdownHockeySense.SelectedValue;
var strengthFitness = dropdownStrengthFitness.SelectedValue;
var mentalToughness = dropdownMentalToughness.SelectedValue;
var battleMentality = dropdownBattleMentality.SelectedValue;
var overallRanking = dropdownOverallRanking.Text.Trim();
var notes = txtNotes.Text.Trim();
// Connect to the database and attempt to add new scouting report
bool editGoalieScoutingReport = ConnectionClass.EditGoalieReport(reportId,
skating, agilitySpeed, trafficReboundControl, hockeySense, strengthFitness,
mentalToughness, battleMentality, overallRanking, notes);
if (editGoalieScoutingReport)
{
lblEditReportError.CssClass = "alert alert-success";
lblEditReportError.Text = "Goalie Report Edited Successfully!";
lblEditReportError.Visible = true;
}
else
{
lblEditReportError.Visible = true;
}
}
}
catch (Exception ex)
{
lblEditReportError.Text += ex.Message;
lblEditReportError.Visible = true;
}
}
// 11/23/18 Minseok Choi
protected void Page_Load(object sender, EventArgs e)
{
// get recruitId from url param
string recruitId = Request.QueryString["id"];
// check username, recruitId and accountType valid
if (Session["username"] == null || String.IsNullOrEmpty(recruitId) ||
Session["accountType"] == null ||
!(Session["accountType"].ToString() == AccountType.Coach.ToString() ||
Session["accountType"].ToString() == AccountType.Scout.ToString()))
{
Response.Redirect("Recruits.aspx");
}
lblLoggedInUser.Text = "Welcome, " + Session["username"];
lblAddScoutingReportError.Visible = false;
// set values in the name labels
ConnectionClass.GetRecruitName(recruitId, out string firstName, out string lastName);
lblRecruitIDData.Text = recruitId;
lblFirstNameData.Text = firstName;
lblLastNameData.Text = lastName;
}
protected void btnUpdateAccount_Click(object sender, EventArgs e)
{
try
{
// Check to make sure form passes all validation checks
if (Page.IsValid)
{
isAdmin();
// Retrieve user inputs from username, password, and email address textboxes
var accountID = lblAccountID.Text.Trim();
var username = txtUsername.Text.Trim();
var password = txtPassword.Text.Trim();
var emailAddress = txtEmailAddress.Text.Trim();
var sAccountType = ddlAccountType.SelectedValue;
AccountType accountType = Utility.ConvertStringToAccountType(sAccountType);
// Connect to the database and attempt to add new user to the tblStaffAccount
var updateAccount = ConnectionClass.UpdateAccount(accountID, username, password, emailAddress, accountType);
// If adding an account is successful redirect user to the account list page
if (updateAccount)
{
Response.Redirect("Accounts.aspx");
}
// If adding an account is not successful display failed message to the suer
else
{
lblUpdateAccountError.Visible = true;
}
}
}
catch (Exception ex)
{
lblUpdateAccountError.Visible = true;
lblUpdateAccountError.Text = ex.Message;
}
}
// 25/11/18 Gabriele //Updated to master
//UPDATE: Gabriele 4/12/18 - to also delete scouting reports for all recruits when applicable
protected void ListViewRecruits_deleteRecruit(object sender, ListViewCommandEventArgs e)
{
string recruitID = e.CommandArgument.ToString();
RecruitClass recruit = ConnectionClass.GetRecruit(Convert.ToInt32(recruitID));
string position = recruit.Position;
try
{
ConnectionClass.DeleteReport(recruitID, position);
}
catch (Exception ex)
{
throw;
}
finally
{
if (e.CommandName == "deleteRecruit")
{
ConnectionClass.DeleteRecruit(recruitID);
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
}