private static string QuerryTermsForDoctor(int Year, int Month, int calendarDoctorId, int calendarId, ClassDoctor dct, List <ClassCalendarDay> dayList, ISqlCalendar sql)
{
string querry = "";
foreach (ClassCalendarDay d in dayList)
{
DateTime data = new DateTime(Year, Month, d.Day);
foreach (var item in sql.ListFixedTermsForSpecifiedDoctor(dct.Doctor_id))
{
if ((int)data.DayOfWeek == item.Day)
{
if (item.Start >= d.StartTime && item.End <= d.EndTime)
{
querry += String.Format("('{0}','{1}','{2}',{3},{4},{5},{6}),", item.Start, item.End, String.Format("{0}-{1}-{2}", data.Year, data.Month, data.Day), calendarDoctorId, sql.SelectCalendarDayId(d.Day, calendarId), dct.OfficeNumber, dct.Doctor_id);
}
break;
}
}
}
return(querry);
}
