private void AddGlobalAndLocalItem(TransactionContext trxContext, ValueObjectList <MoldItemVo> moldItemInVo)
{
if (moldItemInVo != null && moldItemInVo.GetList().Count > 0)
{
foreach (MoldItemVo moldItemVo in moldItemInVo.GetList())
{
if (globalItemList.ContainsKey(moldItemVo.GlobalItemCode))
{
continue;
}
if (localItemList.ContainsKey(moldItemVo.LocalItemCode))
{
continue;
}
if (moldList.ContainsKey(moldItemVo.MoldCode))
{
moldItemVo.MoldId = (int)moldList[moldItemVo.MoldCode];
}
MoldItemVo moldItemOutVo = (MoldItemVo)addGlobalItemLocalItemCbm.Execute(trxContext, moldItemVo);
if (moldItemOutVo != null)
{
globalItemList.Add(moldItemOutVo.GlobalItemCode, moldItemOutVo.GlobalItemId);
localItemList.Add(moldItemOutVo.LocalItemCode, moldItemOutVo.LocalItemId);
}
}
}
}
private void AddModel(TransactionContext trxContext, ValueObjectList <MoldItemVo> moldModelInVo)
{
foreach (MoldItemVo moldModelVo in moldModelInVo.GetList())
{
// Checking existing data
Vo.ModelVo modelInVo = new Vo.ModelVo();
modelInVo.ModelCode = moldModelVo.ModelCode;
modelInVo.ModelName = moldModelVo.ModelCode;
ValueObjectList <ModelVo> modelCheckVo = (ValueObjectList <ModelVo>)checkModelMasterMntCbm.Execute(trxContext, modelInVo);
if (modelCheckVo != null && modelCheckVo.GetList() != null && modelCheckVo.GetList().Count > 0)
{
foreach (Vo.ModelVo curVo in modelCheckVo.GetList())
{
if (!modelList.ContainsKey(curVo.ModelCode))
{
modelList.Add(curVo.ModelCode, curVo.ModelId);
}
}
}
else
{
Vo.ModelVo modelOutVo = (Vo.ModelVo)addModelMasterMntCbm.Execute(trxContext, modelInVo);
modelList.Add(modelInVo.ModelCode, modelOutVo.ModelId);
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionFormatVo inVo = (InspectionFormatVo)vo;
InspectionFormatVo OutVo = null;
//InspectionFormatVo formatVo = (InspectionFormatVo)checkInspectionFormatCbm.Execute(trxContext, vo);
//if(formatVo != null && formatVo.AffectedCount > 0)
//{
// OutVo = new InspectionFormatVo();
// OutVo.AffectedCount = formatVo.AffectedCount;
// return OutVo;
//}
ItemLineInspectionFormatVo ItemlineinVo = new ItemLineInspectionFormatVo();
ItemlineinVo.LineId = inVo.LineId;
ItemlineinVo.SapItemCode = inVo.SapItemCode;
ItemLineInspectionFormatVo itemlineVo = (ItemLineInspectionFormatVo)checkItemLineInspectionFormatMasterMntCbm.Execute(trxContext, ItemlineinVo);
if (itemlineVo != null && itemlineVo.AffectedCount > 0)
{
OutVo = new InspectionFormatVo();
OutVo.AffectedCount = itemlineVo.AffectedCount;
return(OutVo);
}
return(OutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MasterMntCommonInVo inVo = (MasterMntCommonInVo)vo;
CbmController targetCbm = inVo.TargetCbm;
ValueObject targetInVo = inVo.TargetInVo;
ValueObject outVo = targetCbm.Execute(trxContext, targetInVo);
//invoke master mnt log DAO
if (inVo.IsLogging)
{
var stringwriter = new System.IO.StringWriter();
var serializer = new XmlSerializer(outVo.GetType());
serializer.Serialize(stringwriter, outVo);
//MasterMntUpdatedRecord logInVo = new MasterMntUpdatedRecord
//{
// TableName = "user",
// LogContents = stringwriter.ToString()
//};
// UpdateLogMasterMntCbm updateLogCbm = new UpdateLogMasterMntCbm();
//MasterMntUpdatedRecord logOutVo = (MasterMntUpdatedRecord)updateLogCbm.Execute(trxContext, logInVo);
}
return(outVo);
}
private void AddMold(TransactionContext trxContext, ValueObjectList <MoldDetailVo> moldInVo)
{
MoldDetailVo moldOutVo = null;
foreach (MoldDetailVo moldDetailVo in moldInVo.GetList())
{
ValueObjectList <MoldDetailVo> moldGetVo = (ValueObjectList <MoldDetailVo>)getMoldIdForExcelUploadCbm.Execute(trxContext, moldDetailVo);
if (moldGetVo != null && moldGetVo.GetList().Count > 0)
{
foreach (MoldDetailVo curVo in moldGetVo.GetList())
{
if (!moldList.ContainsKey(curVo.MoldCode))
{
moldList.Add(curVo.MoldCode, curVo.MoldId);
}
}
}
else
{
if (categoryList.ContainsKey(moldDetailVo.MoldCategoryCode))
{
moldDetailVo.MoldCategoryId = (int)categoryList[moldDetailVo.MoldCategoryCode];
}
moldOutVo = (MoldDetailVo)addMoldAndMoldDetailMasterMntCbm.Execute(trxContext, moldDetailVo);
moldList.Add(moldDetailVo.MoldCode, moldOutVo.MoldId);
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <MoldItemVo> inVo = (ValueObjectList <MoldItemVo>)vo;
if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
{
return(null);
}
MoldItemVo delInVo = inVo.GetList()[0];
deleteMoldItemCbm.Execute(trxContext, inVo.GetList()[0]);
UpdateResultVo resultVo = null;
foreach (MoldItemVo molditem in inVo.GetList())
{
MoldItemVo MoldItemOutVo = (MoldItemVo)addMoldItemCbm.Execute(trxContext, molditem);
if (resultVo == null)
{
resultVo = new UpdateResultVo();
}
resultVo.AffectedCount += MoldItemOutVo.AffectedCount;
}
return(resultVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
MoldVo moldInVo = (MoldVo)inList.FirstOrDefault();
ProcessWorkMoldVo processWorkMoldInVo = (ProcessWorkMoldVo)inList.Skip(1).FirstOrDefault();
MoldVo moldOutVo = (MoldVo)updateMoldMasterMntCbm.Execute(trxContext, moldInVo);
if (moldOutVo.AffectedCount > 0)
{
processWorkMoldInVo.MoldId = moldInVo.MoldId;
ProcessWorkMoldVo deleteInVo = new ProcessWorkMoldVo();
deleteInVo.MoldId = moldInVo.MoldId;
ProcessWorkMoldVo deleteOutVo = (ProcessWorkMoldVo)deleteProcessWorkMoldMasterMntCbm.Execute(trxContext, deleteInVo);
foreach (ProcessWorkMoldVo processid in processWorkMoldInVo.ProcessWorkMoldListVo)
{
processWorkMoldInVo.ProcessWorkId = processid.ProcessWorkId;
ProcessWorkMoldVo ProcessWorkMoldoutVo = (ProcessWorkMoldVo)addProcessWorkMoldMasterMntCbm.Execute(trxContext, processWorkMoldInVo);
}
}
return(moldOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
LineVo lineInVo = (LineVo)inList.FirstOrDefault();
ProcessWorkLineVo processWorkLineInVo = (ProcessWorkLineVo)inList.Skip(1).FirstOrDefault();
LineVo lineOutVo = (LineVo)addLineMasterMntCbm.Execute(trxContext, lineInVo);
int count = 0;
if (lineOutVo != null && lineOutVo.LineId > 0)
{
count += 1;
foreach (ProcessWorkLineVo curInVo in processWorkLineInVo.ProcessWorkLineListVo)
{
curInVo.LineId = lineOutVo.LineId;
ProcessWorkLineVo processWorkLineOutVo = (ProcessWorkLineVo)addProcessWorkLineMasterMntCbm.Execute(trxContext, curInVo);
}
}
lineOutVo.AffectedCount = count;
return(lineOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldItemVo inVo = (MoldItemVo)vo;
int globalItemSapItemId;
if (!(inVo.GlobalLocalItemId > 0))
{
MoldItemVo globalitemsapitemOutVo = (MoldItemVo)addglobalItemSapItemCbm.Execute(trxContext, inVo);
globalItemSapItemId = globalitemsapitemOutVo.GlobalLocalItemId;
}
else
{
globalItemSapItemId = inVo.GlobalLocalItemId;
}
if (globalItemSapItemId > 0)
{
foreach (MoldItemVo curVo in inVo.MoldItemListVo)
{
curVo.GlobalLocalItemId = globalItemSapItemId;
}
if (!(inVo.MoldItemListVo.Count > 0))
{
deleteGlobalitemSapItemCbm.Execute(trxContext, inVo);
}
inVo.GlobalLocalItemId = globalItemSapItemId;
return(deleteAndAddMoldItemCbm.Execute(trxContext, inVo));
}
return(null);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldDetailVo inVo = (MoldDetailVo)vo;
MoldVo moldVo = new MoldVo();
moldVo.MoldCode = inVo.MoldCode;
moldVo.MoldName = inVo.MoldName;
moldVo.Weight = inVo.Weight;
moldVo.Height = inVo.Height;
moldVo.Depth = inVo.Depth;
moldVo.Width = inVo.Width;
moldVo.Comment = inVo.Comment;
moldVo.LifeShotCount = inVo.LifeShotCount;
moldVo.ProductionDate = inVo.ProductionDate;
MoldVo moldOutVo = (MoldVo)addMoldMasterMntCbm.Execute(trxContext, moldVo);
MoldDetailVo moldDetailOutVo = null;
if (moldOutVo.MoldId > 0)
{
inVo.MoldId = moldOutVo.MoldId;
moldDetailOutVo = (MoldDetailVo)addMoldDetailMasterMntCbm.Execute(trxContext, inVo);
moldDetailOutVo.MoldId = moldOutVo.MoldId;
}
return(moldDetailOutVo);
}
private void AddMoldItemStdCycleTime(TransactionContext trxContext, ValueObjectList <MoldItemVo> moldItemInVo)
{
if (moldItemInVo != null && moldItemInVo.GetList().Count > 0)
{
foreach (MoldItemVo moldItemVo in moldItemInVo.GetList())
{
if (moldList.ContainsKey(moldItemVo.MoldCode))
{
moldItemVo.MoldId = (int)moldList[moldItemVo.MoldCode];
}
if (modelList.ContainsKey(moldItemVo.ModelCode))
{
moldItemVo.ModelId = (int)modelList[moldItemVo.ModelCode];
}
if (globalItemList.ContainsKey(moldItemVo.GlobalItemCode))
{
moldItemVo.GlobalItemId = (int)globalItemList[moldItemVo.GlobalItemCode];
}
ValueObjectList <MoldItemVo> checkMoldItem = (ValueObjectList <MoldItemVo>)getMoldItemCbm.Execute(trxContext, moldItemVo);
if (checkMoldItem == null || checkMoldItem.GetList() == null || checkMoldItem.GetList().Count == 0)
{
MoldItemVo MoldItemOutVo = (MoldItemVo)addmoldItemCbm.Execute(trxContext, moldItemVo);
}
else
{
MoldItemVo MoldItemOutVo = (MoldItemVo)updateMoldItemCbm.Execute(trxContext, moldItemVo);
}
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
LineItemCycleTimeVo deleteInVo = (LineItemCycleTimeVo)inList.FirstOrDefault();
ValueObjectList <LineItemCycleTimeVo> addInVo = (ValueObjectList <LineItemCycleTimeVo>)inList.Skip(1).FirstOrDefault();;
//ValueObjectList<LineItemCycleTimeVo> inVo = new ValueObjectList<LineItemCycleTimeVo>();
UpdateResultVo outVo = new UpdateResultVo();
UpdateResultVo resultVo = (UpdateResultVo)deleteLineItemCycleTimeMasterMntCbm.Execute(trxContext, deleteInVo);
if (addInVo != null && addInVo.GetList() != null && addInVo.GetList().Count > 0)
{
foreach (LineItemCycleTimeVo currentVo in addInVo.GetList())
{
resultVo = (UpdateResultVo)addLineItemCycleTimeMasterMntCbm.Execute(trxContext, currentVo);
outVo.AffectedCount = resultVo.AffectedCount;
}
return(outVo);
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
MachineVo machineInVo = (MachineVo)inList.FirstOrDefault();
ProcessWorkMachineVo processWorkMachineInVo = (ProcessWorkMachineVo)inList.Skip(1).FirstOrDefault();
MachineVo machineOutVo = (MachineVo)updateMachineMasterMntCbm.Execute(trxContext, machineInVo);
if (machineOutVo.AffectedCount > 0)
{
ProcessWorkMachineVo deleteInVo = new ProcessWorkMachineVo();
deleteInVo.MachineId = machineInVo.MachineId;
ProcessWorkMachineVo deleteOutVo = (ProcessWorkMachineVo)deleteProcessWorkMachineMasterMntCbm.Execute(trxContext, deleteInVo);
foreach (ProcessWorkMachineVo curInVo in processWorkMachineInVo.ProcessWorkMachineListVo)
{
curInVo.MachineId = machineInVo.MachineId;
ProcessWorkMachineVo processWorkLineOutVo = (ProcessWorkMachineVo)addProcessWorkMachineMasterMntCbm.Execute(trxContext, curInVo);
}
}
return(machineOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionTestInstructionVo deleteOutVo = (InspectionTestInstructionVo)deleteInspTestInstructionMasterMntCbm.Execute(trxContext, vo);
if (deleteOutVo.AffectedCount > 0)
{
InspectionTestInstructionVo deleteDetailVo = (InspectionTestInstructionVo)deleteInspTestInstructionDetailMasterMntCbm.Execute(trxContext, vo);
}
return(deleteOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionProcessVo inVo = (InspectionProcessVo)vo;
ValueObjectList <InspectionProcessVo> inspectionProcessListInVo = new ValueObjectList <InspectionProcessVo>();
ValueObjectList <InspectionItemVo> inspectionItemListInVo = new ValueObjectList <InspectionItemVo>();
ValueObjectList <InspectionItemSelectionDatatypeValueVo> inspectionDataTypeSelectionListInVo = new ValueObjectList <InspectionItemSelectionDatatypeValueVo>();
ValueObjectList <InspectionSpecificationVo> inspectionSpecificationListInVo = new ValueObjectList <InspectionSpecificationVo>();
ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionListInVo = new ValueObjectList <InspectionTestInstructionVo>();
ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionDetailListInVo = new ValueObjectList <InspectionTestInstructionVo>();
ValueObjectList <ValueObject> OutVo = new ValueObjectList <ValueObject>();
inspectionProcessListInVo.add(inVo);
// Create the Vo to get the Inspection Process
ValueObjectList <InspectionProcessVo> GetProcessinVoList = new ValueObjectList <InspectionProcessVo>();
InspectionProcessVo ProcessVo = new InspectionProcessVo();
ProcessVo.InspectionProcessId = inVo.InspectionProcessIdCopy;
GetProcessinVoList.add(ProcessVo);
//get inspection item list for the above fetched processlist
inspectionItemListInVo = (ValueObjectList <InspectionItemVo>)getInspectionItemListCbm.Execute(trxContext, GetProcessinVoList);
if (inspectionItemListInVo != null && inspectionItemListInVo.GetList() != null && inspectionItemListInVo.GetList().Count > 0)
{
//get inspectionSelectionDataType for the above fetched itemlist
inspectionDataTypeSelectionListInVo = (ValueObjectList <InspectionItemSelectionDatatypeValueVo>)getInspectionSelectionDataTypeListCbm.Execute(trxContext, inspectionItemListInVo);
//get inspectionspecification for the above fetched itemlist
inspectionSpecificationListInVo = (ValueObjectList <InspectionSpecificationVo>)getInspectionSpecficationListCbm.Execute(trxContext, inspectionItemListInVo);
//get inspectiontestinstruction for the above fetched itemlist
inspectionTestInstructionListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionListCbm.Execute(trxContext, inspectionItemListInVo);
}
if (inspectionTestInstructionListInVo != null && inspectionTestInstructionListInVo.GetList() != null && inspectionTestInstructionListInVo.GetList().Count > 0)
{
//get inspectiontestinstructiondetail for the above fetched inspectiontestinstruction
inspectionTestInstructionDetailListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionDetailListCbm.Execute(trxContext, inspectionTestInstructionListInVo);
}
OutVo.add(null);
OutVo.add(inspectionProcessListInVo);
OutVo.add(inspectionItemListInVo);
OutVo.add(inspectionDataTypeSelectionListInVo);
OutVo.add(inspectionSpecificationListInVo);
OutVo.add(inspectionTestInstructionListInVo);
OutVo.add(inspectionTestInstructionDetailListInVo);
return(OutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DefectiveReasonVo deleteOutVo = (DefectiveReasonVo)deleteDefectiveReasonMasterMntCbm.Execute(trxContext, vo);
if (deleteOutVo.AffectedCount > 0)
{
ProcessDefectiveReasonVo inVo = new ProcessDefectiveReasonVo();
inVo.DefectiveReasonId = ((DefectiveReasonVo)vo).DefectiveReasonId;
ProcessDefectiveReasonVo deleteProcessDefectiveReasonOutVo = (ProcessDefectiveReasonVo)deleteProcessDefectiveReasonMasterMntCbm.Execute(trxContext, inVo);
}
return(deleteOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MachineVo deleteMachineOutVo = (MachineVo)deleteMachineMasterMntCbm.Execute(trxContext, vo);
if (deleteMachineOutVo.AffectedCount > 0)
{
ProcessWorkMachineVo inVo = new ProcessWorkMachineVo();
inVo.MachineId = ((MachineVo)vo).MachineId;
ProcessWorkMachineVo deleteProcessWorkMachineOutVo = (ProcessWorkMachineVo)deleteProcessWorkMachineMasterMntCbm.Execute(trxContext, inVo);
}
return(deleteMachineOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionItemVo inVo = (InspectionItemVo)vo;
ValueObjectList <ValueObjectList <ValueObject> > outVo = null;
//if process data not found return the vo
if (inVo == null || inVo.InspectionItemIdCopy == 0)
{
return(outVo);
}
InspectionItemVo returnItemVo = null;
returnItemVo = (InspectionItemVo)addInspectionItemMasterMntCbm.Execute(trxContext, inVo);
//To get the old record for InspectionItem Insertion
inVo.InspectionItemId = inVo.InspectionItemIdCopy;
//No records Added
if (returnItemVo == null || returnItemVo.InspectionItemId == 0)
{
return(outVo);
}
returnItemVo.InspectionItemCode = inVo.InspectionItemCode;
if (inVo.InspectionItemDataType.ToString() == GlobalMasterDataTypeEnum.DATATYPE_SELECTION.GetValue().ToString())
{
//To insert selection value.
InspectionItemSelectionDatatypeValueVo inspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo();
inspectionItemSelectionDatatypeValueVo.InspectionItemCode = inVo.InspectionItemCode;
inspectionItemSelectionDatatypeValueVo.InspectionItemId = returnItemVo.InspectionItemId;
UpdateResultVo updateResultVo = (UpdateResultVo)updateInspectionItemIdForSelectionValueCbm.Execute(trxContext, inspectionItemSelectionDatatypeValueVo);
}
ValueObjectList <ValueObject> CombinationVo = new ValueObjectList <ValueObject>();
CombinationVo.add(inVo);
CombinationVo.add(returnItemVo);
if (outVo == null)
{
outVo = new ValueObjectList <ValueObjectList <ValueObject> >();
}
outVo.add(CombinationVo);
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionFormatVo inVo = (InspectionFormatVo)vo;
UpdateResultVo OutVo = new UpdateResultVo();
OutVo = (UpdateResultVo)deleteInspectionFormatcbm.Execute(trxContext, inVo);
if (OutVo != null && OutVo.AffectedCount > 0)
{
ItemLineInspectionFormatVo itemlineInVo = new ItemLineInspectionFormatVo();
itemlineInVo.InspectionFormatId = inVo.InspectionFormatId;
return(deleteItemLineInspectionFormatMasterMntCbm.Execute(trxContext, itemlineInVo));
}
return(OutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldDetailVo outVo = (MoldDetailVo)deleteMoldDetailMasterMntCbm.Execute(trxContext, vo);
if (outVo.AffectedCount > 0)
{
MoldDetailVo inVo = (MoldDetailVo)vo;
MoldVo moldInVo = new MoldVo();
moldInVo.MoldId = inVo.MoldId;
deleteMoldMasterMntCbm.Execute(trxContext, moldInVo);
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldDetailVo inVo = (MoldDetailVo)vo;
MoldItemVo moldItemInVo = new MoldItemVo();
moldItemInVo.MoldId = inVo.MoldId;
deleteMoldItemCbm.Execute(trxContext, moldItemInVo);
CavityVo cavityInVo = new CavityVo();
cavityInVo.MoldId = inVo.MoldId;
deleteCavityByMoldIdCbm.Execute(trxContext, cavityInVo);
return(deleteMoldDetailMasterMntCbm.Execute(trxContext, inVo));
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <LineRestTimeVo> inVo = (ValueObjectList <LineRestTimeVo>)vo;
UpdateResultVo outVo = new UpdateResultVo();
UpdateResultVo deleteVo = (UpdateResultVo)deleteLineRestTimeMasterMntCbm.Execute(trxContext, inVo.GetList()[0]);
foreach (LineRestTimeVo currentVo in inVo.GetList())
{
if (currentVo.PlanRestMinutes != null && currentVo.PlanRestMinutes != 0)
{
UpdateResultVo resultVo = (UpdateResultVo)addLineRestTimeMasterMntCbm.Execute(trxContext, currentVo);
outVo.AffectedCount = resultVo.AffectedCount;
}
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
DefectiveReasonVo defectiveReasonVoInVo = (DefectiveReasonVo)inList.FirstOrDefault();
ProcessDefectiveReasonVo processDefectiveReasonInVo = (ProcessDefectiveReasonVo)inList.Skip(1).FirstOrDefault();
DefectiveReasonVo defectiveReasonVoOutVo = (DefectiveReasonVo)addDefectiveReasonMasterMntCbm.Execute(trxContext, defectiveReasonVoInVo);
if (defectiveReasonVoOutVo != null && defectiveReasonVoOutVo.DefectiveReasonId > 0)
{
processDefectiveReasonInVo.DefectiveReasonId = defectiveReasonVoOutVo.DefectiveReasonId;
ProcessDefectiveReasonVo processDefectiveReasonoutVo = (ProcessDefectiveReasonVo)addProcessDefectiveReasonMasterMntNewCbm.Execute(trxContext, processDefectiveReasonInVo);
}
return(defectiveReasonVoOutVo);
}
private void AddCavity(TransactionContext trxContext, ValueObjectList <CavityVo> cavityInVo)
{
if (cavityInVo != null && cavityInVo.GetList().Count > 0)
{
foreach (CavityVo cavityVo in cavityInVo.GetList())
{
if (moldList.ContainsKey(cavityVo.MoldCode))
{
cavityVo.MoldId = (int)moldList[cavityVo.MoldCode];
}
CavityVo checkCavityOutVo = (CavityVo)checkCavityMasterMntCbm.Execute(trxContext, cavityVo);
if (checkCavityOutVo == null || checkCavityOutVo.AffectedCount == 0)
{
addCavityMasterMntCbm.Execute(trxContext, cavityVo);
}
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionProcessVo inVo = (InspectionProcessVo)vo;
ValueObjectList <ValueObjectList <ValueObject> > outVo = null;
//if process data not found return the vo
if (inVo == null || inVo.InspectionProcessIdCopy == 0)
{
return(outVo);
}
InspectionProcessVo returnProcessVo = null;
inVo.InspectionProcessCode = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.PROCESS_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.SequenceNo;
returnProcessVo = (InspectionProcessVo)addInspectionProcessMasterMntCbm.Execute(trxContext, inVo);
//To get the old record for InspectionItem Insertion
inVo.InspectionProcessId = inVo.InspectionProcessIdCopy;
//No records Added
if (returnProcessVo == null || returnProcessVo.InspectionProcessId == 0)
{
return(outVo);
}
returnProcessVo.InspectionProcessCode = inVo.InspectionProcessCode;
ValueObjectList <ValueObject> CombinationVo = new ValueObjectList <ValueObject>();
CombinationVo.add(inVo);
CombinationVo.add(returnProcessVo);
if (outVo == null)
{
outVo = new ValueObjectList <ValueObjectList <ValueObject> >();
}
outVo.add(CombinationVo);
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AddBatchProcessVo inVo = (AddBatchProcessVo)vo;
AddBatchProcessVo getOutVo = (AddBatchProcessVo)getBatchProcessCbm.Execute(trxContext, inVo);
CheckBatchProcessVo outVo = new CheckBatchProcessVo();
if (getOutVo != null)
{
outVo.IsBatchStarted = false;
}
else
{
UpdateResultVo updateVo = (UpdateResultVo)addBatchProcessCbm.Execute(trxContext, inVo);
if (updateVo != null && updateVo.AffectedCount > 0)
{
outVo.IsBatchStarted = true;
}
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionFormatVo inVo = (InspectionFormatVo)vo;
InspectionFormatVo OutVo = null;
int SerialNumber = 1;
InspectionFormatVo getseqVo = (InspectionFormatVo)getInspectionFormatLastRecordforSerailNoMasterMnt.Execute(trxContext, vo);
if (getseqVo != null && getseqVo.InspectionFormatCode != null)
{
string[] splitval = getseqVo.InspectionFormatCode.Split(Convert.ToChar(GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()));
if (splitval.Length > 3)
{
if (splitval[splitval.Length - 1].All(Char.IsDigit))
{
SerialNumber = Convert.ToInt32(splitval[splitval.Length - 1]) + 1;
}
}
}
inVo.InspectionFormatCode = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + SerialNumber.ToString().PadLeft(5, '0');
inVo.InspectionFormatSeq = getseqVo.InspectionFormatSeq;
InspectionFormatVo returnformatidVo = (InspectionFormatVo)addInspectionFormatCbm.Execute(trxContext, inVo);
if (returnformatidVo != null && returnformatidVo.InspectionFormatId > 0)
{
ItemLineInspectionFormatVo itemlineInVo = new ItemLineInspectionFormatVo();
itemlineInVo.InspectionFormatId = returnformatidVo.InspectionFormatId;
itemlineInVo.SapItemCode = inVo.SapItemCode;
itemlineInVo.LineId = inVo.LineId;
ItemLineInspectionFormatVo ItemlineOutVo = (ItemLineInspectionFormatVo)addItemLineInspectionFormatMasterMntCbm.Execute(trxContext, itemlineInVo);
if (ItemlineOutVo != null)
{
OutVo = new InspectionFormatVo();
OutVo.AffectedCount = ItemlineOutVo.AffectedCount;
OutVo.InspectionFormatId = returnformatidVo.InspectionFormatId;
OutVo.InspectionFormatCode = inVo.InspectionFormatCode;
}
}
return(OutVo);
}
private void AddCategory(TransactionContext trxContext, ValueObjectList <MoldCategoryVo> moldCategoryInVo)
{
foreach (MoldCategoryVo moldCategoryVo in moldCategoryInVo.GetList())
{
// Checking existing data
ValueObjectList <MoldCategoryVo> moldCategoryCheckVo = (ValueObjectList <MoldCategoryVo>)checkMoldCategoryMasterMntCbm.Execute(trxContext, moldCategoryVo);
if (moldCategoryCheckVo != null && moldCategoryCheckVo.GetList().Count > 0)
{
foreach (MoldCategoryVo curVo in moldCategoryCheckVo.GetList())
{
if (!categoryList.ContainsKey(curVo.MoldCategoryCode))
{
categoryList.Add(curVo.MoldCategoryCode, curVo.MoldCategoryId);
}
}
}
else
{
MoldCategoryVo moldCategoryOutVo = (MoldCategoryVo)addMoldCategoryMasterMntCbm.Execute(trxContext, moldCategoryVo);
categoryList.Add(moldCategoryVo.MoldCategoryCode, moldCategoryOutVo.MoldCategoryId);
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
DefectiveReasonVo defectiveReasonVoInVo = (DefectiveReasonVo)inList.FirstOrDefault();
ProcessDefectiveReasonVo processDefectiveReasonVoInVo = (ProcessDefectiveReasonVo)inList.Skip(1).FirstOrDefault();
DefectiveReasonVo defectiveReasonVoOutVo = (DefectiveReasonVo)updateDefectiveReasonMasterMntCbm.Execute(trxContext, defectiveReasonVoInVo);
if (defectiveReasonVoOutVo.AffectedCount > 0)
{
processDefectiveReasonVoInVo.DefectiveReasonId = defectiveReasonVoInVo.DefectiveReasonId;
ProcessDefectiveReasonVo deleteInVo = new ProcessDefectiveReasonVo();
deleteInVo.DefectiveReasonId = defectiveReasonVoInVo.DefectiveReasonId;
ProcessDefectiveReasonVo deleteOutVo = (ProcessDefectiveReasonVo)deleteProcessDefectiveReasonMasterMntCbm.Execute(trxContext, deleteInVo);
ProcessDefectiveReasonVo ProcessDefectiveReasonoutVo = (ProcessDefectiveReasonVo)addProcessDefectiveReasonMasterMntNewCbm.Execute(trxContext, processDefectiveReasonVoInVo);
}
return(defectiveReasonVoOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
MoldVo moldInVo = (MoldVo)inList.FirstOrDefault();
ProcessWorkMoldVo processWorkMoldInVo = (ProcessWorkMoldVo)inList.Skip(1).FirstOrDefault();
MoldVo moldOutVo = (MoldVo)addGetMoldIdMasterMntCbm.Execute(trxContext, moldInVo);
if (moldOutVo != null && moldOutVo.MoldId > 0)
{
processWorkMoldInVo.MoldId = moldOutVo.MoldId;
foreach (ProcessWorkMoldVo processid in processWorkMoldInVo.ProcessWorkMoldListVo)
{
processWorkMoldInVo.ProcessWorkId = processid.ProcessWorkId;
ProcessWorkMoldVo processWorkMoldoutVo = (ProcessWorkMoldVo)addProcessWorkMoldMasterMntCbm.Execute(trxContext, processWorkMoldInVo);
}
}
return(moldOutVo);
}
