// BaseData class will be parent of this class
public void InsertParkingSpace(ParkingSpace parkingSpace)
{
SqlConnection connection = ManageDatabaseConnection("Open");
try
{
using (SqlCommand sqlCommand = new SqlCommand("insert_newParkingSpace", connection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add("@SpaceNumber", SqlDbType.VarChar).Value = parkingSpace.SpaceNumber;
sqlCommand.Parameters.Add("@IdParkingLot", SqlDbType.Int).Value = parkingSpace.IdParkingLot;
sqlCommand.ExecuteNonQuery();
connection = ManageDatabaseConnection("Close");
}
}
catch (SqlException sqlException)
{
throw sqlException;
}
}
public void InsertNewParkingSpace(ParkingSpace parkingSpace)
{
parkingSpaceData.InsertParkingSpace(parkingSpace);
}
void insertSpaceInDB()
{
ParkingSpace newSpace = new ParkingSpace(TextBoxSpaceIdentifier.Text, 1);
ParkingSpaceTransaction newSpaceTransaction = new ParkingSpaceTransaction();
newSpaceTransaction.InsertNewParkingSpace(newSpace);
ParkingSpaceTransaction transaction = new ParkingSpaceTransaction();
List<string> existingSpaces = transaction.PrintExistingSpaces(1);
printInScreen(existingSpaces);
}
