public void AlertJobs()
{
ILogger <AlertJobsController> _testlogger = null;
using (var context = new AppDbContext(options, null))
{
var controller = new AlertJobsController(context, _testlogger, null);
// Get all
var result = controller.Get();
// Assert
var okResult = Assert.IsAssignableFrom <IEnumerable <AlertJobs> >(result);
var pgcount = okResult.ToList().Count;
Assert.Equal(2, pgcount);
// Get by ID
var result1 = controller.Get(1);
var okResult1 = Assert.IsAssignableFrom <AlertJobs>(result1);
Assert.Equal("user1", okResult1.CreatedBy);
// test update
var pg1 = new AlertJobs {
AlertJobsID = 1, CreatedBy = "user1 upd"
};
controller.UpdateEntry(pg1);
var result3 = controller.Get(1);
Assert.NotEqual("user1", result3.CreatedBy);
Assert.Equal("user1 upd", result3.CreatedBy);
// test delete
var result4 = controller.Get(2);
Assert.Equal("user1", result4.CreatedBy);
var result5 = controller.Delete(2);
var viewResult = Assert.IsType <Microsoft.AspNetCore.Mvc.OkResult>(result5);
var result6 = controller.Get(2);
Assert.Null(result6);
}
}
public IActionResult Create([FromBody] AlertJobs newmodel)
{
if (ModelState.IsValid)
{
_context.AlertJobs.Add(newmodel);
_context.SaveChanges();
return(CreatedAtRoute("GetAlertJobs", new { id = newmodel.AlertJobsID }, newmodel));
}
else
{
return(BadRequest());
}
}
internal void PopulateData()
{
using (var context = new AppDbContext(options, null))
{
if (context.AlertJobs.Count() < 1)
{
var p1 = new AlertJobs {
AlertJobsID = 1, JobName = "AlertJobs 1"
};
var p2 = new AlertJobs {
AlertJobsID = 2, JobName = "AlertJobs 2"
};
context.AlertJobs.Add(p1);
context.AlertJobs.Add(p2);
context.SaveChanges();
}
if (context.AlertNames.Count() < 1)
{
var p1 = new AlertNames {
AlertNameID = 1, NameEntry = "AlertNames 1", AlertJobsID = 1
};
var p2 = new AlertNames {
AlertNameID = 2, NameEntry = "AlertNames 2", AlertJobsID = 2
};
context.AlertNames.Add(p1);
context.AlertNames.Add(p2);
context.SaveChanges();
}
if (context.AlertJobsQueue.Count() < 1)
{
var p1 = new AlertJobsQueue {
AlertJobsQueueID = 1, CreatedBy = "6", StatusCollectionItemID = 1047
};
var p2 = new AlertJobsQueue {
AlertJobsQueueID = 2, CreatedBy = "6", StatusCollectionItemID = 1047
};
context.AlertJobsQueue.Add(p1);
context.AlertJobsQueue.Add(p2);
context.SaveChanges();
}
}
}
public IActionResult UpdateEntry([FromBody] AlertJobs objupd)
{
var targetObject = _context.AlertJobs.FirstOrDefault(t => t.AlertJobsID == objupd.AlertJobsID);
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 AlertJobs()
{
IQueryable <AlertJobs> AlertJobsCollection = Enumerable.Empty <AlertJobs>().AsQueryable();
AlertJobs ct = new AlertJobs {
AlertJobsID = 1, JobName = "Test AlertJobs"
};
Mock <IAlertJobsRepository> AlertJobsService = new Mock <IAlertJobsRepository>();
object obj = new object();
try
{
AlertJobsService.Setup(x => x.GetAll()).Returns(AlertJobsCollection);
AlertJobsService.Setup(x => x.Get(It.IsAny <int>())).Returns(ct);
AlertJobsService.Setup(x => x.Add(It.IsAny <AlertJobs>())).Returns(ct);
AlertJobsService.Setup(x => x.Delete(It.IsAny <AlertJobs>())).Verifiable();
AlertJobsService.Setup(x => x.Update(It.IsAny <AlertJobs>(), It.IsAny <object>())).Returns(ct);
var AlertJobsObject = AlertJobsService.Object;
var p1 = AlertJobsObject.GetAll();
var p2 = AlertJobsObject.Get(1);
var p3 = AlertJobsObject.Update(ct, obj);
var p4 = AlertJobsObject.Add(ct);
AlertJobsObject.Delete(ct);
Assert.IsAssignableFrom <IQueryable <AlertJobs> >(p1);
Assert.IsAssignableFrom <AlertJobs>(p2);
Assert.Equal("Test AlertJobs", p2.JobName);
Assert.Equal("Test AlertJobs", p3.JobName);
AlertJobsService.VerifyAll();
AlertJobsObject.Dispose();
}
finally
{
AlertJobsService = null;
}
}
public IActionResult Update([FromBody] AlertJobs editentry)
{
var result = _repository.Update(editentry, editentry.AlertJobsID);
return(Helper.CheckResult(result));
}
public IActionResult Create([FromBody] AlertJobs newentry)
{
var result = _repository.Add(newentry);
return(Helper.CheckResult(result));
}
internal void PopulateData()
{
using (var context = new AppDbContext(options, null))
{
if (context.AlertJobs.Count() < 1)
{
var p1 = new AlertJobs {
AlertJobsID = 1, CreatedBy = "user1",
};
var p2 = new AlertJobs {
AlertJobsID = 2, CreatedBy = "user1",
};
context.AlertJobs.Add(p1);
context.AlertJobs.Add(p2);
context.SaveChanges();
}
if (context.AlertSchedules.Count() < 1)
{
var p1 = new AlertSchedules {
AlertSchedulesId = 1, CreatedBy = "user1",
};
var p2 = new AlertSchedules {
AlertSchedulesId = 2, CreatedBy = "user1",
};
context.AlertSchedules.Add(p1);
context.AlertSchedules.Add(p2);
context.SaveChanges();
}
if (context.AlertScheduleType.Count() < 1)
{
var p1 = new AlertScheduleType {
AlertScheduleTypeID = 1, CreatedBy = "user1",
};
var p2 = new AlertScheduleType {
AlertScheduleTypeID = 2, CreatedBy = "user1",
};
context.AlertScheduleType.Add(p1);
context.AlertScheduleType.Add(p2);
context.SaveChanges();
}
if (context.AlertSourceType.Count() < 1)
{
var p1 = new AlertSourceType {
AlertSourceTypeID = 1, CreatedBy = "user1",
};
var p2 = new AlertSourceType {
AlertSourceTypeID = 2, CreatedBy = "user1",
};
context.AlertSourceType.Add(p1);
context.AlertSourceType.Add(p2);
context.SaveChanges();
}
if (context.AlertWorkers.Count() < 1)
{
var p1 = new AlertWorkers {
AlertWorkersID = 1, CreatedBy = "user1",
};
var p2 = new AlertWorkers {
AlertWorkersID = 2, CreatedBy = "user1",
};
context.AlertWorkers.Add(p1);
context.AlertWorkers.Add(p2);
context.SaveChanges();
}
if (context.Encoding.Count() < 1)
{
var p1 = new Encoding {
EncodingID = 1, CreatedBy = "user1",
};
var p2 = new Encoding {
EncodingID = 2, CreatedBy = "user1",
};
context.Encoding.Add(p1);
context.Encoding.Add(p2);
context.SaveChanges();
}
}
}
