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