private void PackageIssueInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("PackageIssues", "PackageIssueID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.PackageIssue));
this.totalSmartPortalEntities.CreateTrigger("PackageIssueInitReference", simpleInitReference.CreateQuery());
string queryString = " @PackageIssueID int " + "\r\n";
queryString = queryString + " WITH ENCRYPTION " + "\r\n";
queryString = queryString + " AS " + "\r\n";
queryString = queryString + " SELECT TOP 1 Reference FROM PackageIssues WHERE PackageIssueID = @PackageIssueID " + "\r\n";
this.totalSmartPortalEntities.CreateStoredProcedure("PackageIssueGetReference", queryString);
}
private void PurchaseOrderInitReference()
{
////CHU Y: FOR EACH PROJECT: STANDARD TRIGGER KHÔNG CÓ TÙY BIẾN BY ProjectID. NOW: PurchaseOrderInitReference HAS BEEN MODIFY DIRECTLY BY SQL TOOL. HERE WE HAVE A COPY OF THE T-SQL
////BELOW IS THE FINAL (CORRECT) TRIGGER. WE MODIFY THIS TRIGGER FROM THE STANDARD TRIGGER
////USE [ProjectManager]
////GO
/////****** Object: Trigger [dbo].[PurchaseOrderInitReference] Script Date: 24/07/2017 10:18:03 ******/
////SET ANSI_NULLS ON
////GO
////SET QUOTED_IDENTIFIER ON
////GO
////ALTER TRIGGER [dbo].[PurchaseOrderInitReference]
//// ON [dbo].[PurchaseOrders] AFTER INSERT
//// AS
//// DECLARE @LocationID int SET @LocationID = (SELECT LocationID FROM Inserted)
//// DECLARE @EntityID int SET @EntityID = (SELECT PurchaseOrderID FROM Inserted)
//// DECLARE @EntryDate DateTime SET @EntryDate = (SELECT EntryDate FROM Inserted)
//// DECLARE @ProjectID int SET @ProjectID = (SELECT ProjectID FROM Inserted)
//// DECLARE @PrefixLetter varchar(10) SET @PrefixLetter = 'D'
//// DECLARE @columnNameMax int
//// SET @columnNameMax = (SELECT MAX(CAST( SUBSTRING(Reference, LEN(@PrefixLetter) + 1, CASE PATINDEX('%.%', Reference) WHEN 0 THEN LEN(Reference) - LEN(@PrefixLetter) ELSE PATINDEX('%.%', Reference) - 1 - LEN(@PrefixLetter) END) AS Int)) AS columnNameMax FROM PurchaseOrders WHERE LocationID = @LocationID AND ProjectID = @ProjectID
////) IF @columnNameMax IS NULL SET @columnNameMax = 1 ELSE SET @columnNameMax = @columnNameMax + 1 UPDATE PurchaseOrders
//// SET Reference = @PrefixLetter + RIGHT(CAST(100000000 + @columnNameMax as varchar), 6 - LEN(@PrefixLetter))
//// WHERE PurchaseOrderID = @EntityID
//// UPDATE PurchaseOrders SET PoNumber = RIGHT(Reference, 5) WHERE PurchaseOrderID = @EntityID
//14-JUL-2017: MR TUAN: NO NEED TO INIT REFERENCE BY PROJECT. JUST USE THE STANDARD TRIGGERR
SimpleInitReference simpleInitReference = new SimpleInitReference("PurchaseOrders", "PurchaseOrderID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.PurchaseOrder));
this.projectManagerEntities.CreateTrigger("PurchaseOrderInitReference", simpleInitReference.CreateQuery() + " UPDATE PurchaseOrders SET PoNumber = RIGHT(Reference, 5) WHERE PurchaseOrderID = @EntityID ");
}
private void SalesOrderInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("SalesOrders", "SalesOrderID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.SalesOrder));
this.totalSmartPortalEntities.CreateTrigger("SalesOrderInitReference", simpleInitReference.CreateQuery());
}
private void BatchMasterInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("BatchMasters", "BatchMasterID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.BatchMaster));
this.totalSmartCodingEntities.CreateTrigger("BatchMasterInitReference", simpleInitReference.CreateQuery());
}
private void AccountInvoiceInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("AccountInvoices", "AccountInvoiceID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.AccountInvoice));
this.totalBikePortalsEntities.CreateTrigger("AccountInvoiceInitReference", simpleInitReference.CreateQuery());
}
private void HandlingUnitInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("HandlingUnits", "HandlingUnitID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.HandlingUnit));
this.totalSalesPortalEntities.CreateTrigger("HandlingUnitInitReference", simpleInitReference.CreateQuery());
}
private void SemifinishedProductInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("SemifinishedProducts", "SemifinishedProductID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.SemifinishedProduct));
this.totalSmartPortalEntities.CreateTrigger("SemifinishedProductInitReference", simpleInitReference.CreateQuery());
}
private void FinishedItemInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("FinishedItems", "FinishedItemID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.FinishedItem));
this.totalSmartPortalEntities.CreateTrigger("FinishedItemInitReference", simpleInitReference.CreateQuery());
}
private void GoodsReceiptInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("GoodsReceipts", "GoodsReceiptID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.GoodsReceipt));
this.totalBikePortalsEntities.CreateTrigger("GoodsReceiptInitReference", simpleInitReference.CreateQuery());
}
private void PurchaseOrderInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("PurchaseOrders", "PurchaseOrderID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.PurchaseOrder));
this.totalBikePortalsEntities.CreateTrigger("PurchaseOrderInitReference", simpleInitReference.CreateQuery());
}
private void AccountInvoiceInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("AccountInvoices", "AccountInvoiceID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.AccountInvoice));
this.totalSalesPortalEntities.CreateTrigger("AccountInvoiceInitReference", simpleInitReference.CreateQuery());
}
private void ServiceContractInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("ServiceContracts", "ServiceContractID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.ServiceContract));
this.totalBikePortalsEntities.CreateTrigger("ServiceContractInitReference", simpleInitReference.CreateQuery());
}
private void QuotationInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("Quotations", "QuotationID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.Quotation));
this.totalBikePortalsEntities.CreateTrigger("QuotationInitReference", simpleInitReference.CreateQuery());
}
private void GoodsReceiptInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("GoodsReceipts", "GoodsReceiptID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.GoodsReceipt));
this.totalBikePortalsEntities.CreateTrigger("GoodsReceiptInitReference", simpleInitReference.CreateQuery());
}
private void ServiceContractInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("ServiceContracts", "ServiceContractID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.ServiceContract));
this.totalBikePortalsEntities.CreateTrigger("ServiceContractInitReference", simpleInitReference.CreateQuery());
}
private void DeliveryAdviceInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("DeliveryAdvices", "DeliveryAdviceID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.DeliveryAdvices));
this.totalSmartCodingEntities.CreateTrigger("DeliveryAdviceInitReference", simpleInitReference.CreateQuery());
}
private void BlendingInstructionInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("BlendingInstructions", "BlendingInstructionID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.BlendingInstruction));
this.totalSmartPortalEntities.CreateTrigger("BlendingInstructionInitReference", simpleInitReference.CreateQuery());
}
private void WarehouseAdjustmentInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("WarehouseAdjustments", "WarehouseAdjustmentID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.WarehouseAdjustments));
this.totalSmartCodingEntities.CreateTrigger("WarehouseAdjustmentInitReference", simpleInitReference.CreateQuery());
}
private void GoodsDeliveryInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("GoodsDeliveries", "GoodsDeliveryID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.GoodsDelivery));
this.totalSmartPortalEntities.CreateTrigger("GoodsDeliveryInitReference", simpleInitReference.CreateQuery());
}
private void MaterialIssueInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("MaterialIssues", "MaterialIssueID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.MaterialIssue));
this.totalSmartPortalEntities.CreateTrigger("MaterialIssueInitReference", simpleInitReference.CreateQuery());
}
private void QuotationInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("Quotations", "QuotationID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.Quotation));
this.totalBikePortalsEntities.CreateTrigger("QuotationInitReference", simpleInitReference.CreateQuery());
}
private void TransferOrderInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("TransferOrders", "TransferOrderID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.TransferOrder));
this.totalBikePortalsEntities.CreateTrigger("TransferOrderInitReference", simpleInitReference.CreateQuery());
}
private void CommoditySettingInitReference()
{
SimpleInitReference simpleInitReference = new SimpleInitReference("CommoditySettings", "CommoditySettingID", "Reference", ModelSettingManager.ReferenceLength, ModelSettingManager.ReferencePrefix(GlobalEnums.NmvnTaskID.CommoditySettings));
this.totalSmartCodingEntities.CreateTrigger("CommoditySettingInitReference", simpleInitReference.CreateQuery());
}