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