public int AddEvent(JsonEvent e) { var inserted = db.Events.Add(ToDbEvent(e)); db.SaveChanges(); e.Id = inserted.Id; e.Time = inserted.Time; return inserted.Id; }
public void UpdateEvent(JsonEvent jevent) { var ev = db.Events.Find(jevent.Id); var nev = ToDbEvent(jevent); ev.Comments = nev.Comments; ev.Contact = nev.Contact; ev.SourceReliability = nev.SourceReliability; ev.Text = nev.Text; ev.Time = nev.Time; ev.Topic = nev.Topic; ev.User = nev.User; db.SaveChanges(); }
private Event ToDbEvent(JsonEvent e) { return new Event { Text = e.Event, Comments = e.Comments, Contact = e.Contact, Time = e.Time.HasValue ? e.Time.Value : DateTime.Now, SourceReliability = e.SourceReliability != null ? db .SourceReliability .SingleOrDefault(sr => sr.Text == e.SourceReliability) ?? new SourceReliability { Text = e.SourceReliability } : null, Topic = e.Topic, User = e.User != null ? db .User .SingleOrDefault(u => u.Name == e.User) ?? new User { Name = e.User } : null }; }