public static void Insert(MeetingViewModel meeting)
{
if (!UpdateDatabase)
{
var first = All().OrderByDescending(e => e.MeetingID).FirstOrDefault();
var id = 0;
if (first != null)
{
id = first.MeetingID;
}
meeting.MeetingID = id + 1;
All().Insert(0, meeting);
}
else
{
using (var db = new SampleEntities())
{
if (meeting.Attendees == null)
{
meeting.Attendees = new int[0];
}
var entity = meeting.ToEntity();
foreach (var attendeeId in meeting.Attendees)
{
entity.MeetingAttendees.Add(new MeetingAttendee
{
AttendeeID = attendeeId
});
}
db.Meetings.AddObject(entity);
db.SaveChanges();
meeting.MeetingID = entity.MeetingID;
}
}
}
public static void Update(MeetingViewModel meeting)
{
if (!UpdateDatabase)
{
var target = One(e => e.MeetingID == meeting.MeetingID);
if (target != null)
{
target.Title = meeting.Title;
target.Start = meeting.Start;
target.End = meeting.End;
target.StartTimezone = meeting.StartTimezone;
target.EndTimezone = meeting.EndTimezone;
target.Description = meeting.Description;
target.IsAllDay = meeting.IsAllDay;
target.RecurrenceRule = meeting.RecurrenceRule;
target.RoomID = meeting.RoomID;
target.RecurrenceException = meeting.RecurrenceException;
target.RecurrenceID = meeting.RecurrenceID;
target.Attendees = meeting.Attendees;
}
}
else
{
using (var db = new SampleEntities())
{
if (meeting.Attendees == null)
{
meeting.Attendees = new int[0];
}
var entity = meeting.ToEntity();
db.Meetings.Attach(entity);
var attendees = meeting.Attendees.Select(attendee => new MeetingAttendee
{
AttendeeID = attendee
});
foreach (var attendee in attendees)
{
db.MeetingAttendees.Attach(attendee);
}
entity.MeetingAttendees.Clear();
foreach (var attendee in attendees)
{
entity.MeetingAttendees.Add(attendee);
}
db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
db.SaveChanges();
}
}
}
public static void Delete(MeetingViewModel meeting)
{
if (!UpdateDatabase)
{
var target = One(p => p.MeetingID == meeting.MeetingID);
if (target != null)
{
All().Remove(target);
var recurrenceExceptions = All().Where(m => m.RecurrenceID == meeting.MeetingID).ToList();
foreach (var recurrenceException in recurrenceExceptions)
{
All().Remove(recurrenceException);
}
}
}
else
{
using (var db = new SampleEntities())
{
if (meeting.Attendees == null)
{
meeting.Attendees = new int[0];
}
var entity = meeting.ToEntity();
db.Meetings.Attach(entity);
var attendees = meeting.Attendees.Select(attendee => new MeetingAttendee
{
AttendeeID = attendee
});
foreach (var attendee in attendees)
{
db.MeetingAttendees.Attach(attendee);
}
entity.MeetingAttendees.Clear();
var recurrenceExceptions = db.Meetings.Where(m => m.RecurrenceID == entity.MeetingID);
foreach (var recurrenceException in recurrenceExceptions)
{
db.Meetings.DeleteObject(recurrenceException);
}
db.Meetings.DeleteObject(entity);
db.SaveChanges();
}
}
}
