コード例 #1
0
ファイル: LoansController.cs プロジェクト: levinkata/isas
        public async Task <IActionResult> LoadLoansConfirmed(LoanTempsViewModel viewModel)
        {
            Guid currentUserId    = viewModel.UserID;
            Guid currentproductId = viewModel.ProductID;

            BulkHandles bulkhandle = new BulkHandles();

            int newbulkhandle = bulkhandle.GetBulkHandle(_context);

            var loantemps = from p in _context.LoanTemps
                            .Where(u => u.UserID == currentUserId)
                            .Include(p => p.Component)
                            .OrderBy(i => i.IDNumber)
                            select p;

            int recCount = loantemps.Count();

            foreach (var l in loantemps)
            {
                Loan loan = new Loan();

                if (PolicyExists(l.IDNumber))
                {
                    var loanParams = new object[] { Guid.NewGuid(), GetPolicyId(l.IDNumber), l.ComponentID, l.AccountNumber,
                                                    l.Term, l.Rate, l.LoanDate, l.Value, l.Premium, l.SettlementDate, newbulkhandle,
                                                    DateTime.Now, currentUserId, null, null };

                    await _context.Database.ExecuteSqlCommandAsync(
                        "INSERT INTO Loan(ID, PolicyID, ComponentID, AccountNumber, Term, Rate, LoanDate, " +
                        "Value, Premium, SettlementDate, BulkHandle, DateAdded, AddedBy, DateModified, ModifiedBy) " +
                        "Values ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11}, {12}, {13}, {14})",
                        parameters : loanParams);
                }
                else
                {
                    //  Generate a log file and ask user to load on Client and Policy before loading premiums again.
                }
            }

            Guid myParam = currentUserId;
            await _context.Database.ExecuteSqlCommandAsync(
                "DELETE FROM LoanTemp WHERE UserID = {0}",
                parameters : myParam);

            var bulkParams = new object[] { newbulkhandle, "Loan", DateTime.Now, recCount, DateTime.Now, currentUserId };

            await _context.Database.ExecuteSqlCommandAsync(
                "INSERT INTO BulkHandleGenerator(BulkNumber, TableName, BulkDate, RecordCount, DateAdded, AddedBy) " +
                "Values ({0}, {1}, {2}, {3}, {4}, {5})",
                parameters : bulkParams);

            return(RedirectToAction("ProductClients", "Products", new { productId = currentproductId }));
        }
コード例 #2
0
ファイル: LoansController.cs プロジェクト: levinkata/isas
        // GET: Loans/LoadLoans
        public async Task <IActionResult> LoadLoans(Guid userId, Guid productId)
        {
            var loantemps = await(from p in _context.LoanTemps
                                  .Where(u => u.UserID == userId)
                                  .Include(p => p.Component)
                                  .OrderBy(i => i.IDNumber)
                                  select p).ToListAsync();

            var loanTotal    = loantemps.Sum(p => p.Value);
            var premiumTotal = loantemps.Sum(p => p.Premium);

            LoanTempsViewModel viewModel = new LoanTempsViewModel
            {
                LoanTemps    = loantemps,
                ProductID    = productId,
                UserID       = userId,
                PremiumTotal = premiumTotal,
                LoanTotal    = loanTotal,
                ComponentID  = _context.LoanTemps.FirstOrDefault().ComponentID
            };

            return(View(viewModel));
        }