Notes

private void Form1_Load(object sender, EventArgs e)
{
MasaManager masaManager = new MasaManager();
var masalar = masaManager.MasalariListele();
int tindex = 0;
foreach (var masa in masalar)
{
Button MasaButton = new Button();

MasaButton.Name = "MasaButton" + masa.Id;
MasaButton.Size = new System.Drawing.Size(100, 75);
MasaButton.TabIndex = tindex;
MasaButton.Text = masa.Ad;
MasaButton.BackColor = masa.Dolu ? Color.PaleVioletRed : Color.LightGreen;
// MasaButton.Click += new System.EventHandler(MasaButton_Click);
masaPanel.Controls.Add(MasaButton);
tindex++;
}
}
}
}
22222
public class Masa

{
public int Id { get; set; }
public string Ad { get; set; }
public int Siralama { get; set; }
public bool Dolu { get; set; }

}
}
222222
class Personel
{
public int Id { get; set; }
public string AdSoyad { get; set; }
public Yetkiler Yetki { get; set; }
}

public enum Yetkiler:byte
{
Admin=1,
Garson=2,
Mutfak=3,
Kasa=4
}
}
222222
class Siparis
{
public int Id { get; set; }
public DateTime Tarih { get; set; }
public int PersonelId { get; set; }
public int MasaId { get; set; }
public SiparisDurumlar Durum { get; set; }


}

public enum SiparisDurumlar:byte
{

Iptal =0,
Alindi=1,
Hazirlaniyor=2,
Tamamlandi=3,
OdemeYapildi=4
}
}
22222 class SiparisUrun
{
public int Id { get; set; }
public int SiparisId { get; set; }
public int UrunId { get; set; }
public int Miktar { get; set; }
public double Fiyat { get; set; }
}
}
22222
class Urun
{
public int Id { get; set; }
public string Ad { get; set; }
public double Fiyat { get; set; }
public int Stok { get; set; }
public int KategoriId { get; set; }


}
}
222222
class UrunKategori
{
public int Id { get; set; }
public string Ad { get; set; }
public int Siralama { get; set; }
}
}
33333
public class MasaManager
{
public List<Masa> MasalariListele()
{
var masalar = new List<Masa>();
try
{
string constring = "Server=localhost//SQLEXPRESS01;Database=master;Trusted_Connection=True;";
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand com = new SqlCommand("SELECT * from Masalar", con))
{
con.Open();
SqlDataReader sql = com.ExecuteReader();
while(sql.Read())
{
masalar.Add(new Masa
{
Id = sql.GetInt32(0),
Ad = sql.GetString(1),
Siralama = sql.GetInt32(2),
Dolu = sql.GetBoolean(3)

});
}



}
}

}
catch (Exception e)
{
var a = e;
}
return masalar;
}
}
}
33333
namespace RestoranProjesi.Servis
{
class SiparisManager
{


}
}