public static List <string> GetNicksFromDb() { var nickCollection = new List <string>(); var context = new SaluteDbContext(); nickCollection.AddRange(context.AllTimeRatingDbSet.Select(alr => alr.Nick)); return(nickCollection); }
private static void MemberStatusChanged(string nick, bool check) { using (var context = new SaluteDbContext()) { var inSeason = context.SeasonRatingDbSet.FirstOrDefault(t => t.Nick == nick); var inSeries = context.SeriesRatingDbSet.FirstOrDefault(t => t.Nick == nick); var inWeek = context.WeekRatingDbSet.FirstOrDefault(t => t.Nick == nick); var inAllTime = context.AllTimeRatingDbSet.FirstOrDefault(t => t.Nick == nick); var inSeasonFiim = context.SeasonRatingFiimDbSet.FirstOrDefault(t => t.Nick == nick); var inSeriesFiim = context.SeriesRatingFiimDbSet.FirstOrDefault(t => t.Nick == nick); var inWeekFiim = context.WeekRatingFiimDbSet.FirstOrDefault(t => t.Nick == nick); var inAllTimeFim = context.AllTimeRatingFiimDbSet.FirstOrDefault(t => t.Nick == nick); if (inSeason != null) { inSeason.IsMember = check; } if (inSeries != null) { inSeries.IsMember = check; } if (inWeek != null) { inWeek.IsMember = check; } if (inAllTime != null) { inAllTime.IsMember = check; } if (inSeasonFiim != null) { inSeasonFiim.IsMember = check; } if (inSeriesFiim != null) { inSeriesFiim.IsMember = check; } if (inWeekFiim != null) { inWeekFiim.IsMember = check; } if (inAllTimeFim != null) { inAllTimeFim.IsMember = check; } context.SaveChanges(); } }