public void DataNotFound() { DbContextOptions <Context> options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "not_fount") .Options; // Insert seed data into the database using one instance of the context using (Context context = new Context(options)) { context.OilFields.Add(new OilField { ID = 1, Location = "test1", Name = "test1", NumOfEmployees = 0, NumOfPumpjacks = 1, Production = 5 }); context.OilFields.Add(new OilField { ID = 2, Location = "test2", Name = "test21", NumOfEmployees = 2, NumOfPumpjacks = 2, Production = 5 }); context.OilFields.Add(new OilField { ID = 3, Location = "test3", Name = "test3", NumOfEmployees = 444, NumOfPumpjacks = 444, Production = 444 }); context.SaveChanges(); } // Use a clean instance of the context to run the test using (Context context = new Context(options)) { OilFieldController service = new OilFieldController(context); IActionResult result = service.Get(66); NotFoundResult res = result as NotFoundResult; Assert.AreEqual(404, res.StatusCode); } }
public void GetListOnPage() { DbContextOptions <Context> options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "on_page") .Options; // Insert seed data into the database using one instance of the context using (Context context = new Context(options)) { context.OilFields.Add(new OilField { ID = 1, Location = "test1", Name = "test1", NumOfEmployees = 0, NumOfPumpjacks = 1, Production = 5 }); context.OilFields.Add(new OilField { ID = 2, Location = "test2", Name = "test21", NumOfEmployees = 2, NumOfPumpjacks = 2, Production = 5 }); context.OilFields.Add(new OilField { ID = 3, Location = "test3", Name = "test3", NumOfEmployees = 444, NumOfPumpjacks = 444, Production = 444 }); context.SaveChanges(); } // Use a clean instance of the context to run the test using (Context context = new Context(options)) { OilFieldController service = new OilFieldController(context); IActionResult result = service.Get("2", null).Result; OkObjectResult res = result as OkObjectResult; Assert.AreEqual(200, res.StatusCode); Assert.IsNotNull(res.Value); } }
public void CreateData() { DbContextOptions <Context> options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "post") .Options; using (Context context = new Context(options)) { OilFieldController service = new OilFieldController(context); IActionResult result = service.Get(1); NotFoundResult resNo = result as NotFoundResult; Assert.AreEqual(404, resNo.StatusCode); result = service.Post(new OilField { Location = "test1", Name = "test1", NumOfEmployees = 0, NumOfPumpjacks = 1, Production = 5 }); OkObjectResult res = result as OkObjectResult; Assert.AreEqual(200, res.StatusCode); OilField val = (OilField)res.Value; Assert.AreEqual(1, val.ID); } }
public void UpdateData() { DbContextOptions <Context> options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "put") .Options; using (Context context = new Context(options)) { context.OilFields.Add(new OilField { ID = 1, Location = "test1", Name = "test1", NumOfEmployees = 0, NumOfPumpjacks = 1, Production = 5 }); context.SaveChanges(); } using (Context context = new Context(options)) { OilFieldController service = new OilFieldController(context); IActionResult result = service.Put(1, new OilField { ID = 1, Location = "test2", Name = "test2", NumOfEmployees = 0, NumOfPumpjacks = 1, Production = 5 }); context.SaveChanges(); OkObjectResult res = result as OkObjectResult; Assert.AreEqual(200, res.StatusCode); result = service.Get(1); res = result as OkObjectResult; Assert.AreEqual(200, res.StatusCode); OilField val = (OilField)res.Value; Assert.AreEqual("test2", val.Name); } }