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);
}
