예제 #1
0
        public string checkMedal(long acc)
        {
            BankEntities2 dbContext2 = new BankEntities2();
            int           amt;
            CustomerClass obj = new CustomerClass();

            Account account = dbContext.Accounts.Where(val => val.accountNo == acc).Single <Account>();

            amt = (int)(account.amount);
            CustomerMedal medal = dbContext2.CustomerMedals.Where(val => val.min <amt && val.max> amt).Single <CustomerMedal>();

            account.type = medal.type;
            dbContext.SaveChanges();

            return(account.type);
        }
예제 #2
0
        public void insTrans(long acc1, long acc2, int amt, string type, string comment)
        {
            BankEntities2 dbContext         = new BankEntities2();
            string        date              = DateTime.Now.ToString();
            Transaction   transactionInsert = new Transaction
            {
                fromAccountNo   = acc1,
                toAccountNo     = acc2,
                transactionDate = date,
                amount          = amt,
                transactionType = type,
                comments        = comment
            };

            dbContext.Transactions.Add(transactionInsert);
            dbContext.SaveChanges();
        }