public IHttpActionResult CreateDisbursementDetails(DisbursementDetailsModel dism) { string error = ""; DisbursementDetailsModel disbm = DisbursementDetailsRepo.CreateDisbursementDetails(dism, out error); // get the inventory using the item id from Requisition details InventoryModel invm = InventoryRepo.GetInventoryByItemid(dism.Itemid, out error); // subtract the stock accoring to qty invm.Stock -= dism.Qty; // update the inventory invm = InventoryRepo.UpdateInventory(invm, out error); InventoryTransactionModel invtm = new InventoryTransactionModel { InvID = invm.Invid, ItemID = invm.Itemid, Qty = dism.Qty * -1, TransType = ConInventoryTransaction.TransType.DISBURSEMENT, TransDate = DateTime.Now, Remark = dism.Disid.ToString() }; invtm = InventoryTransactionRepo.CreateInventoryTransaction(invtm, out error); if (error != "" || disbm == null) { return(Content(HttpStatusCode.BadRequest, error)); } return(Ok(disbm)); }
public IHttpActionResult CreateInventoryTransaction(InventoryTransactionModel invt) { string error = ""; InventoryTransactionModel invtm = InventoryTransactionRepo.CreateInventoryTransaction(invt, out error); if (error != "" || invtm == null) { return(Content(HttpStatusCode.BadRequest, error)); } return(Ok(invtm)); }
public IHttpActionResult UpdatePOStatusComplete(PurchaseOrderModel po) { string error = ""; po = PurchaseOrderRepo.GetPurchaseOrderByID(po.PoId, out error); // if the staff has already updated the status to "received" if (po.Status == ConPurchaseOrder.Status.RECEIVED) { return(Ok(po)); } po.Status = ConPurchaseOrder.Status.RECEIVED; List <PurchaseOrderDetailModel> podms = PurchaseOrderDetailRepo.GetPurchaseOrderDetailByID(po.PoId, out error); // if the purchase order is completed, the stock must be updated according to deliver qty. foreach (PurchaseOrderDetailModel podm in podms) { // get the inventory using the item id from purchaseorder detail model InventoryModel invm = InventoryRepo.GetInventoryByItemid(podm.Itemid, out error); // adding the stock accoring to deliver qty invm.Stock += podm.DelivQty; // update the inventory invm = InventoryRepo.UpdateInventory(invm, out error); InventoryTransactionModel invtm = new InventoryTransactionModel(); invtm.InvID = invm.Invid; invtm.ItemID = invm.Itemid; invtm.Qty = podm.DelivQty; invtm.TransType = ConInventoryTransaction.TransType.PURCHASEORDER_RECEIEVED; invtm.TransDate = DateTime.Now; invtm.Remark = podm.PoId.ToString(); invtm = InventoryTransactionRepo.CreateInventoryTransaction(invtm, out error); } // updating the status PurchaseOrderModel pom = PurchaseOrderRepo.UpdatePurchaseOrder(po, out error); if (error != "" || pom == null) { if (error == ConError.Status.NOTFOUND) { return(Content(HttpStatusCode.NotFound, "PO Not Found")); } return(Content(HttpStatusCode.BadRequest, error)); } return(Ok(pom)); }
public IHttpActionResult GetInventoryTransactionByItemID(int itemid) { string error = ""; List <InventoryTransactionModel> invtms = InventoryTransactionRepo.GetInventoryTransactionsByItemID(itemid, out error); if (error != "" || invtms == null) { if (error == ConError.Status.NOTFOUND) { return(Content(HttpStatusCode.NotFound, "InventoryTransaction Not Found")); } return(Content(HttpStatusCode.BadRequest, error)); } return(Ok(invtms)); }
public IHttpActionResult UpdateInventoryTransaction(InventoryTransactionModel invt) { string error = ""; InventoryTransactionModel invtm = InventoryTransactionRepo.UpdateInventoryTransaction(invt, out error); if (error != "" || invtm == null) { if (error == ConError.Status.NOTFOUND) { return(Content(HttpStatusCode.NotFound, "InventoryTransaction Not Found")); } return(Content(HttpStatusCode.BadRequest, error)); } return(Ok(invtm)); }
public IHttpActionResult GetInventoryTransactionByTransDate(DateTime startdate, DateTime enddate) { string error = ""; List <InventoryTransactionModel> invtms = InventoryTransactionRepo.GetInventoryTransactionsByTransDateRange(startdate, enddate.AddDays(1), out error); if (error != "" || invtms == null) { if (error == ConError.Status.NOTFOUND) { return(Content(HttpStatusCode.NotFound, "InventoryTransaction Not Found")); } return(Content(HttpStatusCode.BadRequest, error)); } return(Ok(invtms)); }
public IHttpActionResult GetAllInventoryTransactions() { // declare and initialize error variable to accept the error from Repo string error = ""; // get the list from inventorytransactionrepo and will insert the error if there is one List <InventoryTransactionModel> invtms = InventoryTransactionRepo.GetAllInventoryTransactions(out error); // if the erorr is not blank or the inventorytransaction list is null if (error != "" || invtms == null) { // if the error is 404 if (error == ConError.Status.NOTFOUND) { return(Content(HttpStatusCode.NotFound, "InventoryTransactions Not Found")); } // if the error is other one return(Content(HttpStatusCode.BadRequest, error)); } // if there is no error return(Ok(invtms)); }