Example #1
0
        public ActionResult Add(int id = 0)
        {
            SharedVM.LogPageHit("Bets/Add", User.Identity.Name);
            var newBet = new BetObj();

            newBet.AB       = true;
            newBet.JK       = true;
            newBet.CL       = true;
            newBet.AT       = true;
            newBet.DV       = true;
            newBet.BetDate  = DateTime.Today;
            newBet.GroupBet = "Y";

            if (id == 1)
            {
                newBet.Sport = "NFL";
            }
            else if (id == 2)
            {
                newBet.Sport = "CFB";
            }
            else
            {
                newBet.Sport = "";
            }

            GetDataForDropdowns(ref newBet);
            return(View(newBet));
        }
Example #2
0
        public ActionResult Edit(int id)
        {
            SharedVM.LogPageHit("Bets/Edit/" + id, User.Identity.Name);

            var vm       = new BetsVM(dbConn);
            var thisSite = vm.GetSingleBet(id);

            return(View(thisSite));
        }
Example #3
0
        public ActionResult Index()
        {
            SharedVM.LogPageHit("Bets/Index", User.Identity.Name);

            var vm       = new BetsVM(dbConn);
            var betsList = vm.GetAllBets();

            ViewBag.BetCount = betsList.Count;
            return(View(betsList));
        }
        public ActionResult Index()
        {
            SharedVM.LogPageHit("Scoreboard/Index", User.Identity.Name);

            var vm        = new ScoreboardVM();
            var gamesList = vm.GetNflScores();

            //ViewBag.SiteCount = results.Count();
            return(View(gamesList));
        }
Example #5
0
        public ActionResult Index()
        {
            SharedVM.LogPageHit("Query/Index", User.Identity.Name);
            var queryObj = new QueryObj()
            {
                QuerySql = ""
            };

            return(View(queryObj));
        }
Example #6
0
        public ActionResult Edit(int id)
        {
            SharedVM.LogPageHit("Bets/Edit/" + id, User.Identity.Name);

            var vm      = new BetsVM(dbConn);
            var thisBet = vm.GetSingleBet(id);

            GetDataForDropdowns(ref thisBet);
            return(View(thisBet));
        }
Example #7
0
        public ActionResult Scripts()
        {
            SharedVM.LogPageHit("Query/Scripts/", User.Identity.Name);
            var queryObj = new QueryObj()
            {
                SavedQueries = LoadSavedQueries()
            };
            var vm = new QueryVM();

            return(View(queryObj));
        }
Example #8
0
        public ActionResult Delete(int id)
        {
            SharedVM.LogPageHit("Bets/Delete(" + id + ")", User.Identity.Name);

            var vm = new BetsVM(dbConn);

            if (id > 0)
            {
                vm.DeleteBetItem(id);
            }

            return(RedirectToAction("Index"));
        }
Example #9
0
        public ActionResult SaveAndNew(BetObj myBet)
        {
            SharedVM.LogPageHit("Bets/Edit/Save(" + myBet.BetId + ")", User.Identity.Name);

            var vm = new BetsVM(dbConn);

            if (myBet.BetId > 0)
            {
                vm.UpdateBetItem(myBet);
            }

            return(RedirectToAction("Add"));
        }
Example #10
0
        public ActionResult Edit(BetObj myBet)
        {
            SharedVM.LogPageHit("Bets/Edit/Save(" + myBet.BetId + ")", User.Identity.Name);

            var vm = new BetsVM(dbConn);

            if (myBet.BetId > 0)
            {
                vm.UpdateBetItem(myBet);
            }

            var thisSite = vm.GetSingleBet(myBet.BetId);

            return(View(thisSite));
        }
        public ActionResult Index()
        {
            SharedVM.LogPageHit("Scoreboard/Index", User.Identity.Name);

            var vm              = new ScoreboardVM(dbConn);
            var myBets          = vm.GetScoreboardBets();
            var includesNflGame = myBets.Any(bet => bet.Sport.ToUpper() == "NFL");

            if (includesNflGame)
            {
                var nflScores = vm.GetNflScores();
                myBets = vm.CreateLiveUpdate(myBets, nflScores);
            }

            return(View(myBets));
        }
Example #12
0
        public ActionResult Add(BetObj myBet)
        {
            if (ModelState.IsValid)
            {
                SharedVM.LogPageHit("Bets/Add/Save (" + myBet.BetId + ")", User.Identity.Name);

                var vm = new BetsVM(dbConn);
                vm.AddNewBet(myBet);

                return(RedirectToAction("Index"));
            }
            else
            {
                return(View());
            }
        }
Example #13
0
        public ActionResult Edit(StyleEditPageObj myStyles)
        {
            var user = User.Identity.Name;

            SharedVM.LogPageHit("Elite/Edit/SaveStyles", user);

            var vm = new StyleVM();

            vm.SaveStylesForUser(myStyles.Styles, user);
            var pageObj = new StyleEditPageObj()
            {
                Styles        = vm.GetStylesForUser(user, true),
                DefinedThemes = LoadSavedStyles()
            };

            return(View(pageObj));
        }
Example #14
0
        public ActionResult Scripts(QueryObj queryObj)
        {
            int queryId = queryObj.QueryId;

            SharedVM.LogPageHit("Query/RunSavedQuery/" + queryId, User.Identity.Name);

            var dt = new DataTable();
            var vm = new QueryVM();

            queryObj.QuerySql         = vm.GetSavedQuerySql(queryId);
            queryObj.QueryDescription = vm.GetSavedQueryDesc(queryId);

            try
            {
                var sqlResults = vm.ExecuteSql(queryObj);

                if (sqlResults != null)
                {
                    BuildTableHeader(sqlResults, false, ref dt);

                    if (sqlResults != null && sqlResults.Any())
                    {
                        foreach (var dataRow in sqlResults.ToList())
                        {
                            DataRow row    = dt.NewRow();
                            int     rowNum = 0;
                            foreach (var item in dataRow)
                            {
                                row[rowNum] = item.Value;
                                rowNum++;
                            }
                            dt.Rows.Add(row);
                        }
                    }
                    queryObj.ResultsDataTable = dt;
                }
            }
            catch (Exception)
            {
                //Should probably do something with this, but for now just swallowing it
            }

            queryObj.SavedQueries = LoadSavedQueries();
            return(View(queryObj));
        }
Example #15
0
        public ActionResult Edit()
        {
            var user = User.Identity.Name;

            SharedVM.LogPageHit("Style/Edit", user);

            var styleType = user;

            if (TempData["TmpStyle"] != null)
            {
                styleType = TempData["TmpStyle"].ToString();
            }
            var vm      = new StyleVM();
            var pageObj = new StyleEditPageObj()
            {
                Styles        = vm.GetStylesForUser(styleType, true),
                DefinedThemes = LoadSavedStyles()
            };

            return(View(pageObj));
        }