public static SimplifiedMessage GetMessage(int id) { using (var context = new versioningEntities()) { var result = context.SimplifiedMessages.Single(m => m.Id == id); return(result); } }
public static void UpdateMessage(SimplifiedMessage message) { using (var context = new versioningEntities()) { context.SimplifiedMessages.Attach(message); context.Entry(message).State = EntityState.Modified; try { context.SaveChanges(); } catch (DbUpdateConcurrencyException updateConcurrencyException) { var ex = new ConcurrencyException("Update failed.", updateConcurrencyException); throw ex; } } }
public ActionResult GetMessages() { using (var context = new versioningEntities()) { var messages = context.SimplifiedMessages.ToList(); var query = from m in messages select new SimplifiedMessageEncrypted { Id = m.Id, Number = m.Number, Created = m.Created, Version = m.Version, Modified = m.Modified, EncryptedVersion = this.Encrypt(m.Version) }; return(this.Json(query.ToList(), JsonRequestBehavior.AllowGet)); } }