static void Main(string[] args)
{
TsqlCrud crud = new TsqlCrud();
var customers = crud.ShowCustomers();
foreach (var cust in customers)
{
Console.WriteLine(cust.custid + "||" + cust.contactname);
}
}
public void InsertResturantTest()
{
resturant_info testResturant = new resturant_info
{
rest_name = "Burger King"
};
string restTestName = testResturant.rest_name;
TsqlCrud testeTsqlCrud = new TsqlCrud();
testResturant = testeTsqlCrud.AddResturant(testResturant);
Assert.AreEqual(restTestName, testResturant.rest_name);
}
public void Execution()
{
var libHelper = new TsqlCrud();
int intSelection = CheckInput();
while (intSelection != 4)
{
switch (intSelection)
{
case 1:
Console.Clear();
IEnumerable <resturant_info> sortedList3 = libHelper.SortingByName();
for (int i = 0; i < 3; i++)
{
Console.WriteLine(sortedList3.ElementAt(i).rest_name);
}
Console.WriteLine("Press Enter to return to Menu");
Console.ReadLine();
break;
case 2:
Console.Clear();
Console.WriteLine("How would you like to display the Resturants?");
Console.WriteLine("1) Display as: A-Z");
Console.WriteLine("2) Display as: Z-A");
Console.WriteLine("3) Display by: Rating");
intSelection = CheckInput();
Console.Clear();
if (intSelection == 1)
{
IEnumerable <resturant_info> sortedList = libHelper.SortingByName();
foreach (var x in sortedList)
{
Console.WriteLine(x.rest_name);
}
Console.WriteLine("Press Enter to Continue");
Console.ReadKey();
}
else if (intSelection == 2)
{
IEnumerable <resturant_info> sortedListDesc = libHelper.SortingByNameDesc();
foreach (var x in sortedListDesc)
{
Console.WriteLine(x.rest_name);
}
Console.WriteLine("Press Enter to Continue");
Console.ReadKey();
}
else if (intSelection == 3)
{
Console.Clear();
IEnumerable <resturant_info> sortedList = libHelper.SortingByRating().Reverse();
foreach (var x in sortedList)
{
Console.WriteLine(x.rest_name + " || Rating:" + x.rest_rating);
}
Console.WriteLine("Press Enter to Continue");
Console.ReadKey();
}
else
{
Console.WriteLine("Command Not Recognized");
}
break;
case 3:
//WORK ON SEARCHING THROUGH WITH CASE INSESITIVE
Console.Clear();
Console.WriteLine("Enter resturant name to view information");
string lookUpResturant = Console.ReadLine();
Log.Info(lookUpResturant);
IEnumerable <resturant_info> sortedLookUp = libHelper.SortingByName();
IEnumerable <resturant_info> restruantFound = sortedLookUp.Where(x => x.rest_name.Contains(lookUpResturant));
Console.Clear();
foreach (var rest in restruantFound)
{
Console.WriteLine(rest.rest_name);
Console.WriteLine(rest.rest_address);
Console.WriteLine(rest.city);
Console.WriteLine(rest.rest_zipcode);
Console.WriteLine(rest.state);
Console.WriteLine(rest.rest_phoneNumber);
Console.WriteLine("=========================================");
}
Console.WriteLine("Press Enter to Continue.");
Console.ReadKey();
break;
case 4:
Console.WriteLine("Should end...");
break;
default:
Console.WriteLine("Command not recognized.");
break;
}
Console.Clear();
Selection();
intSelection = CheckInput();
}
}
