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);
}
