예제 #1
0
        public DeliveryAdviceRepository(ProjectManagerEntities totalSalesPortalEntities)
            : base(totalSalesPortalEntities, "DeliveryAdviceEditable", "DeliveryAdviceApproved", null, "DeliveryAdviceVoidable")
        {
            Helpers.SqlProgrammability.Commons.Customer customer = new Helpers.SqlProgrammability.Commons.Customer(totalSalesPortalEntities);
            customer.RestoreProcedure();

            Helpers.SqlProgrammability.Commons.Project project = new Helpers.SqlProgrammability.Commons.Project(totalSalesPortalEntities);
            project.RestoreProcedure();


            Helpers.SqlProgrammability.Commons.PaymentTerm paymentTerm = new Helpers.SqlProgrammability.Commons.PaymentTerm(totalSalesPortalEntities);
            paymentTerm.RestoreProcedure();


            Helpers.SqlProgrammability.Commons.Employee employee = new Helpers.SqlProgrammability.Commons.Employee(totalSalesPortalEntities);
            employee.RestoreProcedure();


            Helpers.SqlProgrammability.Purchases.PurchaseOrder purchaseOrder = new Helpers.SqlProgrammability.Purchases.PurchaseOrder(totalSalesPortalEntities);
            purchaseOrder.RestoreProcedure();

            return;


            Helpers.SqlProgrammability.Inventories.HandlingUnit handlingUnit = new Helpers.SqlProgrammability.Inventories.HandlingUnit(totalSalesPortalEntities);
            handlingUnit.RestoreProcedure();


            Helpers.SqlProgrammability.Inventories.GoodsIssue goodsIssue = new Helpers.SqlProgrammability.Inventories.GoodsIssue(totalSalesPortalEntities);
            goodsIssue.RestoreProcedure();

            Helpers.SqlProgrammability.Reports.SaleReports saleReports = new Helpers.SqlProgrammability.Reports.SaleReports(totalSalesPortalEntities);
            saleReports.RestoreProcedure();


            Helpers.SqlProgrammability.Accounts.AccountInvoice accountInvoice = new Helpers.SqlProgrammability.Accounts.AccountInvoice(totalSalesPortalEntities);
            accountInvoice.RestoreProcedure();



            Helpers.SqlProgrammability.Commons.AccessControl accessControl = new Helpers.SqlProgrammability.Commons.AccessControl(totalSalesPortalEntities);
            accessControl.RestoreProcedure();



            Helpers.SqlProgrammability.Commons.Commons commons = new Helpers.SqlProgrammability.Commons.Commons(totalSalesPortalEntities);
            commons.RestoreProcedure();



            Helpers.SqlProgrammability.Sales.DeliveryAdvice deliveryAdvice = new Helpers.SqlProgrammability.Sales.DeliveryAdvice(totalSalesPortalEntities);
            deliveryAdvice.RestoreProcedure();



            Helpers.SqlProgrammability.Inventories.GoodsDelivery goodsDelivery = new Helpers.SqlProgrammability.Inventories.GoodsDelivery(totalSalesPortalEntities);
            goodsDelivery.RestoreProcedure();



            Helpers.SqlProgrammability.Accounts.Receipt receipt = new Helpers.SqlProgrammability.Accounts.Receipt(totalSalesPortalEntities);
            receipt.RestoreProcedure();



            Helpers.SqlProgrammability.Inventories.Inventories inventories = new Helpers.SqlProgrammability.Inventories.Inventories(totalSalesPortalEntities);
            inventories.RestoreProcedure();
        }
예제 #2
0
        public void CreateStoredProcedure()
        {
            //return;

            Helpers.SqlProgrammability.Inventories.WarehouseTransfer warehouseTransfer = new Helpers.SqlProgrammability.Inventories.WarehouseTransfer(totalSmartPortalEntities);
            warehouseTransfer.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Inventories.TransferOrder transferOrder = new Helpers.SqlProgrammability.Inventories.TransferOrder(totalSmartPortalEntities);
            transferOrder.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Inventories.WarehouseAdjustment warehouseAdjustment = new Helpers.SqlProgrammability.Inventories.WarehouseAdjustment(totalSmartPortalEntities);
            warehouseAdjustment.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Inventories.MaterialIssue materialIssue = new Helpers.SqlProgrammability.Inventories.MaterialIssue(totalSmartPortalEntities);
            materialIssue.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Commons.Commodity commodity = new Helpers.SqlProgrammability.Commons.Commodity(totalSmartPortalEntities);
            commodity.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Productions.PlannedOrder plannedOrder = new Helpers.SqlProgrammability.Productions.PlannedOrder(totalSmartPortalEntities);
            plannedOrder.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Productions.ProductionOrder productionOrder = new Helpers.SqlProgrammability.Productions.ProductionOrder(totalSmartPortalEntities);
            productionOrder.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Productions.SemifinishedProduct semifinishedProduct = new Helpers.SqlProgrammability.Productions.SemifinishedProduct(totalSmartPortalEntities);
            semifinishedProduct.RestoreProcedure();

            Helpers.SqlProgrammability.Productions.SemifinishedHandover semifinishedHandover = new Helpers.SqlProgrammability.Productions.SemifinishedHandover(totalSmartPortalEntities);
            semifinishedHandover.RestoreProcedure();

            Helpers.SqlProgrammability.Productions.FinishedProduct finishedProduct = new Helpers.SqlProgrammability.Productions.FinishedProduct(totalSmartPortalEntities);
            finishedProduct.RestoreProcedure();

            Helpers.SqlProgrammability.Productions.FinishedHandover finishedHandover = new Helpers.SqlProgrammability.Productions.FinishedHandover(totalSmartPortalEntities);
            finishedHandover.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Purchases.PurchaseRequisition purchaseRequisition = new Helpers.SqlProgrammability.Purchases.PurchaseRequisition(totalSmartPortalEntities);
            purchaseRequisition.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Commons.ProductionLine productionLine = new Helpers.SqlProgrammability.Commons.ProductionLine(totalSmartPortalEntities);
            productionLine.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Commons.Mold mold = new Helpers.SqlProgrammability.Commons.Mold(totalSmartPortalEntities);
            mold.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Commons.Workshift workshift = new Helpers.SqlProgrammability.Commons.Workshift(totalSmartPortalEntities);
            workshift.RestoreProcedure();



            //return;
            Helpers.SqlProgrammability.Generals.AccessControl accessControl = new Helpers.SqlProgrammability.Generals.AccessControl(totalSmartPortalEntities);
            accessControl.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Inventories.GoodsReceipt goodsReceipt = new Helpers.SqlProgrammability.Inventories.GoodsReceipt(totalSmartPortalEntities);
            goodsReceipt.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Reports.ProductionReports productionReports = new Helpers.SqlProgrammability.Reports.ProductionReports(totalSmartPortalEntities);
            productionReports.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Reports.InventoryReports inventoryReports = new Helpers.SqlProgrammability.Reports.InventoryReports(totalSmartPortalEntities);
            inventoryReports.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Analysis.Report report = new Helpers.SqlProgrammability.Analysis.Report(totalSmartPortalEntities);
            report.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Commons.Customer customer = new Helpers.SqlProgrammability.Commons.Customer(totalSmartPortalEntities);
            customer.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Sales.SalesOrder salesOrder = new Helpers.SqlProgrammability.Sales.SalesOrder(totalSmartPortalEntities);
            salesOrder.RestoreProcedure();

            //return;


            Helpers.SqlProgrammability.Sales.DeliveryAdvice deliveryAdvice = new Helpers.SqlProgrammability.Sales.DeliveryAdvice(totalSmartPortalEntities);
            deliveryAdvice.RestoreProcedure();

            Helpers.SqlProgrammability.Commons.Bom bom = new Helpers.SqlProgrammability.Commons.Bom(totalSmartPortalEntities);
            bom.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Generals.UserReference userReference = new Helpers.SqlProgrammability.Generals.UserReference(totalSmartPortalEntities);
            userReference.RestoreProcedure();



            return;

            Helpers.SqlProgrammability.Reports.SaleReports saleReports = new Helpers.SqlProgrammability.Reports.SaleReports(totalSmartPortalEntities);
            saleReports.RestoreProcedure();



            return;

            return;

            Helpers.SqlProgrammability.Accounts.Receipt receipt = new Helpers.SqlProgrammability.Accounts.Receipt(totalSmartPortalEntities);
            receipt.RestoreProcedure();



            return;

            return;

            Helpers.SqlProgrammability.Inventories.HandlingUnit handlingUnit = new Helpers.SqlProgrammability.Inventories.HandlingUnit(totalSmartPortalEntities);
            handlingUnit.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Inventories.GoodsIssue goodsIssue = new Helpers.SqlProgrammability.Inventories.GoodsIssue(totalSmartPortalEntities);
            goodsIssue.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Commons.CommodityPrice commodityPrice = new Helpers.SqlProgrammability.Commons.CommodityPrice(totalSmartPortalEntities);
            commodityPrice.RestoreProcedure();



            //return;

            //return;
            Helpers.SqlProgrammability.Inventories.Inventories inventories = new Helpers.SqlProgrammability.Inventories.Inventories(totalSmartPortalEntities);
            inventories.RestoreProcedure();



            //return;

            Helpers.SqlProgrammability.Sales.SalesReturn salesReturn = new Helpers.SqlProgrammability.Sales.SalesReturn(totalSmartPortalEntities);
            salesReturn.RestoreProcedure();



            //return;

            Helpers.SqlProgrammability.Commons.Promotion promotion = new Helpers.SqlProgrammability.Commons.Promotion(totalSmartPortalEntities);
            promotion.RestoreProcedure();

            //return;

            //AccountInvoice: NOT CHECK FOR Approved COMMPLETELY, PLS CHECK IT CAREFULLY LATER. (SaveRelative, GetPendingGoodsIssueDetails, ...). ALSO DO THE SAME CHECK FOR ALL OTHER MODULES
            //AccountInvoice: SHOULD SAVE BillingAddress

            Helpers.SqlProgrammability.Accounts.AccountInvoice accountInvoice = new Helpers.SqlProgrammability.Accounts.AccountInvoice(totalSmartPortalEntities);
            accountInvoice.RestoreProcedure();



            //return;


            Helpers.SqlProgrammability.Commons.Commons commons = new Helpers.SqlProgrammability.Commons.Commons(totalSmartPortalEntities);
            commons.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Commons.Employee employee = new Helpers.SqlProgrammability.Commons.Employee(totalSmartPortalEntities);
            employee.RestoreProcedure();



            //return;

            Helpers.SqlProgrammability.Accounts.CreditNote creditNote = new Helpers.SqlProgrammability.Accounts.CreditNote(totalSmartPortalEntities);
            creditNote.RestoreProcedure();

            //return;
            Helpers.SqlProgrammability.Inventories.GoodsDelivery goodsDelivery = new Helpers.SqlProgrammability.Inventories.GoodsDelivery(totalSmartPortalEntities);
            goodsDelivery.RestoreProcedure();
        }
예제 #3
0
        //1-Set Balance Date to 23.59.59
        //2-Copy 3 table (D.A/ GoodsIssue)
        //3-Add two Store procedure (Update balance/ WH journal)
        //4-Modify to VB Project, verify report 1280.rpt (-> create new report in SSRS -> publish to server)


        //31/03/18: CHU Y: SalesReturnSaveRelative CO NEN LAM GIONG NHU GoodsIssueSaveRelative? NHAM EXECUTE SPSKUBalanceUpdate TO UPDATE ???

        public DeliveryAdviceRepository(TotalSalesPortalEntities totalSalesPortalEntities)
            : base(totalSalesPortalEntities, "DeliveryAdviceEditable", "DeliveryAdviceApproved", null, "DeliveryAdviceVoidable")
        {
            return;

            return;

            return;

            Helpers.SqlProgrammability.Accounts.Receipt receipt = new Helpers.SqlProgrammability.Accounts.Receipt(totalSalesPortalEntities);
            receipt.RestoreProcedure();
            return;

            Helpers.SqlProgrammability.Commons.Promotion promotion = new Helpers.SqlProgrammability.Commons.Promotion(totalSalesPortalEntities);
            promotion.RestoreProcedure();

            return;

            Helpers.SqlProgrammability.Analysis.Report report = new Helpers.SqlProgrammability.Analysis.Report(totalSalesPortalEntities);
            report.RestoreProcedure();


            return;

            Helpers.SqlProgrammability.Generals.UserReference userReference = new Helpers.SqlProgrammability.Generals.UserReference(totalSalesPortalEntities);
            userReference.RestoreProcedure();


            return;

            Helpers.SqlProgrammability.Generals.AccessControl accessControl = new Helpers.SqlProgrammability.Generals.AccessControl(totalSalesPortalEntities);
            accessControl.RestoreProcedure();

            //return;


            Helpers.SqlProgrammability.Sales.DeliveryAdvice deliveryAdvice = new Helpers.SqlProgrammability.Sales.DeliveryAdvice(totalSalesPortalEntities);
            deliveryAdvice.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Reports.SaleReports saleReports = new Helpers.SqlProgrammability.Reports.SaleReports(totalSalesPortalEntities);
            saleReports.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Commons.Customer customer = new Helpers.SqlProgrammability.Commons.Customer(totalSalesPortalEntities);
            customer.RestoreProcedure();



            return;

            return;



            return;

            return;

            Helpers.SqlProgrammability.Inventories.HandlingUnit handlingUnit = new Helpers.SqlProgrammability.Inventories.HandlingUnit(totalSalesPortalEntities);
            handlingUnit.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Inventories.GoodsIssue goodsIssue = new Helpers.SqlProgrammability.Inventories.GoodsIssue(totalSalesPortalEntities);
            goodsIssue.RestoreProcedure();

            //return;

            Helpers.SqlProgrammability.Commons.CommodityPrice commodityPrice = new Helpers.SqlProgrammability.Commons.CommodityPrice(totalSalesPortalEntities);
            commodityPrice.RestoreProcedure();



            //return;

            //return;
            Helpers.SqlProgrammability.Inventories.Inventories inventories = new Helpers.SqlProgrammability.Inventories.Inventories(totalSalesPortalEntities);
            inventories.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Sales.SalesOrder salesOrder = new Helpers.SqlProgrammability.Sales.SalesOrder(totalSalesPortalEntities);
            salesOrder.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Sales.SalesReturn salesReturn = new Helpers.SqlProgrammability.Sales.SalesReturn(totalSalesPortalEntities);
            salesReturn.RestoreProcedure();



            //return;

            //AccountInvoice: NOT CHECK FOR Approved COMMPLETELY, PLS CHECK IT CAREFULLY LATER. (SaveRelative, GetPendingGoodsIssueDetails, ...). ALSO DO THE SAME CHECK FOR ALL OTHER MODULES
            //AccountInvoice: SHOULD SAVE BillingAddress

            Helpers.SqlProgrammability.Accounts.AccountInvoice accountInvoice = new Helpers.SqlProgrammability.Accounts.AccountInvoice(totalSalesPortalEntities);
            accountInvoice.RestoreProcedure();



            //return;


            Helpers.SqlProgrammability.Commons.Commons commons = new Helpers.SqlProgrammability.Commons.Commons(totalSalesPortalEntities);
            commons.RestoreProcedure();


            //return;

            Helpers.SqlProgrammability.Commons.Employee employee = new Helpers.SqlProgrammability.Commons.Employee(totalSalesPortalEntities);
            employee.RestoreProcedure();



            //return;

            Helpers.SqlProgrammability.Accounts.CreditNote creditNote = new Helpers.SqlProgrammability.Accounts.CreditNote(totalSalesPortalEntities);
            creditNote.RestoreProcedure();



            //return;



            Helpers.SqlProgrammability.Inventories.GoodsDelivery goodsDelivery = new Helpers.SqlProgrammability.Inventories.GoodsDelivery(totalSalesPortalEntities);
            goodsDelivery.RestoreProcedure();
        }