public ActionResult ProcessCustomListData(List <CustomListDataViewModel> listDataList)
{
var acResponse = new ActivityResponse {
ListDataList = listDataList, SaveMessages = new List <string>()
};
try
{
if (!listDataList.Any())
{
acResponse.Code = -1;
acResponse.Message = "An unknown error was encountered. Please try again later";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
if (listDataList.Any(p => string.IsNullOrEmpty(p.CustomListId) || string.IsNullOrEmpty(p.ListDataName)))
{
acResponse.Code = -1;
acResponse.Message = "Please provide all required fields and try again";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
listDataList.ForEach(p =>
{
if (string.IsNullOrEmpty(p.CustomListDataId) || p.CustomListDataId == "0")
{
var pcFields = _customListDataService.Query(o => o.ListDataName == p.ListDataName && o.CustomListId == p.CustomListId).Select().ToList();
if (!pcFields.Any())
{
var data = new CustomListData
{
CustomListDataId = Guid.NewGuid().ToString(),
CustomListId = p.CustomListId,
ListDataName = p.ListDataName
};
if (!string.IsNullOrEmpty(p.ParentNodeId))
{
data.ParentNodeId = p.ParentNodeId;
}
else if (!string.IsNullOrEmpty(p.ParentData))
{
var pNodeData = _customListDataService.Query(o => o.ListDataName.ToLower() == p.ParentData.ToLower()).Select().ToList();
if (pNodeData.Any())
{
data.ParentNodeId = pNodeData[0].CustomListDataId;
}
}
_customListDataService.Insert(data);
_unitOfWork.SaveChanges();
}
}
else
{
//Checks if CustomListData Name Exists if the CustomListDataId is not null/empty
var dupDatas = _customListDataService.Query(o => o.ListDataName == p.ListDataName && o.CustomListId == p.CustomListId && o.CustomListDataId != p.CustomListDataId).Select().ToList();
if (!dupDatas.Any())
{
var dataListToUpdate = _customListDataService.Query(o => o.CustomListDataId == p.CustomListDataId).Select().ToList();
if (dataListToUpdate.Any())
{
var dataToUpdate = dataListToUpdate[0];
if (!string.IsNullOrEmpty(p.ParentNodeId))
{
dataToUpdate.ParentNodeId = p.ParentNodeId;
}
else if (!string.IsNullOrEmpty(p.ParentData))
{
var pNodeData = _customListDataService.Query(o => o.ListDataName.ToLower() == p.ParentData.ToLower()).Select().ToList();
if (pNodeData.Any())
{
dataToUpdate.ParentNodeId = pNodeData[0].CustomListDataId;
}
}
dataToUpdate.ListDataName = p.ListDataName;
dataToUpdate.CustomListId = p.CustomListId;
_customListDataService.Update(dataToUpdate);
_unitOfWork.SaveChanges();
}
}
}
});
acResponse.Code = 5;
acResponse.Message = "Process was successfully completed";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
acResponse.Code = -1;
acResponse.Message = "An unknown error was encountered. Please try again.";
ErrorLogger.LogError(e.StackTrace, e.Source, e.Message);
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
}
public ActionResult InstallLicense()
{
var acResponse = new ActivityResponse();
try
{
if (Request.Files != null)
{
var file = Request.Files[0];
if (file == null || file.ContentLength < 1)
{
acResponse.Code = -1;
acResponse.Message = "The provided Site License File could not be correctly accessed. Please provide all required fields and try again later";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
const string folderPath = "~/TempProject";
var mainPath = Server.MapPath(folderPath);
if (!Directory.Exists(mainPath))
{
Directory.CreateDirectory(mainPath);
var dInfo = new DirectoryInfo(mainPath);
var dSecurity = dInfo.GetAccessControl();
dSecurity.AddAccessRule(new FileSystemAccessRule(new SecurityIdentifier(WellKnownSidType.WorldSid, null), FileSystemRights.FullControl, InheritanceFlags.ObjectInherit | InheritanceFlags.ContainerInherit, PropagationFlags.NoPropagateInherit, AccessControlType.Allow));
dInfo.SetAccessControl(dSecurity);
}
var fileName = file.FileName;
var existingFiles = Directory.GetFiles(mainPath);
if (existingFiles.Any())
{
existingFiles.ForEach(System.IO.File.Delete);
}
var path = Path.Combine(mainPath, fileName);
file.SaveAs(path);
var projectLicense = JsonConvert.DeserializeObject <ProjectLicense>(System.IO.File.ReadAllText(path));
var customGroups = new List <CustomGroup>(projectLicense.CustomGroups);
var customFieldTypes = new List <CustomFieldType>(projectLicense.CustomFieldTypes);
var customFields = new List <CustomField>(projectLicense.CustomFields);
var customLists = new List <CustomList>(projectLicense.CustomLists);
var customListData = new List <CustomListData>(projectLicense.CustomListData);
var projectCustomGroups = new List <ProjectCustomGroup>(projectLicense.ProjectCustomGroups);
var projectCustomFields = new List <ProjectCustomField>(projectLicense.ProjectCustomFields);
if (string.IsNullOrEmpty(projectLicense?.ProjectCode) || !customFieldTypes.Any() || !customGroups.Any() || !customFields.Any() || !customLists.Any() || !customListData.Any() || !projectCustomGroups.Any() || !projectCustomFields.Any())
{
acResponse.Code = -1;
acResponse.Message = "The provided Project setup File could not be correctly accessed. Please provide all required fields and try again later";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
var processedProjectTableId = 0;
var projects = _projectService.Query(p => p.ProjectCode == projectLicense.ProjectCode).Select().ToList();
if (projects.Any())
{
var project = projects[0];
project.ProjectName = projectLicense.ProjectName;
project.ProjectDescription = projectLicense.ProjectDescription;
project.ActivationCode = projectLicense.ActivationCode;
project.OnlineMode = projectLicense.OnlineMode;
project.LicenseExpiryDate = projectLicense.LicenseExpiryDate;
_projectService.Update(project);
_unitOfWork.SaveChanges();
processedProjectTableId = project.TableId;
}
else
{
var project = new Project
{
ProjectName = projectLicense.ProjectName,
ProjectDescription = projectLicense.ProjectDescription,
ProjectCode = projectLicense.ProjectCode,
DateCreated = DateTime.Now,
LicenceCode = projectLicense.LicenceCode,
ActivationCode = projectLicense.ActivationCode,
OnlineMode = projectLicense.OnlineMode,
LicenseExpiryDate = projectLicense.LicenseExpiryDate
};
_projectService.Insert(project);
processedProjectTableId = _unitOfWork.SaveChanges();
}
if (processedProjectTableId < 1)
{
acResponse.Code = -1;
acResponse.Message = "Project Licensing failed. Please try again later of contact support.";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
var oldFieldTypes = _customFieldTypeService.Queryable().ToList();
if (oldFieldTypes.Any())
{
customFieldTypes.ForEach(g =>
{
var fieldTypes = oldFieldTypes.Where(x => x.FieldTypeId == g.FieldTypeId).ToList();
if (fieldTypes.Any())
{
var f = fieldTypes[0];
f.FieldTypeName = g.FieldTypeName;
_customFieldTypeService.Update(f);
_unitOfWork.SaveChanges();
}
else
{
_customFieldTypeService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_customFieldTypeService.InsertRange(customFieldTypes);
}
var projectCustomGroupEntities = _projectCustomGroupService.Query(g => g.ProjectCode == projectLicense.ProjectCode).Select().ToList();
if (projectCustomGroupEntities.Any())
{
projectCustomGroups.ForEach(g =>
{
var group = projectCustomGroupEntities.Find(d => d.CustomGroupId == g.CustomGroupId);
if (!string.IsNullOrEmpty(@group?.CustomGroupId))
{
group.TabIndex = g.TabIndex;
_projectCustomGroupService.Update(group);
_unitOfWork.SaveChanges();
}
else
{
_projectCustomGroupService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_projectCustomGroupService.InsertRange(projectCustomGroups);
}
var projectCustomFieldEntities = _projectCustomFieldService.Query(f => f.ProjectCode == projectLicense.ProjectCode).Select().ToList();
if (projectCustomFieldEntities.Any())
{
projectCustomFields.ForEach(g =>
{
var field = projectCustomFieldEntities.Find(d => d.CustomFieldId == g.CustomFieldId);
if (string.IsNullOrEmpty(field?.CustomFieldId))
{
_projectCustomFieldService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_projectCustomFieldService.InsertRange(projectCustomFields);
}
var customGroupEntities = _customGroupService.Queryable().ToList();
if (customGroupEntities.Any())
{
customGroups.ForEach(g =>
{
var cGroup = customGroupEntities.Find(d => d.CustomGroupId == g.CustomGroupId);
if (!string.IsNullOrEmpty(cGroup?.CustomGroupId))
{
cGroup.GroupName = g.GroupName;
cGroup.TabIndex = g.TabIndex;
_customGroupService.Update(cGroup);
_unitOfWork.SaveChanges();
}
else
{
g.TableId = 0;
_customGroupService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_customGroupService.InsertRange(customGroups);
}
var customFieldEntities = _customFieldService.Queryable().ToList();
if (customFieldEntities.Any())
{
customFields.ForEach(g =>
{
var cField = customFieldEntities.Find(d => d.CustomFieldId == g.CustomFieldId);
if (!string.IsNullOrEmpty(cField?.CustomFieldId))
{
cField.CustomFieldName = g.CustomFieldName;
cField.TabIndex = g.TabIndex;
cField.CustomFieldSize = g.CustomFieldSize;
cField.CustomListId = g.CustomListId;
cField.ParentFieldId = g.ParentFieldId;
cField.Required = g.Required;
cField.FieldTypeId = g.FieldTypeId;
cField.CustomGroupId = g.CustomGroupId;
_customFieldService.Update(cField);
_unitOfWork.SaveChanges();
}
else
{
g.TableId = 0;
_customFieldService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_customFieldService.InsertRange(customFields);
}
var customListEntities = _customListService.Queryable().ToList();
if (customListEntities.Any())
{
customLists.ForEach(g =>
{
var cList = customListEntities.Find(d => d.CustomListId == g.CustomListId);
if (!string.IsNullOrEmpty(cList?.CustomListId))
{
cList.CustomListName = g.CustomListName;
cList.CustomListName = g.CustomListName;
cList.ParentListId = g.ParentListId;
_customListService.Update(cList);
_unitOfWork.SaveChanges();
}
else
{
g.TableId = 0;
_customListService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_customListService.InsertRange(customLists);
}
var customListDataEntities = _customListDataService.Queryable().ToList();
if (customListDataEntities.Any())
{
customListData.ForEach(g =>
{
var cListData = customListDataEntities.Find(d => d.CustomListId == g.CustomListId);
if (!string.IsNullOrEmpty(cListData?.CustomListId))
{
cListData.CustomListId = g.CustomListId;
cListData.ListDataName = g.ListDataName;
cListData.ParentNodeId = g.ParentNodeId;
_customListDataService.Update(cListData);
_unitOfWork.SaveChanges();
}
else
{
g.TableId = 0;
_customListDataService.Insert(g);
_unitOfWork.SaveChanges();
}
});
}
else
{
_customListDataService.InsertRange(customListData);
}
_unitOfWork.SaveChanges();
//Necesary to initialise and construct the Identity Tables in the created database
var usermanager = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>();
usermanager?.FindByEmail("*****@*****.**");
acResponse.Code = 5;
acResponse.Message = "The Project License was successfully installed.";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
acResponse.Code = -1;
acResponse.Message = "The provided Site License File could not be correctly accessed. Please provide all required fields and try again later";
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
ErrorLogger.LogError(e.StackTrace, e.Source, e.Message);
acResponse.Code = -1;
acResponse.Message = e.Message;
return(Json(acResponse, JsonRequestBehavior.AllowGet));
}
}