public BuyTetel(BookShopApp bookShopApp, Tetel tetel)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
this.tetel = tetel;
//MessageBox.Show("EZ AZ ID: " + konyv.t_id.ToString());
label1.Text = "Cím:";
label2.Text = "Szerző:";
label3.Text = "Ár:";
label4.Text = "Értékelés:";
label5.Text = "Leírás";
label6.Text = "Komment:";
label7.Text = tetel.cim;
label8.Text = tetel.szerzo;
label9.Text = tetel.ar.ToString();
label10.Text = bookShopApp.db_cont.GetAdatlapById(tetel).ertekels.ToString();
label11.Text = bookShopApp.db_cont.GetAdatlapById(tetel).leiras;
label12.Text = bookShopApp.db_cont.GetAdatlapById(tetel).komment;
this.Visible = true;
}
public NewMusic(BookShopApp bookShopApp)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
mufajcomboBox1.Items.AddRange(new object[] { "Heavy Metal", "Power Metal", "Nu Metal", "Trash Metal", "Hard Rock", "Soft Rock" });
categoriacomboBox1.Items.AddRange(bookShopApp.db_cont.GetCategoria());
}
public NewFilm(BookShopApp bookShopApp)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
mufajcomboBox1.Items.AddRange(new object[] { "Horror", "Scifi", "Komédia", "Dráma" });
categoriacomboBox1.Items.AddRange(bookShopApp.db_cont.GetCategoria());
}
public EddigVasaroltam(BookShopApp bookShopApp)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
KonyvdataGridView1.DataSource = bookShopApp.db_cont.GetMegvettKonyvek(bookShopApp.db_cont.GetOnlineFelhasznalo().u_id);
FilmdataGridView2.DataSource = bookShopApp.db_cont.GetMegvettFilmek(bookShopApp.db_cont.GetOnlineFelhasznalo().u_id);
ZenedataGridView3.DataSource = bookShopApp.db_cont.GetMegvettZenek(bookShopApp.db_cont.GetOnlineFelhasznalo().u_id);
Visible = true;
}
public SajatAdatlap(BookShopApp bookShopApp)
{
this.bookShopApp = bookShopApp;
}
public SajatAdatlap(BookShopApp bookShopApp, Felhasznalo felhasznalo)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
label5.Text = felhasznalo.k_nev;
label6.Text = felhasznalo.v_nev;
label7.Text = felhasznalo.email;
label8.Text = felhasznalo.tel_szam.ToString();
label11.Text = felhasznalo.vasarolt_db.ToString();
Egyenleglabel15.Text = felhasznalo.egyenleg.ToString();
Utcalabel17.Text = bookShopApp.db_cont.GetLakhelyFromUid(felhasznalo.u_id).utca;
Hszámlabel18.Text = bookShopApp.db_cont.GetLakhelyFromUid(felhasznalo.u_id).hazszam.ToString();
if (felhasznalo.admine)
{
label10.Text = "Admin";
}
else
{
label10.Text = "Felhasználó";
}
if (felhasznalo.torzsvasarlo)
{
label12.Text = "Törzsvásárló";
}
else
{
label12.Text = "Nem törzsvásárló";
}
int u_id = bookShopApp.db_cont.GetOnlineFelhasznalo().u_id;
using (OracleConnection conn = new OracleConnection(db_connection))
using (OracleCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM felhasznalo WHERE u_id =" + u_id;
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["kep"] != System.DBNull.Value)
{
byte[] img = (byte[])(reader["kep"]);
if (img == null)
{
pictureBox1.Image = null;
}
else
{
MemoryStream ms = new MemoryStream(img);
pictureBox1.Image = System.Drawing.Image.FromStream(ms);
}
}
}
}
this.Visible = true;
}
public NewShop(BookShopApp bookShopApp)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
}
public Login(BookShopApp bookShopApp)
{
InitializeComponent();
this.bookShopApp = bookShopApp;
}
