Example #1
0
        public IActionResult Transaction(float transact, int AcId, float Balance)
        {
            System.Console.WriteLine($"Line 49, Transaction {transact},{AcId},{Balance}");
            int?Id = HttpContext.Session.GetInt32("UserId");

            ViewBag.Errors = new List <string>();
            if ((transact + Balance) >= 0)
            {
                // System.Console.WriteLine($"Line 38, ACCCont{transact}{AcId}");
                // Accounts RetrievedAccount = _context.Accounts.SingleOrDefault(account => account.AccountsId == AcId);
                // RetrievedAccount.Transaction=transact;
                // RetrievedAccount.CurrentBalance= Balance + transact;
                // RetrievedAccount.UpdatedAt=DateTime.Now;
                // _context.SaveChanges();
                float    total      = Balance + (transact);
                Accounts newAccount = new Accounts {
                    CurrentBalance = total,
                    Transaction    = (float)transact,
                    CreatedAt      = DateTime.Now,
                    UpdatedAt      = DateTime.Now,
                };
                System.Console.WriteLine($"Line 66,Transaction{newAccount.CurrentBalance}");
                _context.Accounts.Add(newAccount);
                _context.SaveChanges();
                Accounts createdAccount = _context.Accounts.Last();
                if (Id != null)
                {
                    JointAccounts newJoint = new JointAccounts {
                        UsersId    = (int)Id,
                        AccountsId = createdAccount.AccountsId
                    };
                    _context.JointAccounts.Add(newJoint);
                    _context.SaveChanges();
                }
                ;
            }
            else
            {
                ViewBag.Errors.Add("Insufficent funds!");
            }

            List <Users> PopulatedUserAccounts = new List <Users> ();

            PopulatedUserAccounts = GetPopulatedUser();



            var accounts = from useraccounts in PopulatedUserAccounts
                           from account in useraccounts.JointAccounts
                           orderby account.Accounts.CreatedAt descending
                           select account;

            ViewBag.CurrentBalance = accounts.First();
            ViewBag.JointAccounts  = accounts;
            ViewBag.user           = PopulatedUserAccounts;

            return(View("Show"));
        }
Example #2
0
        public IActionResult Register(Users newUser)
        {
            System.Console.WriteLine(ModelState.IsValid);
            if (ModelState.IsValid)
            {
                System.Console.WriteLine(newUser.FirstName);
                Users createdUser = new Users {
                    FirstName = newUser.FirstName,
                    LastName  = newUser.LastName,
                    Email     = newUser.Email,
                    Password  = newUser.Password,
                    CreatedAt = DateTime.Now,
                    UpdatedAt = DateTime.Now,
                };
                _context.Users.Add(createdUser);
                _context.SaveChanges();
                Users ReturnedUser = _context.Users.SingleOrDefault(user => user.Email == createdUser.Email);
                System.Console.WriteLine($"Email from returned {ReturnedUser.Email}");
                HttpContext.Session.SetInt32("UserId", (int)ReturnedUser.UsersId);
                // Users populatedUser=GetUsers();
                List <Users> populatedUsers = GetPopulatedUser();

                // Create an Account
                if (populatedUsers[0].JointAccounts.Count == 0)
                {
                    Accounts newAccount = new Accounts {
                        CurrentBalance = 50,
                        Transaction    = 50,
                        CreatedAt      = DateTime.Now,
                        UpdatedAt      = DateTime.Now,
                    };
                    _context.Accounts.Add(newAccount);
                    _context.SaveChanges();
                    Accounts createdAccount = _context.Accounts.Last();
                    int?     jId            = HttpContext.Session.GetInt32("UserId");
                    System.Console.WriteLine($"JIIIIIIIIIDDDDDDDdd    {jId}");
                    if (jId != null)
                    {
                        JointAccounts newJoint = new JointAccounts {
                            UsersId    = (int)jId,
                            AccountsId = createdAccount.AccountsId
                        };
                        _context.JointAccounts.Add(newJoint);
                        _context.SaveChanges();
                    }
                    ;

                    System.Console.WriteLine($"Created account Id{createdAccount.AccountsId}");
                }
                return(RedirectToAction("Show", "Account"));
            }
            else
            {
                ViewBag.Errors = ModelState.Values;
                return(View("Registration"));
            }
        }