Exemple #1
0
        /// <summary>
        /// Method to register a game
        /// </summary>
        /// <param name="match">Match data</param>
        /// <returns>If the game was registered correctly</returns>
        public int RegisterMatch(Match match)
        {
            int idMatch = 0;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    db.Match.Add(match);
                    db.SaveChanges();
                    idMatch = match.idMatch;
                }

                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
                catch (DbUpdateException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(idMatch);
        }
Exemple #2
0
        /// <summary>
        /// This method logs exceptions to telegram
        /// </summary>
        /// /// <param name="obj">Telegram bot data</param>
        /// <param name="exception">The exception to log</param>
        public static void Log(object obj, Exception exception)
        {
            string date          = System.DateTime.Now.ToString("yyyy-MM-dd");
            string time          = System.DateTime.Now.ToString("HH:mm:ss");
            string path          = "Log/log-" + date + ".txt";
            string pathDirectory = "Log";

            try
            {
                if (!Directory.Exists(pathDirectory))
                {
                    Directory.CreateDirectory(pathDirectory);
                }
                StreamWriter streamWriter = new StreamWriter(path, true);
                StackTrace   stacktrace   = new StackTrace();
                streamWriter.WriteLine(obj.GetType().FullName + " " + time);
                streamWriter.WriteLine(stacktrace.GetFrame(1).GetMethod().Name + " - " + exception.ToString());
                streamWriter.WriteLine("");
                streamWriter.Flush();
                streamWriter.Close();
            }
            catch (IOException exceptionLog)
            {
                TelegramBot.SendToTelegram(exceptionLog);
            }
        }
Exemple #3
0
        /// <summary>
        /// Method to know if a player is registered
        /// </summary>
        /// <param name="email">Registered player email</param>
        /// <param name="password">Registered player password</param>
        /// <returns>If the player is registered in the database</returns>
        public bool IsLog(string email, string password)
        {
            bool log = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = new Account();
                    account = db.Account.SingleOrDefault
                                  (accountSearch => accountSearch.email == email && accountSearch.passwordAccount == password);
                    if (account != null)
                    {
                        Player player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == account.nickName &&
                                                                  playerSearch.statusPlayer == "Active");
                        if (player != null)
                        {
                            log = true;
                        }
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(log);
        }
Exemple #4
0
        /// <summary>
        /// Method to remove Players from the Match
        /// </summary>
        /// <param name="idMatch">Match identifier</param>
        /// <param name="players">Players from the Match</param>
        /// <returns>If players were removed from the Match</returns>
        public bool DeletePlayerMatch(int idMatch, List <Player> players)
        {
            bool isDeletePlayerMatch = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Match match = new Match();
                    match = db.Match.SingleOrDefault(matchSearch => matchSearch.idMatch == idMatch);
                    if (match != null)
                    {
                        foreach (Player player in players)
                        {
                            Player playerMatch = db.Player.Find(player.nickName);
                            match.Player.Remove(playerMatch);
                        }
                        db.SaveChanges();
                        isDeletePlayerMatch = true;
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isDeletePlayerMatch);
        }
Exemple #5
0
        /// <summary>
        /// Method to delete a Match
        /// </summary>
        /// <param name="idMatch">Match of the game</param>
        /// <returns>If the match was deleted</returns>
        public bool DeleteMatch(int idMatch)
        {
            bool isDeleteMatch = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Match match = new Match();
                    match = db.Match.SingleOrDefault(matchSearch => matchSearch.idMatch == idMatch);
                    if (match != null)
                    {
                        db.Match.Remove(match);
                        db.SaveChanges();
                        isDeleteMatch = true;
                    }
                }
                catch (EntityException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isDeleteMatch);
        }
Exemple #6
0
        /// <summary>
        /// Method to delete a player
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <returns>If the player was deleted</returns>
        public bool DeletePlayer(string nickname)
        {
            bool isDeletePlayer = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Player player = new Player();
                    player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == nickname);
                    if (player != null)
                    {
                        db.Player.Remove(player);
                        db.SaveChanges();
                        isDeletePlayer = true;
                    }
                }
                catch (EntityException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isDeletePlayer);
        }
Exemple #7
0
        /// <summary>
        /// Method to delete an account
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <returns>If the account was deleted</returns>
        public bool DeleteAccount(string nickname)
        {
            bool isDeleteAccount = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = new Account();
                    account = db.Account.SingleOrDefault(accountSearch => accountSearch.nickName == nickname);
                    if (account != null)
                    {
                        db.Account.Remove(account);
                        db.SaveChanges();
                        isDeleteAccount = true;
                    }
                }
                catch (EntityException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isDeleteAccount);
        }
Exemple #8
0
        /// <summary>
        /// Method to delete a report
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <returns>If the report was deleted</returns>
        public bool DeleteReport(string nickname)
        {
            bool isDeleteReport = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    ReportMisConduct report = new ReportMisConduct();
                    report = db.ReportMisConduct.SingleOrDefault(reportSearch => reportSearch.idReportedPlayer == nickname);
                    if (report != null)
                    {
                        db.ReportMisConduct.Remove(report);
                        db.SaveChanges();
                        isDeleteReport = true;
                    }
                }
                catch (EntityException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isDeleteReport);
        }
Exemple #9
0
        /// <summary>
        /// Method to modify player data
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <param name="playerEdit">The new data of the player</param>
        /// <returns>If the player data was modified correctly</returns>
        public bool UpdatePlayer(string nickname, Player playerEdit)
        {
            bool updatePlayer = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try {
                    Player player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == nickname);
                    if (player != null)
                    {
                        if (!string.IsNullOrWhiteSpace(playerEdit.namePlayer))
                        {
                            player.namePlayer = playerEdit.namePlayer;
                            updatePlayer      = true;
                        }
                        if (!string.IsNullOrWhiteSpace(playerEdit.lastName))
                        {
                            player.lastName = playerEdit.lastName;
                            updatePlayer    = true;
                        }
                        db.SaveChanges();
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(updatePlayer);
        }
Exemple #10
0
        /// <summary>
        /// Method to find a player's account
        /// </summary>
        /// <param name="email">Email of the player</param>
        /// <returns>The player's account</returns>
        public Account SearchAccount(string email)
        {
            Account account = null;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    account = db.Account.SingleOrDefault(accountSearch => accountSearch.email == email);
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(account);
        }
Exemple #11
0
        /// <summary>
        /// Methods to find player data with nickname
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <returns>Player data</returns>
        public Player SearchPlayer(string nickname)
        {
            Player player = null;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == nickname);
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(player);
        }
Exemple #12
0
        /// <summary>
        /// Method to find a player's information with email
        /// </summary>
        /// <param name="email">Email of the player</param>
        /// <returns>Player data</returns>
        public Player SearchInformationPlayer(string email)
        {
            Player player = null;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = db.Account.SingleOrDefault(playerSearch => playerSearch.email == email);
                    player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == account.nickName);
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(player);
        }
Exemple #13
0
        /// <summary>
        /// Method to get a player's report list
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <returns>The player report list</returns>
        public List <ReportMisConduct> SearchReport(String nickname)
        {
            List <ReportMisConduct> reportMisConducts = null;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    List <ReportMisConduct> reports = db.ReportMisConduct.Where(reportMisConductSearch => reportMisConductSearch.idReportedPlayer == nickname).ToList <ReportMisConduct>();
                    reportMisConducts = reports.OrderBy(player => player.dateHour).ToList();
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(reportMisConducts);
        }
Exemple #14
0
        /// <summary>
        /// Methods to obtain the points of all players
        /// </summary>
        /// <returns>List of players with the points obtained</returns>
        public List <Player> SearchBestScoresPlayer()
        {
            List <Player> playersOrder = null;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    List <Player> players = db.Player.Where(player => player.scoreObtained > 0).ToList <Player>();
                    playersOrder = players.OrderBy(score => score.scoreObtained).ToList();
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(playersOrder);
        }
Exemple #15
0
        /// <summary>
        /// Method to register a report
        /// </summary>
        /// <param name="report">Data report</param>
        /// <returns>If the report was registered correctly</returns>
        public bool RegisterReport(ReportMisConduct report)
        {
            bool isReport = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    db.ReportMisConduct.Add(report);
                    db.SaveChanges();
                    isReport = true;
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isReport);
        }
Exemple #16
0
        /// <summary>
        /// Method to search for a sentence
        /// </summary>
        /// <returns>The sentence found</returns>
        public Sentence SearchSentence()
        {
            Sentence sentence = null;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    do
                    {
                        sentence = db.Sentence.OrderBy(r => Guid.NewGuid()).Take(1).FirstOrDefault();
                    } while (sentence == null);
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(sentence);
        }
Exemple #17
0
        /// <summary>
        /// Method to register player account
        /// </summary>
        /// <param name="account">Account data</param>
        /// <param name="player">Player data</param>
        /// <returns>If the player was registered correctly</returns>
        public bool RegisterPlayer(Account account, Player player)
        {
            bool registerOk = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    db.Player.Add(player);
                    db.Account.Add(account);
                    db.SaveChanges();
                    registerOk = true;
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(registerOk);
        }
Exemple #18
0
        /// <summary>
        /// Method to find if a player's email repeats
        /// </summary>
        /// <param name="emailEdit">The new email of the player</param>
        /// <param name="idAccount">The player account identifier</param>
        /// <returns>If the same email was found</returns>
        public bool SearchRepeatEmailAccount(string emailEdit, int idAccount)
        {
            bool search = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = db.Account.SingleOrDefault(accountSearch => accountSearch.email == emailEdit && accountSearch.idAccount != idAccount);
                    if (account != null)
                    {
                        search = true;
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(search);
        }
Exemple #19
0
        /// <summary>
        /// Method to search for a repeated player email
        /// </summary>
        /// <param name="nicknameEdit">The new nickname of the player</param>
        /// <param name="nicknameCurrent">The nickname of the player</param>
        /// <returns>If the nickname was found in the database</returns>
        public bool SearchRepeatNicknamePlayer(string nicknameEdit, string nicknameCurrent)
        {
            bool search = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Player player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == nicknameEdit && playerSearch.nickName != nicknameCurrent);
                    if (player != null)
                    {
                        search = true;
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(search);
        }
Exemple #20
0
        /// <summary>
        /// Method to get the account id
        /// </summary>
        /// <param name="email">Email of the account</param>
        /// <returns>The account id</returns>
        public int ObtainIdAccount(string email)
        {
            int idAccount = 0;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = new Account();
                    account = db.Account.SingleOrDefault(accountSearch => accountSearch.email == email);
                    if (account != null)
                    {
                        idAccount = account.idAccount;
                    }
                }
                catch (EntityException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(idAccount);
        }
Exemple #21
0
        /// <summary>
        /// Method to modify the player's email
        /// </summary>
        /// <param name="email">The email of the player</param>
        /// <param name="idAccount">The account identifier</param>
        /// <returns>If the email was modified correctly</returns>
        public bool UpdateEmail(string email, int idAccount)
        {
            bool updateEmail = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = db.Account.SingleOrDefault(accountSearch => accountSearch.idAccount == idAccount);
                    if (account != null)
                    {
                        account.email = email;
                        db.SaveChanges();
                        updateEmail = true;
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(updateEmail);
        }
Exemple #22
0
        /// <summary>
        /// Method to delete an account
        /// </summary>
        /// <param name="nickname">Nickname of the player</param>
        /// <returns>If the account was deleted successfully</returns>
        public bool DeleteAccountPlayer(string nickname)
        {
            bool isDeletePlayer = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Player player = db.Player.SingleOrDefault(playerSearch => playerSearch.nickName == nickname);
                    if (player != null)
                    {
                        player.statusPlayer = "Inactive";
                        db.SaveChanges();
                        isDeletePlayer = true;
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(isDeletePlayer);
        }
Exemple #23
0
        /// <summary>
        /// Method to change account password
        /// </summary>
        /// <param name="email">Email of the player</param>
        /// <param name="newPassword">The new password</param>
        /// <returns>If the password was changed correctly</returns>
        public bool ChangePassword(string email, string newPassword)
        {
            bool update = false;

            using (HangmanGameContext db = new HangmanGameContext())
            {
                try
                {
                    Account account = db.Account.SingleOrDefault(accountSearch => accountSearch.email == email);
                    if (account != null)
                    {
                        account.passwordAccount = newPassword;
                        db.SaveChanges();
                        update = true;
                    }
                }
                catch (DbEntityValidationException exception)
                {
                    TelegramBot.SendToTelegram(exception);
                    LogException.Log(this, exception);
                }
            }
            return(update);
        }