public bool Insert(AccountSettingRequest data) { if (Get(data) != null) { Update(data); return(false); } short IsSuccessful = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.AccountSettings_Insert", inputParamMapper : delegate(SqlParameterCollection param) { param.AddWithValue("@UserId", data.UserId); param.AddWithValue("@SettingId", data.SettingId); param.AddWithValue("@Value", data.Value); param.Add(new SqlParameter { ParameterName = "IsSuccessful", Value = SqlDbType.Bit, Direction = ParameterDirection.Output }); }, returnParameters : delegate(SqlParameterCollection param) { short.TryParse(param["IsSuccessful"].Value.ToString(), out IsSuccessful); }); if (IsSuccessful == 1) { return(true); } return(false); }
public async Task <ActionResult> OAuth(string code) { var auth = new OAuth(_configService.GetMediaConfig); var oauthResponse = await auth.RequestToken(code); AccountSettingRequest asr = new AccountSettingRequest(); asr.UserId = _userService.GetCurrentUserId(); asr.Value = oauthResponse.AccessToken; asr.SettingId = Enums.AccountSettings.InstagramToken; _accountSettingsSrv.Insert(asr); return(Redirect("/account#!/settings")); }