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)); }