public int EkleUrunStokIslemi(TBLSTOKISLEMLERI ptStokIslemleri)
{
try
{
DbCommand dbcommand = db.GetSqlStringCommand("INSERT INTO TBLSTOKISLEMLERI(URUNID,MIKTAR,ISLEMTIPI,REFERANSID,OLUSMA_ZAMANI) VALUES(@URUNID, @MIKTAR, @ISLEMTIPI, @REFERANSID, @OLUSMA_ZAMANI) SELECT @@IDENTITY");
db.AddInParameter(dbcommand, "URUNID", DbType.Int32, ptStokIslemleri.URUNID);
db.AddInParameter(dbcommand, "MIKTAR", DbType.Decimal, ptStokIslemleri.MIKTAR);
db.AddInParameter(dbcommand, "ISLEMTIPI", DbType.Int16, (short)ptStokIslemleri.ISLEMTIPI);
db.AddInParameter(dbcommand, "REFERANSID", DbType.Double, ptStokIslemleri.REFERANSID);
db.AddInParameter(dbcommand, "OLUSMA_ZAMANI", DbType.DateTime, DateTime.Now);
return(db.ExecuteScalar(dbcommand).ToInt(0));
}
catch (Exception ex)
{
cLog.Write(ex, _iKullaniciID);
return(0);
}
}
public short DuzenleStokIslemi(TBLSTOKISLEMLERI ptStokIslemleri)
{
try
{
DbCommand dbcommand = db.GetSqlStringCommand("UPDATE TBLSTOKISLEMLERI SET URUNID=@URUNID, MIKTAR=@MIKTAR, ISLEMTIPI=@ISLEMTIPI,REFERANSID=@REFERANSID WHERE ID=@ID");
db.AddInParameter(dbcommand, "ID", DbType.Int64, ptStokIslemleri.ID);
db.AddInParameter(dbcommand, "URUNID", DbType.Int32, ptStokIslemleri.URUNID);
db.AddInParameter(dbcommand, "MIKTAR", DbType.Decimal, ptStokIslemleri.MIKTAR);
db.AddInParameter(dbcommand, "ISLEMTIPI", DbType.Int16, (short)ptStokIslemleri.ISLEMTIPI);
db.AddInParameter(dbcommand, "REFERANSID", DbType.Double, ptStokIslemleri.REFERANSID);
db.ExecuteNonQuery(dbcommand);
return(1);
}
catch (Exception ex)
{
cLog.Write(ex, _iKullaniciID);
return(0);
}
}