public void TestUpdate()
{
Schedule schedule = new Schedule();
schedule.EventTitle = "Test title";
schedule.EventDescription = "Description";
schedule.StartTime = "2018-01-22 22:11:32";
Assert.True(ScheduleDBConnector.Update(dataSource, schedule));
}
public IActionResult Index([FromHeader] string sendJson)
{
ViewBag.Active = "Schedule";
string sqlString = "SELECT * FROM Schedule ORDER BY datetime(StartTime)";
var eventList = ScheduleDBConnector.GetSchedules(Constants.DATA_SOURCE, sqlString);
return(sendJson != null && sendJson.Equals("True") ? Json(eventList) : (IActionResult)View(eventList));
}
public IActionResult GetSchedule([FromHeader] string sendJson, int id)
{
ViewBag.Active = "Schedule";
List <Schedule> eventList = new List <Schedule>();
eventList.Add(ScheduleDBConnector.GetSchedule(Constants.DATA_SOURCE, id));
return(sendJson != null && sendJson.Equals("True") ? Json(eventList) : (IActionResult)View("~/Views/Schedule/Index.cshtml", eventList));
}
public void TestUpdate()
{
Schedule schedule = new Schedule();
schedule.EventTitle = "Test16 title";
schedule.EventDescription = "Description";
schedule.StartTime = "2018-01-22 22:11:32";
schedule.EndTime = "2018-01-22 22:11:32";
schedule.Presenter = "prof";
schedule.Room = "Javits";
Assert.True(ScheduleDBConnector.Update(dataSource, schedule));
}
public IActionResult Index(int year, int month, int day, [FromHeader] string sendJson)
{
if (month < 1 || month > 12 || day < 1 || day > 31)
{
return(sendJson != null && sendJson.Equals("True") ? Json(new List <Schedule>()) : (IActionResult)View("Views/Schedule/Index.cshtml", null));
}
string sqlString = "SELECT * FROM Schedule WHERE Date(StartTime) = \"" + year + "-" + (month < 10 ? "0" : "") + month + "-" + (day < 10 ? "0" : "") + day + "\"";
var model = ScheduleDBConnector.GetSchedules(Constants.DATA_SOURCE, sqlString);
return(sendJson != null && sendJson.Equals("True") ? Json(model) : (IActionResult)View("Views/Schedule/Index.cshtml", model));
}
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 <Schedule> schedules = ScheduleDBConnector.GetSchedules(dataSource, "SELECT * FROM Schedule ORDER BY datetime(StartTime)");
Assert.NotNull(schedules);
int count = schedules.Count;
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));
schedules = ScheduleDBConnector.GetSchedules(dataSource, "SELECT * FROM Schedule ORDER BY datetime(StartTime)");
Assert.NotNull(schedules);
Assert.Equal(count + 1, schedules.Count);
}
public void TestRetrieveSpecific()
{
Schedule schedule = ScheduleDBConnector.GetSchedule(dataSource, 2);
Assert.NotNull(schedule);
}
public void TestRetrieveAll()
{
List <Schedule> schedules = ScheduleDBConnector.GetSchedules(dataSource, "SELECT * FROM Schedule ORDER BY datetime(StartTime)");
Assert.NotNull(schedules);
}
public IActionResult Delete(int id)
{
ScheduleDBConnector.Delete(Constants.DATA_SOURCE, id);
return(Redirect("/Schedule"));
}
public IActionResult Edit(int id)
{
return(View(ScheduleDBConnector.GetSchedule(Constants.DATA_SOURCE, id)));
}
public IActionResult Edit(Schedule schedule, int id)
{
ScheduleDBConnector.Update(Constants.DATA_SOURCE, schedule);
return(Redirect("/Schedule"));
}
public IActionResult Add(Schedule schedule)
{
ScheduleDBConnector.Create(Constants.DATA_SOURCE, schedule);
return(Redirect("/Schedule"));
}
