public bool UpdateAddress(DataClass.AddressClass singleAddress) { bool success = false; using (SqlConnection conn = new SqlConnection(CommonFunctions.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand { CommandText = "InsertAddress", CommandType = System.Data.CommandType.StoredProcedure }) { cmd.Parameters.AddWithValue("@PxID", singleAddress.pxID); cmd.Parameters.AddWithValue("@AddressID", singleAddress.AddressID); cmd.Parameters.AddWithValue("@AddressLine1", singleAddress.addressLine1); cmd.Parameters.AddWithValue("@Postcode", singleAddress.postcode); cmd.Parameters.AddWithValue("@Email", singleAddress.email); cmd.Parameters.AddWithValue("@Phone", singleAddress.phone); try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } ; int rowsUpdated = cmd.ExecuteNonQuery(); if (rowsUpdated > 0) { success = true; } ; } finally { if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } ; } } } return(success); }
public bool DeletePatientsAddresses(DataClass.AddressClass singleAddress) { bool success = false; using (SqlConnection conn = new SqlConnection(CommonFunctions.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand { CommandText = "DeletePatientAddress", CommandType = System.Data.CommandType.StoredProcedure }) { cmd.Parameters.AddWithValue("@PxID", singleAddress.pxID); try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } ; int rowsUpdated = cmd.ExecuteNonQuery(); if (rowsUpdated > 0) { success = true; } ; } finally { if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } ; } } } return(success); }