public Example()
{
// repo that should have our CRUD operations for schedules
// (currently only implements Create and Read)
Repository repo = new FakeRepository();
// create our new schedule that will be persisted
var schedule = new DbSchedule()
{
Id = 1,
Schedule = new WeeklySchedule()
{
Frequency = 2,
Monday = true,
Friday = true
}
};
// create the schedule in our repository
repo.Create(schedule);
// now read it back out
schedule = repo.Read(1);
// test the occurrences; it should produce ~2 occurrences
var now = DateTime.Now;
var end = now.AddMonths(2);
foreach (var d in schedule.Schedule.GetOccurrences(now, now.AddMonths(1)).TakeWhile <DateTime>(dt => dt <= end))
{
Console.WriteLine(d);
}
}
public Example()
{
// repo that should have our CRUD operations for schedules
// (currently only implements Create and Read)
Repository repo = new FakeRepository();
// create our new schedule that will be persisted
var schedule = new DbSchedule()
{
Id = 1,
Schedule = new WeeklySchedule()
{
Frequency = 2,
Monday = true,
Friday = true
}
};
// create the schedule in our repository
repo.Create(schedule);
// now read it back out
schedule = repo.Read(1);
// test the occurrences; it should produce ~2 occurrences
var now = DateTime.Now;
var end = now.AddMonths(2);
foreach (var d in schedule.Schedule.GetOccurrences(now, now.AddMonths(1)).TakeWhile<DateTime>(dt => dt <= end))
Console.WriteLine(d);
}
public virtual void Create(DbSchedule schedule)
{
using (var conn = new SqlConnection("connection string"))
{
using (var cmd = conn.CreateCommand())
{
// assume triggers update date created and modified
cmd.CommandText = @"INSERT INTO [Schedules] (Id, Frequency) VALUES (@Id, @Frequency)";
cmd.Parameters.AddWithValue("Id", schedule.Id);
cmd.Parameters.AddWithValue("Frequency", schedule.Schedule.Frequency);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Id", schedule.Id);
// now commit the correct ID into the correct table
if (schedule.Schedule is DailySchedule)
{
cmd.CommandText = "INSERT INTO [ScheduleDay] (Id) VALUES (@Id)";
}
else if (schedule.Schedule is WeeklySchedule)
{
var week = (WeeklySchedule)schedule.Schedule;
cmd.CommandText = "INSERT INTO [ScheduleWeek] (Id, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday) VALUES (@Id, @Monday, @Tuesday, @Wednesday, @Thursday, @Friday, @Saturday, @Sunday)";
cmd.Parameters.AddWithValue("@Monday", week.Monday);
cmd.Parameters.AddWithValue("@Tuesday", week.Tuesday);
cmd.Parameters.AddWithValue("@Wednesday", week.Wednesday);
cmd.Parameters.AddWithValue("@Thursday", week.Thursday);
cmd.Parameters.AddWithValue("@Friday", week.Friday);
cmd.Parameters.AddWithValue("@Saturday", week.Saturday);
cmd.Parameters.AddWithValue("@Sunday", week.Sunday);
}
else if (schedule.Schedule is MonthlyDaySchedule)
{
cmd.CommandText = "INSERT INTO [ScheduleMonthByDay] (Id) VALUES (@Id)";
}
else if (schedule.Schedule is MonthlySchedule)
{
cmd.CommandText = "INSERT INTO [ScheduleMonth] (Id) VALUES (@Id)";
}
else if (schedule.Schedule is YearlySchedule)
{
cmd.CommandText = "INSERT INTO [ScheduleYear] (Id) VALUES (@Id)";
}
cmd.ExecuteNonQuery();
}
}
}
public virtual void Create(DbSchedule schedule)
{
using (var conn = new SqlConnection("connection string"))
{
using (var cmd = conn.CreateCommand())
{
// assume triggers update date created and modified
cmd.CommandText = @"INSERT INTO [Schedules] (Id, Frequency) VALUES (@Id, @Frequency)";
cmd.Parameters.AddWithValue("Id", schedule.Id);
cmd.Parameters.AddWithValue("Frequency", schedule.Schedule.Frequency);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Id", schedule.Id);
// now commit the correct ID into the correct table
if (schedule.Schedule is DailySchedule)
cmd.CommandText = "INSERT INTO [ScheduleDay] (Id) VALUES (@Id)";
else if (schedule.Schedule is WeeklySchedule)
{
var week = (WeeklySchedule)schedule.Schedule;
cmd.CommandText = "INSERT INTO [ScheduleWeek] (Id, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday) VALUES (@Id, @Monday, @Tuesday, @Wednesday, @Thursday, @Friday, @Saturday, @Sunday)";
cmd.Parameters.AddWithValue("@Monday", week.Monday);
cmd.Parameters.AddWithValue("@Tuesday", week.Tuesday);
cmd.Parameters.AddWithValue("@Wednesday", week.Wednesday);
cmd.Parameters.AddWithValue("@Thursday", week.Thursday);
cmd.Parameters.AddWithValue("@Friday", week.Friday);
cmd.Parameters.AddWithValue("@Saturday", week.Saturday);
cmd.Parameters.AddWithValue("@Sunday", week.Sunday);
}
else if (schedule.Schedule is MonthlyDaySchedule)
cmd.CommandText = "INSERT INTO [ScheduleMonthByDay] (Id) VALUES (@Id)";
else if (schedule.Schedule is MonthlySchedule)
cmd.CommandText = "INSERT INTO [ScheduleMonth] (Id) VALUES (@Id)";
else if (schedule.Schedule is YearlySchedule)
cmd.CommandText = "INSERT INTO [ScheduleYear] (Id) VALUES (@Id)";
cmd.ExecuteNonQuery();
}
}
}
public override void Create(DbSchedule schedule)
{
Console.WriteLine("Repository.Create({0})", schedule.Id);
_schedule = schedule;
}
public override void Create(DbSchedule schedule)
{
Console.WriteLine("Repository.Create({0})", schedule.Id);
_schedule = schedule;
}