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();
}
}
}
