//------------------------------------------------------------------------------------------------------------------------------------------
public List <DTO.CategoryDTO> SelectAllCategoryByDataReader()
{
List <DTO.CategoryDTO> list = new List <DTO.CategoryDTO>();
string strCmd = "select_all_category";
SqlDataReader rd = _DataProvicer.ExecuteQueryWithDataReader(strCmd, CommandType.StoredProcedure);
if (rd.HasRows)
{
while (rd.Read())
{
DTO.CategoryDTO dto = new DTO.CategoryDTO
{
CategoryID = rd.GetString(0),
CategoryName = rd.GetString(1),
};
list.Add(dto);
}
}
return(list);
}