public IQueryable<Message> GetMessages() { ChatIdentityEntities context = new ChatIdentityEntities(); var messages = context.Messages; return messages; }
// The return type can be changed to IEnumerable, however to support // paging and sorting, the following parameters must be added: // int maximumRows // int startRowIndex // out int totalRowCount // string sortByExpression public IQueryable<Message> ListViewAdmin_GetData() { ChatIdentityEntities context = new ChatIdentityEntities(); var messages = context.Messages; return messages; }
// The id parameter name should match the DataKeyNames value set on the control public void ListViewAdmin_DeleteItem(int messageId) { ChatIdentityEntities context = new ChatIdentityEntities(); Message message = context.Messages.Find(messageId); if (message != null) { context.Messages.Remove(message); context.SaveChanges(); } }
protected void ButtonSend_Click(object sender, EventArgs e) { var message = Server.HtmlEncode(this.TextBox_NewMessage.Text); if (message == string.Empty) { return; } ChatIdentityEntities context = new ChatIdentityEntities(); context.Messages.Add(new Message() { Message1 = message }); context.SaveChanges(); }
// The id parameter name should match the DataKeyNames value set on the control public void ListViewAdmin_UpdateItem(int messageId) { // Load the item here, e.g. item = MyDataLayer.Find(id); ChatIdentityEntities context = new ChatIdentityEntities(); Message message = context.Messages.Find(messageId); if (message == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Category with id {0} was not found", messageId)); return; } TryUpdateModel(message); if (ModelState.IsValid) { context.Entry(message).State = EntityState.Modified; context.SaveChanges(); } }