public void NewParkingLocation()
{
var location = new ParkingLocation("A");
Assert.AreEqual("A", location.Name);
Assert.IsNull(location.Occupant);
}
public void InsertParkingLocation(ParkingLocation location)
{
string insertComand = "INSERT INTO ParkingLocations(";
insertComand += "GlobalID, Title, Address, Latitude, Longitude, ParkingType, HasValet, Description, Website, DateCreated, LocationPoint) ";
insertComand += "Values(@GlobalID, @Title, @Address, @Latitude, @Longitude, @ParkingType, @HasValet, @Description, @Website, @DateCreated, @LocationPoint)";
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(insertComand, connection))
{
command.Parameters.Add(new SqlParameter("@GlobalID", location.GlobalID));
command.Parameters.Add(new SqlParameter("@Title", location.Title));
command.Parameters.Add(new SqlParameter("@Address", location.Address));
command.Parameters.Add(new SqlParameter("@Latitude", location.Latitude));
command.Parameters.Add(new SqlParameter("@Longitude", location.Longitude));
command.Parameters.Add(new SqlParameter("@ParkingType", location.ParkingType));
command.Parameters.Add(new SqlParameter("@HasValet", location.HasValet));
command.Parameters.Add(new SqlParameter("@Description", location.Description));
command.Parameters.Add(new SqlParameter("@Website", location.Website));
command.Parameters.Add(new SqlParameter("@DateCreated", DateTime.UtcNow));
string locationPoint = $"POINT({location.Longitude} {location.Latitude})";
command.Parameters.Add(new SqlParameter("@LocationPoint", locationPoint));
command.ExecuteNonQuery();
}
}
}
public void ParkingLocationParkAuto()
{
var handler = new MessageHandler <ParkingLocation.AutoParked>();
Simulator.Notifier.Subscribe(handler);
var location = new ParkingLocation("A");
var auto = new Auto("", 0);
location.ParkAuto(auto);
Assert.AreSame(auto, location.Occupant);
Assert.AreEqual(1, handler.MessageCount);
Assert.AreEqual(auto, handler.Message.Auto);
Simulator.Notifier.UnsubscribeFromAll(handler);
}
public void ParkingLocationNullAutoDeparts()
{
var handler = new MessageHandler <ParkingLocation.AutoDeparted>();
Simulator.Notifier.Subscribe(handler);
var location = new ParkingLocation("A");
try
{
location.AutoDeparts();
}
finally
{
Assert.AreEqual(0, handler.MessageCount);
Simulator.Notifier.UnsubscribeFromAll(handler);
}
}
public void AddLocation([FromBody] string locationJson)
{
ParkingLocation location = JsonConvert.DeserializeObject <ParkingLocation>(locationJson);
try
{
location.GlobalID = Guid.NewGuid().ToString();
_dataAccessService.InsertParkingLocation(location);
}
catch (Exception ex)
{
//return new StatusCodeResult(500);
}
//return new StatusCodeResult(200);
}
public List <ParkingLocation> GetAllLocations()
{
List <ParkingLocation> locations = new List <ParkingLocation>();
#region Mock locations
ParkingLocation p1 = new ParkingLocation();
p1.Address = "4221 34th Street";
p1.GlobalID = Guid.NewGuid().ToString();
p1.HasValet = false;
p1.Latitude = -117.3241;
p1.Longitude = 32.8375;
p1.ParkingType = ParkingTypes.Lot;
p1.Title = "Ace Parking San Diego - 32";
p1.Website = "http://aceparkingsd.com";
ParkingLocation p2 = new ParkingLocation();
p2.Address = "1330 Market Street";
p2.GlobalID = Guid.NewGuid().ToString();
p2.HasValet = false;
p2.Latitude = -117.5241;
p2.Longitude = 32.5895;
p2.ParkingType = ParkingTypes.Structure;
p2.Title = "Airport Terminal Parking";
p2.Website = "http://airportparksd.com";
//locations.Add(p1);
//locations.Add(p2);
#endregion
string selectCommand = "SELECT GlobalID, Title, Address, Latitude, Longitude, ParkingType, HasValet, Description, Website FROM ParkingLocations";
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(selectCommand, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ParkingLocation location = new ParkingLocation();
location.GlobalID = reader.GetGuid(0).ToString();
location.Title = reader.GetString(1);
if (!reader.IsDBNull(2))
{
location.Address = reader.GetString(2);
}
location.Latitude = reader.GetDouble(3);
location.Longitude = reader.GetDouble(4);
location.ParkingType = (ParkingTypes)reader.GetInt32(5);
location.HasValet = reader.GetBoolean(6);
if (!reader.IsDBNull(7))
{
location.Description = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
location.Website = reader.GetString(8);
}
locations.Add(location);
}
}
}
}
return(locations);
}
public List <ParkingLocation> GetLocationsWithinEnvelope(Envelope envelope)
{
List <ParkingLocation> locations = new List <ParkingLocation>();
//string selectCommand = "SELECT * FROM ParkingLocations WHERE geography::STPolyFromText('@Envelope', @Wkid).STContains(LocationPoint) = 0";
//string selectCommand = "SELECT GlobalID, Title, Address, Description, HasValet, Latitude, Longitude, ParkingType, Website, DateCreated FROM ParkingLocations WHERE geography::STPointFromText('POINT(' + CAST(Longitude as VARCHAR(20)) + ' ' + CAST(Latitude as VARCHAR(20)) + ')',4326).STWithin(geography::STPolyFromText('@Envelope', @Wkid)) = 0";
string selectCommand = "getLocationsWithinEnvelope";
//32.709528, -117.170906
//32.710729, -117.128088
//32.739684, -117.128903
//32.744172, -117.180230
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(selectCommand, connection))
{
//SqlParameter envelopeParam = new SqlParameter("@Envelope", $"POLYGON(({envelope.Xmin} {envelope.Ymin}, {envelope.Xmin} {envelope.Ymax}, {envelope.Xmax} {envelope.Ymax}, {envelope.Xmax} {envelope.Ymin}, {envelope.Xmin} {envelope.Ymin}))");
//SqlParameter wkidParam = new SqlParameter("@Wkid", envelope.Wkid);
//"POLYGON((-117.170906 32.709528, -117.128088 32.710729,-117.128903 32.739684,-117.180230 32.744172,-117.170906 32.709528)), 4326)");
//command.Parameters.Add(envelopeParam);
//command.Parameters.Add(wkidParam);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = selectCommand;
SqlParameter xmin = new SqlParameter("@xmin", envelope.Xmin);
SqlParameter xmax = new SqlParameter("@xmax", envelope.Xmax);
SqlParameter ymin = new SqlParameter("@ymin", envelope.Ymin);
SqlParameter ymax = new SqlParameter("@ymax", envelope.Ymax);
command.Parameters.AddRange(new[] { xmin, xmax, ymin, ymax });
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ParkingLocation location = new ParkingLocation();
location.GlobalID = reader.GetGuid(0).ToString();
location.Title = reader.GetString(1);
if (!reader.IsDBNull(2))
{
location.Address = reader.GetString(2);
}
location.HasValet = reader.GetBoolean(4);
if (!reader.IsDBNull(3))
{
location.Description = reader.GetString(3);
}
location.Latitude = reader.GetDouble(5);
location.Longitude = reader.GetDouble(6);
location.ParkingType = (ParkingTypes)reader.GetInt32(7);
if (!reader.IsDBNull(8))
{
location.Website = reader.GetString(8);
}
locations.Add(location);
}
}
}
}
return(locations);
}
public ParkingLocation GetParkingLocation(string id)
{
ParkingLocation location = new ParkingLocation();
//#region Mock Location
//location.Address = "5160 Carroll Canyon Rd";
//location.GlobalID = Guid.NewGuid().ToString();
//location.HasValet = false;
//location.Latitude = -117.5241;
//location.Longitude = 32.9154;
//location.ParkingType = ParkingTypes.Street;
//location.Title = "San Diego City Metered Parking";
//location.Website = "http://sandiegometered.com";
//#endregion
string selectCommand = "SELECT GlobalID, Title, Address, Latitude, Longitude, ParkingType, HasValet, Description, Website FROM ParkingLocations ";
selectCommand += "WHERE GlobalID = @GlobalID";
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(selectCommand, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
location.GlobalID = reader.GetGuid(0).ToString();
location.Title = reader.GetString(1);
if (!reader.IsDBNull(2))
{
location.Address = reader.GetString(2);
}
location.Latitude = reader.GetFloat(3);
location.Longitude = reader.GetFloat(4);
location.ParkingType = (ParkingTypes)reader.GetInt32(5);
location.HasValet = reader.GetBoolean(6);
if (!reader.IsDBNull(7))
{
location.Description = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
location.Website = reader.GetString(8);
}
}
}
}
}
return(location);
}
