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")); }