public void PageInit()
{
var entMan = new EntityManager();
var relMan = new EntityRelationManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
var entityRelations = relMan.Read().Object.Where(x => x.TargetEntityId == ErpEntity.Id || x.OriginEntityId == ErpEntity.Id).ToList();
Relation = entityRelations.SingleOrDefault(x => x.Id == RecordId);
if (Relation == null)
{
return;
}
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/relations/r/{Relation.Id}/";
}
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Save Relation", formId: "ManageRecord"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/relations/r/{Relation.Id}/")
});
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "relations"));
TypeOptions = ModelExtensions.GetEnumAsSelectOptions <EntityRelationType>().FindAll(x => x.Value != "1").ToList();
}
public void InitPage()
{
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Create Data Source", formId: "CreateRecord", btnClass: "btn btn-green btn-sm", iconClass: "fa fa-plus"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl)
});
}
public void PageInit()
{
Init();
var entMan = new EntityManager();
var recMan = new RecordManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
if (!SecurityContext.HasEntityPermission(EntityPermission.Update, ErpEntity))
{
ErpEntity = null;
return;
}
Fields = ErpEntity.Fields.OrderBy(x => x.Name).ToList();
var idField = Fields.Single(x => x.Name == "id");
Fields.Remove(idField);
Fields = Fields.OrderBy(x => x.Name).ToList();
Fields.Insert(0, idField);
EntityQuery enQuery = new EntityQuery(ErpEntity.Name, "*", EntityQuery.QueryEQ("id", RecordId));
var response = recMan.Find(enQuery);
if (!response.Success)
{
throw new Exception(response.Message);
}
if (response.Object.Data.Count == 0)
{
return;
}
Record = response.Object.Data[0];
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/data/l/";
}
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Save Record", formId: "ManageRecord"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/data/l/")
});
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "data"));
}
public void PageInit()
{
Init();
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/relations/l";
}
var entMan = new EntityManager();
var relMan = new EntityRelationManager();
var allRelations = relMan.Read().Object;
foreach (var entity in entMan.ReadEntities().Object)
{
foreach (var field in entity.Fields)
{
if (field is GuidField)
{
var sfo = new SelectOption($"{entity.Id}${field.Id}", $"{entity.Name}.{field.Name}");
if (field.Unique && field.Required)
{
OriginOptions.Add(sfo);
}
if (!allRelations.Any(x => x.TargetFieldId == field.Id && x.RelationType != EntityRelationType.ManyToMany))
{
TargetOptions.Add(sfo);
}
}
}
}
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Create Relation", formId: "CreateRecord"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/relations/l")
});
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "relations"));
TypeOptions = ModelExtensions.GetEnumAsSelectOptions <EntityRelationType>().FindAll(x => x.Value != "1").ToList();
}
public void PageInit()
{
Init();
#region << Init Entity >>
var entMan = new EntityManager();
var relMan = new EntityRelationManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
var entityRelations = relMan.Read().Object.Where(x => x.TargetEntityId == ErpEntity.Id || x.OriginEntityId == ErpEntity.Id).ToList();
Relation = entityRelations.SingleOrDefault(x => x.Id == RecordId);
if (Relation == null)
{
return;
}
#endregion
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/relations/l";
}
#region << Actions >>
if (Relation.System)
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.Disabled, label: "Delete locked", formId: "DeleteRecord", btnClass: "btn btn-white btn-sm", iconClass: "fa fa-trash-alt", titleText: "System objects cannot be deleted"));
}
else
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.ConfirmAndSubmitForm, label: "Delete Relation", formId: "DeleteRecord", btnClass: "btn btn-white btn-sm", iconClass: "fa fa-trash-alt go-red"));
};
HeaderActions.Add($"<a href='/sdk/objects/entity/r/{ErpEntity.Id}/rl/relations/m/{RecordId}' class='btn btn-white btn-sm'><i class='fa fa-cog go-orange'></i> Manage Relation</a>");
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "relations"));
#endregion
TypeOptions = ModelExtensions.GetEnumAsSelectOptions <EntityRelationType>().FindAll(x => x.Value != "1").ToList();
}
public void InitPage()
{
Init();
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = "/sdk/objects/entity/l/list";
}
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("create", "create"),
new SelectOption("read", "read"),
new SelectOption("update", "update"),
new SelectOption("delete", "delete")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
valueGrid.Add(keyValuesObj);
}
#endregion
#region << Actions >>
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Create Entity", formId: "CreateRecord", btnClass: "btn btn-green btn-sm", iconClass: "ti-plus"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl)
});
#endregion
}
public void InitPage()
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpRequestContext.RecordId}?returnUrl=%2fsdk%2fobjects%2fentity%2fl";
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("create", "create"),
new SelectOption("read", "read"),
new SelectOption("update", "update"),
new SelectOption("delete", "delete")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
ExistingEntity = new EntityManager().ReadEntity(RecordId ?? Guid.Empty).Object;
if (ExistingEntity == null)
{
throw new Exception("Entity not found.");
}
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
valueGrid.Add(keyValuesObj);
}
#endregion
#region << Actions >>
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Clone Entity", formId: "CloneEntity", btnClass: "btn btn-green btn-sm", iconClass: "fa fa-plus"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl)
});
#endregion
}
public void InitPage()
{
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = "/sdk/objects/data_source/l/list";
}
DataSourceObject = dsMan.Get(RecordId ?? Guid.Empty) as DatabaseDataSource;
if (DataSourceObject == null)
{
return;
}
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Save", formId: "UpdateRecord", btnClass: "btn btn-primary btn-sm", iconClass: "fa fa-save"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl)
});
}
public void PageInit()
{
Init();
var entMan = new EntityManager();
var recMan = new RecordManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
if (!SecurityContext.HasEntityPermission(EntityPermission.Create, ErpEntity))
{
ErpEntity = null;
return;
}
Fields = ErpEntity.Fields.OrderBy(x => x.Name).ToList();
var idField = Fields.Single(x => x.Name == "id");
Fields.Remove(idField);
Fields = Fields.OrderBy(x => x.Name).ToList();
Fields.Insert(0, idField);
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/data/l/";
}
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Save Record", formId: "CreateRecord"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: $"/sdk/objects/entity/r/{ErpEntity.Id}/rl/data/l/")
});
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "data"));
}
public void PageInit()
{
Init();
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = "/sdk/objects/entity/l/list";
}
#region << Init Entity >>
var entMan = new EntityManager();
ErpEntity = entMan.ReadEntity(RecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
if (ErpEntity.RecordScreenIdField != null)
{
var screenField = ErpEntity.Fields.FirstOrDefault(x => x.Id == ErpEntity.RecordScreenIdField);
if (screenField != null)
{
RecordScreenIdFieldName = screenField.Name;
}
}
#endregion
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("create", "create"),
new SelectOption("read", "read"),
new SelectOption("update", "update"),
new SelectOption("delete", "delete")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
if (ErpEntity.RecordPermissions.CanCreate.Contains(role.Id))
{
keyValuesObj.Values.Add("create");
}
if (ErpEntity.RecordPermissions.CanRead.Contains(role.Id))
{
keyValuesObj.Values.Add("read");
}
if (ErpEntity.RecordPermissions.CanUpdate.Contains(role.Id))
{
keyValuesObj.Values.Add("update");
}
if (ErpEntity.RecordPermissions.CanDelete.Contains(role.Id))
{
keyValuesObj.Values.Add("delete");
}
valueGrid.Add(keyValuesObj);
}
RecordPermissions = JsonConvert.SerializeObject(valueGrid);
#endregion
#region << Actions >>
if (ErpEntity.System)
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.Disabled, label: "Delete locked", formId: "DeleteRecord", btnClass: "btn btn-white btn-sm", iconClass: "ti-trash", titleText: "System objects cannot be deleted"));
}
else
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.ConfirmAndSubmitForm, label: "Delete Entity", formId: "DeleteRecord", btnClass: "btn btn-white btn-sm", iconClass: "ti-trash go-red"));
};
HeaderActions.Add($"<a href='/sdk/objects/entity/m/{(ErpEntity != null ? ErpEntity.Id : Guid.Empty)}/manage?returnUrl={HttpUtility.UrlEncode(CurrentUrl)}' class='btn btn-white btn-sm'><i class='ti-settings go-orange'></i> Manage</a>");
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "details"));
#endregion
}
public void InitPage()
{
Init();
var entMan = new EntityManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
if (ErpEntity == null)
{
return;
}
Field = ErpEntity.Fields.FirstOrDefault(x => x.Id == RecordId);
if (Field == null)
{
return;
}
var allCards = AdminPageUtils.GetFieldCards();
FieldCard = allCards.First(x => (string)x["type"] == ((int)Field.GetFieldType()).ToString());
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("read", "read"),
new SelectOption("update", "update")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
if (Field.Permissions.CanRead.Contains(role.Id))
{
keyValuesObj.Values.Add("read");
}
if (Field.Permissions.CanUpdate.Contains(role.Id))
{
keyValuesObj.Values.Add("update");
}
valueGrid.Add(keyValuesObj);
}
FieldPermissions = JsonConvert.SerializeObject(valueGrid);
#endregion
#region << Actions >>
if (Field.System)
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.Disabled, label: "Delete Locked", formId: "DeleteRecord", iconClass: "ti-trash", titleText: "System objects cannot be deleted"));
}
else
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.ConfirmAndSubmitForm, label: "Delete Field", formId: "DeleteRecord", btnClass: "btn btn-white btn-sm", iconClass: "ti-trash go-red"));
};
HeaderActions.Add($"<a href='/sdk/objects/entity/r/{(ErpEntity != null ? ErpEntity.Id : Guid.Empty)}/rl/fields/m/{Field.Id}' class='btn btn-white btn-sm'><i class='ti-settings go-orange'></i> Manage</a>");
#endregion
ApiUrlFieldInlineEdit = ErpSettings.ApiUrlTemplateFieldInlineEdit.Replace("{entityName}", ErpEntity.Name).Replace("{recordId}", (RecordId ?? Guid.Empty).ToString());
}
public void InitPage()
{
Init();
var entMan = new EntityManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
var allCards = AdminPageUtils.GetFieldCards();
if (FieldTypeId > 19 || FieldTypeId < 1)
{
FieldTypeId = 18;
}
FieldCard = allCards.First(x => (string)x["type"] == FieldTypeId.ToString());
if (Enum.TryParse <FieldType>(FieldTypeId.ToString(), out FieldType result))
{
Type = result;
}
#region << Field Type init >>
switch (Type)
{
case FieldType.AutoNumberField:
DisplayFormat = "{0}";
break;
case FieldType.CurrencyField:
CurrencyOptions = Helpers.GetAllCurrency().MapTo <SelectOption>();
break;
case FieldType.DateTimeField:
Format = "yyyy-MMM-dd HH:mm";
break;
default:
break;
}
#endregion
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("read", "read"),
new SelectOption("update", "update")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
}
#endregion
#region << Actions >>
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Create Field", formId: "CreateRecord", btnClass: "btn btn-green btn-sm", iconClass: "ti-plus"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl)
});
#endregion
}
public void PageInit()
{
#region << Init Entity >>
var entMan = new EntityManager();
ErpEntity = entMan.ReadEntity(RecordId ?? Guid.Empty).Object;
if (ErpEntity != null && PageContext.HttpContext.Request.Method == "GET")
{
Name = ErpEntity.Name;
Label = ErpEntity.Label;
LabelPlural = ErpEntity.LabelPlural;
System = ErpEntity.System;
IconName = ErpEntity.IconName;
Color = ErpEntity.Color;
RecordScreenIdField = ErpEntity.RecordScreenIdField;
foreach (var field in ErpEntity.Fields)
{
FieldOptions.Add(new SelectOption()
{
Value = field.Id.ToString(),
Label = field.Name
});
}
}
#endregion
if (String.IsNullOrWhiteSpace(ReturnUrl))
{
ReturnUrl = $"/sdk/objects/entity/r/{ErpEntity.Id}/";
}
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("create", "create"),
new SelectOption("read", "read"),
new SelectOption("update", "update"),
new SelectOption("delete", "delete")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
if (ErpEntity.RecordPermissions.CanCreate.Contains(role.Id))
{
keyValuesObj.Values.Add("create");
}
if (ErpEntity.RecordPermissions.CanRead.Contains(role.Id))
{
keyValuesObj.Values.Add("read");
}
if (ErpEntity.RecordPermissions.CanUpdate.Contains(role.Id))
{
keyValuesObj.Values.Add("update");
}
if (ErpEntity.RecordPermissions.CanDelete.Contains(role.Id))
{
keyValuesObj.Values.Add("delete");
}
valueGrid.Add(keyValuesObj);
}
if (HttpContext.Request.Method == "GET")
{
RecordPermissions = JsonConvert.SerializeObject(valueGrid);
}
#endregion
#region << Actions >>
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Save Entity", formId: "ManageRecord"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl, btnClass: "btn btn-sm btn-outline-secondary ml-1")
});
HeaderToolbar.AddRange(AdminPageUtils.GetEntityAdminSubNav(ErpEntity, "details"));
#endregion
}
public void InitPage(bool isGet = true)
{
IsPostgisInstalled = DbRepository.IsPostgisInstalled();
var entMan = new EntityManager();
ErpEntity = entMan.ReadEntity(ParentRecordId ?? Guid.Empty).Object;
var allCards = AdminPageUtils.GetFieldCards();
if (FieldTypeId == 20) //RelationField
{
throw new Exception("RelationField is unsupported field type");
}
FieldCard = allCards.First(x => (string)x["type"] == FieldTypeId.ToString());
if (Enum.TryParse <FieldType>(FieldTypeId.ToString(), out FieldType result))
{
Type = result;
}
if (isGet)
{
#region << Field Type init >>
switch (Type)
{
case FieldType.AutoNumberField:
DisplayFormat = "{0}";
break;
case FieldType.CurrencyField:
CurrencyOptions = Helpers.GetAllCurrency().MapTo <SelectOption>();
break;
case FieldType.DateTimeField:
Format = "yyyy-MMM-dd HH:mm";
break;
case FieldType.GeographyField:
{
foreach (int format in Enum.GetValues(typeof(GeographyFieldFormat)))
{
string value = format.ToString();
string name = ((GeographyFieldFormat)format).ToString();
GeographyFormats.Add(new SelectOption(value, name));
}
}
break;
default:
break;
}
#endregion
#region << Init RecordPermissions >>
var valueGrid = new List <KeyStringList>();
PermissionOptions = new List <SelectOption>()
{
new SelectOption("read", "read"),
new SelectOption("update", "update")
};
var roles = AdminPageUtils.GetUserRoles(); //Special order is applied
foreach (var role in roles)
{
RoleOptions.Add(new SelectOption(role.Id.ToString(), role.Name));
var keyValuesObj = new KeyStringList()
{
Key = role.Id.ToString(),
Values = new List <string>()
};
}
#endregion
}
#region << Actions >>
if (Type != FieldType.GeographyField)
{
HeaderActions.AddRange(new List <string>()
{
PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Create Field", formId: "CreateRecord", btnClass: "btn btn-green btn-sm", iconClass: "fa fa-plus"),
PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl)
});
}
else if (Type == FieldType.GeographyField)
{
if (IsPostgisInstalled)
{
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.SubmitForm, label: "Create Field", formId: "CreateRecord", btnClass: "btn btn-green btn-sm", iconClass: "fa fa-plus"));
}
HeaderActions.Add(PageUtils.GetActionTemplate(PageUtilsActionType.Cancel, returnUrl: ReturnUrl));
}
#endregion
}