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())); }