public Person(AddressSearch.AdressProvider.Entities.Person person, District district)
{
this.Name = person.Name;
this.Lastname = person.Lastname;
this.StreetAddress = person.StreetAddress;
this.TelephoneNumber = person.TelephoneNumber;
this.Longitude = person.Longitude;
this.Latitude = person.Latitude;
this.District = district;
}
public string address(AddressSearch search)
{
try
{
result = orm.execObject <Result>(search, "api.admin_search_address");
}
catch (Exception exp)
{
errorResult(exp);
}
return(formattedResult(result));
}
public void If_Has_Only_One_Address_Should_Call_The_Finder_Only_Once()
{
var address = new AddressSearch("asd", 100, "asd", "asd", "123");
var list = new List <AddressSearch>()
{
address
};
_routeService.CalculateRouteAsync(list, RouteType.DefaultRouteFaster);
_mockFinder.Verify(x => x.FindCoordinateAsync(address), Times.Once);
}
public void If_Not_Null_Object_Was_Passed_Should_Call_The_Route_Calculator()
{
var address = new AddressSearch("asd", 100, "asd", "asd", "123");
var list = new List <AddressSearch>()
{
address
};
_routeService.CalculateRouteAsync(list, RouteType.DefaultRouteFaster);
_mockRouteCalculator.Verify(x => x.CalcuteRouteAsync(It.IsAny <IList <AddressSearch> >(), RouteType.DefaultRouteFaster), Times.Once());
}
public void If_Not_Null_Object_Was_Passed_Should_Call_The_Coordinate_Finder()
{
var address = new AddressSearch("asd", 100, "asd", "asd", "123");
var list = new List <AddressSearch>()
{
address
};
_routeService.CalculateRouteAsync(list, RouteType.DefaultRouteFaster);
_mockFinder.Verify(x => x.FindCoordinateAsync(address));
}
public void If_Has_Only_Two_Addresses_Should_Call_The_Finder_Only_Teice()
{
var address1 = new AddressSearch("asd", 100, "asd", "asd", "123");
var address2 = new AddressSearch("asd", 100, "asd", "asd", "123");
var list = new List <AddressSearch>()
{
address1, address2
};
_routeService.CalculateRouteAsync(list, RouteType.DefaultRouteFaster);
_mockFinder.Verify(x => x.FindCoordinateAsync(It.IsAny <AddressSearch>()), Times.Exactly(2));
}
public async void Should_Set_Coordinates_For_A_Known_Address()
{
var routeService = new RouteService(new MapLinkCoordinateFinder(new MapLinkToken()), new MapLinkRouteCalculator(new MapLinkToken()));
var address1 = new AddressSearch("Avenida Paulista", 1000, "São Paulo", "SP");
var address2 = new AddressSearch("Avenida Paulista", 2000, "São Paulo", "SP");
var list = new List <AddressSearch>()
{
address1, address2
};
await routeService.CalculateRouteAsync(list, RouteType.DefaultRouteFaster);
Assert.IsTrue(address1.Latitude != 0 && address1.Longitude != 0);
}
public async Task <Coordinate> FindCoordinateAsync(AddressSearch search)
{
using (var addressFinderSoapClient = new AddressFinderSoapClient())
{
var address = Mapper.Map <AddressSearch, Address>(search);
var response = await addressFinderSoapClient.findAddressAsync(address, _config.GetAddressOptions(), _token.Tokenvalue);
if (response.Body.findAddressResult.addressLocation.Length > 0)
{
var point = response.Body.findAddressResult.addressLocation[0].point;
return(new Coordinate(point.y, point.x));
}
}
return(await Task.FromResult(Coordinate.Empty()));
}
protected void Page_Load(object sender, EventArgs e)
{
EntityCollection<AddressEntity, AddressMeta> coll = new AddressSearch().GetAddressCollection();
coll[3].AddressLine2 = "pero";
JsonEntitySet jData = new JsonEntitySet(HttpContext.Current, coll);
string outData = jData.ToJson();
this.uiOutScript.Text = @"<script type='text/javascript' language='javascript'>
$(document).ready(function() {
$('#dataTable').dataTable(" + outData + @");
} );
</script>";
JsonRowSchema schema = new JsonRowSchema(RowSchemaDataType.NumericType, "EntityState", "EntityState", false, false);
this.uiOutText.Text = outData;
}
public async void Should_Throw_An_Exception_If_The_Token_Is_Invalid()
{
var mockToken = new Mock <IToken>();
mockToken.Setup(x => x.Tokenvalue).Returns(string.Empty);
_routeService = new RouteService(new MapLinkCoordinateFinder(mockToken.Object), _mockRouteCalculator.Object);
var address1 = new AddressSearch("Avenida Paulista", 1000, "São Paulo", "SP");
var list = new List <AddressSearch>()
{
address1
};
await _routeService.CalculateRouteAsync(list, RouteType.DefaultRouteFaster);
}
public async void Should_Calculate_The_Route_For_A_Known_Address_Avoiding_The_Traffic_()
{
var routeService = new RouteService(new MapLinkCoordinateFinder(new MapLinkToken()), new MapLinkRouteCalculator(new MapLinkToken()));
var address1 = new AddressSearch("Avenida Paulista", 1000, "São Paulo", "SP");
var address2 = new AddressSearch("Avenida Nove de Julho", 2000, "São Paulo", "SP");
var list = new List <AddressSearch>()
{
address1, address2
};
var route = await routeService.CalculateRouteAsync(list, RouteType.RouteAvoidingTraffic);
Assert.IsTrue(route.TotalCost > 0);
Assert.IsTrue(route.TotalDistance > 0);
Assert.IsTrue(route.TotalFuelCost > 0);
Assert.IsTrue(route.TotalTime != string.Empty);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Actor actor = Actor.GetByUserPass(this.Request, this.Response, true, SuperUser.GetByUserPass);
Address addr = new Address(1007);
addr.Fetch(actor, DataAccessScope.AllRelatedEntites);
this.uiSerializeText.Text = addr.ToJson();
TextWriter writer = new StringWriter();
XmlSerializer ser = new XmlSerializer(typeof(Address));
ser.Serialize(writer, addr);
this.uiSerializeTextXml.Text = writer.ToString();
EntityCollection<AddressEntity, AddressMeta> coll = new AddressSearch().GetAddressCollection();
this.uiSerializeTextEC.Text = JsonConvert.SerializeObject(coll);
writer = new StringWriter();
ser = new XmlSerializer(typeof(EntityCollection<AddressEntity, AddressMeta>));
ser.Serialize(writer, coll);
this.uiSerializeTextECXML.Text = writer.ToString();
}
}
public async Task <HttpResponse <IEnumerable <AddressSearchResult> > > SearchAsync(AddressSearch model)
=> await GetAsync <IEnumerable <AddressSearchResult> >($"api/v1/Address/{model.AddressProvider}/{model.SearchTerm}");
public void SetUp()
{
_search = new AddressSearch("Avenida Nove de Julho", 100, "São Paulo", "SP", "01103-000");
}
//Get Address by column
public List <AddressModel> GetAddressByData(string searchFor, AddressSearch columnName)
{
//Store raw query results to data table
DataTable dt = new DataTable();
//SQLite stuff
SQLiteCommand comm = null;
SQLiteConnection connection = null;
string query = "SELECT * FROM ADDRESS WHERE ADDRESS.@C LIKE '%@param%';";
//useable Data after conversion to be returned
List <AddressModel> addressList = new List <AddressModel>();
try
{
connection = SQLiteHelper.OpenConn();
//comm = new SQLiteCommand(query, connection);
switch (columnName)
{
case AddressSearch.ID:
query = query.Replace("@C", "AddressId");
comm = new SQLiteCommand(query, connection);
int idRes;
if (!int.TryParse(searchFor, out idRes))
{
throw new Exception("Address ID search is restricted to numbers");
}
comm.Parameters.Add("@param", DbType.Int32).Value = idRes;
break;
case AddressSearch.STREET:
query = query.Replace("@C", "Street");
comm = new SQLiteCommand(query, connection);
comm.Parameters.Add("@param", DbType.String).Value = searchFor;
break;
case AddressSearch.CITY:
query = query.Replace("@C", "City");
comm = new SQLiteCommand(query, connection);
comm.Parameters.Add("@param", DbType.String).Value = searchFor;
break;
case AddressSearch.ZIP:
query = query.Replace("@C", "Zip");
comm = new SQLiteCommand(query, connection);
int results;
if (!int.TryParse(searchFor, out results))
{
throw new Exception("ZIP code is restricted to numbers");
}
comm.Parameters.Add("@param", DbType.Int32).Value = results;
break;
case AddressSearch.STATE:
query = query.Replace("@C", "State");
comm = new SQLiteCommand(query, connection);
comm.Parameters.Add("@param", DbType.String).Value = searchFor;
break;
}
//Execute the command and load data to table
SQLiteDataReader reader = comm.ExecuteReader();
dt.Load(reader);
//Closes reader stream then connection
reader.Close();
SQLiteHelper.CloseConn();
//Use Datamapper to map selected results to objects
DataNamesMapper <AddressModel> mapper = new DataNamesMapper <AddressModel>();
addressList = mapper.Map(dt).ToList();
//foreach (DataRow item in dt.Rows)
//{
// Console.WriteLine(item["Street"].ToString()); //BREAKTHRUUUUUUUUU
//}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
SQLiteHelper.CloseConn();
MessageBox.Show(e.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
return(addressList);
}
