public static void GenerateCalendar(int Year, int Month, ISqlCalendar sql)
{
//Check if calendar for next month wasn't already created
if (CalendarAlreadyCreated(Year, Month, sql))
{
throw new Exception("Calendar already created for next month");
}
//Create list of working days for clinic
List <int> daysInMonth = WorkingDaysInMonth(Year, Month);
//Create Calendar
int calendarId = sql.CreateCalendar(Year, Month);
//Create querry
string querry = "";
foreach (int day in daysInMonth)
{
querry += String.Format("({0},'{1}','{2}',{3}),", day, new TimeSpan(7, 0, 0), new TimeSpan(20, 0, 0), calendarId);
}
if (querry.Length == 0)
{
return;
}
querry = Login.ClassHelpers.RemoveLastCharOfString(querry);
//Create calendar days
sql.CreateCalendarDays(querry);
}
