private static void UpdateTaskTest() { var taskRepository = new AdoNetTasksDbRepository(); Console.WriteLine("Enter existing task id"); var id = int.Parse(Console.ReadLine()); var task = taskRepository.GetByIdAsync(id).GetAwaiter().GetResult(); if (task == null) { Console.WriteLine($"Task with id: {id} does not exist"); return; } Console.WriteLine("Enter task title"); task.Title = Console.ReadLine(); Console.WriteLine("Enter task description"); task.Description = Console.ReadLine(); Console.WriteLine("Enter task status"); task.Status = (DataLayer.Enums.Status) int.Parse(Console.ReadLine()); Console.WriteLine("Enter task type"); task.Type = (DataLayer.Enums.TaskType) int.Parse(Console.ReadLine()); Console.WriteLine("Enter task priority"); task.Priority = (DataLayer.Enums.Priority) int.Parse(Console.ReadLine()); taskRepository.UpdateAsync(task).GetAwaiter().GetResult(); Console.WriteLine("Successful update"); Console.ReadLine(); }
private static void InsertTaskTest() { var taskRepository = new AdoNetTasksDbRepository(); var task = new DataLayer.Entities.Task(); Console.WriteLine("Enter task title"); task.Title = Console.ReadLine(); Console.WriteLine("Enter task description"); task.Description = Console.ReadLine(); Console.WriteLine("Enter task status"); task.Status = (DataLayer.Enums.Status) int.Parse(Console.ReadLine()); Console.WriteLine("Enter task type"); task.Type = (DataLayer.Enums.TaskType) int.Parse(Console.ReadLine()); Console.WriteLine("Enter task priority"); task.Priority = (DataLayer.Enums.Priority) int.Parse(Console.ReadLine()); taskRepository.AddAsync(task).GetAwaiter().GetResult(); Console.WriteLine($"Id of the new inserted task: {task.Id}"); Console.ReadLine(); }
static void Main(string[] args) { var taskRepository = new AdoNetTasksDbRepository(); //IEnumerable<DataLayer.Entities.Task> tasks = taskRepository.GetAllAsync() // .GetAwaiter() // .GetResult(); //foreach (var task in tasks) //{ // Console.WriteLine("---------------------------------------------------"); // Console.WriteLine($"Task Id:{task.Id} Title:{task.Title} Description:{task.Description} Priority:{task.Priority} Status:{task.Status} Type:{task.Type}"); // foreach (var subtask in task.SubTasks) // { // Console.WriteLine($"Subtask Id: {subtask.Id}, Title: {subtask.Title}, Description: {subtask.Description}, Status: {subtask.Status}, "); // } // Console.WriteLine("---------------------------------------------------"); //} //Console.WriteLine("Finished with tasks printing"); //Console.WriteLine("Enter task id:"); //int taskId = int.Parse(Console.ReadLine()); //var task = taskRepository.GetByIdAsync(taskId).GetAwaiter().GetResult(); //string taskId = Console.ReadLine(); //var task = taskRepository.GetById(taskId); Console.WriteLine("Enter task title:"); string taskTitle = Console.ReadLine(); var task = taskRepository.GetByTitle(taskTitle); Console.WriteLine($"Task Id:{task.Id} Title:{task.Title} Description:{task.Description} Priority:{task.Priority} Status:{task.Status} Type:{task.Type}"); Console.ReadLine(); }
private static void GetCountTest() { var taskRepository = new AdoNetTasksDbRepository(); var tasksCount = taskRepository.GetCount(); Console.WriteLine($"There are {tasksCount} tasks in the database"); Console.ReadLine(); }
private static void DeleteTaskTest() { var taskRepository = new AdoNetTasksDbRepository(); Console.WriteLine("Enter existing task id"); var id = int.Parse(Console.ReadLine()); var task = taskRepository.GetByIdAsync(id).GetAwaiter().GetResult(); if (task == null) { Console.WriteLine($"Task with id: {id} does not exist"); return; } taskRepository.RemoveAsync(task).GetAwaiter().GetResult(); Console.WriteLine("Successful delete"); Console.ReadLine(); }