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);
}
