예제 #1
0
        public object getTranfer(context db, string AccountNo, string AccountNoTranfer, double Money)
        {
            bool   status  = false;
            string message = string.Empty;

            walle_AccountInfo lai = db.walle_AccountInfos
                                    .Where(o => o.No == AccountNo)
                                    .FirstOrDefault()
            ;
            walle_AccountInfo laiTran  = null;
            walle_UserInfo    user     = null;
            walle_UserInfo    userTran = null;

            if (lai != null)
            {
                if (lai.Balance >= Money)
                {
                    laiTran = db.walle_AccountInfos
                              .Where(o => o.No == AccountNoTranfer)
                              .FirstOrDefault()
                    ;

                    status = Tranfer(ref lai, ref laiTran, Money);

                    user = db.walle_UserInfos
                           .Where(o => o.ID == lai.walle_UserInfo)
                           .FirstOrDefault()
                    ;

                    userTran = db.walle_UserInfos
                               .Where(o => o.ID == laiTran.walle_UserInfo)
                               .FirstOrDefault()
                    ;
                }
                else
                {
                    status  = false;
                    message = "Balance < Money*";
                }
            }

            return(new
            {
                status = status,
                message = message,
                AccountNo = lai,
                AccountNoTranfer = laiTran,
                UserInfo = user,
                UserInfoTran = userTran,
                money = Money
            });
        }
예제 #2
0
        public object getBalance(context db, string userID)
        {
            List <walle_UserInfo> lui = db.walle_UserInfos.AsNoTracking()
                                        .Where(o => o.ID == userID)
                                        .ToList()
            ;
            List <walle_AccountInfo> lai = db.walle_AccountInfos.AsNoTracking()
                                           .Where(o => o.walle_UserInfo == userID)
                                           .ToList()
            ;

            return(new {
                lwalle_UserInfo = lui,
                lwalle_AccountInfo = lai
            });
        }