static void Main(string[] args) { Console.OutputEncoding = Encoding.Unicode; //Behöver ändra typsnitt i konsolenfönstret för att tyda ovanliga tecken. Console.InputEncoding = Encoding.Unicode; // Connectionstringen ligger högst upp i klassen SQLMethods MenuClass.MainMenu(); }
/// <summary> /// Ta bort fordon ur parkeringsplatsen, (hämtar ut) /// </summary> public static void RemoveVehicle(bool payForParking) { Console.Clear(); Console.WriteLine("Type your registrationnumber to remove your vehicle"); string userReg = Console.ReadLine(); connection.ConnectionString = connectionString; bool vehicleRemoved = false; using (connection) { SqlCommand command = new SqlCommand(); command.Connection = connection; //Här testar vi ifall användaren ska betala eller ej för parkering. Detta är för att undvika dublicering av kod. if (payForParking == true) { command.CommandText = "dbo.DeleteParkedVehicle"; } else if (payForParking != true) { command.CommandText = "dbo.RemoveVehicleForFree"; } command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@registrationNumber", userReg); try { connection.Open(); int affectedRows = command.ExecuteNonQuery(); if (affectedRows != 0) { Console.WriteLine("You have now removed your vehicle"); vehicleRemoved = true; } else { Console.WriteLine("Couldnt find your vehicle, try search again."); MenuClass.MainMenu(); } } catch { } } if (vehicleRemoved) { PrintRemovedVehicle(userReg); } }
/// <summary> /// Konverterar till giltiligt datum att skicka in för jämförelser i databasen. /// </summary> /// <param name="userDate">datumet att converetera till datetime.</param> /// <returns></returns> public static DateTime ConvertToDateTime(string userDate) { string date = userDate; DateTime time = new DateTime(); try { time = DateTime.Parse(date); } catch { Console.WriteLine("Invalid date, try again."); Console.ReadKey(); MenuClass.MainMenu(); } return(time); }
/// <summary> /// Flyttar fordon till önskad plats. /// </summary> public static void MoveVehicle() { Console.Clear(); Console.Write("Type your RegistrationNumber to move your vehicle: "); string userReg = Console.ReadLine(); Console.Write("To which spot would you like to move the vehicle to?:"); int userSpot = MenuClass.InputChecker(); connection.ConnectionString = connectionString; using (connection) { SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "dbo.MoveVehicleToSpecificSpot"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@registrationNumber", userReg); command.Parameters.AddWithValue("@parkingSpot", userSpot); try { connection.Open(); int affectedRows = command.ExecuteNonQuery(); if (affectedRows != 0) { Console.WriteLine("You have now moved your vehicle"); PrintWorkOrder(); } else { Console.WriteLine("Couldnt find your vehicle, try search again."); Console.ReadKey(); MenuClass.MainMenu(); } } catch { Console.WriteLine("Couldnt fit your vehicle to desired spot, or spot was not in parkinglot. 1-100"); } } }