public static void UpdateCustomer()
{
Console.Clear();
Console.WriteLine("ClientID:");
int clientID = int.Parse(Console.ReadLine());
while (clientID.ToString() == "")
{
clientID = int.Parse(Console.ReadLine());
}
Console.WriteLine("Client Name:");
string name = Console.ReadLine();
while (name == "")
{
name = Console.ReadLine();
}
Console.WriteLine("Birth Date:");
string birthDate = Console.ReadLine();
Console.WriteLine("ZIP:");
string zip = Console.ReadLine();
while (zip == "")
{
zip = Console.ReadLine();
}
string conString = "Data Source=DESKTOP-MJA5A7T;Initial Catalog=Car Rent;Integrated Security=True";
SqlConnection con = new SqlConnection(conString);
con.Open();
if (Register_New_Customer.ClientExist(con, clientID) && Register_New_Customer.ZipValidation(zip) && Register_New_Customer.DataValidation(birthDate))
{
SqlCommand addCustomer = new SqlCommand("update Customers set Name=@name, BirthDate=@birthDate, Location=@location where CostumerID=@clientID", con);
addCustomer.Parameters.AddWithValue("@clientId", clientID);
addCustomer.Parameters.AddWithValue("@name", name);
addCustomer.Parameters.AddWithValue("@birthDate", birthDate);
addCustomer.Parameters.AddWithValue("@location", zip);
SqlDataReader reader = addCustomer.ExecuteReader();
Program.MenuScreen();
}
else
{
Console.WriteLine("invalid data");
}
}
public static void MenuScreen()
{
Console.Clear();
Console.WriteLine("Menu Screen");
Console.WriteLine();
Console.WriteLine("1. Register new Car Rent");
Console.WriteLine("2. Update Car Rent");
Console.WriteLine("3. List Rents");
Console.WriteLine("4. List Available Cars");
Console.WriteLine("5. Register new Customer");
Console.WriteLine("6. Update Customer");
Console.WriteLine("7. List Customers");
Console.WriteLine("8. Gold/Silver Customers");
Console.WriteLine("9. Most Recent Rented Cars");
Console.WriteLine("10. Most Rented Cars");
Console.WriteLine("11. Less rented Cars");
Console.WriteLine("12. Quit");
Console.WriteLine();
Console.WriteLine("Please, type the number associated with the option you want and the press ENTER");
//Application.EnableVisualStyles();
//Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new MenuScreen());
int number;
//ConsoleKeyInfo cki= Console.ReadKey()
try
{
number = int.Parse(Console.ReadLine());
if (number < 1 || number > 12)
{
Console.WriteLine("This is not a valid option");
}
switch (number)
{
case 1:
Register_New_Rent.RegisterNewCarRent();
break;
case 2:
Update_Rent.UpdateCarRent();
break;
case 3:
List_Rents.ListRents();
break;
case 4:
List_Available_Cars.ListAvailableCars();
break;
case 5:
Register_New_Customer.RegisterNewCustomer();
break;
case 6:
Update_Customer.UpdateCustomer();
break;
case 7:
List_Customers.ListCustomers();
break;
case 8:
Golden_Silver_Customers.GoldSilverCostumers();
break;
case 9:
Most_Recent_Rented_Cars.MostRecentRentedCars();
break;
case 10:
Most_Less_Rented_Cars.MostRentedCars();
break;
case 11:
Most_Less_Rented_Cars.LessRentedCars();
break;
case 12:
Environment.Exit(0);
break;
}
}
catch (FormatException)
{
Console.WriteLine("This is not a valid option");
}
}
