/// <summary>
/// Ariel Sigo
/// Created 2016/11/19
/// </summary>
/// <param name="active"></param>
/// <returns>count of active trainers</returns>
public int GetTrainerCount(bool active = true)
{
try
{
return(TrainerAccessor.RetrieveTrainerCount());
}
catch (Exception)
{
throw;
}
}
private void refreshActiveTrainerList()
{
try
{
_trainers = TrainerAccessor.RetrieveTrainers();
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Ariel Sigo
/// Created 2016/11/19
/// </summary>
/// <returns>List of trainers</returns>
public List <Trainer> GetFullTrainerList()
{
try
{
return(TrainerAccessor.RetrieveTrainers());
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Ariel Sigo
/// Created 2016/11/19
/// </summary>
/// <param name="trainerID"></param>
/// <returns>Trainer from trainerId</returns>
public static Trainer getTrainer(string trainerID)
{
Trainer trainer = null;
try
{
trainer = TrainerAccessor.getTrainer(trainerID);
}
catch (Exception)
{
throw;
}
return(trainer);
}
/// <summary>
/// Ariel Sigo
/// Created Created 2016/11/22
/// </summary>
/// <param name="userID"></param>
/// <param name="oldPassword"></param>
/// <param name="newPassword"></param>
/// <param name="userType"></param>
/// <returns>true if password was updated and succeeded</returns>
public bool UpdatePassword(string userID, string oldPassword, string newPassword, string userType)
{
var result = false;
if (userType == "member") // member update password
{
result = (1 == MemberAccessor.UpdateMemberPasswordHash(userID, HashSHA256(oldPassword), HashSHA256(newPassword)));
}
else if (userType == "trainer") // trainer update password
{
result = (1 == TrainerAccessor.UpdateTrainerPasswordHash(userID, HashSHA256(oldPassword), HashSHA256(newPassword)));
}
return(result);
}
/// <summary>
/// Ariel Sigo
/// Created 2016/11/22
/// </summary>
/// <param name="oldTrainer"></param>
/// <param name="newTrainer"></param>
/// <returns>true if update succeeded for trainer</returns>
public bool UpdateTrainer(Trainer oldTrainer, Trainer newTrainer)
{
var result = false;
if (result = (1 == TrainerAccessor.UpdateTrainer(oldTrainer.TrainerID, newTrainer.TrainerID, oldTrainer.TrainerFirstName, newTrainer.TrainerFirstName, oldTrainer.TrainerLastName, newTrainer.TrainerLastName, oldTrainer.TrainerPhoneNumber, newTrainer.TrainerPhoneNumber, oldTrainer.TrainerStatus, newTrainer.TrainerStatus, oldTrainer.TrainerPoleLevel, newTrainer.TrainerPoleLevel, oldTrainer.TrainerAcroLevel, newTrainer.TrainerAcroLevel, oldTrainer.TrainerSilksLevel, newTrainer.TrainerSilksLevel, oldTrainer.TrainerLyraLevel, newTrainer.TrainerLyraLevel)))
{
return(result);
}
else
{
result = false;
return(result);
}
}
/// <summary>
/// Ariel Sigo
///
/// Created 2016/11/19
/// </summary>
/// <param name="trainerID"></param>
/// <param name="newTrainerID"></param>
/// <returns>true if update was successful</returns>
public bool UpdateTrainerEmail(string trainerID, string newTrainerID)
{
var result = false;
try
{
result = (1 == TrainerAccessor.UpdateTrainerEmail(trainerID, newTrainerID));
refreshActiveTrainerList();
}
catch (Exception)
{
throw;
}
return(result);
}
/// <summary>
/// Ariel Sigo
/// Created 2016/11/19
/// </summary>
/// <param name="oldTrainerID"></param>
/// <param name="newTrainerID"></param>
/// <param name="oldTrainerFirstName"></param>
/// <param name="newTrainerFirstName"></param>
/// <param name="oldTrainerLastName"></param>
/// <param name="newTrainerLastName"></param>
/// <param name="oldTrainerPhoneNumber"></param>
/// <param name="newTrainerPhoneNumber"></param>
/// <param name="oldTrainerStatus"></param>
/// <param name="newTrainerStatus"></param>
/// <param name="oldTrainerPoleLevel"></param>
/// <param name="newTrainerPoleLevel"></param>
/// <param name="oldTrainerAcroLevel"></param>
/// <param name="newTrainerAcroLevel"></param>
/// <param name="oldTrainerSilksLevel"></param>
/// <param name="newTrainerSilksLevel"></param>
/// <param name="oldTrainerLyraLevel"></param>
/// <param name="newTrainerLyraLevel"></param>
/// <returns>True if update on trainer was successsful </returns>
public bool UpdateTrainer(string oldTrainerID, string newTrainerID, string oldTrainerFirstName, string newTrainerFirstName, string oldTrainerLastName, string newTrainerLastName, string oldTrainerPhoneNumber, string newTrainerPhoneNumber, bool oldTrainerStatus, bool newTrainerStatus, string oldTrainerPoleLevel, string newTrainerPoleLevel, string oldTrainerAcroLevel, string newTrainerAcroLevel, string oldTrainerSilksLevel, string newTrainerSilksLevel, string oldTrainerLyraLevel, string newTrainerLyraLevel)
{
var result = false;
try
{
result = (1 == TrainerAccessor.UpdateTrainer(oldTrainerID, newTrainerID, oldTrainerFirstName, newTrainerFirstName, oldTrainerLastName, newTrainerLastName, oldTrainerPhoneNumber, newTrainerPhoneNumber, oldTrainerStatus, newTrainerStatus, oldTrainerPoleLevel, newTrainerPoleLevel, oldTrainerAcroLevel, newTrainerAcroLevel, oldTrainerSilksLevel, newTrainerSilksLevel, oldTrainerLyraLevel, newTrainerLyraLevel));
refreshActiveTrainerList();
}
catch (Exception)
{
throw;
}
return(result);
}
/// <summary>
/// Ariel Sigo
/// Created 2016/11/19
/// </summary>
/// <param name="trainerId"></param>
/// <param name="oldPassword"></param>
/// <param name="newPassword"></param>
/// <returns>True if update on password was successful</returns>
public bool UpdateTrainerPassword(string trainerId, string oldPassword, string newPassword)
{
var result = false;
try
{
if (1 == TrainerAccessor.UpdateTrainerPasswordHash(trainerId, UserManager.HashSHA256(oldPassword), UserManager.HashSHA256(newPassword)))
{
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
throw new ApplicationException("Could Not Find Stored Procedure 'Update Trainer Password'", ex);
}
return(result);
}
