public void TestUpdate() { Resource resource = new Resource(); resource.Description = "Test"; resource.Link = "some link"; resource.Title = "Test Resource"; resource.ProviderName = "Unit Test"; Assert.True(ResourceDBConnector.Update(dataSource, resource)); }
public IActionResult Index([FromHeader] string sendJson, int?id) { ViewBag.Active = "Resources"; string sqlString = "SELECT * FROM Resource"; if (id.HasValue) { sqlString += " WHERE Id = " + id.Value; var model = ResourceDBConnector.GetResources(Constants.DATA_SOURCE, sqlString); var singleEvent = model.Count > 0 ? model.First() : new Resource(); return(sendJson != null && sendJson.Equals("True") ? Json(singleEvent) : (IActionResult)View(singleEvent)); } var eventList = ResourceDBConnector.GetResources(Constants.DATA_SOURCE, sqlString); return(sendJson != null && sendJson.Equals("True") ? Json(eventList) : (IActionResult)View(eventList)); }
public void TestInsert() { List <Resource> resources = ResourceDBConnector.GetResources(dataSource, "SELECT * FROM Resource"); Assert.NotNull(resources); int count = resources.Count; Resource resource = new Resource(); resource.Description = "Test"; resource.Link = "some link"; resource.Title = "Test Resource"; resource.ProviderName = "Unit Test"; Assert.True(ResourceDBConnector.Create(dataSource, resource)); resources = ResourceDBConnector.GetResources(dataSource, "SELECT * FROM Resource"); Assert.NotNull(resources); Assert.Equal(count + 1, resources.Count); }
public void TestRetrieveSpecific() { Resource resource = ResourceDBConnector.GetResource(dataSource, 2); Assert.NotNull(resource); }
public void TestRetrieveAll() { List <Resource> resources = ResourceDBConnector.GetResources(dataSource, "SELECT * FROM Resource"); Assert.NotNull(resources); }
public IActionResult Delete(int id) { ResourceDBConnector.Delete(Constants.DATA_SOURCE, id); return(Redirect("/Resources")); }
public IActionResult Edit(int id) { return(View(ResourceDBConnector.GetResource(Constants.DATA_SOURCE, id))); }
public IActionResult Edit(Resource resource, int id) { ResourceDBConnector.Update(Constants.DATA_SOURCE, resource); return(Redirect("/Resources")); }
public IActionResult Add(Resource resource) { ResourceDBConnector.Create(Constants.DATA_SOURCE, resource); return(Redirect("/Resources")); }