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 : ""; }