public static void ShareCalendar(ClassCalendar calendar, ISqlCalendar sql) { int Year = calendar.Year; int Month = calendar.Month; int calendarId = calendar.CalendarId; //List of Active doctors List <ClassDoctor> DoctorList = ListOfActiveDoctors(sql.DoctorList()); //List of calendar days List <ClassCalendarDay> dayList = sql.ListOfCalendarDays(calendarId); string querry = ""; foreach (ClassDoctor dct in DoctorList) { //Create calendar doctor int calendarDoctorId = sql.CreateCalendarDoctor(dct.Doctor_id, calendarId); //Querry for terms for doctor querry += QuerryTermsForDoctor(Year, Month, calendarDoctorId, calendarId, dct, dayList, sql); } if (querry.Length == 0) { return; } querry = Login.ClassHelpers.RemoveLastCharOfString(querry); //Add new terms sql.CreateTerms(querry); //Update calendar status sql.UpdateCalendarStatus(sql.SelectStatusId(EnumStatus.SharedForDoctors), calendarId); }