public IQueryable<Message> ListMessages() { var context = new ChatCanalEntities(); var messages = context.Messages; return messages; }
public void ListMessages_DeleteItem(int id) { var context = new ChatCanalEntities(); using (context) { var message = context.Messages.FirstOrDefault(p => p.Id == id); context.Messages.Remove(message); context.SaveChanges(); } }
protected void makePostBtn_Click(object sender, EventArgs e) { var context = new ChatCanalEntities(); using (context) { var text = this.usersMessageText.Text; var user = context.AspNetUsers.FirstOrDefault(u => u.UserName == User.Identity.Name); Message post = new Message() { Name = text }; user.Messages.Add(post); context.SaveChanges(); this.ListPosts.DataBind(); } }
public void ListMessages_UpdateItem(int id) { var context = new ChatCanalEntities(); using (context) { var item = context.Messages.FirstOrDefault(p => p.Id == id); if (item == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Item not found", id)); return; } TryUpdateModel(item); if (ModelState.IsValid) { context.SaveChanges(); } } }