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)); }