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