/// <summary> /// Wypełnienie danych kontaktowych danymi adresowymi użytkownika z bazy danych. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void AdresKonta_B_Click(object sender, EventArgs e) { try { fromDb = true; address = QueryEngine.QueryUsersAddress(User.Instance.Id); if(address.PostalCode != null && address.PostalCode != string.Empty) { Kod_TB.Text = address.PostalCode; Miejscowosc_TB.Text = address.City; Ulica_TB.Text = address.Street; Dom_TB.Text = address.Building.ToString(); Lokal_TB.Text = address.House == 0 ? string.Empty : address.House.ToString(); AdresKonta_B.Enabled = false; AdresKonta_B.BackColor = Color.White; AdresKonta_B.Text = "Wykonano"; } else { AdresKonta_B.Enabled = false; AdresKonta_B.BackColor = Color.White; AdresKonta_B.Text = "Nie podano adresu"; } } catch (Exception ex) { AdresKonta_B.Enabled = false; AdresKonta_B.BackColor = Color.White; AdresKonta_B.Text = "Błąd bazy danych"; } }
/// <summary> /// Metoda zwracająca adres zamieszkania przypisany do konta użytkownika. /// </summary> /// <param name="user_id">Id użytkownika w bazie.</param> /// <returns>Zwraca obiekt typu Address.</returns> public static Address QueryUsersAddress(int user_id) { Address result = new Address(); var query = "SELECT a.IdAdresu AS IdAd, a.KodPoczt AS Kod, a.Miasto AS Mias, a.Ulica AS Ul, a.NrDomu AS Nrd, ISNULL(a.NrLokalu, 0) AS Nrl FROM AdresyUzyt au LEFT JOIN Adres a ON au.IdAdresu = a.IdAdresu WHERE au.IdUzyt = " + user_id.ToString(); using (SqlConnection connection = new SqlConnection(QueryEngine.ConnectionString)) { connection.Open(); using (SqlCommand cmd = new SqlCommand(query, connection)) { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { result.Id = reader.GetInt32(reader.GetOrdinal("IdAd")); result.PostalCode = reader.GetString(reader.GetOrdinal("Kod")); result.City = reader.GetString(reader.GetOrdinal("Mias")); result.Street = reader.GetString(reader.GetOrdinal("Ul")); result.Building = reader.GetInt32(reader.GetOrdinal("Nrd")); result.House = reader.GetInt32(reader.GetOrdinal("Nrl")); } } } connection.Close(); } return result; }