public JsonResult UpdateEntity(List <KeyValue> keyValues)
{
try
{
var id = keyValues.FirstOrDefault(x => x.Key == "Id")?.Value;
var name = keyValues.FirstOrDefault(x => x.Key == "Name")?.Value;
var displayName = keyValues.FirstOrDefault(x => x.Key == "DisplayName")?.Value;
var pluralName = keyValues.FirstOrDefault(x => x.Key == "PluralName")?.Value;
var isDisplayOnSideMenu = keyValues.FirstOrDefault(x => x.Key == "IsDisplayOnSideMenu")?.Value;
var sideMenuParentItemId = keyValues.FirstOrDefault(x => x.Key == "SideMenuParentItemId")?.Value;
var sideMenuItemPosition = keyValues.FirstOrDefault(x => x.Key == "SideMenuItemPosition")?.Value;
var fieldTypes = FieldTypeService.QueryFieldTypes();
#region Update entity record
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Entity_update]",
new List <SqlParameter>
{
new SqlParameter("@id", id),
new SqlParameter("@name", name),
new SqlParameter("@displayName", displayName),
new SqlParameter("@pluralName", pluralName),
new SqlParameter("@isDisplayOnSideMenu", isDisplayOnSideMenu),
new SqlParameter("@sideMenuParentItemId", sideMenuParentItemId),
new SqlParameter("@sideMenuItemPosition", sideMenuItemPosition),
new SqlParameter("@stateId", 1)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var newlyCreatedEntity = EntityService.QueryEntityById(Guid.Parse(id));
if (newlyCreatedEntity == null)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult DeleteField(Guid fieldId)
{
try
{
var field = FieldService.QueryFieldById(fieldId);
if (field == null)
{
return(Json(new { message = "Le système n'a pas trouvé l'enregistrement à supprimer!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#region Delete Field Record
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Field_deletefieldbyfieldid]",
new List <SqlParameter>
{
new SqlParameter("@fieldId", fieldId)
});
var deletedField = FieldService.QueryFieldById(fieldId);
if (deletedField != null)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Delete Sql Table Column
var name = field.FirstOrDefault(x => x.Key == "Name").Value.ToString();
var entityName = field.FirstOrDefault(x => x.Key == "EntityName").Value.ToString();
var returnValueDeleteSqlTableColumn = SqlService.DeleteSqlTableColumn(entityName, name);
if (!returnValueDeleteSqlTableColumn)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = "L'attribut a été supprimé avec succès!.", type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CreateField(List <KeyValue> keyValues)
{
try
{
var id = Guid.NewGuid();
var name = keyValues.FirstOrDefault(x => x.Key == "Name")?.Value;
var displayName = keyValues.FirstOrDefault(x => x.Key == "DisplayName")?.Value;
var description = keyValues.FirstOrDefault(x => x.Key == "Description")?.Value;
var entityId = keyValues.FirstOrDefault(x => x.Key == "EntityId")?.Value;
var entityName = keyValues.FirstOrDefault(x => x.Key == "EntityName")?.Value;
var fieldTypeId = keyValues.FirstOrDefault(x => x.Key == "FieldTypeId")?.Value;
var fieldTypeName = keyValues.FirstOrDefault(x => x.Key == "FieldTypeName")?.Value;
var isRequired = keyValues.FirstOrDefault(x => x.Key == "IsRequired")?.Value;
var lookupEntityName = keyValues.FirstOrDefault(x => x.Key == "LookupEntityName")?.Value;
#region Create field record
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Field_create]",
new List <SqlParameter>
{
new SqlParameter("@id", id),
new SqlParameter("@name", name),
new SqlParameter("@displayName", displayName),
new SqlParameter("@description", description),
new SqlParameter("@entityId", entityId),
new SqlParameter("@fieldTypeId", fieldTypeId),
new SqlParameter("@isRequired", isRequired),
new SqlParameter("@stateId", 1)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var newlyCreatedField = FieldService.QueryFieldById(id);
if (newlyCreatedField == null)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Create sql table column
var returnValueCreateSqlTableColumn = SqlService.CreateSqlTableColumn(entityName, name, fieldTypeName, (isRequired == "true" ? "NOT NULL": ""));
if (!returnValueCreateSqlTableColumn)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Create sql foreign key constraint
if (lookupEntityName == null)
{
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
var returnValueCreateSqlForeignKeyConstraint = SqlService.CreateSqlForeignKeyConstraint(entityName, lookupEntityName, name);
if (!returnValueCreateSqlForeignKeyConstraint)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { message = ex.Message, type = "error" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CreateEntity(List <KeyValue> keyValues)
{
try
{
var id = Guid.NewGuid();
var name = keyValues.FirstOrDefault(x => x.Key == "Name")?.Value;
var displayName = keyValues.FirstOrDefault(x => x.Key == "DisplayName")?.Value;
var pluralName = keyValues.FirstOrDefault(x => x.Key == "PluralName")?.Value;
var fieldTypes = FieldTypeService.QueryFieldTypes();
#region Create entity record
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Entity_create]",
new List <SqlParameter>
{
new SqlParameter("@id", id),
new SqlParameter("@name", (name.ToLower())),
new SqlParameter("@displayName", displayName),
new SqlParameter("@pluralName", pluralName),
new SqlParameter("@stateId", 1)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var newlyCreatedEntity = EntityService.QueryEntityById(id);
if (newlyCreatedEntity == null)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Create sql table
var returnValueCreateSqlTable = SqlService.CreateSqlTable(name);
if (!returnValueCreateSqlTable)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
/*Create Fields*/
#region Id Field
/*Id*/
var fieldId = Guid.NewGuid();
var fieldName = "Id";
var fieldDisplayName = "Id";
var fieldDescription = "";
var fieldDefaultValue = "";
var fieldEntityId = id;
var GuidFieldType = FieldTypeService.QueryFieldTypeByName("Guid");
var GuidFieldTypeId = (int)GuidFieldType.FirstOrDefault(x => x.Key == "Id").Value;
var GuidFieldTypeSqlDataType = GuidFieldType.FirstOrDefault(x => x.Key == "SqlDataTypeName").Value.ToString();
var fieldStateId = 1;
var returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, GuidFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Name Field
/*Name*/
fieldId = Guid.NewGuid();
fieldName = "Name";
fieldDisplayName = "Name";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
var texteFieldType = FieldTypeService.QueryFieldTypeByName("Texte");
var texteFieldTypeId = (int)texteFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, texteFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region CreatedOn Field
/*CreatedOn*/
fieldId = Guid.NewGuid();
fieldName = "CreatedOn";
fieldDisplayName = "Date de Création";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
var dateTimeFieldType = FieldTypeService.QueryFieldTypeByName("Date et Heure");
var dateTimeFieldTypeId = (int)dateTimeFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, dateTimeFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region CreatedById Field
/*CreatedId*/
fieldId = Guid.NewGuid();
fieldName = "CreatedById";
fieldDisplayName = "Créer par";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
var lookupFieldType = FieldTypeService.QueryFieldTypeByName("Recherche");
var lookupFieldTypeId = (int)lookupFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, lookupFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region ModifiedOn
/*ModifiedOn*/
fieldId = Guid.NewGuid();
fieldName = "ModifiedOn";
fieldDisplayName = "Date de modification";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, dateTimeFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region ModifiedById Field
/*ModifiedById*/
fieldId = Guid.NewGuid();
fieldName = "ModifiedById";
fieldDisplayName = "Modifié par";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
lookupFieldType = FieldTypeService.QueryFieldTypeByName("Recherche");
lookupFieldTypeId = (int)lookupFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, lookupFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult DeleteEntity(Guid entityId)
{
try
{
var entity = EntityService.QueryEntityById(entityId);
if (entity == null)
{
return(Json(new { message = "Le système n'a pas trouvé l'enregistrement à supprimer!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#region Delete Field Records
var fieldsDeleteError = false;
var fields = FieldService.QueryFieldsByEntityId(entityId);
foreach (var field in fields)
{
var fieldId = (Guid)field.FirstOrDefault(x => x.Key == "Id").Value;
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Field_deletefieldbyfieldid]",
new List <SqlParameter>
{
new SqlParameter("@fieldId", fieldId)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var deletedField = FieldService.QueryFieldById(fieldId);
if (deletedField != null)
{
fieldsDeleteError = true;
}
}
if (fieldsDeleteError)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Delete Entity Record
var returnValueDeleteEntity = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Entity_deleteentitybyentityid]",
new List <SqlParameter>
{
new SqlParameter("@entityId", entityId)
});
if (returnValueDeleteEntity != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var deletedEntity = EntityService.QueryEntityById(entityId);
if (deletedEntity != null)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Delete Sql Table
var entityName = entity.FirstOrDefault(x => x.Key == "Name").Value.ToString();
var returnValueDeleteSqlTableColumn = SqlService.DeleteSqlTable(entityName);
if (!returnValueDeleteSqlTableColumn)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = "L'entité a été supprimé avec succès!.", type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
