public Database.Team ParseTeam(CoachModel coachModel)
{
Database.Team team = new Database.Team();
team.TeamID = coachModel.teamID;
team.TeamName = coachModel.teamName;
team.DivisionID = coachModel.divisionID;
team.CaptainID = coachModel.captainID;
team.CoachID = coachModel.personID;
team.TeamName = coachModel.teamName;
return(team);
}
public Database.Team GetTeam(string teamName)
{
Database.Team team = new Database.Team();
try
{
using (NetballEntities context = new NetballEntities())
{
team = context.Teams
.Where(c => c.TeamName.Trim().ToLower() == teamName.Trim().ToLower())
.FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(team);
}
public Database.Team GetTeam(int teamID)
{
Database.Team team = new Database.Team();
try
{
using (NetballEntities context = new NetballEntities())
{
team = context.Teams
.Where(c => c.TeamID == teamID)
.FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(team);
}
public CoachModel CoachModelSelect(int personID)
{
CoachModel coachModel = new CoachModel();
Database.Team team = new Database.Team();
using (NetballEntities context = new NetballEntities())
{
coachModel = (from p in context.People
where p.PersonID == personID
from t in context.Teams.Where(t => t.CoachID == p.PersonID).DefaultIfEmpty()
select new CoachModel
{
personID = p.PersonID,
//teamID = t.TeamID,
firstName = p.FirstName,
middleName = p.MiddleName,
lastName = p.LastName,
mobile = p.Mobile,
email = p.Email,
emergencyContact = p.EmergencyContact,
emergencyContactNo = p.EmergencyContactNo,
teamName = t.TeamName,
coachName = p.FirstName + " " + p.LastName,
captainID = t.CaptainID,
divisionID = t.DivisionID
})
.FirstOrDefault();
}
if (!string.IsNullOrEmpty(coachModel.teamName))
{
team = _teamSelectLogic.GetTeam(coachModel.teamName);
if (team != null)
{
coachModel.teamID = team.TeamID;
}
}
return(coachModel);
}
public CoachModel GetActiveCoachModel(int teamID)
{
CoachModel coachModel = new CoachModel();
Database.Team team = new Database.Team();
Person person = new Person();
try
{
team = _teamSelectLogic.GetTeam(teamID);
if (team != null)
{
person = _personSelect.GetPerson(team.CoachID ?? 0);
coachModel.activeInd = true;
coachModel.captainID = team.CaptainID;
if (person != null)
{
coachModel.coachName = (person.FirstName + " " + person.LastName).Trim();
coachModel.email = person.Email;
coachModel.emergencyContact = person.EmergencyContact;
coachModel.emergencyContactNo = person.EmergencyContactNo;
coachModel.firstName = person.FirstName;
coachModel.lastName = person.LastName;
coachModel.middleName = person.MiddleName;
coachModel.mobile = person.Mobile;
}
coachModel.divisionID = team.DivisionID;
coachModel.personID = team.CoachID ?? 0;
coachModel.teamID = teamID;
coachModel.teamName = team.TeamName;
}
}
catch (Exception ex)
{
throw ex;
}
return(coachModel);
}
