private async Task<Asset> getNearestAsset(Town borrower, string assetName)
{
var assets = await App.MobileService.GetTable<Asset>().ToListAsync();
var organizations = await App.MobileService.GetTable<Organization>().ToListAsync();
double latitude = borrower.latitude;
double longitude = borrower.longitude;
foreach (Asset asset in assets)
{
foreach (Organization organization in organizations)
{
if(asset.name.Equals(assetName) && asset.owner.Equals(organization.name) && asset.status.Equals("AVAILABLE"))
{
int distance = computeDistance(longitude, latitude, organization.longitude, organization.latitude);
if (minDistance == -1)
{
minDistance = distance;
assetNearest = asset;
}
if (distance < minDistance)
{
minDistance = distance;
assetNearest = asset;
}
}
}
}
return assetNearest;
}
public async void AddAsset(Asset asset)
{
await App.MobileService.GetTable<Asset>().InsertAsync(asset);
}
private async void populate()
{
Organization org = new Organization();
org.name = "oliver";
org.contactperson = "alvin";
org.phone = "5225";
org.email = "*****@*****.**";
org.fax = "1241";
org.username = "******";
org.password = "******";
org.address = "manila";
org.longitude = 121.019205031916;
org.latitude = 14.5596795435995;
org.isverified = "true";
await orgTable.InsertAsync(org);
org = new Organization();
org.name = "vil";
org.contactperson = "john";
org.phone = "657812";
org.email = "*****@*****.**";
org.fax = "112111";
org.username = "******";
org.password = "******";
org.address = "quezon";
org.longitude = 121.016954993829;
org.latitude = 14.5508508011699;
org.isverified = "true";
await orgTable.InsertAsync(org);
org = new Organization();
org.name = "joy";
org.contactperson = "cassandra";
org.phone = "123456765";
org.email = "*****@*****.**";
org.fax = "4444444";
org.username = "******";
org.password = "******";
org.address = "quezon city";
org.longitude = 121.023305878043;
org.latitude = 14.5516221038997;
org.isverified = "true";
await orgTable.InsertAsync(org);
org = new Organization();
org.name = "mark";
org.contactperson = "selene";
org.phone = "544444";
org.email = "*****@*****.**";
org.fax = "34565";
org.username = "******";
org.password = "******";
org.address = "luzon";
org.longitude = 121.012187702581;
org.latitude = 14.5663466770202;
org.isverified = "true";
await orgTable.InsertAsync(org);
org = new Organization();
org.name = "ral";
org.contactperson = "archie";
org.phone = "6455454";
org.email = "*****@*****.**";
org.fax = "95464526";
org.username = "******";
org.password = "******";
org.address = "visayas";
org.longitude = 121.008334541693;
org.latitude = 14.5574766118079;
org.isverified = "true";
await orgTable.InsertAsync(org);
//
Town town = new Town();
town.name = "barangay1";
town.contactperson = "mayor";
town.phone = "85565225";
town.email = "*****@*****.**";
town.username = "******";
town.password = "******";
town.address = "bar 676";
town.longitude = 121.021518521011;
town.latitude = 14.5495645143092;
await townTable.InsertAsync(town);
town = new Town();
town.name = "barangay2";
town.contactperson = "bishop";
town.phone = "899002125";
town.email = "*****@*****.**";
town.username = "******";
town.password = "******";
town.address = "bar 543";
town.longitude = 121.02594207041;
town.latitude = 14.5575703214854;
await townTable.InsertAsync(town);
town = new Town();
town.name = "barangay3";
town.contactperson = "duterte";
town.phone = "4356789087654";
town.email = "*****@*****.**";
town.username = "******";
town.password = "******";
town.address = "bar 321";
town.longitude = 121.025511743501;
town.latitude = 14.5530046150088;
await townTable.InsertAsync(town);
town = new Town();
town.name = "barangay4";
town.contactperson = "gloria";
town.phone = "437834783";
town.email = "*****@*****.**";
town.username = "******";
town.password = "******";
town.address = "bar 908";
town.longitude = 121.019065640867;
town.latitude = 14.5622836332768;
await townTable.InsertAsync(town);
town = new Town();
town.name = "barangay5";
town.contactperson = "ninoy";
town.phone = "7342312";
town.email = "*****@*****.**";
town.username = "******";
town.password = "******";
town.address = "bar 777";
town.longitude = 121.014296589419;
town.latitude = 14.5614915434271;
await townTable.InsertAsync(town);
//
Pending pend = new Pending();
pend.townID = "";
pend.ownerID = "";
pend.assetName = "";
await pendingTable.InsertAsync(pend);
pend = new Pending();
pend.townID = "";
pend.ownerID = "";
pend.assetName = "";
await pendingTable.InsertAsync(pend);
pend = new Pending();
pend.townID = "";
pend.ownerID = "";
pend.assetName = "";
await pendingTable.InsertAsync(pend);
pend = new Pending();
pend.townID = "";
pend.ownerID = "";
pend.assetName = "";
await pendingTable.InsertAsync(pend);
pend = new Pending();
pend.townID = "";
pend.ownerID = "";
pend.assetName = "";
await pendingTable.InsertAsync(pend);
//
Asset asset = new Asset();
asset.name = "truck";
asset.owner = "16A880E2-2C06-4220-8FCB-44606511A82D";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
asset = new Asset();
asset.name = "truck";
asset.owner = "16A880E2-2C06-4220-8FCB-44606511A82D";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
asset = new Asset();
asset.name = "life vest";
asset.owner = "1CC4C6CB-B47C-4F7E-A9C1-111210AD15CB";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
asset = new Asset();
asset.name = "life vest";
asset.owner = "1CC4C6CB-B47C-4F7E-A9C1-111210AD15CB";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
asset = new Asset();
asset.name = "life vest";
asset.owner = "6102DC97-18BC-4028-ADC6-B0B914FF493A";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
asset = new Asset();
asset.name = "rubber boat";
asset.owner = "1CC4C6CB-B47C-4F7E-A9C1-111210AD15CB";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
asset = new Asset();
asset.name = "rubber boat";
asset.owner = "6102DC97-18BC-4028-ADC6-B0B914FF493A";
asset.borrower = "";
asset.status = "AVAILABLE";
await assetTable.InsertAsync(asset);
}