public DisbursementApiControllerTest()
{
context = new ApplicationDbContext();
requisitionRepository = new RequisitionRepository(context);
retrievalRepository = new RetrievalRepository(context);
disbursementRepository = new DisbursementRepository(context);
departmentRepository = new DepartmentRepository(context);
}
public void TestInitialize()
{
context = new ApplicationDbContext();
retrievalService = new RetrievalService(context);
itemService = new ItemService(context);
disbursementService = new DisbursementService(context);
retrievalRepository = new RetrievalRepository(context);
disbursementRepository = new DisbursementRepository(context);
disbursementdetailRepository = new DisbursementDetailRepository(context);
stockmovementRepository = new StockMovementRepository(context);
statusRepository = new StatusRepository(context);
Retrieval retrieval = new Retrieval();
if (retrievalRepository.FindById("TEST") == null)
{
//save retrieval object into db
retrieval.RetrievalId = "TEST";
retrieval.CreatedDateTime = DateTime.Now;
retrievalRepository.Save(retrieval);
retrieval.Status = statusRepository.FindById(19);
}
else
{
retrieval = retrievalRepository.FindById("TEST");
}
Disbursement disbursement = new Disbursement();
if (disbursementRepository.FindById("TEST") == null)
{
disbursement.DisbursementId = "TEST";
disbursement.CreatedDateTime = DateTime.Now;
disbursement.Retrieval = retrieval;
}
else
{
disbursement = disbursementRepository.FindById("TEST");
}
disbursementRepository.Save(disbursement);
//save disbursement detail object into db
DisbursementDetail detail = new DisbursementDetail()
{
Disbursement = disbursement,
Item = context.Item.Where(x => x.ItemCode == "C003").First(),
PlanQuantity = 5,
ActualQuantity = 5
};
disbursementdetailRepository.Save(detail);
}
public RetrievalApiControllerTests()
{
context = new ApplicationDbContext();
retrievalController = new RetrievalController();
departmentService = new DepartmentService(context);
retrievalRepository = new RetrievalRepository(context);
disbursementRepository = new DisbursementRepository(context);
ItemRepository = new ItemRepository(context);
disbursementRepository = new DisbursementRepository(context);
}
public RetrievalService(ApplicationDbContext context)
{
this.context = context;
retrievalRepository = new RetrievalRepository(context);
statusRepository = new StatusRepository(context);
disbursementRepository = new DisbursementRepository(context);
itemService = new ItemService(context);
stockmovementService = new StockMovementService(context);
disbursementService = new DisbursementService(context);
}
public void TestCleanup()
{
// Delete DeliveryOrders
var deliveryOrderRepository = new DeliveryOrderRepository(context);
if (deliveryOrderRepository.FindAll().Where(x => x.InvoiceFileName == "IDSERVICETEST").Count() > 0)
{
deliveryOrderRepository.FindAll().Where(x => x.InvoiceFileName == "IDSERVICETEST").ToList().ForEach(x => deliveryOrderRepository.Delete(x));
}
// Delete Disbursements
var disbursementRepository = new DisbursementRepository(context);
if (disbursementRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").Count() > 0)
{
disbursementRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").ToList().ForEach(x => disbursementRepository.Delete(x));
}
// Delete Purchase Orders
var purchaseOrderRepository = new PurchaseOrderRepository(context);
if (purchaseOrderRepository.FindAll().Where(x => x.Status.StatusId == 16).Count() > 0)
{
purchaseOrderRepository.FindAll().Where(x => x.Status.StatusId == 16).ToList().ForEach(x => purchaseOrderRepository.Delete(x));
}
// Delete Requisitions
var requisitionRepository = new RequisitionRepository(context);
if (requisitionRepository.FindAll().Where(x => x.EmployeeRemarks == "IDSERVICETEST").Count() > 0)
{
requisitionRepository.FindAll().Where(x => x.EmployeeRemarks == "IDSERVICETEST").ToList().ForEach(x => requisitionRepository.Delete(x));
}
// Delete Retrievals
var retrievalRepository = new RetrievalRepository(context);
if (retrievalRepository.FindAll().Where(x => x.Status.StatusId == 16).Count() > 0)
{
retrievalRepository.FindAll().Where(x => x.Status.StatusId == 16).ToList().ForEach(x => retrievalRepository.Delete(x));
}
// Delete StockAdjustments
var stockAdjustmentRepository = new StockAdjustmentRepository(context);
if (stockAdjustmentRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").Count() > 0)
{
stockAdjustmentRepository.FindAll().Where(x => x.Remarks == "IDSERVICETEST").ToList().ForEach(x => stockAdjustmentRepository.Delete(x));
}
}
public static string GetNewRetrievalId(ApplicationDbContext context)
{
string prefix = "RET";
int serialNo = new RetrievalRepository(context)
.FindByCreatedDateTime(DateTime.Now.Date.AddDays(1 - DateTime.Now.Date.Day), DateTime.Now.Date.AddDays(1))
.Where(x => x.RetrievalId.Length == 14)
.Count() > 0 ?
new RetrievalRepository(context)
.FindByCreatedDateTime(DateTime.Now.Date.AddDays(1 - DateTime.Now.Date.Day), DateTime.Now.Date.AddDays(1))
.Where(x => x.RetrievalId.Length == 14)
.AsEnumerable()
.Select(x => Int32.Parse(x.RetrievalId.Substring(x.RetrievalId.Length - 3)))
.OrderByDescending(x => x)
.FirstOrDefault() + 1 : 1;
return($"{prefix}-{DateTime.Now.Year}{DateTime.Now.Month:00}-{serialNo:000}");
}
public void TestCleanup()
{
var disbursementRepository = new DisbursementRepository(context);
var retrievalRepository = new RetrievalRepository(context);
var requisitionRepository = new RequisitionRepository(context);
if (requisitionRepository.ExistsById("RETCONTROLTEST"))
{
requisitionRepository.Delete(requisitionRepository.FindById("RETCONTROLTEST"));
}
if (disbursementRepository.ExistsById("RETCONTROLTEST"))
{
disbursementRepository.Delete(disbursementRepository.FindById("RETCONTROLTEST"));
}
if (retrievalRepository.ExistsById("RETCONTROLTEST"))
{
retrievalRepository.Delete(retrievalRepository.FindById("RETCONTROLTEST"));
}
}
public void TestCleanup()
{
var usedNotificationId = IdService.GetNewNotificationId(context) - 1;
if (notificationRepository.ExistsById(usedNotificationId))
{
notificationRepository.Delete(notificationRepository.FindById(usedNotificationId));
}
//delete test object from Disbursements
List <Disbursement> ddlist = context.Disbursement.Where(x => x.DisbursementId == "TEST").ToList();
foreach (Disbursement dd in ddlist)
{
disbursementRepository.Delete(dd);
}
//delete test object from Requisitions
List <Requisition> rlist = context.Requisition.Where(x => x.RequisitionId == "TEST").ToList();
foreach (Requisition r in rlist)
{
requisitionRepository.Delete(r);
}
//delete test object from StockAdjustments
List <StockAdjustment> salist = context.StockAdjustment.Where(x => x.StockAdjustmentId == "TEST").ToList();
foreach (StockAdjustment SA in salist)
{
saRepository.Delete(SA);
}
var retrievalRepository = new RetrievalRepository(context);
if (retrievalRepository.ExistsById("NOTIFICATIONTEST"))
{
retrievalRepository.Delete(retrievalRepository.FindById("NOTIFICATIONTEST"));
}
}
public void TestInitialize()
{
context = new ApplicationDbContext();
notificationRepository = new NotificationRepository(context);
notificationService = new NotificationService(context);
disbursementRepository = new DisbursementRepository(context);
saRepository = new StockAdjustmentRepository(context);
requisitionRepository = new RequisitionRepository(context);
var retrieval = new RetrievalRepository(context).Save(new Retrieval()
{
RetrievalId = "NOTIFICATIONTEST",
CreatedDateTime = DateTime.Now,
});
//save new disbursement object into db
Disbursement disbursement = new Disbursement();
if (disbursementRepository.FindById("TEST") == null)
{
disbursement.Department = new DepartmentRepository(context).FindById("ENGL");
disbursement.DisbursementId = "TEST";
disbursement.CreatedDateTime = DateTime.Now;
disbursement.Retrieval = retrieval;
disbursement.DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "TEST",
Item = new ItemService(context).FindItemByItemCode("E030"),
ActualQuantity = 20,
}
};
}
else
{
disbursement = disbursementRepository.FindById("TEST");
}
disbursementRepository.Save(disbursement);
//save new requisition object into db
Requisition requisition = new Requisition();
if (requisitionRepository.FindById("TEST") == null)
{
requisition.Department = new DepartmentRepository(context).FindById("ENGL");
requisition.RequisitionId = "TEST";
requisition.CreatedDateTime = DateTime.Now;
requisition.Retrieval = retrieval;
requisition.RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "TEST",
Item = new ItemService(context).FindItemByItemCode("E030"),
Status = new StatusService(context).FindStatusByStatusId(8),
}
};
}
else
{
requisition = requisitionRepository.FindById("TEST");
}
requisitionRepository.Save(requisition);
//create new SA object and save into db
StockAdjustment SA = new StockAdjustment();
if (saRepository.FindById("TEST") == null)
{
SA.StockAdjustmentId = "TEST";
SA.CreatedDateTime = DateTime.Now;
}
else
{
SA = saRepository.FindById("TEST");
}
saRepository.Save(SA);
}
public void ConfirmRetrieval_Valid()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RETCONTROLTEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
Status = new StatusRepository(context).FindById(7),
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "RETCONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Quantity = 30,
Status = new StatusRepository(context).FindById(7),
}
}
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RETCONTROLTEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
Status = new StatusService(context).FindStatusByStatusId(19),
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RETCONTROLTEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RETCONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
PlanQuantity = 30,
ActualQuantity = 30,
Status = new StatusService(context).FindStatusByStatusId(18),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(7),
CreatedDateTime = DateTime.Now,
});
var expectedStatus = new StatusService(context).FindStatusByStatusId(20);
var controller = new RetrievalAPIController()
{
Request = new HttpRequestMessage(),
Configuration = new HttpConfiguration(),
Context = context,
};
// Act
IHttpActionResult actionResult = controller.ConfirmRetrieval(new ConfirmRetrievalViewModel()
{
RetrievalId = "RETCONTROLTEST",
Email = "*****@*****.**",
});
var contentResult = actionResult as OkNegotiatedContentResult <MessageViewModel>;
// Assert
Assert.IsNotNull(contentResult);
Assert.IsNotNull(contentResult.Content);
Assert.AreEqual(contentResult.Content.Message, "Successfully confirmed");
var result = new RetrievalRepository(context).FindById("RETCONTROLTEST");
Assert.AreEqual(expectedStatus.Name, result.Status.Name);
}
public void TestInitialize()
{
// Arrange
context = new ApplicationDbContext();
retrievalRepository = new RetrievalRepository(context);
}
public void TestInitialize()
{
context = new ApplicationDbContext();
disbursementRepository = new DisbursementRepository(context);
disbursementdetailRepository = new DisbursementDetailRepository(context);
disbursementService = new DisbursementService(context);
itemRepository = new ItemRepository(context);
retrievalRepository = new RetrievalRepository(context);
requisitionRepository = new RequisitionRepository(context);
requisitiondetailRepository = new RequisitionDetailRepository(context);
departmentRepository = new DepartmentRepository(context);
Retrieval retrieval = new Retrieval();
if (retrievalRepository.FindById("TEST") == null)
{
//save retrieval object into db
retrieval.RetrievalId = "TEST";
retrieval.CreatedDateTime = DateTime.Now;
retrievalRepository.Save(retrieval);
}
else
{
retrieval = retrievalRepository.FindById("TEST");
}
//save disbursement object into db
Disbursement disbursement = new Disbursement();
if (disbursementRepository.FindById("TEST") == null)
{
disbursement.DisbursementId = "TEST";
disbursement.CreatedDateTime = DateTime.Now;
disbursement.Retrieval = retrieval;
}
else
{
disbursement = disbursementRepository.FindById("TEST");
}
disbursementRepository.Save(disbursement);
//save disbursement detail object into db
DisbursementDetail detail = new DisbursementDetail()
{
Disbursement = disbursement,
Item = context.Item.First(),
PlanQuantity = 20,
ActualQuantity = 20
};
disbursementdetailRepository.Save(detail);
Requisition requisition = new Requisition()
{
RequisitionId = "TEST",
Retrieval = retrieval,
CreatedDateTime = DateTime.Now,
Status = new StatusService(context).FindStatusByStatusId(8)
};
requisitionRepository.Save(requisition);
}
