public Soru FillSoru(IDataReader reader) { nesne = new Soru(); nesne.Id=(Int32)reader["ID"]; nesne.SoruMetni=(String)reader["SORU_METNI"]; nesne.SecenekTip=(Int32)reader["SECENEK_TIP"]; return nesne; }
public int Delete(int id,DbTransaction dbTransaction,Database db) { sqlText="DELETE SORU where ID=@id "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@id", DbType.Int32, id); Soru nesne = new Soru(); nesne.Id = id; return base.Delete(nesne, dbComm, dbTransaction, db); }
public int DeleteBySecenekTip(Int32 secenekTip,DbTransaction dbTransaction,Database db) { sqlText="DELETE SORU where SECENEK_TIP=@secenekTip "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@secenekTip", DbType.Int32, secenekTip); Soru nesne=new Soru(); nesne.Id=-1; nesne.SecenekTip=secenekTip; return base.Delete(nesne, dbComm, dbTransaction, db); }
public int Update(Soru nesne,DbTransaction dbTransaction,Database db) { sqlText=" UPDATE SORU set SORU_METNI = @soruMetni , SECENEK_TIP = @secenekTip WHERE ID = @id "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@id", DbType.Int32, nesne.Id==null?(object)DBNull.Value:nesne.Id); db.AddInParameter(dbComm, "@soruMetni", DbType.String, nesne.SoruMetni==null?(object)DBNull.Value:nesne.SoruMetni); db.AddInParameter(dbComm, "@secenekTip", DbType.Int32, nesne.SecenekTip==null?(object)DBNull.Value:nesne.SecenekTip); return base.Update(nesne, dbComm, dbTransaction, db); }
public int Insert(Soru nesne,DbTransaction dbTransaction,Database db) { sqlText="INSERT INTO SORU (SORU_METNI,SECENEK_TIP)VALUES(@soruMetni,@secenekTip)SELECT @@IDENTITY"; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@soruMetni", DbType.String, nesne.SoruMetni==null?(object)DBNull.Value:nesne.SoruMetni); db.AddInParameter(dbComm, "@secenekTip", DbType.Int32, nesne.SecenekTip==null?(object)DBNull.Value:nesne.SecenekTip); return base.Insert(nesne, dbComm, dbTransaction, db); }
public Soru GetById(int id,Database db) { nesne = new Soru(); sqlText="Select ID,SORU_METNI,SECENEK_TIP from SORU where ID=@id "; dbComm = db.GetSqlStringCommand(sqlText); db.AddInParameter(dbComm, "@id", DbType.Int32, id); using (IDataReader reader = db.ExecuteReader(dbComm)){ if(reader.Read()){ nesne = FillSoru(reader); }else nesne=null; } return nesne; }