public bool SaveFAQ(Models.FAQModel model)
{
String _sql = "";
using (SqlConnection cn = new SqlConnection(connectionString))
{
model.AuthorUsername = ViewBag.Username;
model.Datetime = DateTime.Now;
int?id = model.Id;
if (id == 0)
{
_sql = "INSERT INTO [dbo].[FAQ_Table] VALUES ('"
+ model.Question + "', '" + model.Answer + "', '"
+ model.Datetime + "', '" + model.AuthorUsername + "')";
}
else
{
_sql = "UPDATE [dbo].[FAQ_Table] "
+ "SET Question = '" + model.Question
+ "', Answer = '" + model.Answer + "' WHERE Id = "
+ Convert.ToString(model.Id);
}
SqlCommand cmd = new SqlCommand(_sql, cn);
cn.Open();
cmd.ExecuteNonQuery();
}
return(true);
}
public ActionResult FAQFormView(int?id)
{
if (id == null)
{
return(View());
}
else
{
Models.FAQModel model = null;
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[FAQ_Table] WHERE Id = " + Convert.ToString(id), cn);
cn.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
model = new Models.FAQModel();
model.Id = Int32.Parse(Convert.ToString(rd.GetSqlValue(0)));
model.Question = Convert.ToString(rd.GetSqlValue(1));
model.Answer = Convert.ToString(rd.GetSqlValue(2));
model.Datetime = Convert.ToDateTime(Convert.ToString(rd.GetSqlValue(3)));
model.AuthorUsername = Convert.ToString(rd.GetSqlValue(4));
}
}
return(View(model));
}
}
public ActionResult FAQFormView(Models.FAQModel model)
{
if (SaveFAQ(model))
{
return(RedirectToAction("FAQView"));
}
return(View(model));
}
public List <Models.FAQModel> GetFAQ()
{
Models.FAQModel model = null;
List <Models.FAQModel> FAQs = new List <Models.FAQModel>();
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[FAQ_Table]", cn);
cn.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
model = new Models.FAQModel();
model.Id = Int32.Parse(Convert.ToString(rd.GetSqlValue(0)));
model.Question = Convert.ToString(rd.GetSqlValue(1));
model.Answer = Convert.ToString(rd.GetSqlValue(2));
model.Datetime = Convert.ToDateTime(Convert.ToString(rd.GetSqlValue(3)));
model.AuthorUsername = Convert.ToString(rd.GetSqlValue(4));
FAQs.Add(model);
}
}
return(FAQs);
}
