public AnketSoruAratablo FillAnketSoruAratablo(IDataReader reader) { nesne = new AnketSoruAratablo(); nesne.AnketId=(Int32)reader["ANKET_ID"]; nesne.SoruId=(Int32)reader["SORU_ID"]; return nesne; }
public int Delete(int anketId,DbTransaction dbTransaction,Database db) { sqlText="DELETE ANKET_SORU_ARATABLO where ANKET_ID=@anketId "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@anketId", DbType.Int32, anketId); AnketSoruAratablo nesne = new AnketSoruAratablo(); nesne.AnketId = anketId; return base.Delete(nesne, dbComm, dbTransaction, db); }
public int Insert(AnketSoruAratablo nesne,DbTransaction dbTransaction,Database db) { sqlText="INSERT INTO ANKET_SORU_ARATABLO (ANKET_ID,SORU_ID)VALUES(@anketId,@soruId)SELECT @@IDENTITY"; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@anketId", DbType.Int32, nesne.AnketId==null?(object)DBNull.Value:nesne.AnketId); db.AddInParameter(dbComm, "@soruId", DbType.Int32, nesne.SoruId==null?(object)DBNull.Value:nesne.SoruId); return base.Insert(nesne, dbComm, dbTransaction, db); }
public int Update(AnketSoruAratablo nesne,DbTransaction dbTransaction,Database db) { sqlText=" UPDATE ANKET_SORU_ARATABLO set SORU_ID = @soruId WHERE ANKET_ID = @anketId "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@anketId", DbType.Int32, nesne.AnketId==null?(object)DBNull.Value:nesne.AnketId); db.AddInParameter(dbComm, "@soruId", DbType.Int32, nesne.SoruId==null?(object)DBNull.Value:nesne.SoruId); return base.Update(nesne, dbComm, dbTransaction, db); }
public AnketSoruAratablo GetById(int anketId,Database db) { nesne = new AnketSoruAratablo(); sqlText="Select ANKET_ID,SORU_ID from ANKET_SORU_ARATABLO where ANKET_ID=@anketId "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@anketId", DbType.Int32, anketId); using (IDataReader reader = db.ExecuteReader(dbComm)){ if(reader.Read()){ nesne = FillAnketSoruAratablo(reader); }else nesne=null; } return nesne; }