public HttpResponseMessage Get(LatLongRequest model)
{
List <Ding> dingData = _service.Get(model);
ItemResponse <List <Ding> > resp = new ItemResponse <List <Ding> >();
if (dingData != null)
{
resp.Item = dingData;
return(Request.CreateResponse(HttpStatusCode.Created, resp));
}
return(Request.CreateResponse(HttpStatusCode.Created, resp));
}
internal IList <FuelStationDetail> GetLatLongSortedWithDistanceResults(LatLongRequest filter)
{
IList <FuelStationDetail> listResult = new List <FuelStationDetail>();
Command = new SqlCommand
{
Connection = (SqlConnection)Connection,
CommandType = CommandType.StoredProcedure,
CommandText = "Operation.GetLatLongSortedWithDistanceResults"
};
var param = new SqlParameter
{
ParameterName = "@Lattitude",
DbType = DbType.Decimal,
Value = filter.Lattitude
};
Command.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@Longitude",
DbType = DbType.Decimal,
Value = filter.Longitude
};
Command.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@FuelType",
DbType = DbType.String,
Value = filter.FuelType
};
Command.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@Distance",
DbType = DbType.Decimal,
Value = filter.Distance
};
Command.Parameters.Add(param);
listResult = Populate2((SqlDataReader)Command.ExecuteReader());
return(listResult);
}
public IList <FuelStationDetail> GetLatLongSortedWithDistanceResults(LatLongRequest filter)
{
IList <FuelStationDetail> _listResult = null;
try
{
Connection.Open();
_listResult = _fuelStationDa.GetLatLongSortedWithDistanceResults(filter);
}
finally
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
}
return(_listResult);
}
public List <Ding> Get(LatLongRequest model)
{
string storedProc = "[dbo].[Dings_SelectAll]";
List <Ding> dingData = null;
_dataProvider.ExecuteCmd(storedProc
, inputParamMapper : delegate(SqlParameterCollection sqlParams)
{
sqlParams.AddWithValue("@Date", model.Date);
sqlParams.AddWithValue("@Lat", model.Lat);
sqlParams.AddWithValue("@Long", model.Long);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
Ding ding = new Ding();
int startingIndex = 0;
ding.DingId = reader.GetSafeInt32(startingIndex++);
ding.DingCategory = reader.GetSafeString(startingIndex++);
ding.Value = reader.GetSafeString(startingIndex++);
ding.DateAdded = reader.GetSafeDateTime(startingIndex++);
ding.CreatedBy = reader.GetSafeInt32(startingIndex++);
ding.RouteId = reader.GetSafeInt32(startingIndex++);
ding.StopId = reader.GetSafeInt32(startingIndex++);
ding.StopDisplayName = reader.GetSafeString(startingIndex++);
ding.Agency = reader.GetSafeString(startingIndex++);
ding.Lat = reader.GetSafeDouble(startingIndex++);
ding.Long = reader.GetSafeDouble(startingIndex++);
ding.Miles = reader.GetSafeDouble(startingIndex++);
if (dingData == null)
{
dingData = new List <Ding>();
}
dingData.Add(ding);
});
return(dingData);
}
public Response Get(LatLongRequest request)
{
return(_fuelStationBr.GetLatLongSortedWithDistanceResults(request));
}
public Response GetLatLongSortedWithDistanceResults(LatLongRequest request)
{
try
{
var listResult = _repository.GetLatLongSortedWithDistanceResults(request);
var numberItems = listResult.Count;
if (numberItems == 0)
{
_response = new Response
{
IsSuccess = true,
NumberItems = numberItems,
ListResult = listResult,
StatusResponse = new StatusResponse
{
Status = 404,
Message = Default.LblHttpStatusCode404,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
return(_response);
}
_response = new Response
{
IsSuccess = true,
NumberItems = numberItems,
ListResult = listResult,
StatusResponse = new StatusResponse
{
Status = 200,
Message = Default.LblHttpStatusCode200
}
};
}
catch (Exception exception)
{
var exceptionLog = new ExceptionLog
{
ApplicationName = $"{ConfigurationManager.AppSettings["SolutionName"]} - {ConfigurationManager.AppSettings["UserFuelServices"]}",
Message = exception.Message
};
var exceptionRepository = new ExceptionLogRepository("MetadataConnection");
var exceptionId = exceptionRepository.Add(exceptionLog);
_response = new Response
{
IsSuccess = false,
ListResult = null,
StatusResponse = new StatusResponse
{
Status = 500,
Message = Default.LblHttpStatusCode500,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
}
return(_response);
}
