public static void Insert(TaskViewModel task)
{
if (!UpdateDatabase)
{
var first = All().OrderByDescending(e => e.TaskID).FirstOrDefault();
var id = 0;
if (first != null)
{
id = first.TaskID;
}
task.TaskID = id + 1;
All().Insert(0, task);
}
else
{
using (var db = new SampleEntities())
{
var entity = task.ToEntity();
db.Tasks.AddObject(entity);
db.SaveChanges();
task.TaskID = entity.TaskID;
}
}
}
public static void Update(TaskViewModel task)
{
if (!UpdateDatabase)
{
var target = One(e => e.TaskID == task.TaskID);
if (target != null)
{
target.Title = task.Title;
target.Description = task.Description;
target.IsAllDay = task.IsAllDay;
target.RecurrenceRule = task.RecurrenceRule;
target.RecurrenceException = task.RecurrenceException;
target.RecurrenceID = task.RecurrenceID;
target.OwnerID = task.OwnerID;
target.StartTimezone = task.StartTimezone;
target.EndTimezone = task.EndTimezone;
target.Start = task.Start;
target.End = task.End;
}
}
else
{
using (var db = new SampleEntities())
{
var entity = task.ToEntity();
db.Tasks.Attach(entity);
db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
db.SaveChanges();
}
}
}
public static void Delete(TaskViewModel task)
{
if (!UpdateDatabase)
{
var target = One(p => p.TaskID == task.TaskID);
if (target != null)
{
All().Remove(target);
var recurrenceExceptions = All().Where(m => m.RecurrenceID == task.TaskID).ToList();
foreach (var recurrenceException in recurrenceExceptions)
{
All().Remove(recurrenceException);
}
}
}
else
{
using (var db = new SampleEntities())
{
var entity = task.ToEntity();
db.Tasks.Attach(entity);
var recurrenceExceptions = db.Tasks.Where(t => t.RecurrenceID == task.TaskID);
foreach (var recurrenceException in recurrenceExceptions)
{
db.Tasks.DeleteObject(recurrenceException);
}
db.Tasks.DeleteObject(entity);
db.SaveChanges();
}
}
}