public List <Asiakas> HaeKaikkiAsiakkaat() { try { const string sqlLause = "SELECT * FROM asiakkaat;"; var tulokset = new MySqlCommand(sqlLause, Yhteys).ExecuteReader(); var asiakkaat = new List <Asiakas>(); while (tulokset.Read()) { asiakkaat.Add(new Asiakas(tulokset.GetInt16("id"), tulokset.GetString("etunimi"), tulokset.GetString("sukunimi"), tulokset.GetString("sahkoposti"), tulokset.GetString("puh"), tulokset.GetString("katuosoite"), tulokset.GetInt32("postinumero"), tulokset.GetString("paikkakunta"))); } return(asiakkaat); } catch (Exception e) { throw new Exception("Virhe asiakkaiden hakemisessa. ", e); } }
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); }