public ToDoListViewModel()
{
DbHelper dbHelper = new DbHelper();
dbHelper.CheckIfDbExist();
using (var db = new SqliteConnection(dbHelper.GetConnection().ConnectionString)) {
db.Open();
this.EditableItem = new ToDoItem();
this.ToDoItems = new List <ToDoItem>();
var listItemsCmd = db.CreateCommand();
listItemsCmd.CommandText = "SELECT * FROM todo_items ORDER BY add_date DESC";
using (SqliteDataReader reader = listItemsCmd.ExecuteReader())
{
while (reader.Read())
{
ToDoItem toDoItem = new Models.ToDoItem()
{
Id = (int)(long)reader["id"],
DateAdded = Convert.ToDateTime(reader["add_date"]),
Title = reader["title"].ToString(),
IsDone = Convert.ToBoolean(reader["is_done"])
};
this.ToDoItems.Add(toDoItem);
}
}
}
}
public IActionResult FormPost(string noteTitle, string noteText)
{
Models.ToDoItem newItem = new Models.ToDoItem()
{
Id = itemId + 1,
NoteTitle = noteTitle,
NoteText = noteText
};
return(RedirectToAction("Index", newItem));
}
public ActionResult Index()
{
Models.HomeModel model = new Models.HomeModel();
model.TdList = new List <Models.ToDoItem>();
Models.ToDoItem task1 = new Models.ToDoItem("Go to store", "Need to go to the store and pick up some groceries", 1);
Models.ToDoItem task2 = new Models.ToDoItem("Clean up leaves", "Clean up the leaves in the yard and place then in bags", 2);
Models.ToDoItem task3 = new Models.ToDoItem("Mow the lawn", "After cleaning up the leaves, mow the lawn", 3);
model.TdList.Add(task1);
model.TdList.Add(task2);
model.TdList.Add(task3);
return(View(model));
}
public async Task <IActionResult> AddItem(Models.ToDoItem newItem)
{
if (!ModelState.IsValid)
{
RedirectToAction("Index");
}
var success = await _toDoItemService.AddItemAsync(newItem);
if (!success)
{
return(BadRequest("Could not add item"));
}
return(RedirectToAction("Index"));
}
public static List<ToDoItem> GetList(int userId)
{
List<Models.ToDoItem> userList = new List<ToDoItem>();
var listItems = (from x in DbConnector.GetConnection().Users
where x.Id == userId
select x).Single().ListItems.OrderBy(x => x.Priority).Reverse();
foreach (var listItem in listItems)
{
Models.ToDoItem newItem = new Models.ToDoItem {
id = listItem.Id,
priority = listItem.Priority,
text = listItem.Text
};
userList.Add(newItem);
}
return userList;
}
// GET: /<controller>/
public IActionResult Index(Models.ToDoItem item)
{
return(View(item));
}
