//public async Task<IEnumerable<Fighter>> PlayerFighters() public int GetPlayerBalance() { using (IDbConnection dbConnection = DbProviderFactories.GetFactory("system.data.sqlclient").CreateConnection()) { dbConnection.ConnectionString = "Server=tcp:cipherrex.database.windows.net,1433;Initial Catalog=cipherRexUmbraco;Persist Security Info=False;User ID=cipherrex;Password=R00ksp@wnR00ksp@wn;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; dbConnection.Open(); Models.DAL.SqlDAL sqlDAL = new Models.DAL.SqlDAL(dbConnection); Models.Repositories.PlayerRepos.IPlayerRepo playerRepo = new Models.Repositories.PlayerRepos.PlayerRepo(sqlDAL); var _userEmail = userEmail().Result; return(playerRepo.GetPlayer(_userEmail).Balance); } }
//public async Task<IEnumerable<Fighter>> PlayerFighters() public async void NewFighter([FromBody] string fighterJson) { var _userEmail = userEmail().Result; Fighter fighter = System.Text.Json.JsonSerializer.Deserialize <Fighter>(fighterJson); using (IDbConnection dbConnection = DbProviderFactories.GetFactory("system.data.sqlclient").CreateConnection()) { dbConnection.ConnectionString = "Server=tcp:cipherrex.database.windows.net,1433;Initial Catalog=cipherRexUmbraco;Persist Security Info=False;User ID=cipherrex;Password=R00ksp@wnR00ksp@wn;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; dbConnection.Open(); Models.DAL.SqlDAL sqlDAL = new Models.DAL.SqlDAL(dbConnection); Models.Repositories.Fighter.IFighterRepository fighterRepository = new Models.Repositories.Fighter.FighterRepository(sqlDAL); Models.Repositories.PlayerRepos.IPlayerRepo playerRepo = new Models.Repositories.PlayerRepos.PlayerRepo(sqlDAL); PlayerUoW uow = new PlayerUoW(sqlDAL, playerRepo); string newFighterId = uow.CreateFighter(fighter.Name, _userEmail, fighter.Picture); } }