public Banishment TestIfUserBan(int idAccount) { stopwatch.Start(); try { Banishment banishment = new Banishment(); string queryIfBanned = nameBdd.testIfUserBan(idAccount); if (this.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(queryIfBanned, connection); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { banishment.hasBanned = true; banishment.start = nameBdd.banishmentStart(dataReader); banishment.during = nameBdd.banishmentDuring(dataReader); banishment.end = nameBdd.banishmentEnd(dataReader); banishment.reason = nameBdd.banishmentReason(dataReader); } dataReader.Close(); this.CloseConnection(); stopwatch.Stop(); log.Info("api.CONNECTION.TestIfUserBan ... (" + stopwatch.Elapsed.TotalSeconds + " ms)"); return(banishment); } else { return(banishment); } } catch (Exception ex) { log.Error(ex); return(null); } }
public ResponseFront Connection([FromBody] RequestFrontConnexion request) { log.Info("api.Connection ..."); Bdd bdd = DataBaseConnection.databaseConnection(); Banishment banishment = new Banishment(); string mdpCrypt = ShaHash.GetShaHash(request.password); string concatPasswordKeys = String.Concat(CONST.KEY_CRYPTAGE, mdpCrypt, CONST.KEY_CRYPTAGE); string stringPasswordCrypt = ShaHash.GetShaHash(concatPasswordKeys); string emailCrypt = ShaHash.GetShaHash(request.email); string concatEmailKeys = String.Concat(CONST.KEY_CRYPTAGE, emailCrypt, CONST.KEY_CRYPTAGE); string stringEmailCrypt = ShaHash.GetShaHash(concatEmailKeys); request.password = stringPasswordCrypt; request.email = stringEmailCrypt; try { int exist = bdd.Connection(request); if (exist == 0) { log.Info("Compte introuvable en BDD"); responseFront.hasError = true; responseFront.error = MSG.COMPTE_INTROUVABLE; return(responseFront); } int idAccount = bdd.RetrieveIdAccount(request); banishment = bdd.TestIfUserBan(idAccount); banishment.endFormalize = banishment.end.ToString("dd.MM.yyyy-HH:mm:ss"); if (banishment.hasBanned) { log.Info(MSG.COMPTE_BANNI); responseFront.hasError = true; responseFront.error = banishment; return(responseFront); } string tokenClient = GenerateToken.generationToken(CONST.TOKEN_SIZE); string tokenServer = GenerateToken.generationToken(CONST.TOKEN_SIZE); bdd.InsertToken(idAccount, tokenServer, tokenClient); bdd.NowOnline(idAccount); log.Info("Utilisateur #" + idAccount + " vient de connecter"); responseFront.response = tokenClient; return(responseFront); } catch (Exception e) { log.Error("Erreur durant la connexion", e); responseFront.hasError = true; responseFront.error = MSG.CONNEXION_IMPOSSIBLE; return(responseFront); } }