public static bool IsWeekLocked(int week)
{
using (var db = new SchedulesDb())
{
return db.Schedules.Where(s => s.Week == week).All(s => !s.IsPickable);
}
}
public static int GetWeekCount()
{
using (var db = new SchedulesDb())
{
return db.Schedules.Select(s => s.Week).Distinct().Count();
}
}
public static int? GetCurrentWeek()
{
using (var db = new SchedulesDb())
{
return db.Schedules.Where(s => s.Date >= DateTime.Now).Min(s => (int?)s.Week);
}
}
public static int GetCurrentWeek()
{
using (var db = new SchedulesDb())
{
if (db.Schedules == null || db.Schedules.Count() == 0)
{
return 0;
}
var maxWeek = db.Schedules.Max(s => s.Week);
return db.Schedules.Where(s => s.Date >= DateTime.Now).Min(s => (int?)s.Week).GetValueOrDefault(maxWeek);
}
}