public static void StartDTE()
{
DbEfFactory.StartDTE();
}
public async Task <List <DepotOperationResultStatus> > ProcessDepotBOMRequest(string targetFormulaKey, int rmFormulaLowerLimitValidation, int rmFormulaUpperLimitValidation, List <BOMIngredient> bomIngredients, int?parentBOMRequestId = 0, string BOMRequestTargetKey = null)
{
//assumptions: all formulations are in WERCS, so we don't need to go to Depot for anything here.
//if a formula for a material in the BOM isn't in WERCS, it should be imported into WERCS before starting the BOM formula request
List <DepotOperationResultStatus> bos_ret = new List <DepotOperationResultStatus>();
DepotOperationResultStatus validatebom_ret = ValidateBOMRequest(targetFormulaKey, bomIngredients);
if (validatebom_ret.ErrorMessage?.Length > 0)
{
bos_ret.Add(validatebom_ret);
return(bos_ret);
}
UpdatedBy = GetCurrentUser();
//List<DepotOperationResultStatus> request_ret = new List<DepotOperationResultStatus>();
//DepotOperationResultStatus r;
//string[] lookupKeys = new string[bomIngredients.Count() - 1];
//loop in get_bos_depot and see if there's errors
string RequestSourceSystem = "WERCS";
//added handling of PN in the RM list: 20201222
//List<BOMIngredient> pnParts = bomIngredients.Where(p => p.RMSource.ToLower().StartsWith("PN")).ToList<BOMIngredient>();
List <BOMIngredient> pnParts = bomIngredients.Where(p => p.RMKey.ToLower().Contains("_pnmaterial")).ToList <BOMIngredient>();
if (pnParts?.Any() ?? false)
{
//string pnKeys = string.Join(",", pnParts.Select(a => a.RMKey.ToString().Replace("_PNMaterial", "")));
//string[] pnKeysA;
//pnKeys = Regex.Replace(pnKeys, @"\r\n?|\n", ",");
//pnKeysA = pnKeys.Replace(" ", "").Split(','); //allow only one or no spaces between commas
string pncasTogether = "";
foreach (BOMIngredient part in bomIngredients)
{
if (part.RMKey.ToLower().Contains("_pnmaterial"))
{
pncasTogether = part.RMKey.Replace("_PNMaterial", "");
part.RMKey = pncasTogether.Substring(0, pncasTogether.IndexOf("/"));
part.RMCas = pncasTogether.Substring(pncasTogether.IndexOf("/") + 1);
//decimal rmPercent;
part.RMSource = "Wercs";
}
}
//get_bos_depot = await PassFormulaController.ProcessDepotRequest(prodKeys, sourceSystem: "Depot", overrideBOSErrors: true, formulaLowerPercentValidation: 0, formulaUpperPercentValidation: 0, existingRequestId: 0, parentBOMRequestId: savebom_ret.RequestId, BOMRequestTargetKey: targetFormulaKey);
//DepotOperationResultStatus savebomdetail_ret = DbEfFactory.ProcessBOMRequestPNMaterials(savebom_ret.RequestId, targetFormulaKey, pnParts, "Wercs");
}
DepotOperationResultStatus savebom_ret = DbEfFactory.AddDepotBOMRequest(targetFormulaKey, bomIngredients, rmFormulaLowerLimitValidation, rmFormulaUpperLimitValidation, "BOM Request", UpdatedBy, RequestSourceSystem);
bos_ret.Add(savebom_ret);
List <DepotOperationResultStatus> get_bos_depot = new List <DepotOperationResultStatus>();
string prodKeys = "";
bool depotLoadSuccess = true;
if (savebom_ret.RequestId == 0)
{
bos_ret.Add(new DepotOperationResultStatus {
RequestId = 0, ErrorMessage = "Error saving BOM request."
});
return(bos_ret);
}
List <BOMIngredient> depotParts = bomIngredients.Where(p => p.RMSource.ToLower().Contains("depot")).ToList <BOMIngredient>();
if (depotParts?.Any() ?? false)
{
prodKeys = string.Join(",", depotParts.Select(a => a.RMKey.ToString()));
get_bos_depot = await PassFormulaController.ProcessDepotRequest(prodKeys, sourceSystem : "Depot", overrideBOSErrors : true, formulaLowerPercentValidation : 0, formulaUpperPercentValidation : 0, existingRequestId : 0, parentBOMRequestId : savebom_ret.RequestId, BOMRequestTargetKey : targetFormulaKey);
foreach (DepotOperationResultStatus ret in get_bos_depot)
{
if (ret?.ErrorMessage?.Length > 0 || ret?.ResultCount == -1)
{
//bos_ret.Add(new DepotOperationResultStatus { RequestId = savebom_ret.RequestId, ErrorMessage = "Error Importing BOS for " + prodKeys + " from Depot." });
bos_ret.Add(ret);
depotLoadSuccess = false;
}
}
if (depotLoadSuccess)
{
bos_ret.Add(new DepotOperationResultStatus {
RequestId = savebom_ret.RequestId, SuccessMessage = "Import of BOS for " + prodKeys + " from Depot completed successfully."
});
}
//don't check depotLoadSuccess here... Request will be processed regardless and all errors (depot and wercs) will be on the status (result) page
/*
* else
* {
* return bos_ret;
* }
*/
}
//don't check depotLoadSuccess here... Request will be processed regardless and all errors (depot and wercs) will be on the result/status page
//if (depotLoadSuccess) //if no depotParts or depotParts processed successfully
//{
string processBOMRequest = ConfigurationManager.AppSettings["ProcessBOMRequest"] ?? "true";
if (string.Compare(processBOMRequest, "true", ignoreCase: true) == 0)
{
DepotOperationResultStatus savebomdetail_ret = DbEfFactory.ProcessBOMRequest(savebom_ret.RequestId, targetFormulaKey, "Wercs");
DbEfFactory.StartDTE(); //this may already be incoporated in StageBOMRequest
bos_ret.Add(savebomdetail_ret);
}
//}
return(bos_ret);
}