public IActionResult Create([FromBody] BWQFieldSelect newmodel)
{
if (ModelState.IsValid)
{
_context.BWQFieldSelect.Add(newmodel);
_context.SaveChanges();
return(CreatedAtRoute("GetBWQFieldSelect", new { id = newmodel.BWQFieldSelectID }, newmodel));
}
else
{
return(BadRequest());
}
}
public IActionResult UpdateEntry([FromBody] BWQFieldSelect objupd)
{
var targetObject = _context.BWQFieldSelect.FirstOrDefault(t => t.BWQFieldSelectID == objupd.BWQFieldSelectID);
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 BWQFieldSelect()
{
ILogger <BWQFieldSelectController> _testlogger = null;
using (var context = new AppDbContext(options, null))
{
var controller = new BWQFieldSelectController(context, _testlogger);
// Get all
var result = controller.Get();
// Assert
var okResult = Assert.IsAssignableFrom <IEnumerable <BWQFieldSelect> >(result);
var pgcount = okResult.ToList().Count;
Assert.Equal(2, pgcount);
// Get by ID
var result1 = controller.Get(1);
var okResult1 = Assert.IsAssignableFrom <BWQFieldSelect>(result1);
//var thisresult1 = okResult1.FirstOrDefault();
Assert.Equal("fieldselect type 1", result1.FieldDisplayName);
// test update
var pg1 = new BWQFieldSelect {
BWQFieldSelectID = 1, FieldDisplayName = "fieldselect type 1 upd"
};
controller.UpdateEntry(pg1);
var result3 = controller.Get(1);
//var thisresult3 = result3.FirstOrDefault();
Assert.NotEqual("fieldselect type 1", result3.FieldDisplayName);
Assert.Equal("fieldselect type 1 upd", result3.FieldDisplayName);
// test delete
var result4 = controller.Get(2);
//var thisresult4 = result4.FirstOrDefault();
Assert.Equal("fieldselect type 2", result4.FieldDisplayName);
IActionResult result5 = controller.Delete(2);
var viewResult = Assert.IsType <Microsoft.AspNetCore.Mvc.OkResult>(result5);
var result6 = controller.Get(2);
Assert.Null(result6);
}
}
public void BWQFieldSelect()
{
IQueryable <BWQFieldSelect> BWQFieldSelectBWQFieldSelect = Enumerable.Empty <BWQFieldSelect>().AsQueryable();
BWQFieldSelect ct = new BWQFieldSelect {
BWQFieldSelectID = 1, FieldDisplayName = "Test BWQFieldSelect"
};
Mock <IBWQFieldSelectRepository> BWQFieldSelectService = new Mock <IBWQFieldSelectRepository>();
object obj = new object();
try
{
BWQFieldSelectService.Setup(x => x.GetAll()).Returns(BWQFieldSelectBWQFieldSelect);
BWQFieldSelectService.Setup(x => x.Get(It.IsAny <int>())).Returns(ct);
BWQFieldSelectService.Setup(x => x.Add(It.IsAny <BWQFieldSelect>())).Returns(ct);
BWQFieldSelectService.Setup(x => x.Delete(It.IsAny <BWQFieldSelect>())).Verifiable();
BWQFieldSelectService.Setup(x => x.Update(It.IsAny <BWQFieldSelect>(), It.IsAny <object>())).Returns(ct);
var BWQFieldSelectObject = BWQFieldSelectService.Object;
var p1 = BWQFieldSelectObject.GetAll();
var p2 = BWQFieldSelectObject.Get(1);
var p3 = BWQFieldSelectObject.Update(ct, obj);
var p4 = BWQFieldSelectObject.Add(ct);
BWQFieldSelectObject.Delete(ct);
Assert.IsAssignableFrom <IQueryable <BWQFieldSelect> >(p1);
Assert.IsAssignableFrom <BWQFieldSelect>(p2);
Assert.Equal("Test BWQFieldSelect", p2.FieldDisplayName);
Assert.Equal("Test BWQFieldSelect", p3.FieldDisplayName);
BWQFieldSelectService.VerifyAll();
BWQFieldSelectObject.Dispose();
}
finally
{
BWQFieldSelectService = null;
}
}
public IActionResult Update([FromBody] BWQFieldSelect editentry)
{
var result = _repository.Update(editentry, editentry.BWQFieldSelectID);
return(Helper.CheckResult(result));
}
public IActionResult Create([FromBody] BWQFieldSelect newentry)
{
var result = _repository.Add(newentry);
return(Helper.CheckResult(result));
}
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();
}
}
}
