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