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