private string _GetUnboundValue <T>(ItemPickerMapping im) where T : class, IBqlField
{
IIProductLineFilter filter = PXSelect <IIProductLineFilter, Where <IIProductLineFilter.productLineID, Equal <Current <IIProductLine.productLineID> >, And <IIProductLineFilter.filterID, Equal <Current <T> > > >, OrderBy <Asc <IIProductLineFilter.sortOrder> > > .Select(this, im.ProductLineID).RowCast <IIProductLineFilter>()?.FirstOrDefault();
switch (filter?.MappingColumnNbr)
{
case 1: return(im.Column1);
case 2: return(im.Column2);
case 3: return(im.Column3);
case 4: return(im.Column4);
case 5: return(im.Column5);
case 6: return(im.Column6);
case 7: return(im.Column7);
case 8: return(im.Column8);
case 9: return(im.Column9);
}
return("");
}
private void _SetUnboundValue <T>(ItemPickerMapping im, string value) where T : class, IBqlField
{
IIProductLineFilter filter = PXSelect <IIProductLineFilter, Where <IIProductLineFilter.productLineID, Equal <Current <IIProductLine.productLineID> >, And <IIProductLineFilter.filterID, Equal <Current <T> > > >, OrderBy <Asc <IIProductLineFilter.sortOrder> > > .Select(this, im.ProductLineID).RowCast <IIProductLineFilter>()?.FirstOrDefault();
switch (filter?.MappingColumnNbr)
{
case 1: im.Column1 = value; return;
case 2: im.Column2 = value; return;
case 3: im.Column3 = value; return;
case 4: im.Column4 = value; return;
case 5: im.Column5 = value; return;
case 6: im.Column6 = value; return;
case 7: im.Column7 = value; return;
case 8: im.Column8 = value; return;
case 9: im.Column9 = value; return;
}
}
protected virtual void ItemPickerMapping_RowUpdated(PXCache sender, PXRowUpdatedEventArgs e)
{
ItemPickerMapping im = e.Row as ItemPickerMapping;
if ((im == null) || (im.ProductLineID == null))
{
return;
}
sender.SetDefaultExt <ItemPickerMapping.description>(e.Row);
}
protected virtual void ItemPickerMapping_RowSelecting(PXCache sender, PXRowSelectingEventArgs e)
{
ItemPickerMapping im = e.Row as ItemPickerMapping;
if ((im == null) || (im.ProductLineID == null))
{
return;
}
_GetUnboundValues(im);
}
private void _SetUnboundValues(ItemPickerMapping im)
{
_SetUnboundValue <IIProductLine.unboundColumn1>(im, im.UnboundValueColumn1);
_SetUnboundValue <IIProductLine.unboundColumn2>(im, im.UnboundValueColumn2);
_SetUnboundValue <IIProductLine.unboundColumn3>(im, im.UnboundValueColumn3);
_SetUnboundValue <IIProductLine.unboundColumn4>(im, im.UnboundValueColumn4);
_SetUnboundValue <IIProductLine.unboundColumn5>(im, im.UnboundValueColumn5);
_SetUnboundValue <IIProductLine.unboundColumn6>(im, im.UnboundValueColumn6);
_SetUnboundValue <IIProductLine.unboundColumn7>(im, im.UnboundValueColumn7);
_SetUnboundValue <IIProductLine.unboundColumn8>(im, im.UnboundValueColumn8);
_SetUnboundValue <IIProductLine.unboundColumn9>(im, im.UnboundValueColumn9);
}
private void _GetUnboundValues(ItemPickerMapping im)
{
im.UnboundValueColumn1 = _GetUnboundValue <IIProductLine.unboundColumn1>(im);
im.UnboundValueColumn2 = _GetUnboundValue <IIProductLine.unboundColumn2>(im);
im.UnboundValueColumn3 = _GetUnboundValue <IIProductLine.unboundColumn3>(im);
im.UnboundValueColumn4 = _GetUnboundValue <IIProductLine.unboundColumn4>(im);
im.UnboundValueColumn5 = _GetUnboundValue <IIProductLine.unboundColumn5>(im);
im.UnboundValueColumn6 = _GetUnboundValue <IIProductLine.unboundColumn6>(im);
im.UnboundValueColumn7 = _GetUnboundValue <IIProductLine.unboundColumn7>(im);
im.UnboundValueColumn8 = _GetUnboundValue <IIProductLine.unboundColumn8>(im);
im.UnboundValueColumn9 = _GetUnboundValue <IIProductLine.unboundColumn9>(im);
}
private bool _CheckUniqueness(ItemPickerMapping im)
{
var mappingsSet = new HashSet <MappingsForSet>();
foreach (ItemPickerMapping im1 in ItemPickerMappings.Select())
{
if (im1 != im)
{
mappingsSet.Add(new MappingsForSet(im1.Column1, im1.Column2, im1.Column3, im1.Column4, im1.Column5, im1.Column6, im1.Column7, im1.Column8, im1.Column9, im1.InventoryID));
}
}
return(mappingsSet.Add(new MappingsForSet(im.Column1, im.Column2, im.Column3, im.Column4, im.Column5, im.Column6, im.Column7, im.Column8, im.Column9, im.InventoryID)));
}
protected virtual void ItemPickerMapping_RowUpdating(PXCache sender, PXRowUpdatingEventArgs e)
{
ItemPickerMapping im = e.NewRow as ItemPickerMapping;
if ((im == null) || (im.ProductLineID == null))
{
return;
}
_SetUnboundValues(im);
if (!_CheckUniqueness(im))
{
sender.RaiseExceptionHandling <ItemPickerMapping.unboundValueColumn1>(im, im.UnboundValueColumn1, new PXSetPropertyException("A combination of mapping values and inventory ID must be unique. Make the combination of values unique and save."));
e.Cancel = true;
}
}
