private void Jahresrechner(DateTime a)
{
DateTime b = a;
int Add_days = 7;
int Remove_days;
int Nummer = 1;
bool Schaltjahr = DateTime.IsLeapYear(b.Year);
//create DBContext object
using (var dbCtx = new KalenderModel())
{
if (b.DayOfWeek.ToString() == "Monday")
{
Remove_days = 1;
}
if (b.DayOfWeek.ToString() == "Tuesday")
{
Remove_days = 2;
}
if (b.DayOfWeek.ToString() == "Wednesday")
{
Remove_days = 3;
}
if (b.DayOfWeek.ToString() == "Thursday")
{
Remove_days = 4;
}
if (b.DayOfWeek.ToString() == "Friday")
{
Remove_days = 5;
}
if (b.DayOfWeek.ToString() == "Saturday")
{
Remove_days = 6;
}
else
{
Remove_days = 7;
}
dbCtx.Database.ExecuteSqlCommand("delete from Kalender");
while (b.Year == a.Year)
{
//Add Student object into Students DBset
var datum = new Datum();
datum.Date = b.ToString("s");
if (b.DayOfWeek.ToString() == "Saturday")
{
if (Schaltjahr == false)
{
if (b.DayOfYear > Add_days)
{
if (b.DayOfYear <= 151)
{
datum.Termin = "Deutsche Liga Spiltag " + Nummer;
Nummer++;
}
}
if (b.DayOfYear <= 364 - (7 + Remove_days))
{
if (b.DayOfYear >= 256)
{
datum.Termin = "Deutsche Liga Spiltag " + Nummer;
Nummer++;
}
}
}
if (Schaltjahr == true)
{
if (b.DayOfYear > Add_days)
{
if (b.DayOfYear <= 152)
{
datum.Termin = "Deutsche Liga Spiltag " + Nummer;
Nummer++;
}
}
if (b.DayOfYear <= 365 - (7 + Remove_days))
{
if (b.DayOfYear >= 257)
{
datum.Termin = "Deutsche Liga Spiltag " + Nummer;
Nummer++;
}
}
}
}
// call SaveChanges method to save student into database
b = b.AddDays(1);
dbCtx.Kalender.Add(datum);
}
dbCtx.SaveChanges();
}
}
