public void TestCleanup() { Retrieval retrieval = context.Retrieval.Where(x => x.RetrievalId == "TEST").First(); List <StockMovement> smlist = context.StockMovement.Where(x => x.DisbursementId == "TEST").ToList(); foreach (StockMovement sm in smlist) { stockmovementRepository.Delete(sm); } List <Disbursement> list = disbursementService.FindDisbursementsByRetrievalId(retrieval.RetrievalId); foreach (Disbursement d in list) { //Delete dummy disbursement test objects disbursementRepository.Delete(d); } //delete retrieval objects retrievalRepository.Delete(retrieval); var requisitionRepository = new RequisitionRepository(context); if (disbursementRepository.ExistsById("RSERVICETEST")) { disbursementRepository.Delete(disbursementRepository.FindById("RSERVICETEST")); } if (disbursementRepository.ExistsById("RSERVICETEST1")) { disbursementRepository.Delete(disbursementRepository.FindById("RSERVICETEST1")); } if (disbursementRepository.ExistsById("RSERVICETEST2")) { disbursementRepository.Delete(disbursementRepository.FindById("RSERVICETEST2")); } if (requisitionRepository.ExistsById("RSERVICETEST")) { requisitionRepository.Delete(requisitionRepository.FindById("RSERVICETEST")); } if (requisitionRepository.ExistsById("RSERVICETEST1")) { requisitionRepository.Delete(requisitionRepository.FindById("RSERVICETEST1")); } if (requisitionRepository.ExistsById("RSERVICETEST2")) { requisitionRepository.Delete(requisitionRepository.FindById("RSERVICETEST2")); } if (retrievalRepository.ExistsById("RSERVICETEST")) { retrievalRepository.Delete(retrievalRepository.FindById("RSERVICETEST")); } if (requisitionRepository.FindAll().Where(r => r.EmployeeRemarks.Contains("RSERVICETEST")).Count() > 0) { requisitionRepository.Delete(requisitionRepository.FindAll().Where(r => r.EmployeeRemarks.Contains("RSERVICETEST")).FirstOrDefault()); } }
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 void TestCleanup() { Retrieval retrieval = context.Retrieval.Where(x => x.RetrievalId == "TEST").First(); List <Disbursement> list = disbursementService.FindDisbursementsByRetrievalId(retrieval.RetrievalId); foreach (Disbursement d in list) { //Delete dummy disbursement test objects disbursementRepository.Delete(d); } //have to delete requisitions before retrievals List <Requisition> requisitionlist = context.Requisition.Where(x => x.RequisitionId == "TEST").ToList(); foreach (Requisition r in requisitionlist) { //delete dummy requisition test objects requisitionRepository.Delete(r); } List <Requisition> requisitionlist2 = context.Requisition.Where(x => x.RequisitionId == "TEST2").ToList(); foreach (Requisition r in requisitionlist2) { //delete dummy requisition test objects requisitionRepository.Delete(r); } //delete retrieval objects retrievalRepository.Delete(retrieval); //} if (disbursementRepository.ExistsById("COLLECTIONTEST")) { disbursementRepository.Delete(disbursementRepository.FindById("COLLECTIONTEST")); } if (disbursementRepository.ExistsById("DSERVICETEST")) { disbursementRepository.Delete(disbursementRepository.FindById("DSERVICETEST")); } if (requisitionRepository.ExistsById("DSERVICETEST")) { requisitionRepository.Delete(requisitionRepository.FindById("DSERVICETEST")); } if (retrievalRepository.ExistsById("DSERVICETEST")) { retrievalRepository.Delete(retrievalRepository.FindById("DSERVICETEST")); } }
public void FindByIdTestNotNull() { // Arrange disbursementRepository.Save(new Disbursement() { DisbursementId = "DOREPOTEST", CreatedDateTime = DateTime.Now, }); // Act var result = disbursementRepository.FindById("DOREPOTEST"); // Assert Assert.IsInstanceOfType(result, typeof(Disbursement)); }
public ActionResult Collect(string did) { Disbursement d; try { disbursementService.ConfirmCollection(did); d = disbursementRepository.FindById(did); } catch { TempData["error"] = true; return(RedirectToAction("DisbursementDetails", "Disbursement", new { did })); } TempData["did"] = did; return(RedirectToAction("StationeryDisbursement", "Requisition", new { rid = d.Retrieval.RetrievalId })); }
public void ConfirmCollect_BadRequest() { // Arrange var controller = new DisbursementAPIController() { Request = new HttpRequestMessage(), Configuration = new HttpConfiguration(), Context = context, }; var disbursement = disbursementRepository.FindById("DAPICONTROLTEST"); disbursement.Status = new StatusService(context).FindStatusByStatusId(10); disbursementRepository.Save(disbursement); // Act IHttpActionResult actionResult = controller.ConfirmCollection(new DisbursementIdViewModel() { DisbursementId = "DAPICONTROLTEST", }); // Assert // Assert Assert.IsInstanceOfType(actionResult, typeof(BadRequestErrorMessageResult)); }
public void TestCleanup() { if (disbursementRepository.ExistsById("RAPICONTROLTEST")) { disbursementRepository.Delete(disbursementRepository.FindById("RAPICONTROLTEST")); } if (requisitionRepository.ExistsById("RAPICONTROLTEST")) { requisitionRepository.Delete(requisitionRepository.FindById("RAPICONTROLTEST")); } if (retrievalRepository.ExistsById("RAPICONTROLTEST")) { retrievalRepository.Delete(retrievalRepository.FindById("RAPICONTROLTEST")); } }
public void TestCleanup() { if (disbursementDetailRepository.ExistsById("DDREPOTEST", "E030")) { disbursementDetailRepository.Delete(disbursementDetailRepository.FindById("DDREPOTEST", "E030")); } if (disbursementDetailRepository.ExistsById("DDREPOTEST", "P030")) { disbursementDetailRepository.Delete(disbursementDetailRepository.FindById("DDREPOTEST", "P030")); } if (disbursementRepository.ExistsById("DDREPOTEST")) { disbursementRepository.Delete(disbursementRepository.FindById("DDREPOTEST")); } }
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 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 UpdateRetrievalFormTest() { // ARRANGE RetrievalAPIController retrievalAPIController = new RetrievalAPIController() { Request = new HttpRequestMessage(), Configuration = new HttpConfiguration(), Context = context, }; string retId = "RETRIEVAL"; string deptId = "COMM"; string itemCode = "C001"; string disbId = "DISBURSEMENT"; int actual = 99; Retrieval r = new Retrieval { RetrievalId = retId, CreatedDateTime = DateTime.Now }; Disbursement d = new Disbursement { DisbursementId = disbId, Department = departmentService.FindDepartmentByDepartmentCode(deptId), Retrieval = r, CreatedDateTime = DateTime.Now, DisbursementDetails = new List <DisbursementDetail> { new DisbursementDetail { Item = ItemRepository.FindById(itemCode), PlanQuantity = 99, ActualQuantity = 0 } } }; retrievalRepository.Save(r); disbursementRepository.Save(d); try { SaveJson json = new SaveJson { ItemCode = itemCode, RetId = retId, List = new List <BreakdownByDepartment> { new BreakdownByDepartment { DeptId = deptId, Actual = actual } } }; // ACT retrievalAPIController.UpdateRetrievalForm(json); // ASSERT int expected = 99; DisbursementDetail dd; //using (context = new ApplicationDbContext()) //{ disbursementRepository = new DisbursementRepository(context); dd = disbursementRepository .FindById(disbId) .DisbursementDetails .Where(x => x.ItemCode == itemCode).First(); //} Assert.AreEqual(expected, dd.ActualQuantity); } finally { //using (context = new ApplicationDbContext()) //{ Disbursement deleteD = context.Disbursement.Where(x => x.DisbursementId == disbId).First(); context.Disbursement.Remove(deleteD); Retrieval deleteR = context.Retrieval.Where(x => x.RetrievalId == retId).First(); context.Retrieval.Remove(deleteR); context.SaveChanges(); //} } }
public Disbursement FindDisbursementById(string id) { return(disbursementRepository.FindById(id)); }
public void TestInitialize() { context = new ApplicationDbContext(); stockmovementService = new StockMovementService(context); itemService = new ItemService(context); stockmovementRepository = new StockMovementRepository(context); ddRepository = new DisbursementDetailRepository(context); sadRepository = new StockAdjustmentDetailRepository(context); dodRepository = new DeliveryOrderDetailRepository(context); disbursementRepository = new DisbursementRepository(context); doRepository = new DeliveryOrderRepository(context); saRepository = new StockAdjustmentRepository(context); //create new test object and save into db StockMovement sm = new StockMovement() { StockMovementId = IdService.GetNewStockMovementId(context), DisbursementId = "TEST", StockAdjustmentId = "TEST", DeliveryOrderNo = "TEST", Item = context.Item.Where(x => x.ItemCode == "C003").First(), CreatedDateTime = DateTime.Now, OriginalQuantity = 1, AfterQuantity = 2 }; stockmovementRepository.Save(sm); //create new disbursement object and save into db Disbursement disbursement = new Disbursement(); if (disbursementRepository.FindById("TEST") == null) { disbursement.DisbursementId = "TEST"; disbursement.CreatedDateTime = DateTime.Now; } else { disbursement = disbursementRepository.FindById("TEST"); } disbursementRepository.Save(disbursement); //create new DisbursementDetail object and save into db DisbursementDetail detail = new DisbursementDetail() { DisbursementId = "TEST", Item = context.Item.First(), PlanQuantity = 3, ActualQuantity = 3 }; ddRepository.Save(detail); //create new DO object and save into db DeliveryOrder d = new DeliveryOrder(); if (doRepository.FindById("TEST") == null) { d.DeliveryOrderNo = "TEST"; d.CreatedDateTime = DateTime.Now; } else { d = doRepository.FindById("TEST"); } doRepository.Save(d); //create new DO detail object and save into db DeliveryOrderDetail dod = new DeliveryOrderDetail() { DeliveryOrder = d, Item = context.Item.First(), PlanQuantity = 4, ActualQuantity = 4 }; dodRepository.Save(dod); //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); //create new SA detail object and save into db StockAdjustmentDetail SADetail = new StockAdjustmentDetail() { StockAdjustment = SA, Item = context.Item.First(), OriginalQuantity = 2, AfterQuantity = 4 }; sadRepository.Save(SADetail); }
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); }