Every page in yarn management is involve in updating inventory. For this reason, all pages need conditions and restrictions to alter tables in the database.
Yarn Inventory
stored procedures
[x] Create an insert sp for new Yarn Code in the Inventory in case a new yarn is used. This SP should have an OUTPUT parameter to retrive the SCOPE_IDENTITY()
[x] Alter update SP. Now this SP have an OUTPUT parameter to indicate the number of affected rows.
[x] Alter the Inventory List SP. Now this procedure should only select rows with any value in the factories
[x] Create a Search SP to search for registers of this yarn code in the inventory table.
Service and parameters
[x] Modify names and parameters.
Pages
[x] In input page, transferred yarn page, used yarn page, before updating the inventory, it is now necessary to check if the yarn code is in the inventory. If not, insert a new register.
[x] In the input page, if the spYarn_InventoryUpdate (wich removes quantity from inventory) isn't executed successfully when the line has been selected for editing a record, it isn't possible to continue saving the new input in the inventory.
[x] In Transferred yarn Page, if the spYarn_InventoryUpdate (which removes quantity from "ToFactory", and adds the previous quantirty to "FromFactory") is not executed succesfully when the line has been selected for editing a record, it isn't possible to continue saving the new quantity for the transfer in the inventor, so it isn't possible to save the trsnfer in transfer table.
[x] In used yarn page, if thr spYarn_InventoryUpdate (which adds quantity to inventory) is not executed successfully when the line has benn selected for editing a record, it isn't possible to continue saving the new used yarn in the inventory, so it isn't possible to save this used yarn in the used Detail Table.
[x] Inventory page shows negative numbers in red and doesn't show 0values.
[x] Every page displays a message when the inventory has been updated.
[x] Change all swallSuccess messages for Toast messages
[x] Show CenterName Column en in every page (Input, TransferMaster, TransferDetail, UsedMaster, UsedDetail)
[x] Modify Delete dialogs in every page (YarnRequest, TransferRequest, Input, TransferMaster, TransferDetail, UsedMaster, UsedDetail).
[x] Fix the toast is deployed after close inventory method finishes (The first time it just shows a black rectangle, the second time the method finishes, it shows 2 correct toasts).
[ ] Fix logic in case is necessary change Yarn in Plan or PO when receiveYarn > 0. When receiveYarn>0 get all details with PlanId matches and remove their quantitys from the inventory and then add quantitys in the correct yarn in the inventory.
[ ] Fix logic in case is necessary change Factory in Plan or PO when receiveYarn > 0. When receiveYarn > 0 get all details with PlanId matches and remove their quantitys from the inventory and then add quantitys in the correct factory in the inventory.
[ ] Fix Yarn Name Filter in the add dialogs in Transfer and PO pages (When the dialog has been open for edit one record without Request code, the filter only bring the records with the yarn code).
[x] Agregate Request column in Transfer Master.
[x] Agregate a button in the toolbar for generate a Transfer Format from Transfer Master Page.
Every page in yarn management is involve in updating inventory. For this reason, all pages need conditions and restrictions to alter tables in the database.
Yarn Inventory
stored procedures
[x] Create an insert sp for new Yarn Code in the Inventory in case a new yarn is used. This SP should have an OUTPUT parameter to retrive the SCOPE_IDENTITY()
[x] Alter update SP. Now this SP have an OUTPUT parameter to indicate the number of affected rows.
[x] Alter the Inventory List SP. Now this procedure should only select rows with any value in the factories
[x] Create a Search SP to search for registers of this yarn code in the inventory table.
Service and parameters
[x] Modify names and parameters.
Pages
[x] In input page, transferred yarn page, used yarn page, before updating the inventory, it is now necessary to check if the yarn code is in the inventory. If not, insert a new register.
[x] In the input page, if the spYarn_InventoryUpdate (wich removes quantity from inventory) isn't executed successfully when the line has been selected for editing a record, it isn't possible to continue saving the new input in the inventory.
[x] In Transferred yarn Page, if the spYarn_InventoryUpdate (which removes quantity from "ToFactory", and adds the previous quantirty to "FromFactory") is not executed succesfully when the line has been selected for editing a record, it isn't possible to continue saving the new quantity for the transfer in the inventor, so it isn't possible to save the trsnfer in transfer table.
[x] In used yarn page, if thr spYarn_InventoryUpdate (which adds quantity to inventory) is not executed successfully when the line has benn selected for editing a record, it isn't possible to continue saving the new used yarn in the inventory, so it isn't possible to save this used yarn in the used Detail Table.
[x] Inventory page shows negative numbers in red and doesn't show 0values.
[x] Every page displays a message when the inventory has been updated.
[x] Change all swallSuccess messages for Toast messages
[x] Show CenterName Column en in every page (Input, TransferMaster, TransferDetail, UsedMaster, UsedDetail)
[x] Modify Delete dialogs in every page (YarnRequest, TransferRequest, Input, TransferMaster, TransferDetail, UsedMaster, UsedDetail).
[x] Apply format to Header text of every dialog.
[x] Change e-primary buttons.
[x] Apply general components.
[x] Allow viewer access for Koreans users (For UsedMasterPage, UsedDetailPage, TransferMasterPage, TransferDetailPage, POPage, InputPage)
[x] Allow manager access for Team leaders (For TransferRequestPage, YarnRequestPage)
[x] Print format of TransferRequest according to CenterId
[x] Print format of YarnRequest according to CenterId
[x] Print format of PO according to CenterId
[x] Apply color in columns according to information.