public ForumDTO GetById(int id)
{
try
{
string sql = "SELECT * FROM Forum WHERE ID = @ID";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("ID", id.ToString()),
};
DataSet results = ExecuteSql(sql, parameters);
ForumDTO dto = DataSetParser.DataSetToForum(results, 0);
return(dto);
}
catch (Exception e)
{
throw e;
}
}
public List <ForumDTO> GetAll()
{
List <ForumDTO> forums = new List <ForumDTO>();
try
{
string sql = "SELECT * FROM Forum";
DataSet results = ExecuteSql(sql, new List <KeyValuePair <string, string> >());
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
ForumDTO dto = DataSetParser.DataSetToForum(results, x);
forums.Add(dto);
}
return(forums);
}
catch (Exception e)
{
throw e;
}
}
