public GenericService(IGenericRepository <TEntity> genericRepository, string functionNamePostSaveValidate, string functionNameSaveRelative)
: base(genericRepository)
{
this.genericRepository = genericRepository;
this.functionNamePostSaveValidate = functionNamePostSaveValidate;
this.functionNameSaveRelative = functionNameSaveRelative;
this.nmvnTaskID = (new TPrimitiveDto()).NMVNTaskID;
}
public DateTime GetEditLockedDate(int?locationID, GlobalEnums.NmvnTaskID nmvnTaskID)
{
DateTime?lockedDate = this.TotalSmartCodingEntities.GetLockedDate(locationID).Single();
if (lockedDate == null || lockedDate <= new DateTime(2016, 1, 1))
{
lockedDate = new DateTime(2016, 1, 1);
}
return((DateTime)lockedDate);
}
public DateTime GetEditLockedDate(int?locationID, GlobalEnums.NmvnTaskID nmvnTaskID)
{
DateTime?lockedDate = this.TotalSmartCodingEntities.Locations.Where(w => w.LocationID == locationID).FirstOrDefault().LockedDate;
if (lockedDate == null || lockedDate <= new DateTime(1999, 1, 1))
{
lockedDate = new DateTime(1999, 1, 1);
}
return((DateTime)lockedDate);
}
public bool GetUnVoidablePermitted(int?userID, GlobalEnums.NmvnTaskID nmvnTaskID, int?organizationalUnitID)
{
if (userID == null || userID == 0 || (int)nmvnTaskID == 0)
{
return(false);
}
bool?unVoidablePermitted = this.TotalSmartCodingEntities.GetUnVoidablePermitted(userID, (int)nmvnTaskID, organizationalUnitID).Single();
return(unVoidablePermitted == null ? false : (bool)unVoidablePermitted);
}
public bool GetShowDiscount(int?userID, GlobalEnums.NmvnTaskID nmvnTaskID)
{
if (userID == null || userID == 0 || (int)nmvnTaskID == 0)
{
return(false);
}
bool?showDiscount = this.TotalSmartCodingEntities.GetShowDiscount(userID, (int)nmvnTaskID).Single();
return(showDiscount == null ? false : (bool)showDiscount);
}
public GlobalEnums.AccessLevel GetAccessLevel(int?userID, GlobalEnums.NmvnTaskID nmvnTaskID, int?organizationalUnitID)
{
if (userID == null || userID == 0 || (int)nmvnTaskID == 0)
{
return(GlobalEnums.AccessLevel.Deny);
}
int?accessLevel = this.TotalBikePortalsEntities.GetAccessLevel(userID, (int)nmvnTaskID, organizationalUnitID).Single();
return(accessLevel == null || accessLevel == (int)GlobalEnums.AccessLevel.Deny ? GlobalEnums.AccessLevel.Deny : (accessLevel == (int)GlobalEnums.AccessLevel.Readable ? GlobalEnums.AccessLevel.Readable : (accessLevel == (int)GlobalEnums.AccessLevel.Editable ? GlobalEnums.AccessLevel.Editable : GlobalEnums.AccessLevel.Deny)));
}
public bool GetApprovalPermitted(int?userID, GlobalEnums.NmvnTaskID nmvnTaskID, int?organizationalUnitID)
{
if (userID == null || userID == 0 || (int)nmvnTaskID == 0)
{
return(false);
}
bool?approvalPermitted = this.TotalSalesPortalEntities.GetApprovalPermitted(userID, (int)nmvnTaskID, organizationalUnitID).Single();
return(approvalPermitted == null ? false : (bool)approvalPermitted);
}
private string GetRecyclatePendingWorkshiftsSQL(GlobalEnums.NmvnTaskID nmvnTaskID)
{
string queryString = "";
queryString = queryString + " SELECT Workshifts.WorkshiftID, Workshifts.EntryDate AS WorkshiftEntryDate, Workshifts.Code AS WorkshiftCode, Warehouses.WarehouseID, Warehouses.Code AS WarehouseCode, Warehouses.Name AS WarehouseName, NMVNTaskRemains.TotalQuantityRemains " + "\r\n";
queryString = queryString + " FROM (SELECT WorkshiftID, ROUND(SUM(" + this.nmvnTaskFailures(nmvnTaskID) + " + " + this.nmvnTaskSwarfs(nmvnTaskID) + " - RecycleWeights), " + (int)GlobalEnums.rndQuantity + ") AS TotalQuantityRemains FROM " + this.nmvnTaskTable(nmvnTaskID) + " WHERE Approved = 1 AND EntryDate >= CONVERT(smalldatetime, '" + new DateTime(2019, 7, 22).ToString("dd/MM/yyyy") + "',103) AND ROUND(" + this.nmvnTaskFailures(nmvnTaskID) + " + " + this.nmvnTaskSwarfs(nmvnTaskID) + " - RecycleWeights - RecycleLoss, " + (int)GlobalEnums.rndQuantity + ") > 0 " + " GROUP BY WorkshiftID) AS NMVNTaskRemains " + "\r\n";
queryString = queryString + " INNER JOIN Workshifts ON NMVNTaskRemains.WorkshiftID = Workshifts.WorkshiftID " + "\r\n";
queryString = queryString + " INNER JOIN Warehouses ON Warehouses.WarehouseID = 5 " + "\r\n";
return(queryString);
}
public virtual void AddRequireJsOptions()
{
GlobalEnums.NmvnTaskID moduleDetailID = this.ModuleDetailID;
int moduleID = this.baseService.GetModuleID(moduleDetailID);
MenuSession.SetModuleID(this.HttpContext, moduleID);
RequireJsOptions.Add("LocationID", this.baseService.LocationID, RequireJsOptionsScope.Page);
RequireJsOptions.Add("ModuleID", moduleID, RequireJsOptionsScope.Page);
RequireJsOptions.Add("ModuleDetailID", (int)moduleDetailID, RequireJsOptionsScope.Page);
RequireJsOptions.Add("NmvnTaskID", this.baseService.NmvnTaskID, RequireJsOptionsScope.Page);
}
private int GetDefaultModuleDetailID(GlobalEnums.NmvnTaskID nmvnTaskID, int userID)
{
var moduleDefault = this.totalSmartPortalEntities.ModuleDefaults.Where(w => w.TaskID == (int)nmvnTaskID && w.UserID == (int)userID).FirstOrDefault();
if (moduleDefault != null)
{
return(moduleDefault.ModuleDetailID);
}
{
var moduleDetail = this.totalSmartPortalEntities.ModuleDetails.Where(w => w.TaskID == (int)nmvnTaskID).FirstOrDefault();
return(moduleDetail != null ? moduleDetail.ModuleDetailID : 0);
}
}
public TabletMDI(GlobalEnums.NmvnTaskID nmvnTaskID, Form childForm)
{
InitializeComponent();
try
{
this.nmvnTaskID = nmvnTaskID;
this.childForm = childForm;
this.Size = new Size(960, 488); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog; this.MinimizeBox = false; this.MaximizeBox = false; this.WindowState = FormWindowState.Normal; this.textBoxFilters.Width = 296;
}
catch (Exception exception)
{
ExceptionHandlers.ShowExceptionMessageBox(this, exception);
}
}
public DateTime GetEditLockedDate(int?locationID, GlobalEnums.NmvnTaskID nmvnTaskID)
{
if (nmvnTaskID == GlobalEnums.NmvnTaskID.ServiceContract)
{
return(DateTime.Now.AddYears(-20));
}
else
{
DateTime?lockedDate = this.TotalSalesPortalEntities.Locations.Where(w => w.LocationID == locationID).FirstOrDefault().LockedDate;
if (lockedDate == null || lockedDate <= new DateTime(2016, 1, 1))
{
lockedDate = new DateTime(2016, 1, 1);
}
return((DateTime)lockedDate);
}
}
private string RecyclateSaveRelativeSQL(GlobalEnums.NmvnTaskID nmvnTaskID)
{
string queryString = " " + "\r\n";
queryString = queryString + " BEGIN " + "\r\n";
queryString = queryString + " UPDATE " + this.nmvnTaskTable(nmvnTaskID) + " " + "\r\n";
queryString = queryString + " SET " + this.nmvnTaskTable(nmvnTaskID) + ".RecycleWeights = ROUND(" + this.nmvnTaskTable(nmvnTaskID) + ".RecycleWeights + RecyclateDetails.Quantity * @SaveRelativeOption, " + (int)GlobalEnums.rndQuantity + "), " + "\r\n";
queryString = queryString + " " + this.nmvnTaskTable(nmvnTaskID) + ".RecycleLoss = IIF(@SaveRelativeOption = 1, ROUND(" + this.nmvnTaskFailures(nmvnTaskID) + " + " + this.nmvnTaskSwarfs(nmvnTaskID) + " - (" + this.nmvnTaskTable(nmvnTaskID) + ".RecycleWeights + RecyclateDetails.Quantity), " + (int)GlobalEnums.rndQuantity + "), 0) " + "\r\n"; //UPDATE: SET RecycleLoss = Remains, UNDO: SET RecycleLoss = 0
queryString = queryString + " FROM RecyclateDetails " + "\r\n";
queryString = queryString + " INNER JOIN " + this.nmvnTaskTable(nmvnTaskID) + " ON (" + this.nmvnTaskTable(nmvnTaskID) + ".Approved = 1 OR @SaveRelativeOption = -1) AND RecyclateDetails.RecyclateID = @EntityID AND RecyclateDetails." + this.nmvnTaskPrimaryKey(nmvnTaskID) + " = " + this.nmvnTaskTable(nmvnTaskID) + "." + this.nmvnTaskPrimaryKey(nmvnTaskID) + "\r\n";
queryString = queryString + " SET @affectedRows = @@ROWCOUNT; " + "\r\n";
queryString = queryString + " END " + "\r\n";
return(queryString);
}
public static string ReferencePrefix(GlobalEnums.NmvnTaskID nmvnTaskID)
{
switch (nmvnTaskID)
{
case GlobalEnums.NmvnTaskID.Batch:
return("A");
case GlobalEnums.NmvnTaskID.BatchMaster:
return("F");
case GlobalEnums.NmvnTaskID.PurchaseOrder:
return("D");
case GlobalEnums.NmvnTaskID.PurchaseInvoice:
return("H");
case GlobalEnums.NmvnTaskID.Pickup:
return("P");
case GlobalEnums.NmvnTaskID.GoodsReceipt:
return("R");
case GlobalEnums.NmvnTaskID.SalesOrder:
return("O");
case GlobalEnums.NmvnTaskID.DeliveryAdvice:
return("D");
case GlobalEnums.NmvnTaskID.SalesReturn:
return("SR");
case GlobalEnums.NmvnTaskID.GoodsIssue:
return("K");
case GlobalEnums.NmvnTaskID.TransferOrder:
return("TO");
case GlobalEnums.NmvnTaskID.WarehouseAdjustment:
return("WA");
default:
return("A");
}
}
private string BUILDSQLNew(GlobalEnums.NmvnTaskID nmvnTaskID)
{
string queryString = "";
if (nmvnTaskID == GlobalEnums.NmvnTaskID.SemifinishedProductRecyclate)
{
queryString = queryString + " SELECT 0 AS RecyclateDetailID, 0 AS RecyclateID, SemifinishedProducts.SemifinishedProductID, NULL AS FinishedProductPackageID, NULL AS FinishedItemDetailID, SemifinishedProducts.EntryDate AS RootEntryDate, SemifinishedProducts.Reference AS RootReference, ProductionLines.Code AS ProductionLineCode, FirmOrders.Code AS FirmOrderCode, FirmOrders.Specification, " + "\r\n";
queryString = queryString + " Commodities.CommodityID, Commodities.Code AS CommodityCode, Commodities.CommodityTypeID, Commodities.RecycleCommodityID, RecycleCommodities.Code AS RecycleCommodityCode, RecycleCommodities.Name AS RecycleCommodityName, RecycleCommodities.CommodityTypeID AS RecycleCommodityTypeID, SemifinishedProducts.RejectWeights AS QuantityFailures, SemifinishedProducts.FailureWeights AS QuantitySwarfs, ISNULL(ROUND(SemifinishedProducts.RejectWeights + SemifinishedProducts.FailureWeights - SemifinishedProducts.RecycleWeights, " + (int)GlobalEnums.rndQuantity + "), 0) AS QuantityRemains, 0.0 AS Quantity " + "\r\n"; //QuantityRemains NOT INCLUDED RecycleLoss, BUT: CHECK PENDING MUST MINUS RecycleLoss!!!!!!
queryString = queryString + " FROM SemifinishedProducts " + "\r\n";
queryString = queryString + " INNER JOIN ProductionLines ON SemifinishedProducts.WorkshiftID = @WorkshiftID AND SemifinishedProducts.Approved = 1 AND ROUND(SemifinishedProducts.RejectWeights + SemifinishedProducts.FailureWeights - SemifinishedProducts.RecycleWeights - SemifinishedProducts.RecycleLoss, " + (int)GlobalEnums.rndQuantity + ") > 0 AND SemifinishedProducts.ProductionLineID = ProductionLines.ProductionLineID " + "\r\n";
queryString = queryString + " INNER JOIN FirmOrders ON SemifinishedProducts.FirmOrderID = FirmOrders.FirmOrderID " + "\r\n";
queryString = queryString + " INNER JOIN MaterialIssueDetails ON SemifinishedProducts.MaterialIssueDetailID = MaterialIssueDetails.MaterialIssueDetailID " + "\r\n";
queryString = queryString + " INNER JOIN Commodities ON MaterialIssueDetails.CommodityID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " LEFT JOIN Commodities AS RecycleCommodities ON Commodities.RecycleCommodityID = RecycleCommodities.CommodityID " + "\r\n";
}
if (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedProductRecyclate)
{
queryString = queryString + " SELECT 0 AS RecyclateDetailID, 0 AS RecyclateID, NULL AS SemifinishedProductID, FinishedProductPackages.FinishedProductPackageID, NULL AS FinishedItemDetailID, FinishedProductPackages.EntryDate AS RootEntryDate, FinishedProductPackages.Reference AS RootReference, NULL AS ProductionLineCode, FirmOrders.Code AS FirmOrderCode, FirmOrders.Specification, " + "\r\n";
queryString = queryString + " Commodities.CommodityID, Commodities.Code AS CommodityCode, Commodities.CommodityTypeID, Commodities.RecycleCommodityID, RecycleCommodities.Code AS RecycleCommodityCode, RecycleCommodities.Name AS RecycleCommodityName, RecycleCommodities.CommodityTypeID AS RecycleCommodityTypeID, FinishedProductPackages.QuantityFailureWeights AS QuantityFailures, FinishedProductPackages.Swarfs AS QuantitySwarfs, ISNULL(ROUND(FinishedProductPackages.QuantityFailureWeights + FinishedProductPackages.Swarfs - FinishedProductPackages.RecycleWeights, " + (int)GlobalEnums.rndQuantity + "), 0) AS QuantityRemains, 0.0 AS Quantity " + "\r\n"; //QuantityRemains NOT INCLUDED RecycleLoss, BUT: CHECK PENDING MUST MINUS RecycleLoss!!!!!!
queryString = queryString + " FROM FinishedProductPackages " + "\r\n";
queryString = queryString + " INNER JOIN FirmOrders ON FinishedProductPackages.WorkshiftID = @WorkshiftID AND FinishedProductPackages.Approved = 1 AND ROUND(FinishedProductPackages.QuantityFailureWeights + FinishedProductPackages.Swarfs - FinishedProductPackages.RecycleWeights - FinishedProductPackages.RecycleLoss, " + (int)GlobalEnums.rndQuantity + ") > 0 AND FinishedProductPackages.FirmOrderID = FirmOrders.FirmOrderID " + "\r\n";
queryString = queryString + " INNER JOIN BomDetails ON FirmOrders.BomID = BomDetails.BomID " + "\r\n"; //NOTE: VERY IMPORTANT: HERE BomDetails HAVE ONLY ONE ROW!!!
queryString = queryString + " INNER JOIN Commodities ON BomDetails.MaterialID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " LEFT JOIN Commodities AS RecycleCommodities ON Commodities.RecycleCommodityID = RecycleCommodities.CommodityID " + "\r\n";
}
if (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedItemRecyclate)
{
queryString = queryString + " SELECT 0 AS RecyclateDetailID, 0 AS RecyclateID, NULL AS SemifinishedProductID, NULL AS FinishedProductPackageID, FinishedItemDetails.FinishedItemDetailID, FinishedItemDetails.EntryDate AS RootEntryDate, FinishedItemDetails.Reference AS RootReference, ProductionLines.Code AS ProductionLineCode, FirmOrders.Code AS FirmOrderCode, FirmOrders.Specification, " + "\r\n";
queryString = queryString + " Commodities.CommodityID, Commodities.Code AS CommodityCode, Commodities.CommodityTypeID, Commodities.RecycleCommodityID, RecycleCommodities.Code AS RecycleCommodityCode, RecycleCommodities.Name AS RecycleCommodityName, RecycleCommodities.CommodityTypeID AS RecycleCommodityTypeID, FinishedItemDetails.QuantityFailure AS QuantityFailures, FinishedItemDetails.Swarfs AS QuantitySwarfs, ISNULL(ROUND(FinishedItemDetails.QuantityFailure + FinishedItemDetails.Swarfs - FinishedItemDetails.RecycleWeights, " + (int)GlobalEnums.rndQuantity + "), 0) AS QuantityRemains, 0.0 AS Quantity " + "\r\n"; //QuantityRemains NOT INCLUDED RecycleLoss, BUT: CHECK PENDING MUST MINUS RecycleLoss!!!!!!
queryString = queryString + " FROM FinishedItemDetails " + "\r\n";
queryString = queryString + " INNER JOIN ProductionLines ON FinishedItemDetails.WorkshiftID = @WorkshiftID AND FinishedItemDetails.Approved = 1 AND ROUND(FinishedItemDetails.QuantityFailure + FinishedItemDetails.Swarfs - FinishedItemDetails.RecycleWeights - FinishedItemDetails.RecycleLoss, " + (int)GlobalEnums.rndQuantity + ") > 0 AND FinishedItemDetails.ProductionLineID = ProductionLines.ProductionLineID " + "\r\n";
queryString = queryString + " INNER JOIN FirmOrders ON FinishedItemDetails.FirmOrderID = FirmOrders.FirmOrderID " + "\r\n";
queryString = queryString + " INNER JOIN Commodities ON FinishedItemDetails.CommodityID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " LEFT JOIN Commodities AS RecycleCommodities ON Commodities.RecycleCommodityID = RecycleCommodities.CommodityID " + "\r\n";
}
return(queryString);
}
private string BUILDSQLEdit(GlobalEnums.NmvnTaskID nmvnTaskID)
{
string queryString = "";
if (nmvnTaskID == GlobalEnums.NmvnTaskID.SemifinishedProductRecyclate)
{
queryString = queryString + " SELECT RecyclateDetails.RecyclateDetailID, RecyclateDetails.RecyclateID, RecyclateDetails.SemifinishedProductID, RecyclateDetails.FinishedProductPackageID, RecyclateDetails.FinishedItemDetailID, SemifinishedProducts.EntryDate AS RootEntryDate, SemifinishedProducts.Reference AS RootReference, ProductionLines.Code AS ProductionLineCode, FirmOrders.Code AS FirmOrderCode, FirmOrders.Specification, " + "\r\n";
queryString = queryString + " Commodities.CommodityID, Commodities.Code AS CommodityCode, Commodities.CommodityTypeID, Commodities.RecycleCommodityID, RecycleCommodities.Code AS RecycleCommodityCode, RecycleCommodities.Name AS RecycleCommodityName, RecycleCommodities.CommodityTypeID AS RecycleCommodityTypeID, SemifinishedProducts.RejectWeights AS QuantityFailures, SemifinishedProducts.FailureWeights AS QuantitySwarfs, ISNULL(ROUND(SemifinishedProducts.RejectWeights + SemifinishedProducts.FailureWeights - SemifinishedProducts.RecycleWeights + RecyclateDetails.Quantity, " + (int)GlobalEnums.rndQuantity + "), 0) AS QuantityRemains, RecyclateDetails.Quantity " + "\r\n";
queryString = queryString + " FROM RecyclateDetails " + "\r\n";
queryString = queryString + " INNER JOIN SemifinishedProducts ON RecyclateDetails.RecyclateID = @RecyclateID AND RecyclateDetails.SemifinishedProductID = SemifinishedProducts.SemifinishedProductID " + "\r\n";
queryString = queryString + " INNER JOIN ProductionLines ON SemifinishedProducts.ProductionLineID = ProductionLines.ProductionLineID " + "\r\n";
queryString = queryString + " INNER JOIN FirmOrders ON SemifinishedProducts.FirmOrderID = FirmOrders.FirmOrderID " + "\r\n";
queryString = queryString + " INNER JOIN Commodities ON RecyclateDetails.CommodityID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " LEFT JOIN Commodities AS RecycleCommodities ON RecyclateDetails.RecycleCommodityID = RecycleCommodities.CommodityID " + "\r\n";
}
if (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedProductRecyclate)
{
queryString = queryString + " SELECT RecyclateDetails.RecyclateDetailID, RecyclateDetails.RecyclateID, RecyclateDetails.SemifinishedProductID, RecyclateDetails.FinishedProductPackageID, RecyclateDetails.FinishedItemDetailID, FinishedProductPackages.EntryDate AS RootEntryDate, FinishedProductPackages.Reference AS RootReference, NULL AS ProductionLineCode, FirmOrders.Code AS FirmOrderCode, FirmOrders.Specification, " + "\r\n";
queryString = queryString + " Commodities.CommodityID, Commodities.Code AS CommodityCode, Commodities.CommodityTypeID, Commodities.RecycleCommodityID, RecycleCommodities.Code AS RecycleCommodityCode, RecycleCommodities.Name AS RecycleCommodityName, RecycleCommodities.CommodityTypeID AS RecycleCommodityTypeID, FinishedProductPackages.QuantityFailureWeights AS QuantityFailures, FinishedProductPackages.Swarfs AS QuantitySwarfs, ISNULL(ROUND(FinishedProductPackages.QuantityFailureWeights + FinishedProductPackages.Swarfs - FinishedProductPackages.RecycleWeights + RecyclateDetails.Quantity, " + (int)GlobalEnums.rndQuantity + "), 0) AS QuantityRemains, RecyclateDetails.Quantity " + "\r\n";
queryString = queryString + " FROM RecyclateDetails " + "\r\n";
queryString = queryString + " INNER JOIN FinishedProductPackages ON RecyclateDetails.RecyclateID = @RecyclateID AND RecyclateDetails.FinishedProductPackageID = FinishedProductPackages.FinishedProductPackageID " + "\r\n";
queryString = queryString + " INNER JOIN FirmOrders ON FinishedProductPackages.FirmOrderID = FirmOrders.FirmOrderID " + "\r\n";
queryString = queryString + " INNER JOIN Commodities ON RecyclateDetails.CommodityID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " LEFT JOIN Commodities AS RecycleCommodities ON RecyclateDetails.RecycleCommodityID = RecycleCommodities.CommodityID " + "\r\n";
}
if (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedItemRecyclate)
{
queryString = queryString + " SELECT RecyclateDetails.RecyclateDetailID, RecyclateDetails.RecyclateID, RecyclateDetails.SemifinishedProductID, RecyclateDetails.FinishedProductPackageID, RecyclateDetails.FinishedItemDetailID, FinishedItemDetails.EntryDate AS RootEntryDate, FinishedItemDetails.Reference AS RootReference, ProductionLines.Code AS ProductionLineCode, FirmOrders.Code AS FirmOrderCode, FirmOrders.Specification, " + "\r\n";
queryString = queryString + " Commodities.CommodityID, Commodities.Code AS CommodityCode, Commodities.CommodityTypeID, Commodities.RecycleCommodityID, RecycleCommodities.Code AS RecycleCommodityCode, RecycleCommodities.Name AS RecycleCommodityName, RecycleCommodities.CommodityTypeID AS RecycleCommodityTypeID, FinishedItemDetails.QuantityFailure AS QuantityFailures, FinishedItemDetails.Swarfs AS QuantitySwarfs, ISNULL(ROUND(FinishedItemDetails.QuantityFailure + FinishedItemDetails.Swarfs - FinishedItemDetails.RecycleWeights + RecyclateDetails.Quantity, " + (int)GlobalEnums.rndQuantity + "), 0) AS QuantityRemains, RecyclateDetails.Quantity " + "\r\n";
queryString = queryString + " FROM RecyclateDetails " + "\r\n";
queryString = queryString + " INNER JOIN FinishedItemDetails ON RecyclateDetails.RecyclateID = @RecyclateID AND RecyclateDetails.FinishedItemDetailID = FinishedItemDetails.FinishedItemDetailID " + "\r\n";
queryString = queryString + " INNER JOIN ProductionLines ON FinishedItemDetails.ProductionLineID = ProductionLines.ProductionLineID " + "\r\n";
queryString = queryString + " INNER JOIN FirmOrders ON FinishedItemDetails.FirmOrderID = FirmOrders.FirmOrderID " + "\r\n";
queryString = queryString + " INNER JOIN Commodities ON RecyclateDetails.CommodityID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " LEFT JOIN Commodities AS RecycleCommodities ON RecyclateDetails.RecycleCommodityID = RecycleCommodities.CommodityID " + "\r\n";
}
return(queryString);
}
public static string ReferencePrefix(GlobalEnums.NmvnTaskID nmvnTaskID)
{
switch (nmvnTaskID)
{
case GlobalEnums.NmvnTaskID.PurchaseOrder:
return("D");
case GlobalEnums.NmvnTaskID.PurchaseInvoice:
return("H");
case GlobalEnums.NmvnTaskID.Quotation:
return("B");
case GlobalEnums.NmvnTaskID.SalesInvoice:
return(@"CASE WHEN @SalesInvoiceTypeID =
" + (int)GlobalEnums.SalesInvoiceTypeID.VehiclesInvoice + @" THEN 'X' ELSE
CASE WHEN @SalesInvoiceTypeID =
" + (int)GlobalEnums.SalesInvoiceTypeID.PartsInvoice + @" THEN 'P' ELSE
CASE WHEN @SalesInvoiceTypeID =
" + (int)GlobalEnums.SalesInvoiceTypeID.ServicesInvoice + @" THEN 'S' ELSE '#' END
END END");
case GlobalEnums.NmvnTaskID.GoodsReceipt:
return("N");
case GlobalEnums.NmvnTaskID.ServiceContract:
return("H");
case GlobalEnums.NmvnTaskID.TransferOrder:
return("LD");
case GlobalEnums.NmvnTaskID.StockTransfer:
return(@"CASE WHEN @StockTransferTypeID =
" + (int)GlobalEnums.StockTransferTypeID.VehicleTransfer + @" THEN 'DX' ELSE
CASE WHEN @StockTransferTypeID =
" + (int)GlobalEnums.StockTransferTypeID.PartTransfer + @" THEN 'DP' ELSE '#' END
END");
default:
return("");
}
}
private string GetRecyclateViewPackagesSQL(GlobalEnums.NmvnTaskID nmvnTaskID)
{
string queryString = "";
queryString = queryString + " BEGIN " + "\r\n";
queryString = queryString + " SELECT RecyclatePackages.RecyclatePackageID, RecyclatePackages.RecyclateID, RecyclatePackages.CommodityID, Commodities.Code AS CommodityCode, Commodities.Name AS CommodityName, RecyclatePackages.CommodityTypeID, RecyclatePackages.BatchID, RecyclatePackages.BatchEntryDate, " + "\r\n";
queryString = queryString + " SFP_TABLE.QuantityFailures, SFP_TABLE.QuantitySwarfs, SFP_TABLE.QuantityRemains, RecyclatePackages.Quantity, RecyclatePackages.Remarks " + "\r\n";
queryString = queryString + " FROM RecyclatePackages " + "\r\n";
queryString = queryString + " INNER JOIN Commodities ON RecyclatePackages.RecyclateID = @RecyclateID AND RecyclatePackages.CommodityID = Commodities.CommodityID " + "\r\n";
queryString = queryString + " INNER JOIN (SELECT RecyclateDetails.RecycleCommodityID, SUM(" + this.nmvnTaskFailures(nmvnTaskID) + ") AS QuantityFailures, SUM(" + this.nmvnTaskSwarfs(nmvnTaskID) + ") AS QuantitySwarfs, SUM(ROUND(" + this.nmvnTaskFailures(nmvnTaskID) + " + " + this.nmvnTaskSwarfs(nmvnTaskID) + " - " + this.nmvnTaskTable(nmvnTaskID) + ".RecycleWeights + RecyclateDetails.Quantity, " + (int)GlobalEnums.rndQuantity + ")) AS QuantityRemains " + "\r\n";
queryString = queryString + " FROM RecyclateDetails " + "\r\n";
queryString = queryString + " INNER JOIN " + this.nmvnTaskTable(nmvnTaskID) + " ON RecyclateDetails.RecyclateID = @RecyclateID AND RecyclateDetails." + this.nmvnTaskPrimaryKey(nmvnTaskID) + " = " + this.nmvnTaskTable(nmvnTaskID) + "." + this.nmvnTaskPrimaryKey(nmvnTaskID) + "\r\n";
queryString = queryString + " GROUP BY RecyclateDetails.RecycleCommodityID " + "\r\n";
queryString = queryString + " )SFP_TABLE ON RecyclatePackages.CommodityID = SFP_TABLE.RecycleCommodityID " + "\r\n";
queryString = queryString + " END " + "\r\n";
return(queryString);
}
public int GetModuleID(GlobalEnums.NmvnTaskID nmvnTaskID, int userID, ref int moduleDetailID)
{
int localModuleDetailID = moduleDetailID;
if (localModuleDetailID == 0)
{
localModuleDetailID = this.GetDefaultModuleDetailID(nmvnTaskID, userID);
}
var moduleDetail = this.totalSmartPortalEntities.ModuleDetails.Where(w => w.TaskID == (int)nmvnTaskID && w.ModuleDetailID == localModuleDetailID).FirstOrDefault();
if (moduleDetail == null)
{
localModuleDetailID = this.GetDefaultModuleDetailID(nmvnTaskID, userID);
moduleDetail = this.totalSmartPortalEntities.ModuleDetails.Where(w => w.TaskID == (int)nmvnTaskID && w.ModuleDetailID == localModuleDetailID).FirstOrDefault();
}
moduleDetailID = localModuleDetailID;
return(moduleDetail != null ? moduleDetail.ModuleID : 0);
}
private string BUILDSQL(GlobalEnums.NmvnTaskID nmvnTaskID)
{
string queryString = "" + "\r\n";
queryString = queryString + " BEGIN " + "\r\n";
queryString = queryString + " IF (@RecyclateID > 0) " + "\r\n";
queryString = queryString + " BEGIN " + "\r\n";
queryString = queryString + " " + this.BUILDSQLEdit(nmvnTaskID) + "\r\n";
queryString = queryString + " ORDER BY ProductionLineCode, " + this.nmvnTaskTable(nmvnTaskID) + "." + this.nmvnTaskPrimaryKey(nmvnTaskID) + "\r\n";
queryString = queryString + " END " + "\r\n";
queryString = queryString + " ELSE " + "\r\n";
queryString = queryString + " BEGIN " + "\r\n";
queryString = queryString + " " + this.BUILDSQLNew(nmvnTaskID) + "\r\n";
queryString = queryString + " ORDER BY ProductionLineCode, " + this.nmvnTaskTable(nmvnTaskID) + "." + this.nmvnTaskPrimaryKey(nmvnTaskID) + "\r\n";
queryString = queryString + " END " + "\r\n";
queryString = queryString + " END " + "\r\n";
return(queryString);
}
public virtual IQueryable <TEntity> Loading(string aspUserID, GlobalEnums.NmvnTaskID nmvnTaskID)//for Loading (09/07/2015) - let review and optimize Loading laster
{
int userID = this.TotalBikePortalsEntities.AspNetUsers.Where(w => w.Id == aspUserID).FirstOrDefault().UserID;
return(this.modelDbSet.Where(w => this.TotalBikePortalsEntities.AccessControls.Where(acl => acl.UserID == userID && acl.NMVNTaskID == (int)nmvnTaskID && acl.AccessLevel > 0).Select(s => s.OrganizationalUnitID).Contains(w.OrganizationalUnitID)));
}
public MasterMDI(GlobalEnums.NmvnTaskID nmvnTaskID, Form loadedView, bool isMainView)
{
InitializeComponent();
try
{
this.nmvnTaskID = nmvnTaskID;
IModuleAPIRepository moduleAPIRepository = CommonNinject.Kernel.Get <IModuleAPIRepository>();
this.moduleAPIs = new ModuleAPIs(moduleAPIRepository);
if (GlobalEnums.NMVNOnly)
{
this.panelTopRight.Visible = false;
}
switch (this.nmvnTaskID)
{
case GlobalEnums.NmvnTaskID.SmartCoding:
this.buttonEscape.Visible = false;
this.buttonLoading.Visible = false;
this.buttonNew.Visible = false;
this.buttonEdit.Visible = false;
this.buttonSave.Visible = false;
this.buttonDelete.Visible = false;
this.buttonImport.Visible = false;
this.buttonExport.Visible = false;
this.toolStripSeparatorImport.Visible = false;
this.buttonApprove.Visible = false;
this.buttonVoid.Visible = false;
this.toolStripSeparatorApprove.Visible = false;
this.toolStripSeparatorVoid.Visible = false;
this.buttonPrint.Visible = false;
this.buttonPrintPreview.Visible = false;
this.toolStripSeparatorPrint.Visible = false;
this.separatorInputData.Visible = false;
this.labelSearchBarcode.Visible = false;
this.toolStripTopHead.Visible = false;
break;
case GlobalEnums.NmvnTaskID.Batch:
this.Size = new Size(1180, 732);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MinimizeBox = false; this.MaximizeBox = false; this.WindowState = FormWindowState.Normal;
this.panelTopRight.Visible = false;
this.panelTopLeft.Dock = DockStyle.Fill;
break;
case GlobalEnums.NmvnTaskID.FillingLine:
this.Size = new Size(620, 360);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MinimizeBox = false; this.MaximizeBox = false; this.WindowState = FormWindowState.Normal;
this.toolStripTopHead.Visible = false;
this.panelTopRight.Visible = false;
this.panelTopLeft.Dock = DockStyle.Fill;
this.statusStrip.Visible = false;
break;
default:
break;
}
this.beginingDateBinding = this.dateTimexLowerFillterDate.DataBindings.Add("Value", GlobalEnums.GlobalOptionSetting, CommonExpressions.PropertyName <OptionSetting>(p => p.LowerFillterDate), true, DataSourceUpdateMode.OnPropertyChanged);
this.endingDateBinding = this.dateTimexUpperFillterDate.DataBindings.Add("Value", GlobalEnums.GlobalOptionSetting, CommonExpressions.PropertyName <OptionSetting>(p => p.UpperFillterDate), true, DataSourceUpdateMode.OnPropertyChanged);
this.beginingDateBinding.BindingComplete += new BindingCompleteEventHandler(CommonControl_BindingComplete);
this.endingDateBinding.BindingComplete += new BindingCompleteEventHandler(CommonControl_BindingComplete);
this.buttonNaviBarHeaderVisibleBinding = this.buttonNaviBarHeader.DataBindings.Add("Visible", this.naviBarModuleMaster, "Collapsed", true, DataSourceUpdateMode.OnPropertyChanged);
this.buttonNaviBarHeaderVisibleBinding.Parse += new ConvertEventHandler(buttonNaviBarHeaderVisibleBinding_Parse);
this.buttonNaviBarHeaderVisibleBinding.Format += new ConvertEventHandler(buttonNaviBarHeaderVisibleBinding_Format);
#region fastNMVNTask
this.fastNMVNTask.AboutToCreateGroups += fastNMVNTask_AboutToCreateGroups;
this.fastNMVNTask.ShowGroups = true;
//this.fastNMVNTask.UseTranslucentHotItem = true; //DEFAULT HotItem
fastNMVNTask.UseTranslucentHotItem = false;
fastNMVNTask.UseHotItem = true;
fastNMVNTask.UseExplorerTheme = false;
RowBorderDecoration rbd = new RowBorderDecoration();
rbd.BorderPen = new Pen(Color.SeaGreen, 2);
rbd.FillBrush = null;
rbd.CornerRounding = 4.0f;
HotItemStyle hotItemStyle2 = new HotItemStyle();
hotItemStyle2.Decoration = rbd;
fastNMVNTask.HotItemStyle = hotItemStyle2;
#endregion fastNMVNTask
if (loadedView != null)
{
this.naviBarModuleMaster.Visible = false;
this.OpenView(loadedView);
}
else
{
this.InitializeModuleMaster();
//this.buttonNaviBarHeader_Click(this.buttonNaviBarHeader, new EventArgs());
}
DateTime buildDate = new FileInfo(Assembly.GetExecutingAssembly().Location).LastWriteTime;
this.statusVersion.Text = "Version 1.0." + GlobalVariables.ConfigVersionID(GlobalVariables.ConfigID).ToString() + ", Date: " + buildDate.ToString("dd/MM/yyyy HH:mm:ss");
this.labelDataSource.Text = this.moduleAPIs.DataSource;
this.labelApplicationRole.Text = ApplicationRoles.Required && ApplicationRoles.Name != "" && ApplicationRoles.ExceptionMessage == "" ? "[Application Role]" : "[Windows Authentication]";
this.comboSearchBarcode.Text = this.searchPlaceHolder;
this.toolUserReferences.Visible = ContextAttributes.User.IsDatabaseAdmin && false; //HIDE AT CHEVRON
this.toolUserGroupControls.Visible = ContextAttributes.User.IsDatabaseAdmin;
this.statusUserDescription.Text = ContextAttributes.User.FullyQualifiedUserName;
this.panelTopRight.Width = (this.nmvnTaskID == GlobalEnums.NmvnTaskID.SmartCoding ? 10 : this.labelSearchBarcode.Width) + this.comboSearchBarcode.Width + this.buttonSearchBarcode.Width + 10;
this.panelTop.Height = this.nmvnTaskID == GlobalEnums.NmvnTaskID.SmartCoding ? 61 : 39;
#region JUST DISABLE FOR CHEVRON
int?accessLevel = moduleAPIRepository.TotalSmartCodingEntities.GetAccessLevel(ContextAttributes.User.UserID, (int)TotalBase.Enums.GlobalEnums.NmvnTaskID.MonthEnd, 0).Single();
if (accessLevel < (int)TotalBase.Enums.GlobalEnums.AccessLevel.Readable)
{
this.buttonLockedDate.Enabled = false;
}
this.txtLockedDate.Visible = false;
//this.buttonLockedDate.Visible = false;
#endregion
this.isMainView = isMainView;
if (this.isMainView)
{
this.AddEventLogs("Log on application");
}
}
catch (Exception exception)
{
ExceptionHandlers.ShowExceptionMessageBox(this, exception);
}
}
public DateTime GetEditLockedDate(int?userID, GlobalEnums.NmvnTaskID nmvnTaskID)
{
return(DateTime.Now.AddYears(-1));
}
public MasterMDI(GlobalEnums.NmvnTaskID nmvnTaskID, Form loadedView)
{
InitializeComponent();
try
{
this.nmvnTaskID = nmvnTaskID;
this.moduleAPIs = new ModuleAPIs(CommonNinject.Kernel.Get <IModuleAPIRepository>());
switch (this.nmvnTaskID)
{
case GlobalEnums.NmvnTaskID.SmartCoding:
this.buttonLoading.Visible = false;
this.buttonNew.Visible = false;
this.buttonEdit.Visible = false;
this.buttonSave.Visible = false;
this.buttonDelete.Visible = false;
this.buttonImport.Visible = false;
this.buttonExport.Visible = false;
this.toolStripSeparatorImport.Visible = false;
this.buttonApprove.Visible = false;
this.buttonVoid.Visible = false;
this.toolStripSeparatorApprove.Visible = false;
this.toolStripSeparatorVoid.Visible = false;
this.buttonPrint.Visible = false;
this.buttonPrintPreview.Visible = false;
this.toolStripSeparatorPrint.Visible = false;
this.toolStripTopHead.Visible = false;
break;
case GlobalEnums.NmvnTaskID.Batch:
this.Size = new Size(1388, 740);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MinimizeBox = false; this.MaximizeBox = false; this.WindowState = FormWindowState.Normal;
this.panelTopRight.Visible = false;
this.panelTopLeft.Dock = DockStyle.Fill;
break;
case GlobalEnums.NmvnTaskID.BatchMaster:
if (GlobalVariables.ConfigID != (int)GlobalVariables.FillingLine.BatchMaster)
{
this.Size = new Size(1388, 740);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MinimizeBox = false; this.MaximizeBox = false; this.WindowState = FormWindowState.Normal;
}
//this.panelTopRight.Visible = false;
//this.panelTopLeft.Dock = DockStyle.Fill;
break;
case GlobalEnums.NmvnTaskID.Commodity:
this.Size = new Size(1388, 740);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MinimizeBox = false; this.MaximizeBox = false; this.WindowState = FormWindowState.Normal;
this.panelTopRight.Visible = false;
this.panelTopLeft.Dock = DockStyle.Fill;
break;
default:
break;
}
this.beginingDateBinding = this.textFillterLowerDate.TextBox.DataBindings.Add("Text", GlobalEnums.GlobalOptionSetting, "LowerFillterDate", true);
this.endingDateBinding = this.textFillterUpperDate.TextBox.DataBindings.Add("Text", GlobalEnums.GlobalOptionSetting, "UpperFillterDate", true);
this.beginingDateBinding.BindingComplete += new BindingCompleteEventHandler(CommonControl_BindingComplete);
this.endingDateBinding.BindingComplete += new BindingCompleteEventHandler(CommonControl_BindingComplete);
this.buttonNaviBarHeaderVisibleBinding = this.buttonNaviBarHeader.DataBindings.Add("Visible", this.naviBarModuleMaster, "Collapsed", true, DataSourceUpdateMode.OnPropertyChanged);
this.buttonNaviBarHeaderVisibleBinding.Parse += new ConvertEventHandler(buttonNaviBarHeaderVisibleBinding_Parse);
this.buttonNaviBarHeaderVisibleBinding.Format += new ConvertEventHandler(buttonNaviBarHeaderVisibleBinding_Format);
this.listViewTaskMaster.Dock = DockStyle.Fill;
this.listViewTaskMaster.Columns.Add(new ColumnHeader()
{
Width = this.listViewTaskMaster.Width
});
if (loadedView != null)
{
this.naviBarModuleMaster.Visible = false;
this.OpenView(loadedView);
}
else
{
this.InitializeModuleMaster();
this.buttonNaviBarHeader_Click(this.buttonNaviBarHeader, new EventArgs());
}
DateTime buildDate = new FileInfo(Assembly.GetExecutingAssembly().Location).LastWriteTime;
this.statusVersion.Text = "Version 1.0." + GlobalVariables.ConfigVersionID(GlobalVariables.ConfigID).ToString() + ", Date: " + buildDate.ToString("dd/MM/yyyy HH:mm:ss");
this.comboSearchBarcode.Text = this.searchPlaceHolder;
this.toolUserReferences.Enabled = true; //ContextAttributes.User.IsDatabaseAdmin;
this.statusUserDescription.Text = ContextAttributes.User.FullyQualifiedUserName;
this.panelTop.Height = this.nmvnTaskID == GlobalEnums.NmvnTaskID.SmartCoding ? 61 : 39;
}
catch (Exception exception)
{
ExceptionHandlers.ShowExceptionMessageBox(this, exception);
}
}
public MasterMDI(GlobalEnums.NmvnTaskID nmvnTaskID)
: this(nmvnTaskID, null)
{
}
private string nmvnTaskFailures(GlobalEnums.NmvnTaskID nmvnTaskID)
{
return(nmvnTaskID == GlobalEnums.NmvnTaskID.SemifinishedProductRecyclate ? "SemifinishedProducts.RejectWeights" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedProductRecyclate ? "FinishedProductPackages.QuantityFailureWeights" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedItemRecyclate ? "FinishedItemDetails.QuantityFailure" : "")));
}
private string nmvnTaskPrimaryKey(GlobalEnums.NmvnTaskID nmvnTaskID)
{
return(nmvnTaskID == GlobalEnums.NmvnTaskID.SemifinishedProductRecyclate ? "SemifinishedProductID" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedProductRecyclate ? "FinishedProductPackageID" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedItemRecyclate ? "FinishedItemDetailID" : "")));
}
private string nmvnTaskTable(GlobalEnums.NmvnTaskID nmvnTaskID)
{
return(nmvnTaskID == GlobalEnums.NmvnTaskID.SemifinishedProductRecyclate ? "SemifinishedProducts" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedProductRecyclate ? "FinishedProductPackages" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedItemRecyclate ? "FinishedItemDetails" : "")));
}
private string nmvnTaskSwarfs(GlobalEnums.NmvnTaskID nmvnTaskID)
{
return(nmvnTaskID == GlobalEnums.NmvnTaskID.SemifinishedProductRecyclate ? "SemifinishedProducts.FailureWeights" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedProductRecyclate ? "FinishedProductPackages.Swarfs" : (nmvnTaskID == GlobalEnums.NmvnTaskID.FinishedItemRecyclate ? "FinishedItemDetails.Swarfs" : "")));
}
public TabletMDI(GlobalEnums.NmvnTaskID nmvnTaskID)
: this(nmvnTaskID, null)
{
}
