public static void AddStateFriendlyNameMetaFieldToAllMetaView()
{
using (MetaClassManagerEditScope scope = DataContext.Current.MetaModel.BeginEdit())
{
MetaClass timeTrackingEntry = TimeTrackingEntry.GetAssignedMetaClass();
MetaField mf = timeTrackingEntry.Fields["StateFriendlyName"];
foreach (MetaView mv in DataContext.Current.MetaModel.MetaViews.GetByMetaClass(timeTrackingEntry))
{
mv.AvailableFields.Add(mf);
}
scope.SaveChanges();
}
}
public static void CreateStateFriendlyNameMetaField()
{
using (MetaClassManagerEditScope scope = DataContext.Current.MetaModel.BeginEdit())
{
MetaClass timeTrackingEntry = TimeTrackingEntry.GetAssignedMetaClass();
AttributeCollection attr = new AttributeCollection();
attr.Add(McDataTypeAttribute.StringMaxLength, 255);
attr.Add(McDataTypeAttribute.StringIsUnique, false);
attr.Add(McDataTypeAttribute.Expression,
@"SELECT TOP 1 TTBS.FriendlyName FROM cls_TimeTrackingBlock_State TTBS" + Environment.NewLine +
@" JOIN cls_TimeTrackingBlock TTB ON " + Environment.NewLine +
@" TTB.mc_StateId = TTBS.TimeTrackingBlock_StateId" + Environment.NewLine +
@" AND" + Environment.NewLine +
@" TTB.[TimeTrackingBlockId] = AAA.[ParentBlockId]");
MetaField retVal = timeTrackingEntry.CreateMetaField("StateFriendlyName",
"State", MetaFieldType.Text, true, "''", attr);
scope.SaveChanges();
}
}
public TimeTrackingEntry(CustomTableRow row)
: base(TimeTrackingEntry.GetAssignedMetaClass(), row)
{
}
public TimeTrackingEntry(CustomTableRow row, MetaObjectOptions options)
: base(TimeTrackingEntry.GetAssignedMetaClass(), row, options)
{
}
public TimeTrackingEntry(PrimaryKeyId primaryKeyId)
: base(TimeTrackingEntry.GetAssignedMetaClass(), primaryKeyId)
{
}
public TimeTrackingEntry(PrimaryKeyId primaryKeyId, MetaObjectOptions options)
: base(TimeTrackingEntry.GetAssignedMetaClass(), primaryKeyId, options)
{
}
public TimeTrackingEntry()
: base(TimeTrackingEntry.GetAssignedMetaClass())
{
}
public TimeTrackingEntry(MetaObjectOptions options)
: base(TimeTrackingEntry.GetAssignedMetaClass(), options)
{
}
public static int GetTotalCount(params FilterElement[] filters)
{
return(MetaObject.GetTotalCount(TimeTrackingEntry.GetAssignedMetaClass(), filters));
}
public static TimeTrackingEntry[] List(Mediachase.Ibn.Data.FilterElementCollection filters, Mediachase.Ibn.Data.SortingElementCollection sorting, int start, int count)
{
return(MetaObject.List <TimeTrackingEntry>(TimeTrackingEntry.GetAssignedMetaClass(), filters, sorting, start, count));
}
public static TimeTrackingEntry[] List(params Mediachase.Ibn.Data.SortingElement[] sorting)
{
return(MetaObject.List <TimeTrackingEntry>(TimeTrackingEntry.GetAssignedMetaClass(), sorting));
}
public static TimeTrackingEntry[] List(params Mediachase.Ibn.Data.FilterElement[] filters)
{
return(MetaObject.List <TimeTrackingEntry>(TimeTrackingEntry.GetAssignedMetaClass(), filters));
}
public static TimeTrackingEntry[] List()
{
return(MetaObject.List <TimeTrackingEntry>(TimeTrackingEntry.GetAssignedMetaClass()));
}