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