/// <summary>
/// To update the parking details of the vehicle
/// </summary>
/// <param name="parkingDetails"></param>
/// <returns></returns>
public bool UpdateParking(AddParkingDetails parkingDetails)
{
try
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand sqlCommand = new SqlCommand("spUpdateParkingRecord", sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@ParkingID", parkingDetails.ParkingID);
sqlCommand.Parameters.AddWithValue("@ParkingSlotNo", parkingDetails.ParkingSlotNo);
sqlCommand.Parameters.AddWithValue("@VehicleNo", parkingDetails.VehicleNo);
sqlCommand.Parameters.AddWithValue("@VehicleBrand", parkingDetails.VehicleBrand);
sqlCommand.Parameters.AddWithValue("@VehicleColour", parkingDetails.VehicleColour);
sqlCommand.Parameters.AddWithValue("@ParkingType", parkingDetails.ParkingType);
sqlCommand.Parameters.AddWithValue("@VehicleType", parkingDetails.VehicleType);
sqlCommand.Parameters.AddWithValue("EntryTime", parkingDetails.EntryTime);
sqlCommand.Parameters.AddWithValue("ExitTime", parkingDetails.ExitTime);
sqlCommand.Parameters.AddWithValue("@ChargePerHour", parkingDetails.ChargePerHour = 0);
sqlConnection.Open();
int result = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
if (result == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult AddParking(AddParkingDetails parkingDetails)
{
try
{
bool result = sample.AddParking(parkingDetails);
if (result == true)
{
string message = "Parking Details Entered Succesfully";
return(Ok(new { result, message }));
}
else
{
string message = "Parking Details Failed to be Entered ";
return(BadRequest(new { result, message }));
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool UpdateParking(AddParkingDetails parkingDetails)
{
return(sample.UpdateParking(parkingDetails));
}
public bool AddParking(AddParkingDetails parkingDetails)
{
return(sample.AddParking(parkingDetails));
}
