private void MapFAQCat(IDataReader reader, FAQCategoryDomain obj)
{
int startingIndex = 0;
obj.id = reader.GetSafeInt32(startingIndex++);
obj.title = reader.GetSafeString(startingIndex++);
obj.description = reader.GetSafeString(startingIndex++);
obj.displayOrder = reader.GetSafeInt32(startingIndex++);
obj.createdBy = reader.GetSafeString(startingIndex++);
obj.createdDate = reader.GetSafeDateTime(startingIndex++);
obj.modifiedBy = reader.GetSafeString(startingIndex++);
obj.modifiedDate = reader.GetSafeDateTime(startingIndex++);
obj.ImageURL = reader.GetSafeString(startingIndex++);
}
private static FAQCategoryDomain MapFAQCategory(IDataReader reader)
{
FAQCategoryDomain f = new FAQCategoryDomain();
int startingIndex = 0;
f.id = reader.GetSafeInt32(startingIndex++);
f.title = reader.GetSafeString(startingIndex++);
f.description = reader.GetSafeString(startingIndex++);
f.displayOrder = reader.GetSafeInt32(startingIndex++);
f.createdBy = reader.GetSafeString(startingIndex++);
f.createdDate = reader.GetSafeDateTime(startingIndex++);
f.modifiedBy = reader.GetSafeString(startingIndex++);
f.modifiedDate = reader.GetSafeDateTime(startingIndex++);
f.ImageURL = reader.GetSafeString(startingIndex++);
return(f);
}
public FAQCategoryDomain SelectCat(int id)
{
FAQCategoryDomain obj = null;
List <FAQ> faqList = null;
DataProvider.ExecuteCmd(GetConnection, "FAQs_SelectCatById_V2"
, inputParamMapper : delegate(SqlParameterCollection parmas)
{
parmas.AddWithValue("@Id", id);
}
, map : delegate(IDataReader reader, short set)
{
if (set == 0)
{
obj = new FAQCategoryDomain();
MapFAQCat(reader, obj);
}
else if (set == 1)
{
FAQ f = MapFAQ(reader);
if (faqList == null)
{
faqList = new List <FAQ>();
}
faqList.Add(f);
}
});
if (obj != null)
{
obj.FAQs = faqList;
}
return(obj);
}
public List <FAQ> SelectAll()
{
List <FAQ> faqList = null;
List <FAQCategoryDomain> list = null;
//FaqId, is a list of CatId
Dictionary <int, List <int> > dict = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.FAQs_SelectAll_V2"
, inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
if (set == 0)
{
FAQ question = new FAQ();
MapFaq(reader, question);
if (faqList == null)
{
faqList = new List <FAQ>();
}
faqList.Add(question);
}
else if (set == 1)
{
FAQCategoryDomain f = MapFAQCategory(reader);
if (list == null)
{
list = new List <FAQCategoryDomain>();
}
list.Add(f);
}
else if (set == 2)
{
int catId = reader.GetSafeInt32(0);
int faqId = reader.GetSafeInt32(1);
if (dict == null)
{
dict = new Dictionary <int, List <int> >();
}
if (!dict.ContainsKey(faqId))
{
dict.Add(faqId, new List <int>());
}
List <int> myList = dict[faqId];
myList.Add(catId);
}
});
if (faqList != null && dict != null)
{
foreach (FAQ item in faqList)
{
if (!dict.ContainsKey(item.Id))
{
continue;
}
List <int> catIds = dict[item.Id];
List <FAQCategoryDomain> cats = new List <FAQCategoryDomain>();
foreach (int catId in catIds)
{
FAQCategoryDomain d = list.FirstOrDefault(c => c.id == catId);
cats.Add(d);
}
item.Categories = cats;
}
}
return(faqList);
}
