public async Task <bool> CreateCharacter(CharacterFull character, User user) { using (var connection = dbHelper.GetConnection()) { connection.Open(); using (var transaction = connection.BeginTransaction()) { var res1 = await dbHelper.CallStoredProcedureExec("CreateCharacter", new DynamicParameters() .AddParameter("charID", character.characterID) .AddParameter("userID", character.userID) .AddParameter("charName", character.characterName) .AddParameter("charVisual", character.characterVisualData.ToString(Formatting.None)) .AddParameter("charData", JsonConvert.SerializeObject(character.characterGameData)) ) > 0; if (!res1) { transaction.Rollback(); connection.Close(); return(false); } var res2 = await SetUserData(user.userID, user.userData); if (!res2) { transaction.Rollback(); connection.Close(); return(false); } transaction.Commit(); connection.Close(); return(true); } } }
public async Task <bool> ActivateUser(string userID) { return(await _helper.CallStoredProcedureExec("ActivateUser", new DynamicParameters() .AddParameter("userID", userID) ) > 0); }