public bool dbMarketContextSiparisIptalEt(Siparis siparis)
{
List <SiparisDetayi> siparisDetaylari = new SiparisDetayiRepo().GetAll().Where(x => x.SiparisID == siparis.SiparisID).ToList();
bool iptalDurumu = false;
MarketContext db = new MarketContext();
using (var tran = db.Database.BeginTransaction())
{
try
{
foreach (SiparisDetayi item in siparisDetaylari)
{
db.SiparisDetaylari.Remove(item);
db.SaveChanges();
}
db.Siparisler.Remove(siparis);
db.SaveChanges();
iptalDurumu = true;
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
return(iptalDurumu);
}
public int StokGetir(string barkod)
{
int fark = 0;
List <UrunSatisDetayi> urunSatisDetayListesi = new UrunSatisDetayiRepo().GetAll();
List <SiparisDetayi> siparisDetayListesi = new SiparisDetayiRepo().GetAll();
int satilanAdet = 0, siparisAdet = 0;
int mevcutStok = (new UrunRepo().GetAll().Find(x => x.Barkod == barkod) as Urun).Stok;
foreach (UrunSatisDetayi item in urunSatisDetayListesi)
{
if (item.UrunBarkodu == barkod)
{
satilanAdet += item.Adet;
}
}
foreach (SiparisDetayi item in siparisDetayListesi)
{
if (item.Siparis.SiparisTeslimAlindiMi != true)
{
break;
}
if (item.UrunBarkodu == barkod)
{
siparisAdet += item.Adet;
}
}
if (siparisAdet > satilanAdet)
{
fark = siparisAdet - satilanAdet;
fark += mevcutStok;
}
else if (satilanAdet >= siparisAdet)
{
fark = siparisAdet - satilanAdet;
fark += mevcutStok;
}
if (fark == 0)
{
fark = mevcutStok;
}
return(fark);
}
private void btnSiparisTeslimAlindi_Click(object sender, EventArgs e)
{
Siparis secilenSiparis = gridViewSiparisTeslim.GetFocusedRow() as Siparis;
SiparisRepo dbRepoSiparis = new SiparisRepo();
secilenSiparis.SiparisTeslimAlindiMi = true;
dbRepoSiparis.Update();
SiparisDetayiRepo dbRepoDetay = new SiparisDetayiRepo();
List <SiparisDetayi> liste = new List <SiparisDetayi>();
liste = dbRepoDetay.GetAll().Where(x => x.SiparisID == secilenSiparis.SiparisID).ToList();
UrunRepo dbUrunReposu = new UrunRepo();
liste.ForEach(
x =>
MessageBox.Show(dbUrunReposu.StokGetir(x.UrunBarkodu).ToString())
);
MessageBox.Show("Teslim alınan siparişler stoğa işlendi.");
}
private void GrideSiparisinDetaylariniGetir(int siparisID)
{
SiparisDetayiRepo dbSiparisDetayi = new SiparisDetayiRepo();
gridControlSiparisDetay.DataSource = dbSiparisDetayi.GetAll().Where(x => x.SiparisID == siparisID);
}
