protected virtual void ImportAttributeMappingPropertiesInit(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e)
{
HashSet <string> hiddenFields = new HashSet <string>();
List <string> forcedFields = new List <string>();
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeBAccountID)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeBAccountIDCopy)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.processed)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.processed)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.createDocument)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.curyID)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.curyTranAmt)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.drCr)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.headerRefNbr)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeLocationID)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeLocationID1)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeLocationIDCopy)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.tranType)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.pMInstanceID)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.pMInstanceIDCopy)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.curyTotalAmt)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeMatched)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.paymentMethodID)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.paymentMethodID1)));
hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.paymentMethodIDCopy)));
hiddenFields.Add("CuryRate");
hiddenFields.Add("CuryViewState");
forcedFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeName)));
forcedFields.Add(Details.Cache.GetField(typeof(CABankTran.tranCode)));
for (int i = 0; i < e.Names.Count; i++)
{
if (hiddenFields.Contains(e.Names[i]))
{
e.Names.RemoveAt(i);
e.DisplayNames.RemoveAt(i);
i--;
}
}
foreach (string field in forcedFields)
{
if (!e.Names.Contains(field))
{
e.Names.Add(field);
PXUIFieldAttribute uiAttribute = Details.Cache.GetAttributes(field).FirstOrDefault(a => a is PXUIFieldAttribute) as PXUIFieldAttribute;
if (uiAttribute != null)
{
e.DisplayNames.Add(uiAttribute.DisplayName);
}
else
{
e.DisplayNames.Add(field);
}
}
}
}
private void MappingPropertiesInit(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e)
{
string isCostedFieldName = location.Cache.GetField(typeof(INLocation.isCosted));
if (!e.Names.Contains(isCostedFieldName))
{
e.Names.Add(isCostedFieldName);
e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INLocation.taskID>(location.Cache));
}
string projectTaskFieldName = location.Cache.GetField(typeof(INLocation.taskID));
if (!e.Names.Contains(projectTaskFieldName))
{
e.Names.Add(projectTaskFieldName);
e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INLocation.taskID>(location.Cache));
}
}
public void MappingPropertiesInit(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e)
{
e.Names.Add(typeof(INPIDetail.inventoryID).Name);
e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.inventoryID>(PIDetail.Cache));
if (PXAccess.FeatureInstalled <FeaturesSet.subItem>())
{
e.Names.Add(typeof(INPIDetail.subItemID).Name);
e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.subItemID>(PIDetail.Cache));
}
if (PXAccess.FeatureInstalled <FeaturesSet.warehouseLocation>())
{
e.Names.Add(typeof(INPIDetail.locationID).Name);
e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.locationID>(PIDetail.Cache));
}
if (PXAccess.FeatureInstalled <FeaturesSet.lotSerialTracking>())
{
e.Names.Add(typeof(INPIDetail.lotSerialNbr).Name);
e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.lotSerialNbr>(PIDetail.Cache));
}
}
/// <summary>
/// Restricts the set of columns in Property Name combo box during Excel Import,
/// so as to display only fields that are visible in the UI grid.
/// </summary>
protected virtual void ImportAttributeMappingPropertiesHandler(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e)
{
e.Names.Clear();
e.DisplayNames.Clear();
IEnumerable <Type> fields = new Type[]
{
typeof(PMTran.branchID),
typeof(PMTran.inventoryID),
typeof(PMTran.description),
typeof(PMTran.bAccountID),
typeof(PMTran.uOM),
typeof(PMTran.billableQty),
typeof(PMTran.date),
typeof(PMTran.caseID)
};
IEnumerable <string> fieldNames = fields.Select(field => field.Name.Capitalize());
IEnumerable <string> displayNames = fields.Select(field => PXUIFieldAttribute.GetDisplayName(UnBilled.Cache, field.Name));
e.Names.Add(fieldNames);
e.DisplayNames.Add(displayNames);
}
