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