public IActionResult Add(Faq faq)
{
FaqDBConnector.Create(Constants.DATA_SOURCE, faq);
//ViewBag.Text = "World";
//return View();
return(Redirect("/Faq"));
}
public IActionResult Index([FromHeader] string sendJson)
{
ViewBag.Active = "Faq";
var model = FaqDBConnector.GetFaqs(Constants.DATA_SOURCE);
return(sendJson != null && sendJson.Equals("True") ? Json(model) : (IActionResult)View(model));
}
public void TestUpdate()
{
Faq faq = new Faq();
faq.Question = "Test Question";
faq.Answer = "Test Modified Answer";
Assert.True(FaqDBConnector.Update(dataSource, faq));
}
public void TestDelete()
{
Video video = new Video();
video.Title = "Test";
video.Url = "www.google.com";
Assert.True(VideoDBConnector.Create(dataSource, video));
Assert.True(FaqDBConnector.Delete(dataSource, 1));
}
public void TestDelete()
{
Schedule schedule = new Schedule();
schedule.EventTitle = "Test title";
schedule.EventDescription = "Description";
schedule.StartTime = "2018-01-22 22:11:32";
Assert.True(ScheduleDBConnector.Create(dataSource, schedule));
List <Schedule> schedules = ScheduleDBConnector.GetSchedules(dataSource, "SELECT * FROM Schedule ORDER BY datetime(StartTime)");
Assert.NotNull(schedules);
Assert.True(FaqDBConnector.Delete(dataSource, (int)schedules[0].Id));
}
public void TestInsert()
{
List <Faq> faqs = FaqDBConnector.GetFaqs(dataSource);
Assert.NotNull(faqs);
int count = faqs.Count;
Faq faq = new Faq();
faq.Question = "Test Question";
faq.Answer = "Test Answer";
Assert.True(FaqDBConnector.Create(dataSource, faq));
faqs = FaqDBConnector.GetFaqs(dataSource);
Assert.NotNull(faqs);
Assert.Equal(count + 1, faqs.Count);
}
public void TestDelete()
{
Faq faq = new Faq();
faq.Question = "Test Question";
faq.Answer = "Test Answer";
Assert.True(FaqDBConnector.Create(dataSource, faq));
List <Faq> faqs = FaqDBConnector.GetFaqs(dataSource);
Assert.NotNull(faqs);
int count = faqs.Count;
Assert.True(FaqDBConnector.Delete(dataSource, (int)faqs[0].Id));
faqs = FaqDBConnector.GetFaqs(dataSource);
Assert.NotNull(faqs);
Assert.Equal(count - 1, faqs.Count);
}
public IActionResult Delete(int id)
{
FaqDBConnector.Delete(Constants.DATA_SOURCE, id);
return(Redirect("/Faq"));
}
public IActionResult Edit(int id)
{
return(View(FaqDBConnector.GetFaq(Constants.DATA_SOURCE, id)));
}
public IActionResult Edit(Faq faq, int id)
{
FaqDBConnector.Update(Constants.DATA_SOURCE, faq);
return(Redirect("/Faq"));
}
public IActionResult Add(Faq faq)
{
FaqDBConnector.Create(Constants.DATA_SOURCE, faq);
return(Redirect("/Faq"));
}
public void TestRetrieveSpecific()
{
Faq faq = FaqDBConnector.GetFaq(dataSource, 2);
Assert.NotNull(faq);
}
public void TestRetrieveAll()
{
List <Faq> faqs = FaqDBConnector.GetFaqs(dataSource);
Assert.NotNull(faqs);
}
