コード例 #1
0
        public static AccountType FindOrCreate(int category, string AccountTypeName)
        {
            var accountType = new AccountType
            {
                Category = AccountCategory.Find(category),
                Name     = AccountTypeName
            };

            All.Add(accountType);

            return(accountType);
        }
コード例 #2
0
        public static AccountType[] Load(SqlConnection connection)
        {
            var list = new List <AccountType>();

            var query  = new SqlCommand("select id, name, account_category_id from account_type", connection);
            var reader = query.ExecuteReader(System.Data.CommandBehavior.SingleResult);

            while (reader.Read())
            {
                list.Add(new AccountType
                {
                    Id       = reader.GetFieldValue <int>(0),
                    Name     = reader.GetFieldValue <string>(1),
                    Category = AccountCategory.Find(reader.GetFieldValue <int>(2))
                });
            }
            reader.Close();

            All.AddRange(list);

            return(All.ToArray());
        }