/// <summary>
/// Sends the data request (in case of database calls stored procedure)
/// </summary>
/// <param name="dataResourceName">the resource name (stored procedure name if database used)</param>
protected virtual void SendDataRequest(string dataResourceName)
{
try
{
BuildDependencies();
_querryResults = _dataConnect.SendDataRequest(dataResourceName, _dataRequestParameters);
}
catch (Exception e)
{
throw new TouristTalkException("Error requesting data", e);
}
}
/// <summary>
/// Gets the vehicles pollution from database
/// </summary>
/// <param name="numberPlate">number plate of the vehicle</param>
/// <returns></returns>
private double GetVehicleDetailsPollution(string numberPlate)
{
try
{
IDataConnect vehicleDB = DependencyFactory.ResolveDataConnect();;
Dictionary <string, object> vehicleParameters = new Dictionary <string, object>()
{
{ "Registration", numberPlate }
};
List <Dictionary <string, object> > vehicleDetails
= vehicleDB.SendDataRequest("usp_GetVehicleData", vehicleParameters);
VehicleNo = (int)vehicleDetails[0]["VehicleID"];
return((double)vehicleDetails[0]["Pollution"]);
}
catch (Exception ex)
{
throw new JunctionException("Error getting vehicle pollution data from data source", ex);
}
}
/// <summary>
/// Logs vehicle details to database
/// </summary>
private void LogJourney()
{
try
{
if (LogjourneySetting())
{
IDataConnect vehicleDB = DependencyFactory.ResolveDataConnect();
Dictionary <string, object> vehicleParameters = new Dictionary <string, object>()
{
{ "ID", VehicleNo },
{ "RouteNo", RouteNo },
{ "SectionNo", SectionNo },
{ "Direction", Direction },
{ "Pollution", Pollution }
};
List <Dictionary <string, object> > vehicleDetails
= vehicleDB.SendDataRequest("usp_InsertJourneyLog", vehicleParameters);
}
}
catch (JunctionException ex)
{
throw new JunctionException("Error Logging Journey to database", ex);
}
}
