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); } }