public StatusAccount getStatus(int id)
{
try
{
String sql = "SELECT * FROM dbo.status_Account WHERE code =@code";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@code", id);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StatusAccount statusAccount = new StatusAccount();
statusAccount.code = Convert.ToInt32(reader["code"]);
statusAccount.status = Convert.ToString(reader["status"]);
return(statusAccount);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
}
return(null);
}
public BankAccount(string owner, string accountNumber, decimal balance, StatusAccount status)
{
this.owner = owner;
this.accountNumber = accountNumber;
this.balance = balance;
this.status = status;
}
public void ChangeState(StatusAccount accountState)
{
status = accountState;
}
