/// <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)); }