private void SetCurrentUser()
{
var modifiedBy = _entitySchemaColumns.FindByName("ModifiedBy");
if (modifiedBy != null)
{
_entity.SetColumnValue("ModifiedById", _userConnection.CurrentUser.ContactId);
}
}
private Select WrapSelect(Select sourceSelect)
{
EntitySchemaColumnCollection visaColumns = _baseVisaSchema.Columns;
string alias = "InternalSelect";
Select select =
new Select(_userConnection)
.Column(alias, "Id")
.Column(alias, "CreatedOn")
.Column(alias, "CreatedById")
.Column(alias, "ModifiedOn")
.Column(alias, "ModifiedById")
.Column(alias, "ProcessListeners")
.Column(alias, "Objective")
.Column(alias, "VisaOwnerId")
.Column(alias, "IsAllowedToDelegate")
.Column(alias, "DelegatedFromId")
.Column(alias, "StatusId")
.Column(alias, "SetById")
.Column(alias, "SetDate")
.Column(alias, "IsCanceled")
.Column(alias, "Comment")
.Column(alias, "VisaSchemaName")
.Column(alias, "Title")
.Column(alias, "VisaObjectId")
.Column(alias, "VisaSchemaTypeId")
.Column(alias, "VisaTypeName")
.Column(alias, "VisaSchemaCaption")
.Column(alias, "SchemaName")
.Column(alias, "SourceSchemaName")
.Column("CreatedBy", "Name").As(visaColumns.FindByName("CreatedBy").DisplayColumnValueName)
.Column("VisaStatus", "Name").As(visaColumns.FindByName("Status").DisplayColumnValueName)
.From(sourceSelect).As(alias)
.LeftOuterJoin("Contact").As("CreatedBy").On("CreatedBy", "Id").IsEqual(alias, "CreatedById")
.LeftOuterJoin("VisaStatus").On("VisaStatus", "Id").IsEqual(alias, "StatusId")
.OrderBy(OrderDirectionStrict.Descending, alias, "ModifiedOn") as Select;
return(select);
}
/// <summary>
/// Fills column value of the entity.
/// </summary>
/// <param name="entity">Entity.</param>
/// <param name="columnName">Column name.</param>
/// <param name="value">Column value.</param>
public static void SpecifyActivityLookupColumnValue(Entity entity, string columnName, Guid value)
{
if (value.IsEmpty())
{
return;
}
EntitySchema activitySchema = entity.Schema;
EntitySchemaColumnCollection columns = activitySchema.Columns;
EntitySchemaColumn entitySchemaColumn = columns.FindByName(columnName);
if (entitySchemaColumn != null)
{
entity.SetColumnValue(entitySchemaColumn, value);
}
}
protected EntitySchemaColumn GetColumnByName(string columnName)
{
EntitySchemaColumnCollection columns = _rootSchema.Columns;
return(columns.FindByName(columnName) ?? columns.FindByColumnValueName(columnName));
}
private EntitySchemaColumn GetSchemaColumnByName(string columnName, EntitySchema schema)
{
EntitySchemaColumnCollection columns = schema.Columns;
return(columns.FindByName(columnName) ?? columns.FindByColumnValueName(columnName));
}