Пример #1
0
        public int SaveOverSeasAddress(OverSeasAddress ovAddress)
        {
            conn = new SqlConnection(cs.DBConn);
            conn.Open();
            string qry = "insert into ForeignAddress(Street,State,PostalCode,UserId) Values(@d1,@d2,@d3,@d4)";

            cmd = new SqlCommand(qry, conn);
            cmd.Parameters.AddWithValue("@d1", ovAddress.Street);
            cmd.Parameters.AddWithValue("@d2", ovAddress.State);
            cmd.Parameters.AddWithValue("@d3", ovAddress.PostalCode);
            cmd.Parameters.AddWithValue("@d4", ovAddress.OUserId);
            affectedRows4 = cmd.ExecuteNonQuery();
            conn.Close();
            return(affectedRows4);
        }
Пример #2
0
 public int SaveOverSeasAddress(OverSeasAddress ovAddress)
 {
     aUserGateway = new UserGateway();
     return(aUserGateway.SaveOverSeasAddress(ovAddress));
 }