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