// The id parameter name should match the DataKeyNames value set on the control
public void ListViewTodos_UpdateItem(int Id)
{
var db = new TodoDbContext();
TodoTask item = null;
var itemData = db.Todos.Find(Id);
if (itemData == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Item with id {0} was not found", Id));
return;
}
item = new TodoTask()
{
Title = itemData.Title,
Body = itemData.Body,
LastModified = DateTime.Now,
CategoryId = itemData.CategoryId
};
TryUpdateModel(item);
if (ModelState.IsValid)
{
itemData.Title = item.Title;
itemData.Body = item.Body;
itemData.LastModified = item.LastModified;
itemData.CategoryId = item.CategoryId;
db.SaveChanges();
}
}
// The id parameter name should match the DataKeyNames value set on the control
public void ListViewTodos_DeleteItem(int id)
{
var db = new TodoDbContext();
var todos = db.Todos.Find(id);
db.Todos.Remove(todos);
db.SaveChanges();
this.ListViewTodos.DataBind();
}
public void ListViewTodos_InsertItem()
{
var db = new TodoDbContext();
var item = new TodoTask();
TryUpdateModel(item);
if (ModelState.IsValid)
{
var itemData = new TodoTask()
{
Title = item.Title,
Body = item.Body,
LastModified = DateTime.Now,
CategoryId = item.CategoryId
};
db.Todos.Add(itemData);
db.SaveChanges();
}
}
// The id parameter name should match the DataKeyNames value set on the control
public void lvCategories_DeleteItem(int id)
{
var db = new TodoDbContext();
var category = db.Categories.Find(id);
db.Categories.Remove(category);
db.SaveChanges();
this.lvCategories.DataBind();
}
// 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<TodoTask> ListViewTodos_GetData()
{
var db = new TodoDbContext();
return db.Todos.AsQueryable();
}
// The id parameter name should match the DataKeyNames value set on the control
public void lvCategories_UpdateItem(int Id)
{
var db = new TodoDbContext();
Category item = null;
var itemData = db.Categories.Find(Id);
if (itemData == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Item with id {0} was not found", Id));
return;
}
item = new Category()
{
Name = itemData.Name
};
TryUpdateModel(item);
if (ModelState.IsValid)
{
itemData.Name = item.Name;
db.SaveChanges();
}
}
public void lvCategories_InsertItem()
{
var db = new TodoDbContext();
var item = new Category();
TryUpdateModel(item);
if (ModelState.IsValid)
{
var itemData = new Category()
{
Name = item.Name
};
db.Categories.Add(itemData);
db.SaveChanges();
}
}
// 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 lvCategories_GetData()
{
var db = new TodoDbContext();
return db.Categories.AsQueryable();
}
