public ActionResult AlpacaApiKeys(AlpacaKeyModel model)
        {
            if (ModelState.IsValid)
            {
                var userID = User.Identity.GetUserId();

                int recordsCreated = UpdateAlpacaKeys(userID,
                                                      model.LiveApiKey,
                                                      model.LiveApiSecretKey,
                                                      model.PaperApiKey,
                                                      model.PaperApiSecretKey);

                return(RedirectToAction("AlpacaApiKeys"));
            }

            return(View());
        }
        public ActionResult AlpacaApiKeys()
        {
            ViewBag.Message = "Alpaca Keys Entry";

            var userID     = User.Identity.GetUserId();
            var alpacaKeys = LoadAlpacaKeys(userID);

            //Quick mapper
            AlpacaKeyModel alpacaKeyMap = new AlpacaKeyModel
            {
                LiveApiKey        = alpacaKeys.LastOrDefault().LiveApiKey,
                LiveApiSecretKey  = alpacaKeys.LastOrDefault().LiveApiSecretKey,
                PaperApiKey       = alpacaKeys.LastOrDefault().PaperApiKey,
                PaperApiSecretKey = alpacaKeys.LastOrDefault().PaperApiSecretKey
            };

            return(View(alpacaKeyMap));
        }
        public static int UpdateAlpacaKeys(string userID, string liveApiKey, string liveApiSecretKey, string paperApiKey, string paperApiSecretKey)
        {
            AlpacaKeyModel data = new AlpacaKeyModel
            {
                UserID            = userID,
                LiveApiKey        = liveApiKey,
                LiveApiSecretKey  = liveApiSecretKey,
                PaperApiKey       = paperApiKey,
                PaperApiSecretKey = paperApiSecretKey
            };

            string sql = @"update users set LiveApiKey = @LiveApiKey,
                                            LiveApiSecretKey = @LiveApiSecretKey,
                                            PaperApiKey = @PaperApiKey,
                                            PaperApiSecretKey = @PaperApiSecretKey
                                            where Id=@UserID;";


            return(MySqlDataAccess.SaveData(sql, data));
        }