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();
}
