public ActionResult ManagePlayerApplication(PlayerApplication Player, string Coaches, Guid id)//id = PlayerApplicationID
{
RegistrarAccessRepository rep = new RegistrarAccessRepository();
try
{
Player.ID = id;
bool isUpdated = rep.UpdatePlayer(Player, Coaches);
if (isUpdated)
{
ViewData["Message"] = "Player application updated successfully!";
}
else
{
ViewData["Message"] = "There was an error updating this player application. Please contact your administrator!";
}
return(View("ManagePlayerApplication", null));
}
catch (Exception e)
{
}
return(View("ManagePlayerApplication"));
}
public List <PlayerApplication> GetAllPlayers()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetAllPlayerApplicationsForRegistrar";
try
{
cmd.Connection.Open();
DataTable dt = new DataTable();
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
dataAdapter.Fill(dt);
cmd.Connection.Close();
List <PlayerApplication> players = new List <PlayerApplication>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Person person = new Person(Guid.Parse(dt.Rows[i]["PersonID"].ToString()));
person.LastName = dt.Rows[i]["LastName"].ToString();
person.FirstName = dt.Rows[i]["FirstName"].ToString();
PlayerApplication player = new PlayerApplication(Guid.Parse(dt.Rows[i]["PlayerAppID"].ToString()), person);
player.BirthDate = DateTime.Parse(dt.Rows[i]["BirthDate"].ToString());
player.RegistrationDate = DateTime.Parse(dt.Rows[i]["RegistrationDate"].ToString());
player.Paid = (bool)dt.Rows[i]["Paid"];
if (Convert.IsDBNull(dt.Rows[i]["CoachID"]))
{
player.Coach = null;
}
else
{
Person coach = new Person(Guid.Parse(dt.Rows[i]["CoachID"].ToString()));
player.Coach = coach;
}
players.Add(player);
}
return(players);
// return ConvertToList<Person>(dt);
}
catch (Exception e)
{
cmd.Connection.Close();
}
return(null);
}
//TODO: The Guardian1 ,and Guardian2 may use the same address with the Player, modifed it to support it
public bool UpdatePlayer(PlayerApplication Player, string Coaches)
{
UserAccessRepository rep = new UserAccessRepository();
rep.UpdatePerson(Player.Player);
rep.UpdatePerson(Player.Guardian1);
rep.UpdatePerson(Player.Guardian2);
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdatePlayer";
cmd.Parameters.Add(new SqlParameter("@playerApplicationID", SqlDbType.UniqueIdentifier)).Value = Player.ID;
cmd.Parameters.Add(new SqlParameter("@bcMedicalNumber", SqlDbType.VarChar, 10)).Value = Player.BCMedicalNumber;
cmd.Parameters.Add(new SqlParameter("@birthDate", SqlDbType.DateTime)).Value = Player.BirthDate;
cmd.Parameters.Add(new SqlParameter("@gender", SqlDbType.Char)).Value = Player.Gender;
cmd.Parameters.Add(new SqlParameter("@medicalNotes", SqlDbType.VarChar, 200)).Value = (Player.MedicalAlert == null) ? DBNull.Value.ToString() : Player.MedicalAlert;
cmd.Parameters.Add(new SqlParameter("@paid", SqlDbType.Bit)).Value = Player.Paid ? 1 : 0;
cmd.Parameters.Add(new SqlParameter("@payment", SqlDbType.Money)).Value = Player.Payment;
cmd.Parameters.Add(new SqlParameter("@previousTeam", SqlDbType.VarChar, 50)).Value = (Player.PreviousTeam == null) ? DBNull.Value.ToString() : Player.PreviousTeam;
cmd.Parameters.Add(new SqlParameter("@school", SqlDbType.VarChar, 50)).Value = Player.School;
if (!IsValidGUID(Coaches) || Coaches == "")
{
cmd.Parameters.Add(new SqlParameter("@coach_id", SqlDbType.UniqueIdentifier)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@coach_id", SqlDbType.UniqueIdentifier)).Value = Guid.Parse(Coaches);
}
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception e)
{
cmd.Connection.Close();
return(false);
}
return(true);
}
public List <PlayerApplication> GetUnassignedPlayers(Guid CoachID)
{
List <PlayerApplication> applications = null;
SqlCommand cmd = new SqlCommand("GetCoachUnassignedPlayers", new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString));
SqlParameter param = new SqlParameter("@coach_id", SqlDbType.UniqueIdentifier);
param.Value = CoachID;
cmd.Parameters.Add(param);
cmd.CommandType = CommandType.StoredProcedure;
try
{
cmd.Connection.Open();
DataTable dt = new DataTable();
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
dataAdapter.Fill(dt);
cmd.Connection.Close();
applications = new List <PlayerApplication>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Person person = new Person(Guid.Parse(dt.Rows[i]["player_id"].ToString()));
person.FirstName = dt.Rows[i]["firstname"].ToString();
person.LastName = dt.Rows[i]["lastname"].ToString();
person.MainPhone = dt.Rows[i]["mainphone"].ToString();
person.WorkPhone = dt.Rows[i]["workphone"].ToString();
person.Email = dt.Rows[i]["email"].ToString();
PlayerApplication application = new PlayerApplication(Guid.Parse(dt.Rows[i]["playerapp_id"].ToString()), person);
application.BirthDate = DateTime.Parse(dt.Rows[i]["birthdate"].ToString());
applications.Add(application);
}
}
catch (Exception e)
{
cmd.Connection.Close();
}
return(applications);
}
public PlayerApplication GetPlayer(Guid PlayerID)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetPlayerApplicationByID";
cmd.Parameters.Add(new SqlParameter("@playerAppID", SqlDbType.UniqueIdentifier)).Value = PlayerID;
try
{
cmd.Connection.Open();
DataTable dt = new DataTable();
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
dataAdapter.Fill(dt);
cmd.Connection.Close();
if (dt.Rows.Count == 1)
{
//Player information
PlayerApplication player = new PlayerApplication(PlayerID);
player.BCMedicalNumber = (dt.Rows[0]["bcMedicalNumber"].ToString());
player.BirthDate = DateTime.Parse(dt.Rows[0]["birthdate"].ToString());
player.Gender = dt.Rows[0]["gender"].ToString()[0];
player.MedicalAlert = dt.Rows[0]["medicalNotes"].ToString();
player.Paid = Boolean.Parse(dt.Rows[0]["paid"].ToString());
player.Payment = Double.Parse(dt.Rows[0]["payment"].ToString());
player.PreviousTeam = dt.Rows[0]["previousTeam"].ToString();
player.School = dt.Rows[0]["school"].ToString();
UserAccessRepository rep = new UserAccessRepository();
player.Player = new Person();
player.Player = rep.GetPerson(Guid.Parse(dt.Rows[0]["player_id"].ToString()));
player.Player.Address = new Address(player.Player.Address.Id);
player.Player.Address = rep.GetAddress(player.Player.Address.Id);
//Guardian1's information
player.Guardian1 = new Person();
player.Guardian1 = rep.GetPerson(Guid.Parse(dt.Rows[0]["contact1_id"].ToString()));
player.Guardian1.Address = new Address(player.Guardian1.Address.Id);
player.Guardian1.Address = rep.GetAddress(player.Guardian1.Address.Id);
if (Guid.Parse(dt.Rows[0]["contact2_id"].ToString()) != Guid.Empty)
{
player.Guardian2 = new Person();
player.Guardian2 = rep.GetPerson(Guid.Parse(dt.Rows[0]["contact2_id"].ToString()));
player.Guardian2.Address = new Address(player.Guardian2.Address.Id);
player.Guardian2.Address = rep.GetAddress(player.Guardian2.Address.Id);
}
if (Convert.IsDBNull(dt.Rows[0]["coach_id"]))
{
player.Coach = null;
}
else
{
Person coach = new Person(Guid.Parse(dt.Rows[0]["coach_id"].ToString()));
player.Coach = coach;
}
return(player);
}
}
catch (Exception e)
{
}
return(null);
}
public Guid CreatePlayerApplication(PlayerApplication PlayerApplication)
{
UserAccessRepository rep = new UserAccessRepository();
// Player's information
Guid playerAddressID = rep.CreateAddress(PlayerApplication.Player.Address);
Guid playerID = rep.CreatePerson(PlayerApplication.Player, playerAddressID);
// Guardian1's information(required)
Guid guardian1AddressID = rep.CreateAddress(PlayerApplication.Guardian1.Address);
Guid guardian1ID = rep.CreatePerson(PlayerApplication.Guardian1, guardian1AddressID);
// Guardian2's information(optional)
Guid guardian2ID = Guid.Empty;
if (PlayerApplication.Guardian2 != null) //If user enter the address, use the one entered
{
Guid guardian2AddressID = rep.CreateAddress(PlayerApplication.Guardian2.Address);
guardian2ID = rep.CreatePerson(PlayerApplication.Guardian2, guardian2AddressID);
}
else //if not, user the player's address
{
Guid guardian2AddressID = rep.CreateAddress(PlayerApplication.Player.Address);
guardian2ID = rep.CreatePerson(PlayerApplication.Guardian2, guardian2AddressID);
}
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CreateNewPlayerApplication";
Guid playerApplicationID = Guid.NewGuid();
cmd.Parameters.Add(new SqlParameter("@playerApplicationID", SqlDbType.UniqueIdentifier)).Value = playerApplicationID;
cmd.Parameters.Add(new SqlParameter("@bcMedicalNumber", SqlDbType.VarChar, 10)).Value = PlayerApplication.BCMedicalNumber;
cmd.Parameters.Add(new SqlParameter("@registrationDate", SqlDbType.DateTime)).Value = PlayerApplication.RegistrationDate;
cmd.Parameters.Add(new SqlParameter("@endDate", SqlDbType.DateTime)).Value = SqlDateTime.Null;
cmd.Parameters.Add(new SqlParameter("@birthDate", SqlDbType.DateTime)).Value = PlayerApplication.BirthDate;
cmd.Parameters.Add(new SqlParameter("@consentApproved", SqlDbType.Bit)).Value = PlayerApplication.ConsentApproved ? 1 : 0;
cmd.Parameters.Add(new SqlParameter("@gender", SqlDbType.Char)).Value = PlayerApplication.Gender;
cmd.Parameters.Add(new SqlParameter("@medicalAlert", SqlDbType.VarChar, 200)).Value = PlayerApplication.MedicalAlert;
cmd.Parameters.Add(new SqlParameter("@paid", SqlDbType.Bit)).Value = 0;
cmd.Parameters.Add(new SqlParameter("@payment", SqlDbType.Money)).Value = PlayerApplication.Payment;
cmd.Parameters.Add(new SqlParameter("@previousTeam", SqlDbType.VarChar, 50)).Value = PlayerApplication.PreviousTeam;
cmd.Parameters.Add(new SqlParameter("@school", SqlDbType.VarChar, 50)).Value = PlayerApplication.School;
cmd.Parameters.Add(new SqlParameter("@playerID", SqlDbType.UniqueIdentifier)).Value = playerID;
cmd.Parameters.Add(new SqlParameter("@guardian1ID", SqlDbType.UniqueIdentifier)).Value = guardian1ID;
cmd.Parameters.Add(new SqlParameter("@guardian2ID", SqlDbType.UniqueIdentifier)).Value = guardian2ID;
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception e)
{
playerApplicationID = Guid.Empty;
}
return(playerApplicationID);
}
public ActionResult NewPlayer(PlayerApplication PlayerApplication)
{
try
{
RegisterAccessRepository rep = new RegisterAccessRepository();
PlayerApplication.Paid = false;
PlayerApplication.RegistrationDate = DateTime.Now;
PlayerApplication.Payment = 0.0;
PlayerApplication.Player.Address.Country = "Canada";
PlayerApplication.Player.Organization = new Organization(Guid.Parse(ConfigurationManager.AppSettings["HostingOrganizationID"].ToString()));
if (PlayerApplication.Guardian1.Address == null)
{
PlayerApplication.Guardian1.Address = PlayerApplication.Player.Address;
}
else
{
PlayerApplication.Guardian1.Address.Country = "Canada";
}
PlayerApplication.Guardian1.Organization = PlayerApplication.Player.Organization;
if (PlayerApplication.Guardian2.Address == null)
{
PlayerApplication.Guardian2.Address = PlayerApplication.Player.Address;
}
else
{
PlayerApplication.Guardian2.Address.Country = "Canada";
}
if (PlayerApplication.Guardian1.Address.City == null)
{
PlayerApplication.Guardian1.Address.City = PlayerApplication.Player.Address.City;
}
if (PlayerApplication.Guardian1.Address.StreetAddress == null)
{
PlayerApplication.Guardian1.Address.StreetAddress = PlayerApplication.Player.Address.StreetAddress;
}
if (PlayerApplication.Guardian1.Address.PostalCode == null)
{
PlayerApplication.Guardian1.Address.PostalCode = PlayerApplication.Player.Address.PostalCode;
}
if (PlayerApplication.Guardian2.Address.City == null)
{
PlayerApplication.Guardian2.Address.City = PlayerApplication.Player.Address.City;
}
if (PlayerApplication.Guardian2.Address.StreetAddress == null)
{
PlayerApplication.Guardian2.Address.StreetAddress = PlayerApplication.Player.Address.StreetAddress;
}
if (PlayerApplication.Guardian2.Address.PostalCode == null)
{
PlayerApplication.Guardian2.Address.PostalCode = PlayerApplication.Player.Address.PostalCode;
}
if (PlayerApplication.MedicalAlert == null)
{
PlayerApplication.MedicalAlert = "";
}
if (PlayerApplication.PreviousTeam == null)
{
PlayerApplication.PreviousTeam = "";
}
PlayerApplication.Guardian2.Organization = PlayerApplication.Player.Organization;
Guid playerApplicationID = rep.CreatePlayerApplication(PlayerApplication);
if (playerApplicationID != Guid.Empty)
{
MailMessage message = new MailMessage();
message.To.Add(new MailAddress(PlayerApplication.Player.Email));
message.Subject = "PhoenixFC - Application Recieved!";
message.Body = "Dear Player: We have recieved your application. Someone from PhoenixFC will contact you regarding your next steps. Please do not reply to this email. Thank you.";
SmtpClient client = new SmtpClient();
client.Send(message);
ViewData["Message"] = "Thank you. Your application has been submitted. An email has been sent your email account.";
return(RedirectToAction("All", "Teams", new { message = ViewData["Message"] }));
}
}
catch (Exception e)
{
if (e is System.Net.Mail.SmtpException)
{
ViewData["Message"] = "Your application has been submitted. However, there was an error sending confirmation email. Please contact PhoenixFC at your convenience to confirm your application submission.";
}
else
{
ViewData["Message"] = "There was an error processing your request. Please contact administrator.";
}
return(RedirectToAction("All", "Teams", new { message = ViewData["Message"] }));
}
return(View());
}
public ActionResult DeactivatePlayer(string id)//id = PlayerApplicationID
{
PlayerApplication player = new PlayerApplication(Guid.Parse(id));
return(View("DeactivatePlayer", player));
}
