public static void addTodo() { using (var db = new LearnEFEntities()) { Console.WriteLine("Input Todo ="); string input1 = Console.ReadLine(); Console.WriteLine(); Console.WriteLine("Input Is Done (yes or no) ="); string input2 = Console.ReadLine(); Console.WriteLine(); bool Isdoneval = false; if (input2.ToLower() == "yes") { Isdoneval = true; } else if (input2.ToLower() == "no") { Isdoneval = false; } else { Console.WriteLine(" Salah Input !!!!!"); Console.WriteLine("Is Done (yes or no) ="); } var todo = new TodoList { Todo = input1, Isdone = Isdoneval }; Console.WriteLine("Data has been saved."); db.TodoLists.Add(todo); db.SaveChanges(); } }
public static void deleteTodo() { delete: Console.WriteLine("Input id table for deleted ="); int inputid = Convert.ToInt32(Console.ReadLine()); Console.WriteLine(); LearnEFEntities entities = new LearnEFEntities(); TodoList todoToDelete = (from r in entities.TodoLists.Where (a => a.Id == inputid) select r).FirstOrDefault(); try { entities.TodoLists.Remove(todoToDelete); Console.WriteLine("Data deleted. \n If delete data again press 1 : "); string back = Console.ReadLine(); if (back == "1") { goto delete; } else { entities.SaveChanges(); } } catch (Exception e) { Console.WriteLine("Data not found"); goto delete; } }
public static void updateTodo() { updateTodo: Console.WriteLine("Input id table for update ="); int inputid = Convert.ToInt32(Console.ReadLine()); Console.WriteLine(); LearnEFEntities entities = new LearnEFEntities(); TodoList todoToModofy = (from r in entities.TodoLists.Where (a => a.Id == inputid) select r).FirstOrDefault(); try { //update todo Console.WriteLine("Update Todo ="); string input1 = Console.ReadLine(); Console.WriteLine(); //update ISDONE Start: Console.WriteLine("Input Is Done (yes or no) ="); string input2 = Console.ReadLine(); Console.WriteLine(); bool Isdoneval = false; if (input2.ToLower() == "yes") { Isdoneval = true; } else if (input2.ToLower() == "no") { Isdoneval = false; } else { Console.WriteLine(" Wrong Input !!!!!"); goto Start; } todoToModofy.Todo = input1; todoToModofy.Isdone = Isdoneval; Console.WriteLine(" Data has been updated !!!!!"); } catch (Exception e) { Console.WriteLine("Data not found"); goto updateTodo; } entities.SaveChanges(); }