void stokEkle(int StokID, decimal Miktar)
{
try
{
DataRow dr = dtArestekiStoklar.NewRow();
TrGenel = SqlConnections.GetBaglanti().BeginTransaction();
//clsTablolar.Stok.csStok stokEkleme = new clsTablolar.Stok.csStok(SqlConnections.GetBaglanti(), TrGenel, StokID);
clsTablolar.n11.csN11Product n11Prod = new clsTablolar.n11.csN11Product(SqlConnections.GetBaglanti(), TrGenel, StokID);
clsTablolar.Stok.csStokFiyat Fiyat = new clsTablolar.Stok.csStokFiyat();
dr["AresStokID"] = StokID;
dr["AresN11StokKodu"] = n11Prod.N11StokKodu;
dr["AresUrunBasligi"] = n11Prod.UrunBasligi;
dr["AresAltBaslik"] = n11Prod.AltBaslik;
switch (n11Prod.StokMiktariEsitlemeSekli)
{
case clsTablolar.n11.csN11Product.StokMiktariEsitlemeSekliTanim.SabitMiktar:
dr["ArestekiN11Miktari"] = n11Prod.StokMiktariEsitlemeMiktari;
break;
case clsTablolar.n11.csN11Product.StokMiktariEsitlemeSekliTanim.StokMiktarıninAynisi:
dr["ArestekiN11Miktari"] = miktarr.StokMiktariGetir(SqlConnections.GetBaglanti(), TrGenel, StokID);
break;
case clsTablolar.n11.csN11Product.StokMiktariEsitlemeSekliTanim.StokMiktarindanAdetFazla:
dr["ArestekiN11Miktari"] = miktarr.StokMiktariGetir(SqlConnections.GetBaglanti(), TrGenel, StokID) + n11Prod.StokMiktariEsitlemeMiktari;
break;
case clsTablolar.n11.csN11Product.StokMiktariEsitlemeSekliTanim.StokMiktarindanAdetEksik:
dr["ArestekiN11Miktari"] = miktarr.StokMiktariGetir(SqlConnections.GetBaglanti(), TrGenel, StokID) - n11Prod.StokMiktariEsitlemeMiktari;
break;
default:
break;
}
dr["ArestekiN11approvalStatus"] = n11Prod.N11approvalStatus;
dr["ArestekiN11Fiyati"] = Fiyat.StokFiyatiniGetir(SqlConnections.GetBaglanti(), TrGenel, StokID, n11Prod.KullanilacakFiyatTanimID);
TrGenel.Commit();
dtArestekiStoklar.Rows.Add(dr);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmN11Urun_Load(object sender, EventArgs e)
{
try
{
TrGenel = SqlConnections.GetBaglanti().BeginTransaction();
Urun = new clsTablolar.n11.csN11Product(SqlConnections.GetBaglanti(), TrGenel, StokID);
TrGenel.Commit();
KategoriDoldur();
FiyatTanimlariniGetir();
Al();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
