/// <summary>
/// Kikeresi az adatbázisból egy yachtnak a képét
/// </summary>
/// <param name="id">yacht id</param>
/// <returns>yacht kép</returns>
public BitmapImage MysqlYachtImage(int id)
{
BitmapImage image = null;
try
{
string query = "SELECT Image FROM enYacht WHERE yacht_id = ?yacht_id;";
Globals.connect.Open();
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
cmd.Parameters.Add("?yacht_id", MySqlDbType.Int16).Value = id;
try
{ image = MysqlGeneral.ByteToImage((byte[])cmd.ExecuteScalar()); }
catch (Exception)
{ image = null; }
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error in adding mysql row. Error: " + ex.Message);
}
finally
{
Globals.connect.Close();
}
return(image);
}
/// <summary>
/// Bejelentkezés és az felhasználó adatainak a beolvasása
/// </summary>
/// <param name="login_name">Login név</param>
/// <param name="password">Jelszó</param>
/// <returns></returns>
public Felhasznalo MysqlFelhasznalo(string login_name, string password)
{
Felhasznalo user = new Felhasznalo();
user.login = Mysql_Login(login_name, password);
try
{
if (user.login != null)
{
string query = "SELECT * FROM enYacht_Club_Tag INNER JOIN enzipcode USING(zip_code) WHERE member_id = ?member_id;";
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
cmd.Parameters.Add("?member_id", MySqlDbType.Int32).Value = user.login.id;
MySqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
user.member_id = (int)read["member_id"];
user.nickname = read["nickname"].ToString();
user.veztek_nev = read["last_name"].ToString();
user.kereszt_nev = read["first_name"].ToString();
user.orszag = read["country"].ToString();
user.lakcim = read["address"].ToString();
user.iranyitoszm = (int)read["zip_code"];
user.varos = read["city"].ToString();
user.szuletesdt = DateTime.Parse(read["birthday"].ToString());
try
{ user.kep = MysqlGeneral.ByteToImage((byte[])read["image"]); }
catch (Exception)
{ user.kep = null; }
}
}
}
else
{
return(null);
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error in adding mysql row. Error: " + ex.Message);
}
finally
{
Globals.connect.Close();
}
return(user);
}
