public string UpdateViewCount(int FAQID,int usermoduleID,int portalID) { string question = string.Empty; int count = 0; try { FAQsDataContext dbFAQ = new FAQsDataContext(SystemSetting.SageFrameConnectionString); var FAQs = dbFAQ.sp_FAQsViewCountUpdate(FAQID, true, portalID); foreach (sp_FAQsViewCountUpdateResult faq in FAQs) { count = faq.ViewCount; } BaseUserControl suc = new BaseUserControl(); var faqAll = dbFAQ.sp_GetFAQWithTemplate(usermoduleID, true, true, portalID, suc.GetUsername); foreach (sp_GetFAQWithTemplateResult faqs in faqAll) { if (FAQID == (int)faqs.FAQID) { question = faqs.QUESTION; } } } catch (Exception ex) { throw ex; } return question; }
public BaseBOLFAQs() { dataContext = new FAQsDataContext(); }