/// <summary>
/// Fetches all.
/// </summary>
/// <returns></returns>
public static FAQ[] FetchAll(int categoryId)
{
string cacheKey = String.Format("FAQ_FetchAll_{0}",categoryId);
if(HttpContext.Current != null && HttpContext.Current.Cache[cacheKey] != null) {
//return HttpContext.Current.Cache[cacheKey] as FAQ[];
}
//using (var conn = Config.DB.Open())
{
List<FAQ> lQuestions = new List<FAQ>();
using (var reader = SqlHelper.GetDB().ExecuteReader("FetchFAQs", categoryId))
{
while (reader.Read())
{
FAQ aQuestion = new FAQ();
aQuestion.id = (int) reader["Id"];
aQuestion.name = (string) reader["Name"];
aQuestion.active = (bool) reader["Active"];
aQuestion.question = (string) reader["QuestionDisplay"];
aQuestion.answer = (string) reader["AnswerDisplay"];
aQuestion.categoryId = (int) reader["CategoryId"];
aQuestion.order = (int) reader["OrderId"];
lQuestions.Add(aQuestion);
}
reader.Close();
}
FAQ[] questions = lQuestions.ToArray();
if(HttpContext.Current != null) {
//Global.AddCacheItem("FAQs", cacheKey, questions);
HttpContext.Current.Cache.Insert(cacheKey, questions, null, DateTime.Now.AddMinutes(30),
Cache.NoSlidingExpiration, CacheItemPriority.NotRemovable, null);
}
return questions;
}
}
private static FAQ[] Fetch(int id, string name)
{
List<FAQ> lFAQ = new List<FAQ>();
//using (var conn = Config.DB.Open())
{
using (var reader = SqlHelper.GetDB().ExecuteReader("FetchFAQ", id, name))
{
while (reader.Read())
{
FAQ aQuestion = new FAQ();
aQuestion.id = (int) reader["Id"];
aQuestion.name = (string) reader["Name"];
aQuestion.question = (string) reader["QuestionDisplay"];
aQuestion.answer = (string) reader["AnswerDisplay"];
aQuestion.active = (bool) reader["Active"];
aQuestion.categoryId = (int) reader["CategoryId"];
aQuestion.order = (int) reader["OrderId"];
lFAQ.Add(aQuestion);
}
reader.Close();
}
}
return lFAQ.ToArray();
}
/// <summary>
/// Creates the specified name.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="active">if set to <c>true</c> [active].</param>
/// <returns></returns>
public static FAQ Create(string name,string question, string answer, bool active, int categoryId)
{
FAQ newQuestion = new FAQ();
newQuestion.id = -1;
newQuestion.categoryId = categoryId;
newQuestion.name = name;
newQuestion.QuestionDisplay = question;
newQuestion.AnswerDisplay = answer;
newQuestion.active = active;
return newQuestion;
}
