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); }
public int SaveOverSeasAddress(OverSeasAddress ovAddress) { aUserGateway = new UserGateway(); return(aUserGateway.SaveOverSeasAddress(ovAddress)); }