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