public static bool AddMeetRoomBookingRecord(MeetingRoomBookingRecord meetBookingRecord) { if (meetBookingRecord != null) { List <MeetingRoomBookingRecord> records = GetMeetRoomBookingRecordsByRoomID((int)meetBookingRecord.RoomId); foreach (var item in records) { bool Check1 = (meetBookingRecord.StartDateTime < item.StartDateTime) & (meetBookingRecord.StartDateTime < item.EndDateTime) & (meetBookingRecord.EndDateTime < item.StartDateTime) & (meetBookingRecord.EndDateTime < item.EndDateTime); bool Check2 = (meetBookingRecord.StartDateTime > item.StartDateTime) & (meetBookingRecord.StartDateTime > item.EndDateTime) & (meetBookingRecord.EndDateTime > item.StartDateTime) & (meetBookingRecord.EndDateTime > item.EndDateTime); if ((Check1 == false) && (Check2 == false)) { return(false); } } using (DBEntities db = new DBEntities()) { db.MeetingRoomBookingRecords.Add(meetBookingRecord); int recordsAffected = db.SaveChanges(); if (recordsAffected > 0) { return(true); } } } return(false); }
public static bool DeleteMeetingRoomBookingRecord(MeetingRoomBookingRecord record) { if (record != null) { using (DBEntities db = new DBEntities()) { MeetingRoomBookingRecord record1 = db.MeetingRoomBookingRecords.SingleOrDefault(x => x.Id == record.Id); db.MeetingRoomBookingRecords.Remove(record1); db.SaveChanges(); } return(true); } return(false); }
public static bool SaveMeetingRecordFilePath(int id, string filepath) { if (id > 0 && filepath != null) { MeetingRoomBookingRecord record = new MeetingRoomBookingRecord() { Id = id, MeetingRecordPath = filepath }; using (DBEntities db = new DBEntities()) { db.MeetingRoomBookingRecords.Attach(record); db.Entry(record).Property(x => x.MeetingRecordPath).IsModified = true; db.SaveChanges(); } return(true); } return(false); }