public void BWQ()
{
ILogger <BWQController> _testlogger = null;
using (var context = new AppDbContext(options, null))
{
var controller = new BWQController(context, _testlogger, null);
// Get all
var result = controller.Get();
// Assert
var okResult = Assert.IsAssignableFrom <JsonResult>(result);
//JObject jObj = (JObject)JsonConvert.DeserializeObject(result.ToString());
//int bwqcount = jObj.Count;
//var pgcount = okResult.ToList().Count;
//Assert.Equal(2, bwqcount);
// Get by ID
var result1 = controller.Get(1);
var okResult1 = Assert.IsAssignableFrom <JsonResult>(result1);
//var thisresult1 = okResult1.FirstOrDefault();
//Assert.Equal("bwqbatch 1", result1.BatchName);
// test update
var pg1 = new BWQ {
BWQID = 1, BatchName = "bwqbatch 1 upd"
};
//controller.UpdateEntry(pg1);
var result3 = controller.Get(1);
//var thisresult3 = result3.FirstOrDefault();
//Assert.NotEqual("bwqbatch 1", result3.BatchName);
//Assert.Equal("bwqbatch 1 upd", result3.BatchName);
// test delete
var result4 = controller.Get(2);
//var thisresult4 = result4.FirstOrDefault();
//Assert.Equal("bwqbatch 2", result4.BatchName);
Assert.NotNull(result4);
//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();
}
}
}
