private void btnListele_Click(object sender, EventArgs e) { var ent = new CafeOtomasyonEntities(); var sonuc = from Urun in ent.SiparisUrun select Urun; dgvSiparisGoster.DataSource = sonuc.ToList(); }
private void btnListele_Click(object sender, EventArgs e) { var ent = new CafeOtomasyonEntities(); var sonuc = from Urun in ent.Urunler select new { Urun.urunAdi, Urun.birimFiyat, Urun.kalanAdet }; dgvListele.DataSource = sonuc.ToList(); }
// Adisyon ads = new Adisyon(); private void btnSiparisOnay_Click(object sender, EventArgs e) { MessageBox.Show("Sipariş alındı", "Sipariş Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information); //ads.masaNo = Convert.ToInt32(txtMasaNo.Text); siparis.adisyonNo = Convert.ToInt32(txtMasaNo.Text); siparis.urunID = Convert.ToInt32(txtUrunID.Text); siparis.adet = Convert.ToInt32(txtMiktar.Text); using (CafeOtomasyonEntities ent = new CafeOtomasyonEntities()) { ent.SiparisUrun.Add(siparis); ent.SaveChanges(); } }
private void btnEkle_Click(object sender, EventArgs e) { urun.kategoriID = Convert.ToInt32(txtKategori.Text); urun.birimFiyat = Convert.ToDecimal(txtUrunFiyat.Text); urun.urunAdi = txtUrunAdi.Text; urun.satilanAdet = 0; urun.kalanAdet = Convert.ToInt32(txtStok.Text); using (CafeOtomasyonEntities ent = new CafeOtomasyonEntities()) { ent.Urunler.Add(urun); ent.SaveChanges(); } }