Exemplo n.º 1
0
 public BookingDoctorsApproveViewModel(BookingDoctorsCalendars dc, BookingTimeslots ts) : this()
 {
     Title       = ts != null ? (ts.HoursStart + "h" + ts.MinuteStart + " - " + ts.HoursEnd + "h" + ts.MinuteEnd) : "";
     Start       = new DateTime(dc.CalendarDate.Year, dc.CalendarDate.Month, dc.CalendarDate.Day, int.Parse(ts.HoursStart), int.Parse(ts.MinuteStart), 0);
     End         = new DateTime(dc.CalendarDate.Year, dc.CalendarDate.Month, dc.CalendarDate.Day, int.Parse(ts.HoursEnd), int.Parse(ts.MinuteEnd), 0);
     Color       = dc.Status == 1 ? "bisque" : (dc.Status == 2 ? "deepskyblue" : "aquamarine");
     TextColor   = dc.Status == 2 ? "red" : "black";
     ClassName   = dc.Status == 2 ? "del" : "";
     Description = dc.Address;
     //AllDay = true;
     //DisplayEventTime = false;
 }
        public BookingDoctorsCalendarsViewModel(BookingDoctorsCalendars obj, string connectionString) : this()
        {
            context = new MySqlContext(new MySqlConnectionFactory(connectionString));

            CalendarId         = obj.CalendarId;
            TimeSlotId         = obj.TimeSlotId;
            DoctorId           = obj.DoctorId;
            CalendarDate       = obj.CalendarDate;
            Address            = obj.Address;
            Status             = obj.Status;
            StrCalendarDate    = obj.CalendarDate.ToString("dd/MM/yyyy");
            HealthFacilitiesId = obj.HealthFacilitiesId;

            var Doctor = context.JoinQuery <BookingDoctorsCalendars, Doctor>((o, o1) => new object[]
            {
                JoinType.InnerJoin, o.DoctorId == o1.DoctorId
            })
                         .Where((o, o1) => o.CalendarId == obj.CalendarId)
                         .Select((o, o1) => o1).FirstOrDefault();

            var BookingDoctorsCalendars = context.JoinQuery <BookingDoctorsCalendars, BookingTimeslots>((o, o1) => new object[]
            {
                JoinType.InnerJoin, o.TimeSlotId == o1.TimeSlotId
            })
                                          .Where((o, o1) => o.CalendarId == obj.CalendarId)
                                          .Select((o, o1) => o1).FirstOrDefault();

            var HealthFacilities = context.JoinQuery <BookingDoctorsCalendars, HealthFacilities>((d, h) => new object[]
            {
                JoinType.InnerJoin, d.HealthFacilitiesId == h.HealthFacilitiesId
            })
                                   .Where((d, h) => d.CalendarId == obj.CalendarId)
                                   .Select((d, h) => h).FirstOrDefault();

            FullName             = Doctor != null ? Doctor.FullName : "";
            HoursStart           = BookingDoctorsCalendars != null ? BookingDoctorsCalendars.HoursStart : "";
            MinuteStart          = BookingDoctorsCalendars != null ? BookingDoctorsCalendars.MinuteStart : "";
            HoursEnd             = BookingDoctorsCalendars != null ? BookingDoctorsCalendars.HoursEnd : "";
            MinuteEnd            = BookingDoctorsCalendars != null ? BookingDoctorsCalendars.MinuteEnd : "";
            HealthFacilitiesName = HealthFacilities != null ? HealthFacilities.Name : "";
        }