private void DisplayWallet(Wallet i_wallet)
        {
            lblWalletAmount.Visible = true;
            txtbxWalletAmount.Visible = true;
            txtbxWalletAmount.Text = i_wallet.Amount.ToString();

        } // DisplayWallet ()
Ejemplo n.º 2
0
        public static Wallet FindByAccountId(int i_iAccountId)
        {
            SqlConnection l_sqlConnection = null;
            SqlCommand l_sqlCommand = null;
            SqlDataReader l_sqlDataReader = null;
            Wallet l_result = null;
            string l_strSqlToExecute =
                "select sum(amount) as sum_amount from transactions where AccountId = @param_account_id";    
            try
            {
                l_sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[Common.DbName].ConnectionString);
                l_sqlConnection.Open();

                l_sqlCommand = new SqlCommand(l_strSqlToExecute, l_sqlConnection);
                SqlParameter l_param = new SqlParameter("param_account_id", SqlDbType.Int);
                l_param.Value = i_iAccountId;
                l_sqlCommand.Parameters.Add(l_param);

                l_sqlDataReader = l_sqlCommand.ExecuteReader();
                if ( l_sqlDataReader.Read() )
                {
                    l_result = new Wallet();
                    if ( l_sqlDataReader["sum_amount"] == DBNull.Value)
                    {
                        l_result.Amount = 0;
                    }
                    else
                    {
                        l_result.Amount = (decimal)l_sqlDataReader["sum_amount"];    
                    }                    
                }
                return l_result;
            }
            catch (Exception ex)
            {
                throw new Exception("Cannot find wallet: ex: " + ex);
            }
            finally
            {
                if (l_sqlDataReader != null)
                {
                    l_sqlDataReader.Close();
                }
                if (l_sqlCommand != null)
                {
                    l_sqlCommand.Dispose();
                }
                if (l_sqlConnection != null)
                {
                    if (l_sqlConnection.State == ConnectionState.Open)
                    {
                        l_sqlConnection.Close();
                    }
                    l_sqlConnection.Dispose();
                }
            }
        } // FindByAccountId ()