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