public void Update(int addressId)
{
try {
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
string sql =
"UPDATE Address SET UserId=@UserId,NickName=@NickName,FirstName=@FirstName,LastName=@LastName,Company=@Company,AddressLine1=@Address1,AddressLine2=@Address2,Suite=@Suite,City=@City," +
"StateProvinceID=@StateProvinceID,ZipPostal=@ZipPostal,CountryID=@CountryID,IsResidential=@IsResidential,Phone=@Phone,IsActive=@IsActive " +
"WHERE AddressID=@AddressID";
m_AddressID = addressId;
using (SqlCommand cmd = new SqlCommand(sql, cn)) {
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("AddressID", SqlDbType.Int).Value = AddressID;
cmd.Parameters.Add("UserId", SqlDbType.UniqueIdentifier).Value = UserId;
cmd.Parameters.Add("NickName", SqlDbType.NVarChar, 100).Value = NickName;
cmd.Parameters.Add("FirstName", SqlDbType.NVarChar, 100).Value = FirstName;
cmd.Parameters.Add("LastName", SqlDbType.NVarChar, 100).Value = LastName;
cmd.Parameters.Add("Company", SqlDbType.NVarChar, 100).Value = Company;
cmd.Parameters.Add("Address1", SqlDbType.NVarChar, 100).Value = Address1;
cmd.Parameters.Add("Address2", SqlDbType.NVarChar, 100).Value = Address2;
cmd.Parameters.Add("Suite", SqlDbType.NVarChar, 50).Value = Suite;
cmd.Parameters.Add("City", SqlDbType.NVarChar, 100).Value = City;
cmd.Parameters.Add("StateProvinceID", SqlDbType.Int).Value = StateProvinceID;
cmd.Parameters.Add("ZipPostal", SqlDbType.NVarChar, 10).Value = ZipPostal.ToUpper();
cmd.Parameters.Add("CountryID", SqlDbType.Int).Value = CountryID;
cmd.Parameters.Add("IsResidential", SqlDbType.Int).Value = IsResidential ? 1 : 0;
cmd.Parameters.Add("Phone", SqlDbType.NVarChar, 25).Value = Phone;
cmd.Parameters.Add("IsActive", SqlDbType.Bit).Value = IsActive;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
} catch (Exception) {
throw;
}
}
public void New()
{
try {
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
string sql =
"INSERT INTO Address(UserId,NickName,FirstName,LastName,Company,AddressLine1,AddressLine2,Suite,City,StateProvinceID,ZipPostal,CountryID,IsResidential,Phone,IsActive) " +
"OUTPUT INSERTED.AddressID " +
"VALUES(@UserId,@NickName,@FirstName,@LastName,@Company,@Address1,@Address2,@Suite,@City,@StateProvinceID,@ZipPostal,@CountryID,@IsResidential,@Phone,@IsActive);";
using (SqlCommand cmd = new SqlCommand(sql, cn)) {
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("UserId", SqlDbType.UniqueIdentifier).Value = UserId;
cmd.Parameters.Add("NickName", SqlDbType.NVarChar, 100).Value = NickName;
cmd.Parameters.Add("FirstName", SqlDbType.NVarChar, 100).Value = FirstName;
cmd.Parameters.Add("LastName", SqlDbType.NVarChar, 100).Value = LastName;
cmd.Parameters.Add("Company", SqlDbType.NVarChar, 100).Value = Company;
cmd.Parameters.Add("Address1", SqlDbType.NVarChar, 100).Value = Address1;
cmd.Parameters.Add("Address2", SqlDbType.NVarChar, 100).Value = Address2;
cmd.Parameters.Add("Suite", SqlDbType.NVarChar, 50).Value = Suite;
cmd.Parameters.Add("City", SqlDbType.NVarChar, 100).Value = City;
cmd.Parameters.Add("StateProvinceID", SqlDbType.Int).Value = StateProvinceID;
cmd.Parameters.Add("ZipPostal", SqlDbType.NVarChar, 10).Value = ZipPostal.ToUpper();
cmd.Parameters.Add("CountryID", SqlDbType.Int).Value = CountryID;
cmd.Parameters.Add("IsResidential", SqlDbType.Int).Value = IsResidential ? 1 : 0;
cmd.Parameters.Add("Phone", SqlDbType.NVarChar, 25).Value = Phone;
cmd.Parameters.Add("IsActive", SqlDbType.Bit).Value = IsActive;
cmd.Connection.Open();
m_AddressID = (int)cmd.ExecuteScalar();
cmd.Connection.Close();
}
}
} catch (Exception) {
throw;
}
}
