Example #1
0
        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);
        }