public QnaInfo GetDataById(int q_id)
{
QnaInfo info = new QnaInfo();
IDataReader reader = db.GetDataById(q_id).CreateDataReader();
if (reader.Read())
{
info = QnaInfo.Populate(reader);
}
return(info);
}
public List <QnaInfo> GetDataBySorting(int sorting)
{
List <QnaInfo> infos = new List <QnaInfo>();
IDataReader reader = db.GetDataBySorting(sorting).CreateDataReader();
while (reader.Read())
{
infos.Add(QnaInfo.Populate(reader));
}
return(infos);
}
public int InsertSorting()
{
QnaInfo info = new QnaInfo();
IDataReader reader = db.InsertSorting().CreateDataReader();
if (reader.Read())
{
info = QnaInfo.Populate(reader);
return(info.q_sort + 1);
}
return(1);
}