public IHttpActionResult GetRetrieval([FromBody] ConfirmRetrievalViewModel model)
{
var retrieval = new RetrievalService(context).FindRetrievalById(model.RetrievalId);
if (retrieval == null)
{
return(NotFound());
}
return(Ok(retrieval.Disbursements
.SelectMany(d => d.DisbursementDetails
.Select(dd => new RetrievalDetailByDeptViewModel()
{
Department = dd.Disbursement.Department.Name,
DepartmentCode = dd.Disbursement.Department.DepartmentCode,
ItemCode = dd.ItemCode,
ItemName = dd.Item.Name,
Bin = dd.Bin,
PlanQuantity = dd.PlanQuantity,
ActualQuantity = dd.ActualQuantity,
Status = dd.Status.Name,
RetrievalStatus = retrieval.Status.Name,
Uom = dd.Item.Uom,
})
)));
}
public IHttpActionResult GetRetrievals()
{
var retrievals = new RetrievalService(context).FindAllRetrievals().OrderByDescending(r => r.CreatedDateTime);
if (retrievals.Count() == 0)
{
return(NotFound());
}
return(Ok(retrievals.Select(retrieval => new RetrievalMobileViewModel()
{
RetrievalId = retrieval.RetrievalId,
CreatedBy = retrieval.CreatedBy != null ? $"{retrieval.CreatedBy.FirstName} {retrieval.CreatedBy.LastName}" : "",
CreatedDate = retrieval.CreatedDateTime.ToShortDateString(),
Status = retrieval.Status.Name,
RetrievalDetails = retrieval.Disbursements.SelectMany(d => d.DisbursementDetails.Select(dd => new RetrievalDetailByDeptViewModel()
{
Department = dd.Disbursement.Department.Name,
DepartmentCode = dd.Disbursement.Department.DepartmentCode,
ItemCode = dd.ItemCode,
ItemName = dd.Item.Name,
Bin = dd.Bin,
PlanQuantity = dd.PlanQuantity,
ActualQuantity = dd.ActualQuantity,
Status = dd.Status.Name,
Uom = dd.Item.Uom,
})).ToList(),
})));
}
/// <summary>
/// Initialize webservice connection and local controls
/// </summary>
public void InitializeServices()
{
// Initialize a connection with the webservice
// If successful, initialize this object/handlers
try
{
proxy = new RetrievalService();
#pragma warning disable CS0618 // Type or member is obsolete
proxy.RequestSoapContext.Security.Tokens.Add(userToken);
#pragma warning restore CS0618 // Type or member is obsolete
// Connection Success
if (proxy.TestUserAccess())
{
Console.WriteLine("FFIEC Connected :: User Authorized");
Connected = true;
// Set up async handlers
InitializeWebserviceHandlers();
// Request valid reporting periods
RequestValidReportingPeriods();
}
// Connection failure
else
{
Console.WriteLine("Failed to authorize FFIED User");
}
}
catch (Exception) { Console.WriteLine("Webservice Connection Error"); }
}
public RequisitionControllerTests()
{
context = new ApplicationDbContext();
requisitionController = new RequisitionController();
disbursementService = new DisbursementService(context);
retrievalService = new RetrievalService(context);
}
public RequisitionAPIControllerTests()
{
context = new ApplicationDbContext();
requisitionApiController = new RequisitionAPIController();
requisitionRepository = new RequisitionRepository(context);
itemService = new ItemService(context);
retrievalService = new RetrievalService(context);
disbursementService = new DisbursementService(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 StationeryStoreApiController(RequisitionService reqService, InventoryService invService, DepartmentService deptService, DisbursementService disService, NotificationService notiService, StationeryContext dbcontext, RetrievalService rservice)
{
this.deptService = deptService;
this.invService = invService;
this.reqService = reqService;
this.dbcontext = dbcontext;
this.disService = disService;
this.rservice = rservice;
this.notiService = notiService;
}
public RequisitionController()
{
context = new ApplicationDbContext();
requisitionRepository = new RequisitionRepository(context);
userRepository = new UserRepository(context);
requisitionService = new RequisitionService(context);
retrievalService = new RetrievalService(context);
itemService = new ItemService(context);
collectionPointService = new CollectionPointService(context);
departmentService = new DepartmentService(context);
statusService = new StatusService(context);
userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
}
public RequisitionAPIController()
{
context = new ApplicationDbContext();
requisitionService = new RequisitionService(context);
requisitionRepository = new RequisitionRepository(context);
retrievalService = new RetrievalService(context);
disbursementService = new DisbursementService(context);
statusService = new StatusService(context);
itemService = new ItemService(context);
departmentRepository = new DepartmentRepository(context);
userRepository = new UserRepository(context);
statusRepository = new StatusRepository(context);
collectionPointRepository = new CollectionPointRepository(context);
notificationService = new NotificationService(context);
}
private void initialize()
{
this.wwo = new WWObjectImpl();
this.remoteRetrievalService = (RetrievalService)createConfigurationComponent(
AVKey.RETRIEVAL_SERVICE_CLASS_NAME);
this.localRetrievalService = (RetrievalService)createConfigurationComponent(
AVKey.RETRIEVAL_SERVICE_CLASS_NAME);
this.taskService = (TaskService)createConfigurationComponent(AVKey.TASK_SERVICE_CLASS_NAME);
this.dataFileStore = (FileStore)createConfigurationComponent(AVKey.DATA_FILE_STORE_CLASS_NAME);
this.memoryCacheSet = (MemoryCacheSet)createConfigurationComponent(AVKey.MEMORY_CACHE_SET_CLASS_NAME);
this.networkStatus = (NetworkStatus)createConfigurationComponent(AVKey.NETWORK_STATUS_CLASS_NAME);
this.sessionCache = (SessionCache)createConfigurationComponent(AVKey.SESSION_CACHE_CLASS_NAME);
this.scheduledTaskService = new BasicScheduledTaskService();
// Seems like an unlikely place to load the tiff reader, but do it here nonetheless.
IIORegistry.getDefaultInstance().registerServiceProvider(GeotiffImageReaderSpi.inst());
}
public IHttpActionResult UpdateRetrievalForm(SaveJson json)
{
var retrievalService = new RetrievalService(Context);
var disbursementService = new DisbursementService(Context);
try
{
// find the Retrieval
Retrieval r = retrievalService.FindRetrievalById(json.RetId);
foreach (BreakdownByDepartment bd in json.List)
{
// find the related Disbursement
Disbursement d = r.Disbursements.Where(x => x.Department.DepartmentCode == bd.DeptId).First();
disbursementService.UpdateActualQuantityForDisbursementDetail(d.DisbursementId, json.ItemCode, bd.Actual);
}
} catch (Exception e)
{
return(BadRequest(e.Message));
}
return(Ok());
}
public RetrievalAPIController(RetrievalService rs)
{
this.rs = rs;
}
public RetrievalAPIController()
{
context = new ApplicationDbContext();
disbursementService = new DisbursementService(Context);
retrievalService = new RetrievalService(Context);
}
public RetrievalController(RetrievalService rs, InventoryService invSvc)
{
this.rs = rs;
this.invSvc = invSvc;
}
public RetrievalController()
{
context = new ApplicationDbContext();
itemService = new ItemService(context);
retrievalService = new RetrievalService(context);
}
