public ResultTransactionModel GetLocations(Vehicle vehicle, out GetLocationModel model)
{
try
{
GetLocationModel modelTem = new GetLocationModel();
modelTem.locations = new List <Location>();
conn.Open();
var command = conn.CreateCommand();
command.CommandText = "[GetVehicleLocation]";
command.CommandType = CommandType.StoredProcedure;
DbParameter vehicleId = command.CreateParameter();
vehicleId.ParameterName = "@vehicleId";
vehicleId.Value = vehicle.vehicleId;
command.Parameters.Add(vehicleId);
DbDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
DateTime datetime = Convert.ToDateTime(reader["datetime"]);
string[] location = Convert.ToString(reader["location"]).Split(' ');
modelTem.locations.Add(new Location()
{
datetime = datetime, latitud = location[0], longitud = location[1]
});
}
model = modelTem;
return(new ResultTransactionModel()
{
numAffactedRows = null, Description = null
});
}
finally {
conn.Close();
}
}
public async Task <IActionResult> GetLocationForUpdate(string Name)
{
string userid = User.Claims.First(c => c.Type == "UserId").Value;
var user = await _userManager.FindByIdAsync(userid);
var location = _db.LocationInfos.Where(x => x.Owner.UserName == user.UserName).ToList();
foreach (LocationInfo Locate in location)
{
if (Locate.Name == Name)
{
Result = Locate;
break;
}
}
GetLocationModel locationModel = new GetLocationModel
{
CityName = Result.District.city.CityName,
DistrictName = Result.District.DistrictName,
Menu = Result.Menu,
Type = Result.Type,
Name = Result.Name
};
return(Ok(locationModel));
}
public void GetCurrentLocationTest()
{
var updateLocationModel = new GetLocationModel
{
vehicle = new Vehicle {
vehicleId = "AAA-AAA"
}
};
VahicleController vehicleController = new VahicleController(repository);
vehicleController.Request = new HttpRequestMessage();
vehicleController.Request.SetConfiguration(new HttpConfiguration());
var result = vehicleController.GetCurrectLocation(updateLocationModel);
}
public HttpResponseMessage GetLocations(GetLocationModel request)
{
var resultado = repository.GetLocations(request.vehicle, out request);
return(Request.CreateResponse(HttpStatusCode.OK, new { resultado = resultado, data = request }));
}
