public static void AddRecords(List <Record> records)
{
using (var context = new TimerContext())
{
context.Records.AddRange(records);
context.SaveChanges();
}
}
public static void AddGroup(Group group)
{
using (var context = new TimerContext())
{
context.Users.Attach(group.User);
context.Groups.Add(group);
context.SaveChanges();
context.Entry(group).State = System.Data.Entity.EntityState.Unchanged;
}
}
public static void DeleteRecords(List <Guid> record_ids)
{
using (var context = new TimerContext())
{
var toDelete = context.Records.Where(r => record_ids.Contains(r.Id)).ToList();
foreach (Record record in toDelete)
{
context.Records.Remove(record);
}
context.SaveChanges();
}
}
public static void AddRecord(Record record)
{
using (var context = new TimerContext())
{
context.Users.Attach(record.User);
if (record.Group != null)
{
context.Groups.Attach(record.Group);
}
context.Records.Add(record);
context.SaveChanges();
}
}
public static void UpdateRecord(Record record, string[] update_fields)
{
using (var context = new TimerContext())
{
context.Users.Attach(record.User);
if (record.Group != null)
{
context.Groups.Attach(record.Group);
}
Record nRecord = context.Records.FirstOrDefault(r => r.Id == record.Id);
if (nRecord == null)
{
context.Records.Add(record);
}
else
{
foreach (string p in update_fields)
{
switch (p)
{
case "StartTime":
nRecord.StartTime = record.StartTime;
break;
case "Duration":
nRecord.Duration = record.Duration;
break;
case "EndTime":
nRecord.EndTime = record.EndTime;
break;
case "Comment":
nRecord.Comment = record.Comment;
break;
case "Group":
nRecord.Group = record.Group;
nRecord.GroupId = record.GroupId;
break;
}
}
}
context.SaveChanges();
}
}