public int EkleUrunOzellik(TBLURUN_OZELLIKLERI ptUrunOzellik)
{
try
{
DbCommand dbcommand = db.GetSqlStringCommand("INSERT INTO TBLURUN_OZELLIKLERI(URUNID,OZELLIKID,DEGER) VALUES(@URUNID,@OZELLIKID,@DEGER) SELECT @@IDENTITY");
db.AddInParameter(dbcommand, "URUNID", DbType.Int32, ptUrunOzellik.URUNID);
db.AddInParameter(dbcommand, "OZELLIKID", DbType.Int32, ptUrunOzellik.OZELLIKID);
db.AddInParameter(dbcommand, "DEGER", DbType.String, ptUrunOzellik.DEGER);
return(db.ExecuteScalar(dbcommand).ToInt(0));
}
catch (Exception ex)
{
cLog.Write(ex, _iKullaniciID);
return(0);
}
}
public short DuzenleUrunOzellik(TBLURUN_OZELLIKLERI ptUrunOzellik)
{
try
{
DbCommand dbcommand = db.GetSqlStringCommand("UPDATE TBLURUN_OZELLIKLERI SET URUNID=@URUNID, OZELLIKID=@OZELLIKID, DEGER=@DEGER WHERE ID=@ID");
db.AddInParameter(dbcommand, "ID", DbType.Int32, ptUrunOzellik.ID);
db.AddInParameter(dbcommand, "URUNID", DbType.Int32, ptUrunOzellik.URUNID);
db.AddInParameter(dbcommand, "OZELLIKID", DbType.Int32, ptUrunOzellik.OZELLIKID);
db.AddInParameter(dbcommand, "DEGER", DbType.String, ptUrunOzellik.DEGER);
db.ExecuteNonQuery(dbcommand);
return(1);
}
catch (Exception ex)
{
cLog.Write(ex, _iKullaniciID);
return(0);
}
}