public JsonResult SaveEvent(MeetingRoomBooking e) { var status = false; if (e.BookingId > 0) { var v = db.MeetingRoomBooking.Where(a => a.BookingId == e.BookingId).FirstOrDefault(); if (v != null) { v.EmployeeID = e.EmployeeID; v.中文姓名 = e.中文姓名; v.MeetingRoomName = e.MeetingRoomName; v.MeetingSubject = e.MeetingSubject; v.BookingStartTime = e.BookingStartTime; v.BookingEndTime = e.BookingEndTime; v.MeetingAttentee = e.MeetingAttentee; v.MeetingRemark = e.MeetingRemark; v.IsAllDay = e.IsAllDay; } } else { db.MeetingRoomBooking.Add(e); } db.SaveChanges(); status = true; return(new JsonResult { Data = new { status = status } }); }
public List <MeetingRoomObserveInfo> GetAllObserveMeetingRooms() { DateTime TodayStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); DateTime TodayEnd = new DateTime(DateTime.Now.AddDays(1).Year, DateTime.Now.AddDays(1).Month, DateTime.Now.AddDays(1).Day); List <MeetingRoomObserveInfo> mroList = new List <MeetingRoomObserveInfo>(); List <MeetingRoom> meetingRooms = _context.MeetingRoom.ToList(); foreach (MeetingRoom mr in meetingRooms) { MeetingRoomBooking booking = _context.MeetingRoomBooking.Where(x => x.MeetingRoomID == mr.ID && x.StartTime > TodayStart && x.EndTime <TodayEnd && x.EndTime> DateTime.Now).FirstOrDefault(); MeetingRoomObserveInfo observeInfo = new MeetingRoomObserveInfo() { ID = mr.ID, Name = mr.Name, Description = mr.Description, Floor = mr.Floor, Capacity = mr.Capacity, Status = (booking != null && booking.StartTime > DateTime.Now) ? MeetingRoomStatus.Busy : MeetingRoomStatus.Available }; if (booking != null) { observeInfo.CurrentBooking = new MeetingRoomBookingInfo() { Title = booking.Title, Description = booking.Description, MeetingRoomID = booking.MeetingRoomID, StartTime = booking.StartTime, EndTime = booking.EndTime, OwnerID = booking.OwnerID }; } mroList.Add(observeInfo); } return(mroList); }
public void EditMeetingRoomBooking(MeetingRoomBookingInfo mrbInfo) { MeetingRoomBooking mrb = _context.MeetingRoomBooking.Find(mrbInfo.ID); mrb.Title = mrbInfo.Title; mrb.Description = mrbInfo.Description; mrb.MeetingRoomID = mrbInfo.MeetingRoomID; mrb.StartTime = mrbInfo.StartTime; mrb.EndTime = mrbInfo.EndTime; mrb.OwnerID = mrbInfo.OwnerID; _context.Entry(mrb).State = EntityState.Modified; _context.SaveChanges(); }
public void SaveMeetingRoomBooking(MeetingRoomBookingInfo mrbInfo) { MeetingRoomBooking mrb = new MeetingRoomBooking() { Title = mrbInfo.Title, Description = mrbInfo.Description, MeetingRoomID = mrbInfo.MeetingRoomID, StartTime = mrbInfo.StartTime, EndTime = mrbInfo.EndTime, OwnerID = mrbInfo.OwnerID }; _context.MeetingRoomBooking.Add(mrb); _context.SaveChanges(); }