示例#1
0
        public ActionResult Index()
        {
            var sr = new SecurityRepository();
            var opStatus = sr.InsertSecurityData();

            if (opStatus.Status)
            {
                var mr = new MarketsAndNewsRepository();
                opStatus = mr.InsertMarketData();

                if (opStatus.Status)
                {
                    var ar = new AccountRepository();
                    opStatus = ar.RefreshAccountsData();
                }
            }

            ViewBag.OperationStatus = opStatus;

            return View();
        }
        public ActionResult Index()
        {
            var sr       = new SecurityRepository();
            var opStatus = sr.InsertSecurityData();

            if (opStatus.Status)
            {
                var mr = new MarketsAndNewsRepository();
                opStatus = mr.InsertMarketData();

                if (opStatus.Status)
                {
                    var ar = new AccountRepository();
                    opStatus = ar.RefreshAccountsData();
                }
            }

            ViewBag.OperationStatus = opStatus;

            return(View());
        }
示例#3
0
        internal static void Initialize(AccountAtAGlanceContext context)
        {
            //var customer = new Customer()
            //{
            //    FirstName = "Marcus",
            //    LastName = "Hightower",
            //    Address = "1234 Anywhere St.",
            //    City = "Phoenix",
            //    State = "AZ",
            //    Zip = 85229,
            //    CustomerCode = "C15643"
            //};
            //var ba = new BrokerageAccount()
            //{
            //    AccountNumber = "Z485739881",
            //    AccountTitle = "Joint Brokerage",
            //    Total = 1369265.00M,
            //    MarginBalance = 414888.67M,
            //    IsRetirement = false,
            //    CashTotal = 10000.00M,
            //    PositionsTotal = 1359265.00M,
            //    WatchList = new WatchList { Title = "My Watch Securities" }
            //};
            //customer.BrokerageAccounts.Add(ba);
            //context.Customers.Add(customer);

            //var exchange = new Exchange
            //{
            //    Title = "NYSE"
            //};

            //var stock = new Stock
            //{
            //    Change = 2.5M,
            //    PercentChange = 5.00M,
            //    Last = 32.10M,
            //    Shares = 100000,
            //    Symbol = "MSFT",
            //    RetrievalDateTime = DateTime.Now,
            //    Company = "Microsoft Corporation",
            //    Exchange = exchange,
            //    DayHigh = 33.00M,
            //    DayLow = 32.00M,
            //    Dividend = 0M,
            //    Open = 32.00M,
            //    Volume = 1000000M,
            //    YearHigh = 34.00M,
            //    YearLow = 28.00M,
            //    AverageVolume = 100000M,
            //    MarketCap = 10000000M
            //};

            //context.Stocks.Add(stock);

            context.Database.ExecuteSqlCommand(@"
                    CREATE PROCEDURE dbo.DeleteSecuritiesAndExchanges

                    AS
                        BEGIN

             		                    BEGIN TRANSACTION
                            BEGIN TRY
                                DELETE FROM WatchListSecurity;
                                DELETE FROM Positions;
                                DELETE FROM Securities_Stock;
                                DELETE FROM Securities_MutualFund;
                                DELETE FROM Securities;
                                DELETE FROM Exchanges;
                                DELETE FROM MarketIndexes
                                COMMIT TRANSACTION
                                SELECT 0
                            END TRY
                            BEGIN CATCH
                                ROLLBACK TRANSACTION
                                SELECT -1
                            END CATCH

                        END
            ");

            context.Database.ExecuteSqlCommand(@"
                CREATE PROCEDURE dbo.DeleteAccounts

                AS
                    BEGIN

                        BEGIN TRANSACTION
                            BEGIN TRY
                                DELETE FROM Orders;
                                DELETE FROM BrokerageAccounts;
                                DELETE FROM WatchLists;
                                DELETE FROM Customers
                                COMMIT TRANSACTION
                                SELECT 0
                            END TRY
                            BEGIN CATCH
                                ROLLBACK TRANSACTION
                                SELECT -1
                            END CATCH
                    END
            ");

            IStockEngine engine = new StockEngine();
            var sr = new SecurityRepository(engine);
            var opStatus = sr.InsertSecurityData();

            if (opStatus.Status)
            {
                var mr = new MarketsAndNewsRepository(engine);
                opStatus = mr.InsertMarketData();

                if (opStatus.Status)
                {
                    var ar = new AccountRepository(engine);
                    opStatus = ar.RefreshAccountsData();
                }
            }
        }