private void Button_Click(object sender, RoutedEventArgs e)
{
if ((AddressDTO)cbAddress.SelectedItem == null)
{
AddressDTO newAddress = new AddressDTO
{
City = tbTown.Text,
Street = tbStreet.Text,
House = tbHouse.Text,
Apartment = int.Parse(tbApartment.Text)
};
DBHelper helper = new DBHelper();
helper.AddAddress(newAddress);
returnID = helper.GetAddressID(newAddress);
tmpLabel.Content = newAddress.ToString();
}
else
{
returnID = ((AddressDTO)cbAddress.SelectedItem).ID;
}
this.Close();
}
public AddressDTO FindBy(string type)
{
AddressDTO address;
CityDTO city;
string queryString = "SELECT * FROM dbo.Address WHERE addressType = @type";
try
{
// The connection is automatically closed at the end of the using block.
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(queryString, con))
{
cmd.Parameters.AddWithValue("@type", SqlDbType.VarChar).Value = type;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
address = new AddressDTO();
city = new CityDTO();
address = GenerateAddress(reader, address, city);
//return product instance as data object
Debug.Print("AddressDAL: /FindByType/ " + address.ToString());
return(address);
}
}
}
}
catch (Exception e)
{
e.GetBaseException();
}
return(null);
}
private async void GetSomeAddress(int?id)
{
DBHelper helper = new DBHelper();
AddressDTO address = null;
await Task.Run(() => { address = helper.GetSomeAddress(id); });
lbAddress.Content = address.ToString();
adrID = address.ID;
}
public void TestToString_OnlyHasPostCode()
{
var dto = new AddressDTO();
dto.PostalCode = "PostalCode";
var s = dto.ToString();
Assert.IsNotNull(s);
Assert.IsTrue(s.Contains(dto.PostalCode));
}
public void TestToString_OnlyHasDivision()
{
var dto = new AddressDTO();
dto.Division = "Division";
var s = dto.ToString();
Assert.IsNotNull(s);
Assert.IsTrue(s.Contains(dto.Division));
}
public void TestToString_OnlyHasCountry()
{
var dto = new AddressDTO();
dto.Country = "Country";
var s = dto.ToString();
Assert.IsNotNull(s);
Assert.IsTrue(s.Contains(dto.Country));
}
private async void Loading()
{
await Task.Run(() =>
{
this.Dispatcher.Invoke(() =>
{
tbName.Text = currentEmp.Name;
tbSurname.Text = currentEmp.Surname;
tbPhone.Text = currentEmp.Phone;
tbEmail.Text = currentEmp.Email;
dpDate.SelectedDate = currentEmp.DateOfBirths;
tbDetail.Text = currentEmp.Details;
tbDepartment.Text = dep.Name;
lbAddress.Content = adr.ToString();
});
});
}
public void TestToString_DoesNotContainStreets()
{
var dto = new AddressDTO();
dto.City = "city";
dto.Division = "division";
dto.Country = "country";
dto.PostalCode = "12345";
var s = dto.ToString();
Assert.IsNotNull(s);
Assert.IsTrue(s.Contains(dto.City));
Assert.IsTrue(s.Contains(dto.Division));
Assert.IsTrue(s.Contains(dto.Country));
Assert.IsTrue(s.Contains(dto.PostalCode));
}
public void TestValidateAddressObjectInvalidAddress()
{
var address = new AddressDTO
{
AddressLine1 = "Invalid address",
PostalCode = "12345"
};
var ex = new InvalidAddressException();
_addressGeocodingService.Setup(mocked => mocked.ValidateAddress(address.ToString())).Throws(ex);
var result = _fixture.ValidateAddress(address);
Assert.IsNotNull(result);
Assert.IsInstanceOf <ResponseMessageResult>(result);
var responseMessageResult = (ResponseMessageResult)result;
Assert.AreEqual(HttpStatusCode.NotFound, responseMessageResult.Response.StatusCode);
}
public void TestValidateAddressObject()
{
var address = new AddressDTO
{
AddressLine1 = "Valid address",
PostalCode = "12345"
};
var addressDto = new AddressDTO();
_addressGeocodingService.Setup(mocked => mocked.ValidateAddress(address.ToString())).Returns(addressDto);
var result = _fixture.ValidateAddress(address);
Assert.IsNotNull(result);
Assert.IsInstanceOf <OkNegotiatedContentResult <AddressDTO> >(result);
var okResult = (OkNegotiatedContentResult <AddressDTO>)result;
Assert.AreSame(addressDto, okResult.Content);
}
public void TestToString_HasStreetsCityDivisionCountryPostalCode()
{
var dto = new AddressDTO();
dto.Street1 = "1";
dto.Street2 = "2";
dto.Street3 = "3";
dto.City = "city";
dto.Division = "division";
dto.Country = "country";
dto.PostalCode = "12345";
var s = dto.ToString();
Assert.IsNotNull(s);
Assert.IsTrue(s.Contains(dto.Street1));
Assert.IsTrue(s.Contains(dto.Street2));
Assert.IsTrue(s.Contains(dto.Street3));
Assert.IsTrue(s.Contains(dto.City));
Assert.IsTrue(s.Contains(dto.Division));
Assert.IsTrue(s.Contains(dto.Country));
Assert.IsTrue(s.Contains(dto.PostalCode));
}
public IHttpActionResult ValidateAddress(AddressDTO address)
{
return(ValidateAddress(address.ToString()));
}
public AddressDTO ValidateAddress(AddressDTO address)
{
return(ValidateAddress(address.ToString()));
}
public GeoCoordinate GetGeoCoordinates(AddressDTO address)
{
return(GetGeoCoordinates(address.ToString()));
}
