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