//QUESTIONS CRUD FUNCTIONS
public static void CreateFAQQuestion(FAQQuestions m_FAQQuestion)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
int sortOrder = getSortOrder(m_FAQQuestion.FaqID);
string queryString = "INSERT INTO CMS_FAQQuestions(faqID, faqQuestion, faqAnswer, sortOrder) VALUES(@faqID, @faqQuestion, @faqAnswer, @sortOrder)";
SqlCommand insertFAQQuestion = new SqlCommand(queryString, conn);
insertFAQQuestion.Parameters.AddWithValue("faqID", m_FAQQuestion.FaqID);
insertFAQQuestion.Parameters.AddWithValue("faqQuestion", m_FAQQuestion.FaqQuestion);
insertFAQQuestion.Parameters.AddWithValue("faqAnswer", m_FAQQuestion.FaqAnswer);
insertFAQQuestion.Parameters.AddWithValue("sortOrder", sortOrder);
insertFAQQuestion.ExecuteNonQuery();
conn.Close();
}
public bool UpdateFAQQuestion(FAQQuestions m_FAQQuestion)
{
DBFAQ.UpdateFAQQuestion(m_FAQQuestion);
return true;
}
public bool CreateFAQQuestion(FAQQuestions m_FAQQuestion)
{
DBFAQ.CreateFAQQuestion(m_FAQQuestion);
return true;
}
public static void UpdateFAQQuestion(FAQQuestions m_FAQQuestion)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "UPDATE CMS_FAQQuestions SET faqID = @faqID, faqQuestion = @faqQuestion, faqAnswer = @faqAnswer WHERE id = @id";
SqlCommand updateFAQQuestion = new SqlCommand(queryString, conn);
updateFAQQuestion.Parameters.AddWithValue("faqID", m_FAQQuestion.FaqID);
updateFAQQuestion.Parameters.AddWithValue("faqQuestion", m_FAQQuestion.FaqQuestion);
updateFAQQuestion.Parameters.AddWithValue("faqAnswer", m_FAQQuestion.FaqAnswer);
updateFAQQuestion.Parameters.AddWithValue("id", m_FAQQuestion.QID);
updateFAQQuestion.ExecuteNonQuery();
conn.Close();
}
public static FAQQuestions RetrieveOneFAQQuestion(int m_FaqQuestionID)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_FAQQuestions WHERE id = @id AND pageWorkFlowState != 4";
SqlCommand getFAQQuestion = new SqlCommand(queryString, conn);
getFAQQuestion.Parameters.AddWithValue("id", m_FaqQuestionID);
SqlDataReader myFAQQuestion = getFAQQuestion.ExecuteReader();
FAQQuestions tempQuestion = new FAQQuestions();
if (myFAQQuestion.Read())
{
tempQuestion.QID = myFAQQuestion.GetInt32(0);
tempQuestion.FaqID = myFAQQuestion.GetInt32(1);
tempQuestion.FaqQuestion = myFAQQuestion.GetString(2);
tempQuestion.FaqAnswer = myFAQQuestion.GetString(3);
tempQuestion.PageWorkFlowState = myFAQQuestion.GetInt32(4);
tempQuestion.SortOrder = myFAQQuestion.GetInt32(5);
}
conn.Close();
return tempQuestion;
}
public static List<FAQQuestions> RetrieveAllFAQQuestions(int m_FaqID)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_FAQQuestions WHERE faqID = @faqID AND pageWorkFlowState != 4 ORDER BY sortOrder";
SqlCommand getFAQQuestions = new SqlCommand(queryString, conn);
getFAQQuestions.Parameters.AddWithValue("faqID", m_FaqID);
SqlDataReader myFAQQuestions = getFAQQuestions.ExecuteReader();
List<FAQQuestions> m_FAQs = new List<FAQQuestions>();
while (myFAQQuestions.Read())
{
FAQQuestions tempFAQQuestion = new FAQQuestions();
tempFAQQuestion.QID = myFAQQuestions.GetInt32(0);
tempFAQQuestion.FaqID = myFAQQuestions.GetInt32(1);
tempFAQQuestion.FaqQuestion = myFAQQuestions.GetString(2);
tempFAQQuestion.FaqAnswer = myFAQQuestions.GetString(3);
m_FAQs.Add(tempFAQQuestion);
}
conn.Close();
return m_FAQs;
}
public ActionResult FAQQuestionEdit(FAQQuestions m_FAQQuestion)
{
if (ModelState.IsValid)
{
FAQRepository.UpdateFAQQuestion(m_FAQQuestion);
return RedirectToAction("FAQQuestions", "FAQ", new { id = m_FAQQuestion.FaqID });
}
else
{
return View("FAQQuestionEdit", m_FAQQuestion);
}
}
public ActionResult FAQQuestionAdd(FAQQuestions myQuestion)
{
if (ModelState.IsValid)
{
FAQRepository.CreateFAQQuestion(myQuestion);
return RedirectToAction("FAQQuestions", "FAQ", new { id = myQuestion.FaqID });
}
else
{
ViewBag.FAQID = myQuestion.FaqID;
return View("FAQQuestionAdd", myQuestion);
}
}
public ActionResult FAQQuestionAdd(string id)
{
int FaqID = int.Parse(id);
ViewBag.FAQID = FaqID;
FAQQuestions myQuestion = new FAQQuestions();
return View("FAQQuestionAdd", myQuestion);
}