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