public static void RemoveDataFromDatabase() { using (var db = new TodoListEntities()) { Console.Write("\nDo you want to remove any Task? y/n "); ConsoleKeyInfo keyInfo = Console.ReadKey(); if (keyInfo.Key == ConsoleKey.Y) { Console.Write("\nPlease enter TaskID to remove it --> "); int taskId = int.Parse(Console.ReadLine()); var taskDelete = db.Tasks.Find(taskId); if (taskDelete != null) { db.Tasks.Remove(taskDelete); db.SaveChanges(); Console.WriteLine("Task removed successfully"); } else { Console.WriteLine("Task with this Id can't find"); } } else if (keyInfo.Key == ConsoleKey.N) { } else { Console.WriteLine("\nThis Key is not valid"); } } }
public static void DisplayAllData() { using (var db = new TodoListEntities()) { Console.WriteLine("All Tasks in the database:\n"); Console.WriteLine("TaskID | Task"); Console.WriteLine("-------|------------------"); foreach (var item in db.Tasks .OrderBy(t => t.TaskID)) { Console.WriteLine(string.Format("{0, -6} | {1}", item.TaskID, item.Context)); } } }
public static void AddDataToDatabase() { using (var db = new TodoListEntities()) { Console.WriteLine("enter a Chore or Task:"); var userEnter = Console.ReadLine(); var task = new Tasks { Context = userEnter }; while (!string.IsNullOrWhiteSpace(task.Context)) { db.Tasks.Add(task); db.SaveChanges(); Console.WriteLine("enter a Chore or Task:"); userEnter = Console.ReadLine(); task = new Tasks { Context = userEnter }; } } }