/// <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;
}
