public List <Address> GetShippingAdressByUserId(int userId)
{
var addressesShipping = new List <AddressDAL>();
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("PS_GetShippingAddrsesByUserId", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserId", userId));
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var addressShipping = new AddressDAL();
addressShipping.AddressId = (int)rdr["ShippingAddressId"];
addressShipping.Number = (int)rdr["Number"];
addressShipping.Street = (string)rdr["Street"];
addressShipping.ZipCode = (int)rdr["ZipCode"];
addressShipping.City = (string)rdr["City"];
addressShipping.Country = (string)rdr["Country"];
addressShipping.IsDefault = (bool)rdr["IsDefault"];
addressesShipping.Add(addressShipping);
}
}
}
List <Address> userAddressShipping = addressesShipping.Select(addressShipping => addressShipping.ToDomain()).ToList();
return(userAddressShipping);
}