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(); }
static void Main(string[] args) { MainMenu1: Console.WriteLine("Aplikasi Test EF"); Console.WriteLine("===================================================="); Console.WriteLine("1. View Data \n"); Console.WriteLine("2. Create Data \n"); Console.WriteLine("3. Delete Data \n"); Console.WriteLine("4. Update Data \n"); Console.WriteLine("5. Exit \n"); Console.WriteLine("Pilih Operasi yang diinginkan (Masukan Angka) !!! \n"); string angka = Console.ReadLine(); Console.WriteLine(); if (angka == "1") { Console.WriteLine("Tampilkan data : \n"); LearnEFEntities entities = new LearnEFEntities(); var result = from t in entities.TodoLists select t; foreach (var t in result) { Console.WriteLine("{" + t.Id + "} {" + t.Todo + "} {" + t.Isdone + "}"); Console.ReadLine(); } Console.ReadKey(true); Console.WriteLine("Data all Display"); back: Console.WriteLine("Back to Main Menu? if to main menu input number 1 "); string back = Console.ReadLine(); if (back == "1") { Console.Clear(); goto MainMenu1; } else { goto back; } } else if (angka == "2") { addTodo(); Console.Clear(); goto MainMenu1; } else if (angka == "3") { deleteTodo(); Console.Clear(); goto MainMenu1; } else if (angka == "4") { updateTodo(); Console.Clear(); goto MainMenu1; } else { Environment.Exit(0); } }