get custom table properties value according to item id
// ID : Item ID
// displayField: other customer table properties
public static string GetCustomTableField(string customTableClassName, int ID, string displayField)
{
try
{
string returnvalue = "";
DataSet data = CacheHelper.Cache(cs => GetCustomTableDSInternal(cs, customTableClassName),
new CacheSettings(20, "customtabledatasource|" + customTableClassName.ToLower()));
DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(customTableClassName);
if (!DataHelper.DataSourceIsEmpty(data))
{
DataRow[] rows = data.Tables[0].Select("ItemID = " + ID);
if (rows.Length > 0)
{
returnvalue = ValidationHelper.GetString(rows[0][displayField], string.Empty);
}
}
return returnvalue;
}
catch (Exception ex)
{
EventLogProvider.LogException("BDHelpers", "GetCustomTableField", ex);
return "";
}
}