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