public void magazaGuncelle() { for (int i = 0; i < panel11.Controls.Count; i++) { panel11.Controls.RemoveAt(i); } con.Open(); using (var command = new NpgsqlCommand("SELECT magaza_isim,magaza_puan From magaza ", con)) { NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { UserControl4 uc4 = new UserControl4(dr["magaza_isim"].ToString(), dr["magaza_puan"].ToString()); uc4.Dock = DockStyle.Top; uc4.MouseHover += new EventHandler(this.mh); uc4.MouseLeave += new EventHandler(this.ml); uc4.Click += new EventHandler(this.click); panel11.Controls.Add(uc4); } con.Close(); } }
public anasayfa(int k) { InitializeComponent(); kID = k; string connString = String.Format( "Server=localhost;User Id=postgres;Database=yemegimigetir;Port=5432;Password=benbuyum123;SSLMode=Prefer"); con = new NpgsqlConnection(connString); con.Open(); using (var command = new NpgsqlCommand("SELECT kullanici_adi,kullanici_soyadi,kullanici_bakiye From kullanici WHERE kullanici_id=@id ", con)) { command.Parameters.AddWithValue("id", kID); NpgsqlDataReader dr = command.ExecuteReader(); if (dr.Read()) { label_isim.Text = dr["kullanici_adi"].ToString() + " " + dr["kullanici_soyadi"].ToString(); label_bakiye.Text += dr["kullanici_bakiye"].ToString(); bakiye = int.Parse(dr["kullanici_bakiye"].ToString()); } con.Close(); } con.Open(); using (var command = new NpgsqlCommand("SELECT adres_baslik,adres_adres From adres WHERE adres_kid=@id ", con)) { command.Parameters.AddWithValue("id", kID); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { UserControl3 uc3 = new UserControl3(dr["adres_baslik"].ToString(), dr["adres_adres"].ToString()); uc3.Dock = DockStyle.Top; panel9.Controls.Add(uc3); } con.Close(); } con.Open(); using (var command = new NpgsqlCommand("SELECT magaza_isim,magaza_puan From magaza ", con)) { NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { UserControl4 uc4 = new UserControl4(dr["magaza_isim"].ToString(), dr["magaza_puan"].ToString()); uc4.Dock = DockStyle.Top; uc4.MouseHover += new EventHandler(this.mh); uc4.MouseLeave += new EventHandler(this.ml); uc4.Click += new EventHandler(this.click); panel11.Controls.Add(uc4); } con.Close(); } }
void ml(object sender, EventArgs e) { UserControl4 panel = (UserControl4)sender; panel.BackColor = SystemColors.Control; }
void click(object sender, EventArgs e) { panel_menu2.Controls.Clear(); panel_yemek.Controls.Clear(); panel_icecek2.Controls.Clear(); UserControl4 uc4 = (UserControl4)sender; con.Open(); var command1 = new NpgsqlCommand("SELECT magaza_id From magaza where magaza_isim=@isim and magaza_puan=@puan", con); command1.Parameters.AddWithValue("isim", uc4.yy); command1.Parameters.AddWithValue("puan", int.Parse(uc4.p)); var mid = command1.ExecuteScalar(); con.Close(); magazaID = (int)mid; panel15.Visible = true; panel11.Controls.Clear(); button_geri.Visible = true; con.Open(); using (var command = new NpgsqlCommand("SELECT menu_isim,menu_fiyat From menu where menu_magazaid=@id", con)) { command.Parameters.AddWithValue("id", mid); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { UserControl5 uc5 = new UserControl5(dr["menu_isim"].ToString(), int.Parse(dr["menu_fiyat"].ToString()), this); uc5.Dock = DockStyle.Top; panel_menu2.Controls.Add(uc5); } con.Close(); } con.Open(); using (var command = new NpgsqlCommand("SELECT yemek_isim,yemek_fiyat From yemek where yemek_magazaid=@id", con)) { command.Parameters.AddWithValue("id", mid); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { UserControl5 uc5 = new UserControl5(dr["yemek_isim"].ToString(), int.Parse(dr["yemek_fiyat"].ToString()), this); uc5.Dock = DockStyle.Top; panel_yemek.Controls.Add(uc5); } con.Close(); } con.Open(); using (var command = new NpgsqlCommand("SELECT icecek_isim,icecek_fiyat From icecek where icecek_magazaid=@id", con)) { command.Parameters.AddWithValue("id", mid); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { UserControl5 uc5 = new UserControl5(dr["icecek_isim"].ToString(), int.Parse(dr["icecek_fiyat"].ToString()), this); uc5.Dock = DockStyle.Top; panel_icecek2.Controls.Add(uc5); } con.Close(); } }
void mh(object sender, EventArgs e) { UserControl4 panel = (UserControl4)sender; panel.BackColor = SystemColors.ActiveBorder; }