public List <SqlParameter> MapParamsForDelete(AddressPostalData entity)
        {
            var sql_params = new List <SqlParameter>();

            sql_params.Add(new SqlParameter("@postal_code", entity.PostalCode));
            sql_params.Add(GetOutParam());

            return(sql_params);
        }
 public AddressPostal Map(AddressPostalData address_postal_data)
 {
     return(new AddressPostal()
     {
         CountryName = address_postal_data.Country,
         PostalCode = address_postal_data.PostalCode,
         StateCode = address_postal_data.StateCode,
         StateFullName = address_postal_data.StateFullName,
         CityName = address_postal_data.CityName,
         CountyName = address_postal_data.CountyName,
         TimeZone = address_postal_data.TimeZone,
     });
 }
        } // Map function closer

        public List <SqlParameter> MapParamsForUpsert(AddressPostalData entity)
        {
            var sql_params = new List <SqlParameter>();

            sql_params.Add(new SqlParameter("@country", entity.Country));
            sql_params.Add(new SqlParameter("@postal_code", entity.PostalCode));
            sql_params.Add(new SqlParameter("@state_code", entity.StateCode));
            sql_params.Add(new SqlParameter("@state_full_name", entity.StateFullName));
            sql_params.Add(new SqlParameter("@city_name", entity.CityName));
            sql_params.Add(new SqlParameter("@county_name", entity.CountyName));
            sql_params.Add(new SqlParameter("@time_zone", entity.TimeZone));
            sql_params.Add(GetOutParam());
            return(sql_params);
        }
Example #4
0
        public void AddressPostalModelTest1()
        {
            var data = new AddressPostalData
            {
                Country       = "TEST",
                PostalCode    = "TEST",
                StateCode     = "TEST",
                StateFullName = "TEST",
                CityName      = "TEST",
                CountyName    = "TEST",
                TimeZone      = 1,
            };
            //var sut = new AddressPostal(data);

            //Assert.True(sut.Country == "TEST");
            //Assert.True(sut.PostalCode == "TEST");
            //Assert.True(sut.StateCode == "TEST");
            //Assert.True(sut.StateFullName == "TEST");
            //Assert.True(sut.CityName == "TEST");
            //Assert.True(sut.CountyName == "TEST");
            //Assert.True(sut.TimeZone == 1);
        }