Пример #1
0
        //public ImageSource ListImage { get; set; }

        public ItemsViewModel(int add_month = 0)
        {
            Title = "収入管理";

            if (Now.Year < 2000)
            {
                Now = DateTime.Now;
            }

            DateTime target_date = Now.AddMonths(add_month);

            Now = Now.AddMonths(add_month);

            //ListImage = ImageSource.FromResource("Eri.Imeges.pig.png");
            Items = new ObservableCollection <IncomeDetail>();

            LoadItemsCommand = new Command(async() => await ExecuteLoadItemsCommand(target_date));

            MessagingCenter.Subscribe <NewItemPage, IncomeDetail>(this, "AddItem", async(obj, item) =>
            {
                var newItem = item as IncomeDetail;
                Items.Add(newItem);
                //await DataStore.AddItemAsync(newItem);
            });
        }
Пример #2
0
 private JwtSecurityToken GetJwtSecurityToken(User dbUser)
 {
     return(JwtSecurityTokenFactory.GetToken(
                _config.Value.Issuer,
                _config.Value.Audience,
                dbUser.Id.ToString(),
                dbUser.Roles.Select(role => role.Type),
                Now.AddMonths(_config.Value.JwtExpirationInMonths),
                _config.Value.JwtSecretKey,
                HmacSha256
                ));
 }
Пример #3
0
        //Expire the members
        public void MemExpire()
        {
            //Declarations
            DateTime JDate, iDate, Now; string MemID, Mtype; int MTi, x = 0;

            Now = DateTime.Today;

            //Read Each members
            string       sqlMem = string.Format("SELECT MemberID, MType, DateJoined FROM Member WHERE MStatus = 'Valid'");
            OleDbCommand cmdMem = new OleDbCommand(sqlMem, db.con);

            if (db.con.State.Equals(ConnectionState.Closed))
            {
                db.con.Open();
            }
            OleDbDataReader drMem = cmdMem.ExecuteReader();

            //For each member
            while (drMem.Read())
            {
                //Declare
                MemID = drMem["MemberID"].ToString(); Mtype = drMem["MType"].ToString(); JDate = DateTime.Parse(drMem["DateJoined"].ToString());

                //Set Member Type index
                //Get the date, a member of such type should have joined, if his membership to be expired today.
                if (Mtype == "Adult")
                {
                    MTi = 0;
                }
                else
                {
                    MTi = 1;
                }
                iDate = Now.AddMonths(-set.Expire[MTi]);

                //Compare dates
                int i = DateTime.Compare(JDate, iDate); // if in past,
                if (i < 0)
                {
                    string       sqlUMem = string.Format("UPDATE Member SET MStatus = 'Expired' WHERE MemberID = '{0}'", MemID);
                    OleDbCommand cmdUMem = new OleDbCommand(sqlUMem, db.con);
                    if (db.con.State.Equals(ConnectionState.Closed))
                    {
                        db.con.Open();
                    }
                    cmdUMem.ExecuteNonQuery(); x++;
                }
            }
            if (db.con.State.Equals(ConnectionState.Open))
            {
                db.con.Close();
            }
        }
Пример #4
0
        }         // GatherAvailableFunds

        /// <summary>
        /// Collects customer data from DB. Can be overridden to provide
        /// specific customer data instead of the current one.
        /// </summary>
        protected virtual void GatherData()
        {
            this.caisAccounts.Clear();

            Cfg.Load();

            DB.ForEachRowSafe(
                ProcessRow,
                "LoadAutoApprovalData",
                CommandSpecies.StoredProcedure,
                new QueryParameter("CustomerID", Args.CustomerID),
                new QueryParameter("Now", Now)
                );

            MetaData.NumOfDefaultAccounts = ExperianConsumerDataExt.FindNumOfPersonalDefaults(
                this.caisAccounts,
                Cfg.Reject_Defaults_Amount,
                Now.AddMonths(-1 * Cfg.Reject_Defaults_MonthsNum)
                );

            OriginationTime.FromExperian(MetaData.IncorporationDate);

            GatherAvailableFunds();

            Trail.MyInputData.FullInit(
                Now,
                Cfg,
                Args,
                MetaData,
                Payments,
                OriginationTime,
                Turnover,
                Funds,
                DirectorNames,
                HmrcBusinessNames
                );

            MetaData.Validate();
        }         // GatherData
Пример #5
0
        public MaterialProvider(MaterialLogger logger)
        {
            All    = logger.Read().ToArray();
            AsDays = MakeDiff(EachDay(All)).Reverse().ToArray();
            DateTime firsttime = Now;

            if (All.Count > 0)
            {
                firsttime = All[0].DateTime;
            }
            Durations = new[]
            {
                new { TitleKey = "ChartTimeRange_Days1", From = Now.AddDays(-1) },
                new { TitleKey = "ChartTimeRange_Weeks1", From = Now.AddDays(-7) },
                new { TitleKey = "ChartTimeRange_Weeks2", From = Now.AddDays(-14) },
                new { TitleKey = "ChartTimeRange_Months1", From = Now.AddMonths(-1) },
                new { TitleKey = "ChartTimeRange_Months2", From = Now.AddMonths(-2) },
                new { TitleKey = "ChartTimeRange_Months3", From = Now.AddMonths(-3) },
                new { TitleKey = "ChartTimeRange_Months6", From = Now.AddMonths(-6) },
                new { TitleKey = "ChartTimeRange_Years1", From = Now.AddYears(-1) },
                new { TitleKey = "ChartTimeRange_All", From = firsttime }
            };
            From = Now.AddDays(-14);
        }
Пример #6
0
        public ExpireAccountFundsCommandHandlerTestsFixture()
        {
            Now                   = DateTime.UtcNow;
            NextMonth             = Now.AddMonths(1);
            MessageHandlerContext = new Mock <IMessageHandlerContext>();
            ExpectedAccountId     = 112L;
            Command               = new ExpireAccountFundsCommand {
                AccountId = ExpectedAccountId
            };
            FundsIn = new List <LevyFundsIn>
            {
                new LevyFundsIn {
                    CalendarPeriodYear = 2018, CalendarPeriodMonth = 07, FundsIn = 12000
                },
                new LevyFundsIn {
                    CalendarPeriodYear = 2018, CalendarPeriodMonth = 08, FundsIn = 15000
                }
            };
            FundsOut = new List <PaymentFundsOut>
            {
                new PaymentFundsOut {
                    CalendarPeriodYear = 2018, CalendarPeriodMonth = 09, FundsOut = 10000
                },
                new PaymentFundsOut {
                    CalendarPeriodYear = 2018, CalendarPeriodMonth = 10, FundsOut = 10000
                }
            };
            ExistingExpiredFunds = new List <ExpiredFund>
            {
                new ExpiredFund {
                    CalendarPeriodYear = 2018, CalendarPeriodMonth = 01, Amount = 2000
                },
                new ExpiredFund {
                    CalendarPeriodYear = 2018, CalendarPeriodMonth = 02, Amount = 2000
                }
            };
            ExpiringFunds = new Dictionary <CalendarPeriod, decimal>
            {
                { new CalendarPeriod(2018, 03), 1000 },
                { new CalendarPeriod(2018, 04), 1000 },
                { new CalendarPeriod(2018, 05), 0 },
                { new CalendarPeriod(NextMonth.Year, NextMonth.Month), 1000 }
            };
            ExpiredFunds = new Dictionary <CalendarPeriod, decimal>
            {
                { new CalendarPeriod(2018, 03), 1000 },
                { new CalendarPeriod(2018, 04), 1000 },
                { new CalendarPeriod(2018, 05), 0 },
                { new CalendarPeriod(Now.Year, Now.Month), 0 }
            };

            MockCurrentDateTime = new Mock <ICurrentDateTime>();
            FundsExpiryPeriod   = 18;

            MockLevyFundsInRepository     = new Mock <ILevyFundsInRepository>();
            MockPaymentFundsOutRepository = new Mock <IPaymentFundsOutRepository>();
            MockExpiredFunds           = new Mock <IExpiredFunds>();
            MockExpiredFundsRepository = new Mock <IExpiredFundsRepository>();
            MockLogger = new Mock <ILog>();
            EmployerFinanceConfiguration = new EmployerFinanceConfiguration {
                FundsExpiryPeriod = FundsExpiryPeriod
            };

            MockCurrentDateTime.Setup(x => x.Now).Returns(Now);
            MockLevyFundsInRepository.Setup(x => x.GetLevyFundsIn(ExpectedAccountId)).ReturnsAsync(FundsIn);
            MockPaymentFundsOutRepository.Setup(x => x.GetPaymentFundsOut(ExpectedAccountId)).ReturnsAsync(FundsOut);
            MockExpiredFundsRepository.Setup(x => x.Get(ExpectedAccountId)).ReturnsAsync(ExistingExpiredFunds);
            MockExpiredFunds.Setup(x => x.GetExpiringFunds(
                                       It.Is <Dictionary <CalendarPeriod, decimal> >(fi => AreFundsInEqual(FundsIn, fi)),
                                       It.Is <Dictionary <CalendarPeriod, decimal> >(fo => AreFundsOutEqual(FundsOut, fo)),
                                       It.Is <Dictionary <CalendarPeriod, decimal> >(ex => AreExpiredFundsEqual(ExistingExpiredFunds, ex)),
                                       FundsExpiryPeriod)).Returns(ExpiringFunds);

            Handler = new ExpireAccountFundsCommandHandler(MockCurrentDateTime.Object, MockLevyFundsInRepository.Object, MockPaymentFundsOutRepository.Object, MockExpiredFunds.Object, MockExpiredFundsRepository.Object, MockLogger.Object, EmployerFinanceConfiguration);
        }