public PersonAddressDetails build()
{
PersonAddressDetails paDetails = new PersonAddressDetails();
paDetails.AddressL1 = AddressL1;
paDetails.AddressL2 = AddressL2;
paDetails.City = City;
paDetails.Country = Country;
paDetails.Description = Description;
paDetails.FName = FName;
paDetails.Image = Image;
paDetails.Latitude = Latitude;
paDetails.LName = LName;
paDetails.Longitude = Longitude;
paDetails.PersonID = PersonID;
paDetails.PostalCode = PostalCode;
paDetails.State = State;
paDetails.Thumbnail = Thumbnail;
paDetails.UserName = UserName;
return paDetails;
}
public static PersonAddressDetails[] GetInstancesOfTypeWithinDistance(AddressDetails addr, int dist, int typeID)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "GetInstancesOfTypeWithinDistance";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@Long";
param.DbType = DbType.Double;
param.Value = addr.Longitude;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Lat";
param.DbType = DbType.Double;
param.Value = addr.Latitude;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Dist";
param.DbType = DbType.Int32;
param.Value = dist;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@TypeID";
param.DbType = DbType.Int32;
param.Value = typeID;
comm.Parameters.Add(param);
DataTable perAddTable = GenericDataAccess.ExecuteSelectCommand(comm);
PersonAddressDetails[] personaddressStructs=new PersonAddressDetails[perAddTable.Rows.Count];
for (int row=0;row<perAddTable.Rows.Count;row++) {
DataRow dataRow = perAddTable.Rows[row];
personaddressStructs[row].PersonID= Int32.Parse(dataRow["PersonID"].ToString());
personaddressStructs[row].FName = dataRow["FName"].ToString();
personaddressStructs[row].LName = dataRow["LName"].ToString();
personaddressStructs[row].UserName = dataRow["UserName"].ToString();
personaddressStructs[row].Thumbnail = dataRow["Thumbnail"].ToString();
personaddressStructs[row].Image = dataRow["Image"].ToString();
personaddressStructs[row].Description = dataRow["Description"].ToString();
personaddressStructs[row].Country = dataRow["Country"].ToString();
personaddressStructs[row].City = dataRow["City"].ToString();
personaddressStructs[row].State = dataRow["State"].ToString();
personaddressStructs[row].AddressL1 = dataRow["AddressLine1"].ToString();
personaddressStructs[row].AddressL2 = dataRow["AddressLine2"].ToString();
personaddressStructs[row].State = dataRow["State"].ToString();
personaddressStructs[row].PostalCode = dataRow["PostalCode"].ToString();
personaddressStructs[row].Latitude = Double.Parse(dataRow["Latitude"].ToString());
personaddressStructs[row].Longitude = Double.Parse(dataRow["Longitude"].ToString());
}
return personaddressStructs;
}
public static string personAddressToStringPerson(PersonAddressDetails personAddressDetails)
{
string s = personAddressDetails.FName + " " + personAddressDetails.LName;
return s;
}
public static string personAddressToStringAddress(PersonAddressDetails personAddressDetails)
{
string s = personAddressDetails.AddressL1 + " " + personAddressDetails.City + " " + personAddressDetails.State + " " + personAddressDetails.PostalCode + " " + personAddressDetails.Country;
return s;
}
