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