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