private AnnouncementCategoryTotal MapCategoryTotal(IDataReader reader)
{
AnnouncementCategoryTotal catTotal = new AnnouncementCategoryTotal();
int ord = 0;
catTotal.CategoryTotal = reader.GetSafeInt32(ord++);
catTotal.AnnouncementCategoryId = reader.GetSafeInt32(ord++);
catTotal.CategoryName = reader.GetSafeString(ord++);
return(catTotal);
}
public AnnouncementAndCategory SelectAllAnnouncementsAndCategories()
{
List <Announcement> list = null;
List <AnnouncementCategoryTotal> ctList = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.AnnouncementAndCategory_SelectAll"
, inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
AnnouncementCategoryTotal annCatTotal = MapCategoryTotal(reader);
if (ctList == null)
{
ctList = new List <AnnouncementCategoryTotal>();
}
ctList.Add(annCatTotal);
break;
case 1:
Announcement announcement = MapAnnouncement(reader);
if (list == null)
{
list = new List <Announcement>();
}
list.Add(announcement);
break;
}
}
);
return(new AnnouncementAndCategory {
CategoriesWithTotals = ctList,
Announcements = list
});
}
