public string FaqSave(Faq_model faq)
{
string status = "failed";
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "tmpprcpostfaq";
cmd.Parameters.AddWithValue("@question", faq.questions);
cmd.Parameters.AddWithValue("@answer", faq.answer);
cmd.ExecuteNonQuery();
}
status = "saved";
}
catch (Exception ex)
{
status = ex.Message;
}
return(status);
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
string status = "";
Services.Post_Service postService = new Services.Post_Service();
if (ModelState.IsValid)
{
Faq_model model = new Faq_model();
model.answer = Request.Form["answer"].ToString();
model.questions = Request.Form["query"].ToString();
status = postService.FaqSave(model);
}
else
{
status = "PostDataError";
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public Faq_model_list FaqGetAll()
{
string status = "failed";
Faq_model_list list = new Faq_model_list();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
DataSet ds = new DataSet();
con.Open();
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmpprcgetfaq");
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow dr in dt.Rows)
{
Faq_model obj = new Faq_model();
if (!string.IsNullOrEmpty(dr["question"].ToString()))
{
obj.questions = dr["question"].ToString();
}
else
{
obj.questions = "";
}
if (!string.IsNullOrEmpty(dr["answer"].ToString()))
{
obj.answer = dr["answer"].ToString();
}
else
{
obj.answer = "";
}
list.list.Add(obj);
}
}
}
list.message = "fetched";
}
catch (Exception ex)
{
list.message = ex.Message;
}
return(list);
}
