public IActionResult Create([FromBody] BWQEntities newmodel) { if (ModelState.IsValid) { _context.BWQEntities.Add(newmodel); _context.SaveChanges(); return(CreatedAtRoute("GetBWQEntities", new { id = newmodel.BWQEntitiesID }, newmodel)); } else { return(BadRequest()); } }
public IActionResult UpdateEntry([FromBody] BWQEntities objupd) { var targetObject = _context.BWQEntities.FirstOrDefault(t => t.BWQEntitiesID == objupd.BWQEntitiesID); if (targetObject == null) { return(NotFound()); } _context.Entry(targetObject).CurrentValues.SetValues(objupd); ReturnData ret; ret = _context.SaveData(); if (ret.Message == "Success") { return(Ok()); } return(NotFound(ret)); }
public void BWQEntities() { //ILogger<BWQEntitiesController> _testlogger = null; using (var context = new AppDbContext(options, null)) { var controller = new BWQEntitiesController(context, null, null, null); // Get all var result = controller.Get(); // Assert var okResult = Assert.IsAssignableFrom <IEnumerable <BWQEntities> >(result); var pgcount = okResult.ToList().Count; Assert.Equal(2, pgcount); // Get by ID var result1 = controller.Get(1); var okResult1 = Assert.IsAssignableFrom <BWQEntities>(result1); //var thisresult1 = okResult1.FirstOrDefault(); Assert.Equal("bwqentity type 1", result1.EntityName); // test update var pg1 = new BWQEntities { BWQEntitiesID = 1, BWQID = 1, EntityName = "bwqentity type 1 upd" }; controller.UpdateEntry(pg1); var result3 = controller.Get(1); //var thisresult3 = result3.FirstOrDefault(); Assert.NotEqual("bwqentity type 1", result3.EntityName); Assert.Equal("bwqentity type 1 upd", result3.EntityName); // test delete var result4 = controller.Get(2); //var thisresult4 = result4.FirstOrDefault(); Assert.Equal("bwqentity type 2", result4.EntityName); IActionResult result5 = controller.Delete(2); var viewResult = Assert.IsType <Microsoft.AspNetCore.Mvc.OkResult>(result5); var result6 = controller.Get(2); Assert.Null(result6); } }
internal void PopulateData() { using (var context = new AppDbContext(options, null)) { if (context.Collection.Count() < 1) { var p1 = new Collection { CollectionID = 1, CollectionName = "collection type 1", }; var p2 = new Collection { CollectionID = 2, CollectionName = "collection type 2", }; context.Collection.Add(p1); context.Collection.Add(p2); context.SaveChanges(); } if (context.CollectionItem.Count() < 1) { var p1 = new CollectionItem { CollectionItemID = 1, CollectionID = 1, ItemText = "collectionitem type 1", }; var p2 = new CollectionItem { CollectionItemID = 2, CollectionID = 1, ItemText = "collectionitem type 2", }; context.CollectionItem.Add(p1); context.CollectionItem.Add(p2); if (context.Collection.Count() < 1) { var p3 = new Collection { CollectionID = 1, CollectionName = "collection type 1", }; } context.SaveChanges(); } if (context.BWQStatusType.Count() < 1) { var p1 = new BWQStatusType { BWQStatusTypeID = 1, BwqStatusTypeDescription = "bwqstatus type 1", }; var p2 = new BWQStatusType { BWQStatusTypeID = 2, BwqStatusTypeDescription = "bwqstatus type 2", }; context.BWQStatusType.Add(p1); context.BWQStatusType.Add(p2); context.SaveChanges(); } if (context.BWQFieldSelect.Count() < 1) { var p1 = new BWQFieldSelect { BWQFieldSelectID = 1, FieldDisplayName = "fieldselect type 1", }; var p2 = new BWQFieldSelect { BWQFieldSelectID = 2, FieldDisplayName = "fieldselect type 2", }; context.BWQFieldSelect.Add(p1); context.BWQFieldSelect.Add(p2); context.SaveChanges(); } if (context.BWQDispositions.Count() < 1) { var p1 = new BWQDispositions { BWQDispositionsID = 1, BWQDispositionsDescription = "bwqdisposition type 1", }; var p2 = new BWQDispositions { BWQDispositionsID = 2, BWQDispositionsDescription = "bwqdisposition type 2", }; context.BWQDispositions.Add(p1); context.BWQDispositions.Add(p2); context.SaveChanges(); } if (context.BWQEntities.Count() < 1) { var p1 = new BWQEntities { BWQEntitiesID = 1, BWQID = 1, EntityName = "bwqentity type 1", }; var p2 = new BWQEntities { BWQEntitiesID = 2, BWQID = 1, EntityName = "bwqentity type 2", }; context.BWQEntities.Add(p1); context.BWQEntities.Add(p2); if (context.BWQ.Count() < 1) { var p3 = new BWQ { BWQID = 1, BatchName = "bwqbatch 1", }; } context.SaveChanges(); } if (context.BWQ.Count() < 1) { var p1 = new BWQ { BWQID = 1, BatchName = "bwqbatch 1", }; var p2 = new BWQ { BWQID = 2, BatchName = "bwqbatch 2", }; context.BWQ.Add(p1); context.BWQ.Add(p2); context.SaveChanges(); } if (context.BWQInstructions.Count() < 1) { var p1 = new BWQInstructions { BWQInstructionsID = 1, BWQEntitiesID = 1, BWQDispositionsID = 1, BWQFieldSelectID = 1, Instructions = "Instructions 1" }; var p2 = new BWQInstructions { BWQInstructionsID = 2, BWQEntitiesID = 1, BWQDispositionsID = 1, BWQFieldSelectID = 1, Instructions = "Instructions 2" }; context.BWQInstructions.Add(p1); context.BWQInstructions.Add(p2); if (context.BWQEntities.Count() < 1) { var p3 = new BWQEntities { BWQEntitiesID = 1, BWQID = 1, EntityName = "bwqentity type 1", }; context.BWQEntities.Add(p3); } if (context.BWQDispositions.Count() < 1) { var p4 = new BWQDispositions { BWQDispositionsID = 1, BWQDispositionsDescription = "bwqdisposition type 1", }; context.BWQDispositions.Add(p4); } if (context.BWQFieldSelect.Count() < 1) { var p5 = new BWQFieldSelect { BWQFieldSelectID = 1, FieldDisplayName = "fieldselect type 1", }; context.BWQFieldSelect.Add(p5); } context.SaveChanges(); } } }
public IActionResult Update([FromBody] BWQEntities editentry) { BWQEntities result = _repository.Update(editentry, editentry.BWQEntitiesID); return(Helper.CheckResult(result)); }
public IActionResult Create([FromBody] BWQEntities newentry) { BWQEntities result = _repository.Add(newentry); return(Helper.CheckResult(result)); }
public IActionResult Get(int id) { BWQEntities data = _repository.GetIdIncluding(id); return(Helper.CheckResult(data)); }