private static void HandleDeleteOperation()
{
Console.Write("Enter the JobId to Delete : ");
if (int.TryParse(Console.ReadLine(), out var temp))
{
JobModel.JobId = temp;
}
else
{
JobModel.JobId = 0;
Console.WriteLine("Input is not in numbers..INVALID");
}
if (Oracle.CheckJobExists())
{
Oracle.DeleteJob();
}
}
static void HandleUpdateOperation()
{
Console.Write("Enter Job Id to Update: ");
if (int.TryParse(Console.ReadLine(), out var temp))
{
JobModel.JobId = temp;
}
else
{
JobModel.JobId = 0;
Console.WriteLine("Input is not in numbers..INVALID");
}
if (Oracle.CheckJobExists())
{
UserInteraction.GetJobDetails();
Oracle.UpdateJob();
}
}
static void Main(string[] args)
{
while (true)
{
switch (UserInteraction.GetCRUDOperation())
{
case 1:
UserInteraction.GetJobDetails();
Oracle.InsertJob();
break;
case 2:
HandleRetrieveOperation();
break;
case 3:
HandleUpdateOperation();
break;
case 4:
HandleDeleteOperation();
break;
default:
Console.WriteLine("Choise is Not awailable..exiting..!");
break;
}
Console.Write("\nWant to do another operation ? Y/N : ");
var userInput = Console.ReadLine();
if (!(userInput == "Y" || userInput == "y"))
{
break;
}
Console.WriteLine();
}
Console.WriteLine("\nProgram is Terminating...!");
Thread.Sleep(500);
}
static void HandleRetrieveOperation()
{
while (true)
{
Console.Write("Single Job : 0 \nMultiple Jobs : 1 \nPick Your Choice : ");
if (!int.TryParse(Console.ReadLine(), out var temp))
{
temp = 9;
}
if (temp == 0)
{
Console.Write("Enter the JobId to retrieve related data: ");
if (int.TryParse(Console.ReadLine(), out temp))
{
JobModel.JobId = temp;
}
else
{
JobModel.JobId = 0;
Console.WriteLine("Input is not in numbers..INVALID");
}
Console.WriteLine("- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -");
Oracle.RetrieveJob();
break;
}
if (temp == 1)
{
Console.WriteLine(" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -");
Oracle.RetrieveJobs();
Console.WriteLine(" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -");
break;
}
Console.WriteLine("\nChoose from 0 and 1");
}
}