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();
}
