public async Task<bool> RegisterStudent(StudentSignUpDM studentSignUp)
{
using (var context = new LearningFivesEntities())
{
context.StudentSignUps.Add(new StudentSignUp
{
StudentStatus = studentSignUp.StudentStatus,
SummonerInfo = new SummonerInfo
{
SummonerName = studentSignUp.SummonerInfo.SummonerName,
ServerName = studentSignUp.SummonerInfo.Server,
RankTier = studentSignUp.SummonerInfo.RankTier,
RankDivision = studentSignUp.SummonerInfo.RankDivision,
Age = studentSignUp.SummonerInfo.Age,
Email = studentSignUp.SummonerInfo.Email,
HasSlackAccount = studentSignUp.SummonerInfo.HasSlackAccount
},
RoleInfo = new RoleInfo
{
PreferredRole = studentSignUp.RoleInfo.PreferredRole,
TopLaneComfort = studentSignUp.RoleInfo.TopLaneComfort,
JungleComfort = studentSignUp.RoleInfo.JungleComfort,
MidComfort = studentSignUp.RoleInfo.MidComfort,
MarksmanComfort = studentSignUp.RoleInfo.MarksmanComfort,
SupportComfort = studentSignUp.RoleInfo.SupportComfort
},
AvailabilityInfo = new AvailabilityInfo
{
MondayStart = studentSignUp.AvailabilityInfo.MondayStart,
MondayEnd = studentSignUp.AvailabilityInfo.MondayEnd,
TuesdayStart = studentSignUp.AvailabilityInfo.TuesdayStart,
TuesdayEnd = studentSignUp.AvailabilityInfo.TuesdayEnd,
WednesdayStart = studentSignUp.AvailabilityInfo.WednesdayStart,
WednesdayEnd = studentSignUp.AvailabilityInfo.WednesdayEnd,
ThursdayStart = studentSignUp.AvailabilityInfo.ThursdayStart,
ThursdayEnd = studentSignUp.AvailabilityInfo.ThursdayEnd,
FridayStart = studentSignUp.AvailabilityInfo.FridayStart,
FridayEnd = studentSignUp.AvailabilityInfo.FridayEnd,
SaturdayStart = studentSignUp.AvailabilityInfo.SaturdayStart,
SaturdayEnd = studentSignUp.AvailabilityInfo.SaturdayEnd,
SundayStart = studentSignUp.AvailabilityInfo.SundayStart,
SundayEnd = studentSignUp.AvailabilityInfo.SundayEnd
},
Languages = studentSignUp.Languages,
PairedPlayers = studentSignUp.PairedPlayers,
PlayerStrengths = studentSignUp.PlayerStrengths,
PlayerImprovement = studentSignUp.PlayerImprovement,
PlayerExpectations = studentSignUp.PlayerExpectations,
Commitment = new Commitment
{
CommitmentLevel = studentSignUp.Commitment.CommitmentLevel,
SeriousnessLevel = studentSignUp.Commitment.SeriousnessLevel
},
Toxic = new Toxic
{
ToxicLevel = studentSignUp.Toxic.ToxicLevel,
HadLowPriorityPunish = studentSignUp.Toxic.HadLowPriorityPunish,
HadChatRestriction = studentSignUp.Toxic.HadChatRestrictions,
HadRankedRestrictions = studentSignUp.Toxic.HadRankedRestrictions,
HadTemporaryBan = studentSignUp.Toxic.HadTemporaryBan,
HadPermanentBan = studentSignUp.Toxic.HadPermanentBan
},
MoreInformation = studentSignUp.MoreInformation,
EmailSignUp = studentSignUp.EmailSignUp
});
return await context.SaveChangesAsync() > 0;
}
}
public async Task<List<StudentSignUpDM>> GetAllStudentsAsync(GetStudentsDM studentFilter)
{
using (var context = new LearningFivesEntities())
{
var filter = context.StudentSignUps.AsQueryable();
if (studentFilter.StudentStatus >= 0)
{
filter = filter.Where(i => i.StudentStatus == studentFilter.StudentStatus);
}
if (!string.IsNullOrEmpty(studentFilter.Server))
{
filter = filter.Where(i => i.SummonerInfo.ServerName == studentFilter.Server);
}
if (!string.IsNullOrEmpty(studentFilter.RankTier))
{
filter = filter.Where(i => i.SummonerInfo.RankTier == studentFilter.RankTier);
}
return await filter.Select(student => new StudentSignUpDM
{
StudentStatus = student.StudentStatus,
SummonerInfo = new SummonerSignUpDM
{
SummonerName = student.SummonerInfo.SummonerName,
Server = student.SummonerInfo.ServerName,
RankTier = student.SummonerInfo.RankTier,
RankDivision = student.SummonerInfo.RankDivision,
Age = student.SummonerInfo.Age,
Email = student.SummonerInfo.Email,
HasSlackAccount = student.SummonerInfo.HasSlackAccount
},
RoleInfo = new RoleSignUpDM
{
PreferredRole = student.RoleInfo.PreferredRole,
TopLaneComfort = student.RoleInfo.TopLaneComfort,
JungleComfort = student.RoleInfo.JungleComfort,
MidComfort = student.RoleInfo.MidComfort,
MarksmanComfort = student.RoleInfo.MarksmanComfort,
SupportComfort = student.RoleInfo.SupportComfort
},
AvailabilityInfo = new AvailabilitySignUpDM
{
MondayStart = student.AvailabilityInfo.MondayStart,
MondayEnd = student.AvailabilityInfo.MondayEnd,
TuesdayStart = student.AvailabilityInfo.TuesdayStart,
TuesdayEnd = student.AvailabilityInfo.TuesdayEnd,
WednesdayStart = student.AvailabilityInfo.WednesdayStart,
WednesdayEnd = student.AvailabilityInfo.WednesdayEnd,
ThursdayStart = student.AvailabilityInfo.ThursdayStart,
ThursdayEnd = student.AvailabilityInfo.ThursdayEnd,
FridayStart = student.AvailabilityInfo.FridayStart,
FridayEnd = student.AvailabilityInfo.FridayEnd,
SaturdayStart = student.AvailabilityInfo.SaturdayStart,
SaturdayEnd = student.AvailabilityInfo.SaturdayEnd,
SundayStart = student.AvailabilityInfo.SundayStart,
SundayEnd = student.AvailabilityInfo.SundayEnd
},
Languages = student.Languages,
PairedPlayers = student.PairedPlayers,
PlayerStrengths = student.PlayerStrengths,
PlayerImprovement = student.PlayerImprovement,
PlayerExpectations = student.PlayerExpectations,
Commitment = new CommitmentSignUpDM
{
CommitmentLevel = student.Commitment.CommitmentLevel,
SeriousnessLevel = student.Commitment.SeriousnessLevel
},
Toxic = new ToxicSignUpDM
{
ToxicLevel = student.Toxic.ToxicLevel,
HadLowPriorityPunish = student.Toxic.HadLowPriorityPunish,
HadChatRestrictions = student.Toxic.HadChatRestriction,
HadRankedRestrictions = student.Toxic.HadRankedRestrictions,
HadTemporaryBan = student.Toxic.HadTemporaryBan,
HadPermanentBan = student.Toxic.HadPermanentBan
},
MoreInformation = student.MoreInformation,
EmailSignUp = student.EmailSignUp
})
.OrderBy(i => i.SummonerInfo.SummonerName)
.Skip((studentFilter.PageNumber - 1) * studentFilter.PageSize)
.Take(studentFilter.PageSize)
.ToListAsync();
}
}
public async Task<bool> RegisterCoach(CoachSignUpDM coachSignUp)
{
using (var context = new LearningFivesEntities())
{
context.CoachSignUps.Add(new CoachSignUp
{
CoachStatus = coachSignUp.CoachStatus,
SummonerInfo = new SummonerInfo
{
SummonerName = coachSignUp.SummonerInfo.SummonerName,
ServerName = coachSignUp.SummonerInfo.Server,
RankTier = coachSignUp.SummonerInfo.RankTier,
RankDivision = coachSignUp.SummonerInfo.RankDivision,
Age = coachSignUp.SummonerInfo.Age,
Email = coachSignUp.SummonerInfo.Email,
HasSlackAccount = coachSignUp.SummonerInfo.HasSlackAccount
},
InterestedBronze = coachSignUp.InterestedBronze,
InterestedSilver = coachSignUp.InterestedSilver,
InterestedGold = coachSignUp.InterestedGold,
InterestedPlat = coachSignUp.InterestedPlat,
InterestedDiamond = coachSignUp.InterestedDiamond,
WillingBronze = coachSignUp.WillingBronze,
WillingSilver = coachSignUp.WillingSilver,
WillingGold = coachSignUp.WillingGold,
WillingPlat = coachSignUp.WillingPlat,
WillingDiamond = coachSignUp.WillingDiamond,
AvailabilityInfo = new AvailabilityInfo
{
MondayStart = coachSignUp.AvailabilityInfo.MondayStart,
MondayEnd = coachSignUp.AvailabilityInfo.MondayEnd,
TuesdayStart = coachSignUp.AvailabilityInfo.TuesdayStart,
TuesdayEnd = coachSignUp.AvailabilityInfo.TuesdayEnd,
WednesdayStart = coachSignUp.AvailabilityInfo.WednesdayStart,
WednesdayEnd = coachSignUp.AvailabilityInfo.WednesdayEnd,
ThursdayStart = coachSignUp.AvailabilityInfo.ThursdayStart,
ThursdayEnd = coachSignUp.AvailabilityInfo.ThursdayEnd,
FridayStart = coachSignUp.AvailabilityInfo.FridayStart,
FridayEnd = coachSignUp.AvailabilityInfo.FridayEnd,
SaturdayStart = coachSignUp.AvailabilityInfo.SaturdayStart,
SaturdayEnd = coachSignUp.AvailabilityInfo.SaturdayEnd,
SundayStart = coachSignUp.AvailabilityInfo.SundayStart,
SundayEnd = coachSignUp.AvailabilityInfo.SundayEnd
},
Languages = coachSignUp.Languages,
PairedPlayers = coachSignUp.PairedPlayers,
CoachingStyle = coachSignUp.CoachingStyle,
CoachingExperience = coachSignUp.CoachingExperience,
Commitment = new Commitment
{
CommitmentLevel = coachSignUp.Commitment.CommitmentLevel,
SeriousnessLevel = coachSignUp.Commitment.SeriousnessLevel
},
Toxic = new Toxic
{
ToxicLevel = coachSignUp.Toxic.ToxicLevel,
HadLowPriorityPunish = coachSignUp.Toxic.HadLowPriorityPunish,
HadChatRestriction = coachSignUp.Toxic.HadChatRestrictions,
HadRankedRestrictions = coachSignUp.Toxic.HadRankedRestrictions,
HadTemporaryBan = coachSignUp.Toxic.HadTemporaryBan,
HadPermanentBan = coachSignUp.Toxic.HadPermanentBan
},
MoreInformation = coachSignUp.MoreInformation,
EmailSignUp = coachSignUp.EmailSignUp
});
return await context.SaveChangesAsync() > 0;
}
}
public async Task<List<CoachSignUpDM>> GetAllCoachesAsync(GetCoachesDM coachFilter)
{
using (var context = new LearningFivesEntities())
{
var filter = context.CoachSignUps.AsQueryable();
if (coachFilter.CoachStatus > 0)
{
filter = filter.Where(i => i.CoachStatus == coachFilter.CoachStatus);
}
if (coachFilter.Server != null)
{
filter = filter.Where(i => i.SummonerInfo.ServerName == coachFilter.Server);
}
if (coachFilter.RankTier != null)
{
filter = filter.Where(i => i.SummonerInfo.RankTier == coachFilter.RankTier);
}
return await filter.Select(coach => new CoachSignUpDM
{
CoachStatus = coach.CoachStatus,
SummonerInfo = new SummonerSignUpDM
{
SummonerName = coach.SummonerInfo.SummonerName,
Server = coach.SummonerInfo.ServerName,
RankTier = coach.SummonerInfo.RankTier,
RankDivision = coach.SummonerInfo.RankDivision,
Age = coach.SummonerInfo.Age,
Email = coach.SummonerInfo.Email,
HasSlackAccount = coach.SummonerInfo.HasSlackAccount
},
InterestedBronze = coach.InterestedBronze,
InterestedSilver = coach.InterestedSilver,
InterestedGold = coach.InterestedGold,
InterestedPlat = coach.InterestedPlat,
InterestedDiamond = coach.InterestedDiamond,
WillingBronze = coach.WillingBronze,
WillingSilver = coach.WillingSilver,
WillingGold = coach.WillingGold,
WillingPlat = coach.WillingPlat,
WillingDiamond = coach.WillingDiamond,
AvailabilityInfo = new AvailabilitySignUpDM
{
MondayStart = coach.AvailabilityInfo.MondayStart,
MondayEnd = coach.AvailabilityInfo.MondayEnd,
TuesdayStart = coach.AvailabilityInfo.TuesdayStart,
TuesdayEnd = coach.AvailabilityInfo.TuesdayEnd,
WednesdayStart = coach.AvailabilityInfo.WednesdayStart,
WednesdayEnd = coach.AvailabilityInfo.WednesdayEnd,
ThursdayStart = coach.AvailabilityInfo.ThursdayStart,
ThursdayEnd = coach.AvailabilityInfo.ThursdayEnd,
FridayStart = coach.AvailabilityInfo.FridayStart,
FridayEnd = coach.AvailabilityInfo.FridayEnd,
SaturdayStart = coach.AvailabilityInfo.SaturdayStart,
SaturdayEnd = coach.AvailabilityInfo.SaturdayEnd,
SundayStart = coach.AvailabilityInfo.SundayStart,
SundayEnd = coach.AvailabilityInfo.SundayEnd
},
Languages = coach.Languages,
PairedPlayers = coach.PairedPlayers,
CoachingStyle = coach.CoachingStyle,
CoachingExperience = coach.CoachingExperience,
Commitment = new CommitmentSignUpDM
{
CommitmentLevel = coach.Commitment.CommitmentLevel,
SeriousnessLevel = coach.Commitment.SeriousnessLevel
},
Toxic = new ToxicSignUpDM
{
ToxicLevel = coach.Toxic.ToxicLevel,
HadLowPriorityPunish = coach.Toxic.HadLowPriorityPunish,
HadChatRestrictions = coach.Toxic.HadChatRestriction,
HadRankedRestrictions = coach.Toxic.HadRankedRestrictions,
HadTemporaryBan = coach.Toxic.HadTemporaryBan,
HadPermanentBan = coach.Toxic.HadPermanentBan
},
MoreInformation = coach.MoreInformation,
EmailSignUp = coach.EmailSignUp
})
.OrderBy(i => i.SummonerInfo.SummonerName)
.Skip((coachFilter.PageNumber - 1) * coachFilter.PageSize)
.Take(coachFilter.PageSize)
.ToListAsync();
}
}