//I put methods here to clean up the forms public static bool login(string user, string pass, bool hash) { if (hash) { pass = Hash.passwordHash(pass); } try { MySqlDataReader reader = new MySqlCommand("SELECT * FROM teacher WHERE login_id = '" + user + "' and pass = '******';", conn).ExecuteReader(); if (reader.HasRows) { reader.Read(); admin = reader.GetBoolean("administrator"); id = reader.GetString("login_id"); reader.Close(); username = user; return(true); } else { reader.Close(); } }catch (Exception e) { Console.WriteLine(e.StackTrace); } return(false); }
public static Account GetAccountFromDb(string ndc) { Locker.EnterReadLock(); try { Account account = null; string query = "SELECT * FROM Accounts WHERE Username = '******'"; MySqlDataReader dataReader = new MySqlCommand(query, AuthDatabaseProvider.Connection).ExecuteReader(); while (dataReader.Read()) { account = new Account(); account.Username = ndc; account.Password = dataReader["Password"].ToString(); account.Nickname = dataReader["Nickname"].ToString(); account.Role = (ServerRoleEnum)dataReader.GetInt32("Role"); account.Id = dataReader.GetInt32("Id"); account.Banned = dataReader.GetBoolean("Banned"); account.MaxCharactersCount = dataReader.GetInt32("MaxCharactersCount"); account.PointsCount = dataReader.GetInt32("PointCount"); } dataReader.Close(); return(account); } finally { Locker.ExitReadLock(); } }
private void FetchData() { try { var S = new StatystykaSQL(); string SqlString; SqlString = S.SelectObsada(Settings.Default.IdSchool.ToString(), Settings.Default.SchoolYear, rbOkres.Tag.ToString() == "S"?EndOfSemester:EndOfSchoolYear); SqlString += S.SelectLiczbaOcen(Settings.Default.IdSchool.ToString(), Settings.Default.SchoolYear, rbOkres.Tag.ToString()); SqlString += S.SelectStanKlasy(Settings.Default.IdSchool.ToString(), Settings.Default.SchoolYear, rbOkres.Tag.ToString() == "S" ? EndOfSemester : EndOfSchoolYear); SqlString += S.SelectStanKlasyWirtualnej(Settings.Default.IdSchool.ToString(), Settings.Default.SchoolYear, rbOkres.Tag.ToString() == "S" ? EndOfSemester : EndOfSchoolYear); SqlString += S.CountGroupMember(Settings.Default.IdSchool.ToString(), Settings.Default.SchoolYear); using (var R = new MySqlCommand(SqlString, conn).ExecuteReader()) { lstObsada.Clear(); while (R.Read()) { lstObsada.Add(new SubjectStaff { Class = new StaffUnit { ID = R.GetInt32("Klasa"), Nazwa = R.GetString("Nazwa_Klasy") }, Subject = new SubjectUnit { ID = R.GetInt32("IdPrzedmiot"), Nazwa = R.GetString("Przedmiot"), IdSzkolaPrzedmiot = R.GetInt32("IdSzkolaPrzedmiot") }, Teacher = new StaffUnit { ID = R.GetInt32("IdNauczyciel"), Nazwa = R.GetString("Nauczyciel") }, IsVirtual = R.GetBoolean("Virtual") } ); } R.NextResult(); lstLiczbaOcen.Clear(); while (R.Read()) { lstLiczbaOcen.Add(new ScoreInfo { ScoreCount = R.GetInt32("LiczbaOcen"), ScoreWeight = (int)R.GetFloat("Waga"), ClassID = R.GetInt32("Klasa"), SubjectID = R.GetInt32("IdPrzedmiot"), TeacherID = R.GetInt32("Nauczyciel") }); } R.NextResult(); lstLiczbaUczniow.Clear(); while (R.Read()) { lstLiczbaUczniow.Add(new StudentCount { ClassID = R.GetInt32("Klasa"), Count = R.GetInt32("StanKlasy") }); } R.NextResult(); lstLiczbaUczniowNI.Clear(); while (R.Read()) { lstLiczbaUczniowNI.Add(new VirtualStudentCount { ClassID = R.GetInt32("Klasa"), Count = R.GetInt32("StanKlasy"), SubjectID = R.GetInt32("IdPrzedmiot"), VirtualClassID = R.GetInt32("KlasaWirtualna") }); } R.NextResult(); lstLiczbaUczniowGrupa.Clear(); while (R.Read()) { lstLiczbaUczniowGrupa.Add(new SubjectGroupCount { ClassID = R.GetInt32("Klasa"), Count = R.GetInt32("StanGrupy"), SubjectID = R.GetInt32("IdPrzedmiot"), SubjectIdBySchool = R.GetInt32("IdSzkolaPrzedmiot") }); } } } catch (Exception) { throw; } }
internal static Dictionary <string, object> Get(int CharacterID) { Dictionary <string, object> CharacterData = new Dictionary <string, object>(); MySqlDataReader ResultReader; ResultReader = new MySqlCommand($"select * FROM usercharacter WHERE UserCharacterID = {CharacterID}") { Connection = Connection }.ExecuteReader(); ResultReader.Read(); CharacterData.Add("CharacterID", ResultReader.GetInt64(0)); CharacterData.Add("Name", ResultReader.GetString(2)); //The 0 here is an Ordinal CharacterData.Add("GuildID", ResultReader.GetInt64(3)); CharacterData.Add("Credits", ResultReader.GetInt64(4)); CharacterData.Add("LastInInstanceID", ResultReader.GetInt16(5)); CharacterData.Add("LastInInstance", ResultReader.GetInt64(6)); CharacterData.Add("PositionX", ResultReader.GetFloat(7)); CharacterData.Add("PositionY", ResultReader.GetFloat(8)); CharacterData.Add("Deleted", ResultReader.GetBoolean(10)); ResultReader.Close(); ResultReader = new MySqlCommand($"select * FROM usercharacterxp WHERE UserCharacterID = {CharacterID}") { Connection = Connection }.ExecuteReader(); ResultReader.Read(); CharacterData.Add("MageXP", ResultReader.GetInt64(1)); CharacterData.Add("HealerXP", ResultReader.GetInt64(2)); CharacterData.Add("AttackerXP", ResultReader.GetInt64(3)); CharacterData.Add("TankXP", ResultReader.GetInt64(4)); CharacterData.Add("WoodcuttingXP", ResultReader.GetInt64(5)); CharacterData.Add("CombatXP", ResultReader.GetInt64(6)); ResultReader.Close(); ResultReader = new MySqlCommand($"select * FROM usercharacteroutfit WHERE CharacterID = {CharacterID} AND IsEquipped = 1") { Connection = Connection }.ExecuteReader(); ResultReader.Read(); CharacterData.Add("HeadIndex", ResultReader.GetInt16(3)); CharacterData.Add("HeadColor", ResultReader.GetString(4)); CharacterData.Add("HairIndex", ResultReader.GetInt16(5)); CharacterData.Add("HairColor", ResultReader.GetString(6)); CharacterData.Add("EyesIndex", ResultReader.GetInt16(7)); CharacterData.Add("EyesColor", ResultReader.GetString(8)); CharacterData.Add("TorsoIndex", ResultReader.GetInt16(9)); CharacterData.Add("TorsoColor", ResultReader.GetString(10)); CharacterData.Add("ArmsIndex", ResultReader.GetInt16(11)); CharacterData.Add("ArmsColor", ResultReader.GetString(12)); CharacterData.Add("HandsIndex", ResultReader.GetInt16(13)); CharacterData.Add("HandsColor", ResultReader.GetString(14)); CharacterData.Add("LegsIndex", ResultReader.GetInt16(15)); CharacterData.Add("LegsColor", ResultReader.GetString(16)); CharacterData.Add("FeetIndex", ResultReader.GetInt16(17)); CharacterData.Add("FeetColor", ResultReader.GetString(18)); ResultReader.Close(); return(CharacterData); }
// Users static public Tuple <int, string, bool> Login(string username, string password) { var query = "select id, username, password, is_admin from users where username = '******' AND password = SHA2('" + MySqlHelper.EscapeString(password) + "', 256);"; Tuple <int, string, bool> result = null; if (OpenConnection()) { var reader = new MySqlCommand(query, connection).ExecuteReader(); if (reader.Read()) { result = new Tuple <int, string, bool>(reader.GetInt32("id"), reader.GetString("username"), reader.GetBoolean("is_admin")); } reader.Close(); } CloseConnection(); return(result); }