private bool unitInUse(Unit unit)
{
DataStructureManager dataStructureManager = null;
DataContainerManager dataAttributeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
dataStructureManager = new DataStructureManager();
bool inUse = false;
if (unit.Name.ToLower() == "none")
{
inUse = true;
}
else if (dataAttributeManager.DataAttributeRepo.Query(d => d.Unit.Id.Equals(unit.Id)).Count() > 0)
{
inUse = true;
}
else if (dataStructureManager.VariableRepo.Query(d => d.Unit.Id.Equals(unit.Id)).Count() > 0)
{
inUse = true;
}
return(inUse);
}
finally
{
dataAttributeManager.Dispose();
dataStructureManager.Dispose();
}
}
public ActionResult deletConstraint(long Id, long attributeId)
{
if (Id != 0 && attributeId != 0)
{
DataContainerManager dam = null;
try
{
dam = new DataContainerManager();
DataAttribute dataattribute = dam.DataAttributeRepo.Get(attributeId);
Constraint constraint = dam.DataAttributeRepo.Get(attributeId).Constraints.Where(c => c.Id == Id).FirstOrDefault();
foreach (Constraint c in dataattribute.Constraints.ToList())
{
if (c.Id == constraint.Id)
{
dataattribute.Constraints.Remove(c);
break;
}
}
dataattribute = dam.UpdateDataAttribute(dataattribute);
}
finally
{
dam.Dispose();
}
//if (constraint is RangeConstraint)
// dam.RemoveConstraint((RangeConstraint)constraint);
}
return(RedirectToAction("openAttributeWindow", new { Id = attributeId, showConstraints = true }));
}
public ActionResult deleteDataAttribute(long Id, string cssId = "")
{
MessageModel DataAttributeDeleteValidation = MessageModel.validateAttributeDelete(Id);
if (DataAttributeDeleteValidation.hasMessage)
{
return(PartialView("_messageWindow", DataAttributeDeleteValidation));
}
else
{
DataContainerManager dataAttributeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
DataAttribute dataAttribute = dataAttributeManager.DataAttributeRepo.Get(Id);
dataAttributeManager.DeleteDataAttribute(dataAttribute);
return(PartialView("_message", new MessageModel()
{
Message = "DataStructure" + Id + "deleted",
hasMessage = false,
CssId = "deleted"
}));
}
finally
{
dataAttributeManager.Dispose();
}
}
}
public void CreateDomainConstraint(ResourceStructureAttribute attr, List <DomainItem> domainItems)
{
using (DataContainerManager dcManager = new DataContainerManager())
{
DomainConstraint c3 = new DomainConstraint(ConstraintProviderSource.Internal, "", "en-US", "a simple domain validation constraint", false, null, null, null, domainItems);
dcManager.AddConstraint(c3, attr);
}
}
public JsonResult DisplayPattern(long id, string variable)
{
//id less then 1 is not possible so return empty string
if (id <= 0)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
using (var datasetManager = new DatasetManager())
using (var dataStructureManager = new DataStructureManager())
using (var dataContainerManager = new DataContainerManager())
using (var dataTypeManager = new DataTypeManager())
{
var dataset = datasetManager.GetDataset(id);
if (dataset == null)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
var datastructureId = dataset.DataStructure.Id;
var datastructure = dataStructureManager.StructuredDataStructureRepo.Get(datastructureId);
var v = datastructure.Variables.Where(var => var.Label.ToLower().Equals(variable.ToLower())).FirstOrDefault();
//if variable not exit return false
if (v == null)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
if (v.DataAttribute != null)
{
var attr = dataContainerManager.DataAttributeRepo.Get(v.DataAttribute.Id);
if (attr.DataType.SystemType.Equals("DateTime"))
{
var dataType = dataTypeManager.Repo.Get(attr.DataType.Id);
if (dataType != null && dataType.Extra != null)
{
DataTypeDisplayPattern dp = DataTypeDisplayPattern.Materialize(dataType.Extra);
if (dp != null)
{
return(Json(dp.StringPattern, JsonRequestBehavior.AllowGet));
}
}
}
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <remarks></remarks>
/// <seealso cref=""/>
public void GetDataAttributeList()
{
DataContainerManager DataAttributeManager = null;
try
{
DataAttributeManager = new DataContainerManager();
this.dataAttributeList = DataAttributeManager.DataAttributeRepo.Get().ToList();
}
finally
{
DataAttributeManager.Dispose();
}
}
public static MessageModel validateAttributeInUse(long Id)
{
DataContainerManager dataAttributeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
DataAttribute dataAttribute = dataAttributeManager.DataAttributeRepo.Get(Id);
return(validateAttributeInUse(Id, dataAttribute));
}
finally
{
dataAttributeManager.Dispose();
}
}
/// <summary>
/// This function creates a dictionary based on the data structure with variable labels as keys and the corresponding datatype as value.
/// </summary>
/// <param name="dataSturctureId"></param>
/// <returns></returns>
private Dictionary <string, string> GetVariablesWithType(long dataSturctureId)
{
Dictionary <string, string> tmp = new Dictionary <string, string>();
using (var dataStructureManager = new DataStructureManager())
using (var dataTypeManager = new DataTypeManager())
using (var dataContainerManager = new DataContainerManager())
{
// check if structure is sturctured or files only
var structuredDataSturcture = dataStructureManager.StructuredDataStructureRepo.Get(dataSturctureId);
if (structuredDataSturcture == null)
{
throw new Exception("Datastructure is not structured");
}
//check if variables exist
if (structuredDataSturcture.Variables.Any())
{
//go to each variable
foreach (var v in structuredDataSturcture.Variables)
{
// because of lazy loading data needs to be loaded directly
// load data attribute from varibale
var dataAttribute = dataContainerManager.DataAttributeRepo.Get(v.DataAttribute.Id);
if (dataAttribute == null)
{
throw new Exception("DataAttribute with Id " + v.DataAttribute.Id + "not exist.");
}
// load datatype from data attribute
var dataType = dataTypeManager.Repo.Get(dataAttribute.DataType.Id);
if (dataType == null)
{
throw new Exception("DataType with Id " + dataType.Id + "not exist.");
}
// get the systemtype name of the datatype and use this as the key for the dictionary
var systemstype = dataType?.SystemType;
// add variable label and systemtype to dictionary
tmp.Add(v.Label, systemstype);
}
}
}
return(tmp);
}
public AttributePreviewStruct fill(long attributeId, bool getConstraints)
{
DataContainerManager dataAttributeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
DataAttribute DataAttribute = dataAttributeManager.DataAttributeRepo.Get(attributeId);
return(this.fill(DataAttribute, getConstraints));
}
finally
{
dataAttributeManager.Dispose();
}
}
public void RegisterTypes(IUnityContainer container)
{
// Register services
container.RegisterType <IBetService, BetService>();
container.RegisterType <IBetStatisticService, BetsStatisticService>();
container.RegisterType <ICategoryService, CategoryService>();
container.RegisterType <IGamePropertyService, GamePropertyService>();
container.RegisterType <IMovieService, MovieService>();
container.RegisterType <IWatchedMovieService, WatchedMovieService>();
container.RegisterType <IWatcheMoviesStatisticService, WatcheMoviesStatisticService>();
// Register data types
DataContainerManager containerManager = new DataContainerManager();
containerManager.RegisterTypes(container);
}
public DataAttributeManagerModel(DataAttributeModel dataAttributeModel)
{
try
{
dataContainerManager = new DataContainerManager();
DataAttributeModel = dataAttributeModel;
dataContainerManager.DataAttributeRepo.Get().ToList().ForEach(da => DataAttributeStructs.Add(new DataAttributeStruct()
{
Id = da.Id, Name = da.Name, ShortName = da.ShortName, Description = da.Description, DataType = da.DataType.Name, Unit = da.Unit.Name, InUse = inUse(da), FormalDescriptions = getFormalDescriptions(da)
}));
}
finally
{
dataContainerManager.Dispose();
}
}
public DataAttribute storeDomainConstraint(DomainConstraintModel constraintModel)
{
DataContainerManager dcManager = null;
try
{
dcManager = new DataContainerManager();
DataAttribute dataAttribute = dcManager.DataAttributeRepo.Get(constraintModel.AttributeId);
List <DomainItem> items = new List <DomainItem>();
if (constraintModel.Terms != null && constraintModel.Terms.Trim() != "")
{
items = createDomainItems(constraintModel.Terms.Trim());
}
if (items.Any())
{
if (constraintModel.Id == 0)
{
DomainConstraint constraint = new DomainConstraint(ConstraintProviderSource.Internal, "", AppConfiguration.Culture.Name, constraintModel.Description, constraintModel.Negated, null, null, null, items);
dcManager.AddConstraint(constraint, dataAttribute);
}
else
{
DomainConstraint temp = new DomainConstraint();
for (int i = 0; i < dataAttribute.Constraints.Count; i++)
{
if (dataAttribute.Constraints.ElementAt(i).Id == constraintModel.Id)
{
temp = (DomainConstraint)dataAttribute.Constraints.ElementAt(i);
temp.Materialize();
temp.Description = constraintModel.Description;
temp.Negated = constraintModel.Negated;
temp.Items = items;
dcManager.AddConstraint(temp, dataAttribute);
break;
}
}
}
}
return(dataAttribute);
}
finally
{
dcManager.Dispose();
}
}
public List <VariableStruct> getOrderedVariableStructs(StructuredDataStructure structuredDataStructure)
{
List <VariableStruct> variableStructs = new List <VariableStruct>();
List <Variable> variables = getOrderedVariables(structuredDataStructure);
DataContainerManager dataAttributeManager = null;
VariableStruct temp = new VariableStruct();
List <BExIS.Dlm.Entities.DataStructure.Constraint> tempconstraints;
UnitDimenstionModel unitDimenstionModel = new UnitDimenstionModel();
foreach (Variable v in variables)
{
try
{
unitDimenstionModel = new UnitDimenstionModel();
temp.variable = v;
temp.unitStructs = unitDimenstionModel.getUnitListByDimenstionAndDataType(v.DataAttribute.Unit.Dimension.Id, v.DataAttribute.DataType.Id);
dataAttributeManager = new DataContainerManager();
tempconstraints = dataAttributeManager.DataAttributeRepo.Get(v.DataAttribute.Id).Constraints.ToList();
temp.rangeConstraints = new List <RangeConstraint>();
temp.domainConstraints = new List <DomainConstraint>();
temp.patternConstraints = new List <PatternConstraint>();
foreach (BExIS.Dlm.Entities.DataStructure.Constraint c in tempconstraints)
{
if (c is DomainConstraint)
{
DomainConstraint tempDomainConstraint = (DomainConstraint)c;
tempDomainConstraint.Materialize();
temp.domainConstraints.Add(tempDomainConstraint);
}
if (c is PatternConstraint)
{
temp.patternConstraints.Add((PatternConstraint)c);
}
if (c is RangeConstraint)
{
temp.rangeConstraints.Add((RangeConstraint)c);
}
}
variableStructs.Add(temp);
}
finally
{
dataAttributeManager.Dispose();
}
}
return(variableStructs);
}
public static MessageModel validateAttributeName(long Id, string Name, string cssId = "")
{
if (Name.Trim() == "" || string.IsNullOrEmpty(Name))
{
return(new MessageModel()
{
hasMessage = true,
Message = "The name field is required.",
CssId = cssId
});
}
else
{
DataContainerManager dataContainerManager = null;
dataContainerManager = new DataContainerManager();
try
{
List <DataAttribute> dataAttributes = dataContainerManager.DataAttributeRepo.Get().ToList();
foreach (DataAttribute da in dataAttributes)
{
if (Id != da.Id)
{
if (da.Name.Trim().ToLower() == Name.Trim().ToLower())
{
return(new MessageModel()
{
hasMessage = true,
Message = "A variable template with same name already exists.",
CssId = cssId
});
}
}
}
}
finally
{
dataContainerManager.Dispose();
}
}
return(new MessageModel()
{
CssId = cssId
});
}
public AttributePreviewModel fill(bool getConstraints)
{
this.AttributePreviews = new List <AttributePreviewStruct>();
DataContainerManager dataAttributeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
foreach (DataAttribute da in dataAttributeManager.DataAttributeRepo.Get().ToList())
{
this.AttributePreviews.Add(new AttributePreviewStruct().fill(da, getConstraints));
}
return(this);
}
finally
{
dataAttributeManager.Dispose();
}
}
public DataAttribute storeRangeConstraint(RangeConstraintModel constraintModel)
{
DataContainerManager dcManager = null;
try
{
dcManager = new DataContainerManager();
DataAttribute dataAttribute = dcManager.DataAttributeRepo.Get(constraintModel.AttributeId);
if (constraintModel.Max != 0 || constraintModel.Min != 0)
{
if (constraintModel.Id == 0)
{
RangeConstraint constraint = new RangeConstraint(ConstraintProviderSource.Internal, "", AppConfiguration.Culture.Name, constraintModel.Description, constraintModel.Negated, null, null, null, constraintModel.Min, constraintModel.MinInclude, constraintModel.Max, constraintModel.MaxInclude);
dcManager.AddConstraint(constraint, dataAttribute);
}
else
{
for (int i = 0; i < dataAttribute.Constraints.Count; i++)
{
if (dataAttribute.Constraints.ElementAt(i).Id == constraintModel.Id)
{
((RangeConstraint)dataAttribute.Constraints.ElementAt(i)).Description = constraintModel.Description;
((RangeConstraint)dataAttribute.Constraints.ElementAt(i)).Negated = constraintModel.Negated;
((RangeConstraint)dataAttribute.Constraints.ElementAt(i)).Lowerbound = constraintModel.Min;
((RangeConstraint)dataAttribute.Constraints.ElementAt(i)).LowerboundIncluded = constraintModel.MinInclude;
((RangeConstraint)dataAttribute.Constraints.ElementAt(i)).Upperbound = constraintModel.Max;
((RangeConstraint)dataAttribute.Constraints.ElementAt(i)).UpperboundIncluded = constraintModel.MaxInclude;
break;
}
}
}
}
return(dataAttribute);
}
finally
{
dcManager.Dispose();
}
}
private async Task InitializeServicesAsync()
{
if (this.apiClient == null)
{
this.apiClient = ApiClientProvider.GetClient();
}
if (this.typeContainer == null)
{
this.typeContainer = new ContributionTypeContainer(this.apiClient);
}
if (this.areaContainer == null)
{
this.areaContainer = new ContributionAreaContainer(this.apiClient);
}
if (contributionSubmissionService == null)
{
contributionSubmissionService = new ContributionSubmissionService(this.apiClient);
}
if (this.containerManager == null)
{
this.containerManager = new DataContainerManager(
this.typeContainer,
this.areaContainer);
}
try
{
await this.containerManager.LoadAsync();
}
catch (Exception ex)
{
#if DEBUG
System.Diagnostics.Debug.WriteLine(ex.ToString());
#endif
}
}
public DataAttribute deletConstraint(long constraintId, DataAttribute attribute)
{
DataContainerManager dam = null;
try
{
dam = new DataContainerManager();
if (constraintId != 0 && attribute.Id != 0)
{
foreach (Constraint c in attribute.Constraints.ToList())
{
if (c.Id == constraintId)
{
attribute.Constraints.Remove(c);
if (c is RangeConstraint)
{
dam.RemoveConstraint((RangeConstraint)c);
}
if (c is PatternConstraint)
{
dam.RemoveConstraint((PatternConstraint)c);
}
if (c is DomainConstraint)
{
dam.RemoveConstraint((DomainConstraint)c);
}
break;
}
}
}
return(attribute);
}
finally
{
dam.Dispose();
}
}
public new VariablePreviewStruct fill(long attributeId, bool getConstraints)
{
DataContainerManager dataAttributeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
DataAttribute dataAttribute = dataAttributeManager.DataAttributeRepo.Get(attributeId);
Variable variable = new Variable()
{
Label = dataAttribute.Name,
Description = dataAttribute.Description,
Unit = dataAttribute.Unit,
DataAttribute = dataAttribute
};
return(this.fill(variable, getConstraints));
}
finally
{
dataAttributeManager.Dispose();
}
}
public static void RegisterTypes(IUnityContainer container)
{
container.RegisterType <IUnitOfWork>(
new InjectionFactory(x =>
HttpContext.Current
.GetOwinContext()
.Get <IUnitOfWork>()));
container.RegisterType <ApplicationUserManager>(
new InjectionFactory(x =>
HttpContext.Current
.GetOwinContext()
.Get <ApplicationUserManager>()));
container.RegisterType <ApplicationSignInManager>(
new InjectionFactory(x =>
HttpContext.Current
.GetOwinContext()
.Get <ApplicationSignInManager>()));
DataContainerManager.RegisterTypes(container);
BusinessContainerManager.RegisterTypes(container);
}
public DataAttribute storePatternConstraint(PatternConstraintModel constraintModel)
{
DataContainerManager dcManager = null;
try
{
dcManager = new DataContainerManager();
DataAttribute dataAttribute = dcManager.DataAttributeRepo.Get(constraintModel.AttributeId);
if (constraintModel.MatchingPhrase != null && constraintModel.MatchingPhrase != "")
{
if (constraintModel.Id == 0)
{
PatternConstraint constraint = new PatternConstraint(ConstraintProviderSource.Internal, "", AppConfiguration.Culture.Name, constraintModel.Description, constraintModel.Negated, null, null, null, constraintModel.MatchingPhrase, false);
dcManager.AddConstraint(constraint, dataAttribute);
}
else
{
for (int i = 0; i < dataAttribute.Constraints.Count; i++)
{
if (dataAttribute.Constraints.ElementAt(i).Id == constraintModel.Id)
{
((PatternConstraint)dataAttribute.Constraints.ElementAt(i)).Description = constraintModel.Description;
((PatternConstraint)dataAttribute.Constraints.ElementAt(i)).Negated = constraintModel.Negated;
((PatternConstraint)dataAttribute.Constraints.ElementAt(i)).MatchingPhrase = constraintModel.MatchingPhrase;
break;
}
}
}
}
return(dataAttribute);
}
finally
{
dcManager.Dispose();
}
}
public ActionResult deletAttribute(long id, string name)
{
if (id != 0)
{
DataContainerManager DAM = null;
try
{
DAM = new DataContainerManager();
DataAttribute dataAttribute = DAM.DataAttributeRepo.Get(id);
if (dataAttribute != null)
{
if (!attributeInUse(dataAttribute))
{
DAM.DeleteDataAttribute(dataAttribute);
}
}
}
finally
{
DAM.Dispose();
}
}
return(RedirectToAction("AttributeManager"));
}
public MessageModel storeAtttribute(long Id, string Name, long unitId, long dataTypeId, string Description = "", string cssId = "", bool inUse = false)
{
Name = Server.UrlDecode(Name);
Description = Server.UrlDecode(Description);
MessageModel DataStructureValidation = MessageModel.validateAttributeInUse(Id);
if (DataStructureValidation.hasMessage && inUse == false)
{
return(DataStructureValidation);
}
else
{
DataStructureValidation = MessageModel.validateAttributeName(Id, Name, cssId);
if (DataStructureValidation.hasMessage)
{
return(DataStructureValidation);
}
else
{
DataContainerManager dataAttributeManager = null;
UnitManager um = null;
DataTypeManager dataTypeManager = null;
try
{
dataAttributeManager = new DataContainerManager();
DataAttribute dataAttribute;
if (Id == 0)
{
um = new UnitManager();
Unit unit = um.Repo.Get(unitId);
dataTypeManager = new DataTypeManager();
DataType dataType = dataTypeManager.Repo.Get(dataTypeId);
dataAttribute = dataAttributeManager.CreateDataAttribute(Name, Name, Description, false, false, "", MeasurementScale.Categorial, DataContainerType.ReferenceType, "", dataType, unit, null, null, null, null, null, null);
return(new MessageModel()
{
Message = dataAttribute.Id.ToString(),
hasMessage = false,
CssId = "refresh"
});
}
else
{
dataAttribute = dataAttributeManager.DataAttributeRepo.Get(Id);
dataAttribute.Name = Name;
dataAttribute.Description = Description;
dataAttribute = dataAttributeManager.UpdateDataAttribute(dataAttribute);
return(new MessageModel()
{
Message = Id.ToString(),
hasMessage = false,
CssId = "refresh"
});
}
}
finally
{
dataAttributeManager.Dispose();
um.Dispose();
dataTypeManager.Dispose();
}
}
}
}
public ActionResult storeVariables(long Id, storeVariableStruct[] variables)
{
DataStructureManager dataStructureManager = null;
DataContainerManager dataContainerManager = null;
MissingValueManager missingValueManager = null;
UnitManager um = null;
try
{
dataStructureManager = new DataStructureManager();
missingValueManager = new MissingValueManager();
dataContainerManager = new DataContainerManager();
um = new UnitManager();
var structureRepo = dataStructureManager.GetUnitOfWork().GetReadOnlyRepository <StructuredDataStructure>();
StructuredDataStructure dataStructure = structureRepo.Get(Id);
MessageModel returnObject = new MessageModel();
MessageModel messageModel = MessageModel.validateDataStructureInUse(dataStructure.Id, dataStructure);
if (messageModel.hasMessage)
{
foreach (Variable v in dataStructure.Variables)
{
if (variables.Select(svs => svs.Id).ToList().Contains(v.Id))
{
v.Description = variables.Where(svs => svs.Id == v.Id).FirstOrDefault().Description;
dataStructure = dataStructureManager.UpdateStructuredDataStructure(dataStructure);
}
}
return(PartialView("_messageWindow", messageModel));
}
if (variables != null && variables.Any())
{
Variable variable = new Variable();
List <long> order = new List <long>();
foreach (Variable v in dataStructure.Variables)
{
if (!variables.Select(svs => svs.Id).ToList().Contains(v.Id))
{
List <MissingValue> missingValues = missingValueManager.Repo.Query(mv => mv.Variable.Id.Equals(v.Id)).ToList();
foreach (MissingValue mv in missingValues)
{
missingValueManager.Delete(mv);
}
dataStructureManager.RemoveVariableUsage(v);
}
}
foreach (storeVariableStruct svs in variables.Where(svs => svs.Id == 0).ToList())
{
if (svs.Lable == null)
{
svs.Lable = "";
}
if (svs.Description == null)
{
svs.Description = "";
}
DataAttribute dataAttribute = dataContainerManager.DataAttributeRepo.Get(svs.AttributeId);
if (dataAttribute != null)
{
variable = dataStructureManager.AddVariableUsage(dataStructure, dataAttribute, svs.isOptional, svs.Lable.Trim(), null, null, svs.Description.Trim(), um.Repo.Get(svs.UnitId));
svs.Id = variable.Id;
foreach (MissingValueStruct mvs in svs.MissingValues)
{
if (mvs.Id == 0)
{
if (String.IsNullOrEmpty(mvs.Placeholder))
{
missingValueManager.Create(mvs.DisplayName, mvs.Description, variable);
}
else
{
missingValueManager.Create(mvs.DisplayName, mvs.Description, variable, mvs.Placeholder);
}
}
}
}
else
{
returnObject = new MessageModel()
{
hasMessage = true,
Message = "Not all Variables are stored.",
CssId = "0"
};
}
}
//dataStructure = structureRepo.Get(Id); // Javad: why it is needed?
variables = variables.Where(v => v.Id != 0).ToArray();
MissingValue missingValue = new MissingValue();
foreach (storeVariableStruct svs in variables.Where(svs => svs.Id != 0).ToList())
{
if (svs.Lable == null)
{
svs.Lable = "";
}
if (svs.Description == null)
{
svs.Description = "";
}
variable = dataStructure.Variables.Where(v => v.Id == svs.Id).FirstOrDefault();
if (variable != null)
{
variable.Label = svs.Lable.Trim();
variable.Description = svs.Description.Trim();
variable.Unit = um.Repo.Get(svs.UnitId);
variable.DataAttribute = dataContainerManager.DataAttributeRepo.Get(svs.AttributeId);
variable.IsValueOptional = svs.isOptional;
List <MissingValue> missingValues = missingValueManager.Repo.Query(mv => mv.Variable.Id.Equals(svs.Id)).ToList();
foreach (MissingValue mv in missingValues)
{
if (!svs.MissingValues.Select(mvs => mvs.Id).Contains(mv.Id))
{
missingValueManager.Delete(mv);
}
}
foreach (MissingValueStruct mvs in svs.MissingValues)
{
if (mvs.Id == 0)
{
if (String.IsNullOrEmpty(mvs.Placeholder))
{
missingValueManager.Create(mvs.DisplayName, mvs.Description, variable);
}
else
{
missingValueManager.Create(mvs.DisplayName, mvs.Description, variable, mvs.Placeholder);
}
}
else if (mvs.Id > 0)
{
missingValue = missingValues.Where(mv => mv.Id.Equals(mvs.Id)).FirstOrDefault();
if (missingValue != null)
{
missingValue.DisplayName = mvs.DisplayName;
missingValue.Description = mvs.Description;
missingValue.Placeholder = mvs.Placeholder;
missingValueManager.Update(missingValue);
}
}
}
}
}
dataStructure = dataStructureManager.UpdateStructuredDataStructure(dataStructure);
DataStructureIO.setVariableOrder(dataStructure, variables.Select(svs => svs.Id).ToList());
}
else
{
foreach (Variable v in dataStructure.Variables)
{
List <MissingValue> missingValues = missingValueManager.Repo.Query(mv => mv.Variable.Id.Equals(v.Id)).ToList();
foreach (MissingValue mv in missingValues)
{
missingValueManager.Delete(mv);
}
dataStructureManager.RemoveVariableUsage(v);
}
}
LoggerFactory.LogCustom("Variables for Data Structure " + Id + " stored.");
return(Json(returnObject, JsonRequestBehavior.AllowGet));
}
finally
{
dataStructureManager.Dispose();
dataContainerManager.Dispose();
um.Dispose();
missingValueManager.Dispose();
}
}
/// <summary>
///
/// </summary>
/// <remarks></remarks>
/// <seealso cref=""/>
public void GetDataAttributeList()
{
DataContainerManager DataAttributeManager = new DataContainerManager();
this.dataAttributeList = DataAttributeManager.DataAttributeRepo.Get().ToList();
}
//[MeasurePerformance]
//temporary solution: norman
//For original solution, look into Aquadiva Code
public List <Error> FinishUpload(EasyUploadTaskManager taskManager)
{
DataStructureManager dsm = new DataStructureManager();
DatasetManager dm = new DatasetManager();
DataContainerManager dam = new DataContainerManager();
//SubjectManager sm = new SubjectManager();
EntityPermissionManager entityPermissionManager = new EntityPermissionManager();
List <Error> temp = new List <Error>();
try
{
using (IUnitOfWork unitOfWork = this.GetUnitOfWork())
{
// initialize all necessary manager
DataTuple[] rows = null;
//First, try to validate - if there are errors, return immediately
string JsonArray = TaskManager.Bus[EasyUploadTaskManager.SHEET_JSON_DATA].ToString();
List <Error> ValidationErrors = ValidateRows(JsonArray);
if (ValidationErrors.Count != 0)
{
temp.AddRange(ValidationErrors);
return(temp);
}
string timestamp = DateTime.UtcNow.ToString("r");
string title = Convert.ToString(TaskManager.Bus[EasyUploadTaskManager.FILENAME]);
if (TaskManager.Bus.ContainsKey(EasyUploadTaskManager.DESCRIPTIONTITLE))
{
string tmp = Convert.ToString(TaskManager.Bus[EasyUploadTaskManager.DESCRIPTIONTITLE]);
if (!String.IsNullOrWhiteSpace(tmp))
{
title = Convert.ToString(TaskManager.Bus[EasyUploadTaskManager.DESCRIPTIONTITLE]);
}
}
StructuredDataStructure sds = null;
List <VariableIdentifier> identifiers = new List <VariableIdentifier>(); //Used in Excel reader
//Try to find an exact matching datastructure
Boolean foundReusableDataStructure = false;
List <RowModel> headers = (List <RowModel>)TaskManager.Bus[EasyUploadTaskManager.ROWS];
//For some reason, MappedHeaders might be in a different order in this list than what's indicated by its IDs - to prevent mismatching, sort the headers
headers.Sort((m1, m2) => m1.Index.CompareTo(m2.Index));
List <StructuredDataStructure> allDatastructures = dsm.StructuredDataStructureRepo.Get().ToList();
foreach (StructuredDataStructure existingStructure in allDatastructures)
{
if (!foundReusableDataStructure)
{
//For now a datastructure is considered an exact match if it contains variables with
//the same names (labels), datatypes and units in the correct order
List <Variable> variablesOfExistingStructure = existingStructure.Variables.ToList();
foundReusableDataStructure = true;
if (variablesOfExistingStructure.Count != headers.Count)
{
foundReusableDataStructure = false;
}
else
{
for (int i = 0; i < variablesOfExistingStructure.Count; i++)
{
Variable exVar = variablesOfExistingStructure.ElementAt(i);
RowModel currentHeader = headers.ElementAt(i);
if (exVar.Label != currentHeader.Name ||
exVar.Unit.Id != currentHeader.SelectedUnit.UnitId ||
exVar.DataAttribute.DataType.Id != currentHeader.SelectedDataType.DataTypeId)
{
foundReusableDataStructure = false;
}
}
}
if (foundReusableDataStructure)
{
sds = existingStructure;
foreach (Variable exVar in variablesOfExistingStructure)
{
VariableIdentifier vi = new VariableIdentifier
{
name = exVar.Label,
id = exVar.Id
};
identifiers.Add(vi);
}
}
}
}
if (!foundReusableDataStructure)
{
sds = dsm.CreateStructuredDataStructure(title, title + " " + timestamp, "", "", DataStructureCategory.Generic);
}
TaskManager.AddToBus(EasyUploadTaskManager.DATASTRUCTURE_ID, sds.Id);
TaskManager.AddToBus(EasyUploadTaskManager.DATASTRUCTURE_TITLE, title + " " + timestamp);
if (!TaskManager.Bus.ContainsKey(EasyUploadTaskManager.DATASET_TITLE))
{
TaskManager.AddToBus(EasyUploadTaskManager.DATASET_TITLE, title);
TaskManager.AddToBus(EasyUploadTaskManager.TITLE, title);
}
MetadataStructure metadataStructure = null;
if (TaskManager.Bus.ContainsKey(EasyUploadTaskManager.SCHEMA))
{
long metadataStructureId = Convert.ToInt64(TaskManager.Bus[EasyUploadTaskManager.SCHEMA]);
metadataStructure = unitOfWork.GetReadOnlyRepository <MetadataStructure>()
.Get(m => m.Id == metadataStructureId).FirstOrDefault();
}
else
{
//Default option but shouldn't happen because previous steps can't be finished without selecting the metadata-structure
metadataStructure = unitOfWork.GetReadOnlyRepository <MetadataStructure>()
.Get(m => m.Name.ToLower().Contains("eml")).FirstOrDefault();
}
ResearchPlan rp = unitOfWork.GetReadOnlyRepository <ResearchPlan>().Get().FirstOrDefault();
TaskManager.AddToBus(EasyUploadTaskManager.RESEARCHPLAN_ID, rp.Id);
TaskManager.AddToBus(EasyUploadTaskManager.RESEARCHPLAN_TITLE, rp.Title);
#region Progress Information
if (TaskManager.Bus.ContainsKey(EasyUploadTaskManager.CURRENTPACKAGESIZE))
{
TaskManager.Bus[EasyUploadTaskManager.CURRENTPACKAGESIZE] = 0;
}
else
{
TaskManager.Bus.Add(EasyUploadTaskManager.CURRENTPACKAGESIZE, 0);
}
if (TaskManager.Bus.ContainsKey(EasyUploadTaskManager.CURRENTPACKAGE))
{
TaskManager.Bus[EasyUploadTaskManager.CURRENTPACKAGE] = 0;
}
else
{
TaskManager.Bus.Add(EasyUploadTaskManager.CURRENTPACKAGE, 0);
}
#endregion Progress Information
if (!foundReusableDataStructure)
{
#region Set Variables and information for new DataStructure
XmlDocument xmldoc = new XmlDocument();
XmlElement extraElement = xmldoc.CreateElement("extra");
XmlElement orderElement = xmldoc.CreateElement("order");
//Sorting necessary to prevent problems when inserting the tuples
headers.OrderBy(r => r.Index);
var dataTypeRepo = unitOfWork.GetReadOnlyRepository <DataType>();
var unitRepo = unitOfWork.GetReadOnlyRepository <Unit>();
var dataAttributeRepo = unitOfWork.GetReadOnlyRepository <DataAttribute>();
List <DataAttribute> allDataAttributes = dataAttributeRepo.Get().ToList();
foreach (RowModel header in headers)
{
int i = headers.IndexOf(header);
DataType dataType = dataTypeRepo.Get(header.SelectedDataType.DataTypeId);
Unit CurrentSelectedUnit = unitRepo.Get(header.SelectedUnit.UnitId);
DataAttribute CurrentDataAttribute = new DataAttribute();
//If possible, map the chosen variable name, unit and datatype to an existing DataAttribute (Exact match)
DataAttribute existingDataAttribute = allDataAttributes.Where(da => da.Name.ToLower().Equals(TrimAndLimitString(header.SelectedDataAttribute.Name).ToLower()) &&
da.Unit.Dimension == CurrentSelectedUnit.Dimension).FirstOrDefault();
if (existingDataAttribute != null)
{
CurrentDataAttribute = existingDataAttribute;
}
else
{
//No matching DataAttribute => Create a new one
CurrentDataAttribute = dam.CreateDataAttribute(TrimAndLimitString(header.Name), header.Name, header.SelectedDataAttribute.Description, false, false, "", MeasurementScale.Categorial, DataContainerType.ReferenceType, "", dataType, CurrentSelectedUnit, null, null, null, null, null, null);
}
Variable newVariable = dsm.AddVariableUsage(sds, CurrentDataAttribute, true, header.Name, "", "", "", CurrentSelectedUnit);
VariableIdentifier vi = new VariableIdentifier
{
name = newVariable.Label,
id = newVariable.Id
};
identifiers.Add(vi);
XmlElement newVariableXml = xmldoc.CreateElement("variable");
newVariableXml.InnerText = Convert.ToString(newVariable.Id);
orderElement.AppendChild(newVariableXml);
}
extraElement.AppendChild(orderElement);
xmldoc.AppendChild(extraElement);
sds.Extra = xmldoc;
sds.Name = "generated import structure " + timestamp;
sds.Description = "automatically generated structured data structure by user " + GetUsernameOrDefault() + " for file " + title + " on " + timestamp;
#endregion Set Variables and information for new DataStructure
}
Dataset ds = null;
ds = dm.CreateEmptyDataset(sds, rp, metadataStructure);
long datasetId = ds.Id;
long sdsId = sds.Id;
if (dm.IsDatasetCheckedOutFor(datasetId, GetUsernameOrDefault()) || dm.CheckOutDataset(datasetId, GetUsernameOrDefault()))
{
DatasetVersion dsv = dm.GetDatasetWorkingCopy(datasetId);
long METADATASTRUCTURE_ID = metadataStructure.Id;
XmlMetadataWriter xmlMetadatWriter = new XmlMetadataWriter(XmlNodeMode.xPath);
XDocument metadataX = xmlMetadatWriter.CreateMetadataXml(METADATASTRUCTURE_ID);
XmlDocument metadataXml = XmlMetadataWriter.ToXmlDocument(metadataX);
dsv.Metadata = metadataXml;
try
{
dsv.Metadata = xmlDatasetHelper.SetInformation(dsv, metadataXml, NameAttributeValues.title, title);
dsv.Title = title;
}
catch (NullReferenceException ex)
{
//Reference of the title node is missing
throw new NullReferenceException("The extra-field of this metadata-structure is missing the title-node-reference!");
}
dm.EditDatasetVersion(dsv, null, null, null);
}
#region security
// add security
if (GetUsernameOrDefault() != "DEFAULT")
{
foreach (RightType rightType in Enum.GetValues(typeof(RightType)).Cast <RightType>())
{
//The user gets full permissions
// add security
if (GetUsernameOrDefault() != "DEFAULT")
{
entityPermissionManager.Create <User>(GetUsernameOrDefault(), "Dataset", typeof(Dataset), ds.Id, Enum.GetValues(typeof(RightType)).Cast <RightType>().ToList());
}
}
}
#endregion security
#region excel reader
int packageSize = 100000;
int numberOfRows = 0;
//HACK ?
TaskManager.Bus[EasyUploadTaskManager.CURRENTPACKAGESIZE] = packageSize;
int counter = 0;
dm.CheckOutDatasetIfNot(ds.Id, GetUsernameOrDefault()); // there are cases, the dataset does not get checked out!!
if (!dm.IsDatasetCheckedOutFor(ds.Id, GetUsernameOrDefault()))
{
throw new Exception(string.Format("Not able to checkout dataset '{0}' for user '{1}'!", ds.Id, GetUsernameOrDefault()));
}
DatasetVersion workingCopy = dm.GetDatasetWorkingCopy(ds.Id);
counter++;
TaskManager.Bus[EasyUploadTaskManager.CURRENTPACKAGE] = counter;
//rows = reader.ReadFile(Stream, TaskManager.Bus[TaskManager.FILENAME].ToString(), oldSds, (int)id, packageSize).ToArray();
List <string> selectedDataAreaJsonArray = (List <string>)TaskManager.Bus[EasyUploadTaskManager.SHEET_DATA_AREA];
string selectedHeaderAreaJsonArray = TaskManager.Bus[EasyUploadTaskManager.SHEET_HEADER_AREA].ToString();
List <int[]> areaDataValuesList = new List <int[]>();
foreach (string area in selectedDataAreaJsonArray)
{
areaDataValuesList.Add(JsonConvert.DeserializeObject <int[]>(area));
}
int[] areaHeaderValues = JsonConvert.DeserializeObject <int[]>(selectedHeaderAreaJsonArray);
Orientation orientation = 0;
switch (TaskManager.Bus[EasyUploadTaskManager.SHEET_FORMAT].ToString())
{
case "LeftRight":
orientation = Orientation.rowwise;
break;
case "Matrix":
//orientation = Orientation.matrix;
break;
default:
orientation = Orientation.columnwise;
break;
}
String worksheetUri = null;
//Get the Uri to identify the correct worksheet
if (TaskManager.Bus.ContainsKey(EasyUploadTaskManager.ACTIVE_WOKSHEET_URI))
{
worksheetUri = TaskManager.Bus[EasyUploadTaskManager.ACTIVE_WOKSHEET_URI].ToString();
}
int batchSize = (new Object()).GetUnitOfWork().PersistenceManager.PreferredPushSize;
int batchnr = 1;
foreach (int[] areaDataValues in areaDataValuesList)
{
//First batch starts at the start of the current data area
int currentBatchStartRow = areaDataValues[0] + 1;
while (currentBatchStartRow <= areaDataValues[2] + 1) //While the end of the current data area has not yet been reached
{
//End row is start row plus batch size
int currentBatchEndRow = currentBatchStartRow + batchSize;
//Set the indices for the reader
EasyUploadFileReaderInfo fri = new EasyUploadFileReaderInfo
{
DataStartRow = currentBatchStartRow,
//End row is either at the end of the batch or the end of the marked area
//DataEndRow = (currentBatchEndRow > areaDataValues[2] + 1) ? areaDataValues[2] + 1 : currentBatchEndRow,
DataEndRow = Math.Min(currentBatchEndRow, areaDataValues[2] + 1),
//Column indices as marked in a previous step
DataStartColumn = areaDataValues[1] + 1,
DataEndColumn = areaDataValues[3] + 1,
//Header area as marked in a previous step
VariablesStartRow = areaHeaderValues[0] + 1,
VariablesStartColumn = areaHeaderValues[1] + 1,
VariablesEndRow = areaHeaderValues[2] + 1,
VariablesEndColumn = areaHeaderValues[3] + 1,
Offset = areaDataValues[1],
Orientation = orientation
};
//Create a new reader each time because the reader saves ALL tuples it read and therefore the batch processing wouldn't work
EasyUploadExcelReader reader = new EasyUploadExcelReader(sds, fri);
// open file
Stream = reader.Open(TaskManager.Bus[EasyUploadTaskManager.FILEPATH].ToString());
//Set variable identifiers because they might differ from the variable names in the file
reader.setSubmittedVariableIdentifiers(identifiers);
//Read the rows and convert them to DataTuples
rows = reader.ReadFile(Stream, TaskManager.Bus[EasyUploadTaskManager.FILENAME].ToString(), fri, (int)datasetId, worksheetUri);
//After reading the rows, add them to the dataset
if (rows != null)
{
dm.EditDatasetVersion(workingCopy, rows.ToList(), null, null);
numberOfRows += rows.Count();
}
//Close the Stream so the next ExcelReader can open it again
Stream.Close();
//Debug information
int lines = (areaDataValues[2] + 1) - (areaDataValues[0] + 1);
int batches = lines / batchSize;
batchnr++;
//Next batch starts after the current one
currentBatchStartRow = currentBatchEndRow + 1;
}
}
#endregion excel reader
//set modification
workingCopy.ModificationInfo = new EntityAuditInfo()
{
Performer = GetUsernameOrDefault(),
Comment = "Data",
ActionType = AuditActionType.Create
};
dm.EditDatasetVersion(workingCopy, null, null, null);
dm.CheckInDataset(ds.Id, "Import " + numberOfRows + " rows", GetUsernameOrDefault());
//Reindex search
if (this.IsAccessible("DDM", "SearchIndex", "ReIndexSingle"))
{
this.Run("DDM", "SearchIndex", "ReIndexSingle", new RouteValueDictionary()
{
{ "id", datasetId }
});
}
TaskManager.AddToBus(EasyUploadTaskManager.DATASET_ID, ds.Id);
return(temp);
}
}
catch (Exception ex)
{
temp.Add(new Error(ErrorType.Other, "An error occured during the upload. " +
"Please try again later. If this problem keeps occuring, please contact your administrator."));
return(temp);
}
finally
{
dsm.Dispose();
dm.Dispose();
dam.Dispose();
//sm.Dispose();
entityPermissionManager.Dispose();
}
}
public ActionResult SaveResourceStructureAttribute(EditResourceStructureAttributeModel model, string[] keys)
{
using (var rsaManager = new ResourceStructureAttributeManager())
{
//check name
if (model.AttributeName != null)
{
ResourceStructureAttribute tempRS = rsaManager.GetResourceStructureAttributesByName(StringHelper.CutSpaces(model.AttributeName));
if (tempRS != null && tempRS.Id != model.Id)
{
ModelState.AddModelError("NameExist", "Name already exist.");
}
}
//check domain items
if (keys != null)
{
List <DomainItemModel> tempList = new List <DomainItemModel>();
foreach (string k in keys)
{
DomainItemModel d = new DomainItemModel();
d.Key = k;
d.Value = k;
tempList.Add(d);
if (string.IsNullOrEmpty(k))
{
ModelState.AddModelError("DomainItem", "One domain item has no value.");
}
}
model.DomainItems = tempList;
}
if (ModelState.IsValid)
{
ResourceStructureAttribute rsa = new ResourceStructureAttribute();
using (var rsManager = new ResourceStructureManager())
{
if (model.Id == 0)
{
rsa = rsaManager.CreateResourceStructureAttribute(model.AttributeName, model.AttributeDescription);
}
else
{
rsa = rsaManager.GetResourceStructureAttributesById(model.Id);
rsa.Name = model.AttributeName;
rsa.Description = model.AttributeDescription;
rsaManager.UpdateResourceStructureAttribute(rsa);
}
if (rsa != null && model.Id == 0)
{
//Start -> add security ----------------------------------------
using (EntityPermissionManager pManager = new EntityPermissionManager())
using (var entityTypeManager = new EntityManager())
using (UserManager userManager = new UserManager())
{
var userTask = userManager.FindByNameAsync(HttpContext.User.Identity.Name);
userTask.Wait();
var user = userTask.Result;
Entity entityType = entityTypeManager.FindByName("ResourceStructureAttribute");
pManager.Create(user, entityType, rsa.Id, 31);
}
//End -> add security ------------------------------------------
}
if (keys != null)
{
List <DomainItem> domainItems = CreateDomainItems(keys);
using (var dcManager = new DataContainerManager())
{
if (model.Id == 0 || rsa.Constraints.Count() == 0)
{
DomainConstraint dc = new DomainConstraint(ConstraintProviderSource.Internal, "", "en-US", "a simple domain validation constraint", false, null, null, null, domainItems);
dcManager.AddConstraint(dc, rsa);
}
else
{
DomainConstraint temp = (DomainConstraint)rsa.Constraints.ElementAt(0);
temp.Materialize();
temp.Items = domainItems;
dcManager.AddConstraint(temp, rsa);
}
}
}
//Creation with usage
if (model.rsID != 0)
{
ResourceStructure resourceStructure = rsManager.GetResourceStructureById(model.rsID);
rsaManager.CreateResourceAttributeUsage(rsa, resourceStructure, true, false);
//resourceStructure.ResourceStructureAttributes.Add(rsa);
//rsManager.Update(resourceStructure);
//return View("_editResourceStructure", new ResourceStructureModel(resourceStructure));
return(Json(new { success = true }));
}
else
{
return(Json(new { success = true }));
}
}
}
else
{
return(PartialView("_createResourceStructureAttribute", model));
}
}
}
public StructuredDataStructure CreateADataStructure()
{
var unitManager = new UnitManager();
var dataTypeManager = new DataTypeManager();
var attributeManager = new DataContainerManager();
var dsManager = new DataStructureManager();
try
{
var dim = unitManager.Create("TestDimnesion", "For Unit Testing", "");
var unit = unitManager.Create("None_UT", "NoneUT", "Use in unit tsting", dim, Dlm.Entities.DataStructure.MeasurementSystem.Metric);
var intType = dataTypeManager.Create("Integer", "Integer", TypeCode.Int32);
var strType = dataTypeManager.Create("String", "String", TypeCode.String);
var doubleType = dataTypeManager.Create("Double", "Double", TypeCode.Double);
var boolType = dataTypeManager.Create("Bool", "Bool", TypeCode.Boolean);
var dateTimeType = dataTypeManager.Create("DateTime", "DateTime", TypeCode.DateTime);
var dataAttribute1 = attributeManager.CreateDataAttribute(
"att1UT", "att1UT", "Attribute for Unit testing",
false, false, "", Dlm.Entities.DataStructure.MeasurementScale.Nominal, Dlm.Entities.DataStructure.DataContainerType.ValueType,
"", intType, unit,
null, null, null, null, null, null
);
var dataAttribute2 = attributeManager.CreateDataAttribute(
"att2UT", "att1UT", "Attribute for Unit testing",
false, false, "", Dlm.Entities.DataStructure.MeasurementScale.Nominal, Dlm.Entities.DataStructure.DataContainerType.ValueType,
"", strType, unit,
null, null, null, null, null, null
);
var dataAttribute3 = attributeManager.CreateDataAttribute(
"att3UT", "att3UT", "Attribute for Unit testing",
false, false, "", Dlm.Entities.DataStructure.MeasurementScale.Nominal, Dlm.Entities.DataStructure.DataContainerType.ValueType,
"", doubleType, unit,
null, null, null, null, null, null
);
var dataAttribute4 = attributeManager.CreateDataAttribute(
"att4UT", "att4UT", "Attribute for Unit testing",
false, false, "", Dlm.Entities.DataStructure.MeasurementScale.Nominal, Dlm.Entities.DataStructure.DataContainerType.ValueType,
"", boolType, unit,
null, null, null, null, null, null
);
var dataAttribute5 = attributeManager.CreateDataAttribute(
"att5UT", "att5UT", "Attribute for Unit testing",
false, false, "", Dlm.Entities.DataStructure.MeasurementScale.Nominal, Dlm.Entities.DataStructure.DataContainerType.ValueType,
"", dateTimeType, unit,
null, null, null, null, null, null
);
StructuredDataStructure dataStructure = dsManager.CreateStructuredDataStructure("dsForTesting", "DS for unit testing", "", "", Dlm.Entities.DataStructure.DataStructureCategory.Generic);
dsManager.AddVariableUsage(dataStructure, dataAttribute1, true, "var1UT", "", "", "Used for unit testing");
dsManager.AddVariableUsage(dataStructure, dataAttribute2, true, "var2UT", "", "", "Used for unit testing");
dsManager.AddVariableUsage(dataStructure, dataAttribute3, true, "var3UT", "", "", "Used for unit testing");
dsManager.AddVariableUsage(dataStructure, dataAttribute4, true, "var4UT", "", "", "Used for unit testing");
dsManager.AddVariableUsage(dataStructure, dataAttribute5, true, "var5UT", "", "", "Used for unit testing");
return(dataStructure);
}
catch (Exception ex) { return(null); }
finally
{
unitManager.Dispose();
dataTypeManager.Dispose();
attributeManager.Dispose();
dsManager.Dispose();
}
}
/// <summary>
///
/// </summary>
/// <remarks></remarks>
/// <seealso cref=""/>
/// <param name="variables"></param>
/// <param name="path"></param>
/// <param name="filename"></param>
/// <returns></returns>
public SpreadsheetDocument CreateTemplate(List <Variable> variables, string path, string filename)
{
if (!Directory.Exists(Path.Combine(AppConfiguration.DataPath, path)))
{
Directory.CreateDirectory(Path.Combine(AppConfiguration.DataPath, path));
}
SpreadsheetDocument template = SpreadsheetDocument.Open(Path.Combine(AppConfiguration.GetModuleWorkspacePath("RPM"), "Template", _fileName), true);
SpreadsheetDocument dataStructureFile = SpreadsheetDocument.Create(Path.Combine(AppConfiguration.DataPath, path, filename), template.DocumentType);
//dataStructureFile = SpreadsheetDocument.Open(Path.Combine(AppConfiguration.GetModuleWorkspacePath("RPM"), "Template", filename), true);
foreach (OpenXmlPart part in template.GetPartsOfType <OpenXmlPart>())
{
OpenXmlPart newPart = dataStructureFile.AddPart <OpenXmlPart>(part);
}
template.Close();
// get worksheet
List <StyleIndexStruct> styleIndex = new List <StyleIndexStruct>();
CellFormats cellFormats = dataStructureFile.WorkbookPart.WorkbookStylesPart.Stylesheet.Elements <CellFormats>().First();
//number 0,00
CellFormat cellFormat = new CellFormat()
{
NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true
};
cellFormat.Protection = new Protection();
cellFormat.Protection.Locked = false;
cellFormats.Append(cellFormat);
styleIndex.Add(new StyleIndexStruct()
{
Name = "Decimal", Index = (uint)cellFormats.Count++, DisplayPattern = null
});
//number 0
cellFormat = new CellFormat()
{
NumberFormatId = (UInt32Value)1U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true
};
cellFormat.Protection = new Protection();
cellFormat.Protection.Locked = false;
cellFormats.Append(cellFormat);
styleIndex.Add(new StyleIndexStruct()
{
Name = "Number", Index = (uint)cellFormats.Count++, DisplayPattern = null
});
//text
cellFormat = new CellFormat()
{
NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true
};
cellFormat.Protection = new Protection();
cellFormat.Protection.Locked = false;
cellFormats.Append(cellFormat);
styleIndex.Add(new StyleIndexStruct()
{
Name = "Text", Index = (uint)cellFormats.Count++, DisplayPattern = null
});
//DateTime
cellFormat = new CellFormat()
{
NumberFormatId = (UInt32Value)22U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true
};
cellFormat.Protection = new Protection();
cellFormat.Protection.Locked = false;
cellFormats.Append(cellFormat);
styleIndex.Add(new StyleIndexStruct()
{
Name = "DateTime", Index = (uint)cellFormats.Count++, DisplayPattern = DataTypeDisplayPattern.Pattern.Where(p => p.Systemtype.Equals(DataTypeCode.DateTime) && p.Name.Equals("DateTime")).FirstOrDefault()
});
//Date
cellFormat = new CellFormat()
{
NumberFormatId = (UInt32Value)14U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true
};
cellFormat.Protection = new Protection();
cellFormat.Protection.Locked = false;
cellFormats.Append(cellFormat);
styleIndex.Add(new StyleIndexStruct()
{
Name = "Date", Index = (uint)cellFormats.Count++, DisplayPattern = DataTypeDisplayPattern.Pattern.Where(p => p.Systemtype.Equals(DataTypeCode.DateTime) && p.Name.Equals("Date")).FirstOrDefault()
});
//Time
cellFormat = new CellFormat()
{
NumberFormatId = (UInt32Value)21U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true
};
cellFormat.Protection = new Protection();
cellFormat.Protection.Locked = false;
cellFormats.Append(cellFormat);
styleIndex.Add(new StyleIndexStruct()
{
Name = "Time", Index = (uint)cellFormats.Count++, DisplayPattern = DataTypeDisplayPattern.Pattern.Where(p => p.Systemtype.Equals(DataTypeCode.DateTime) && p.Name.Equals("Time")).FirstOrDefault()
});
Worksheet worksheet = dataStructureFile.WorkbookPart.WorksheetParts.First().Worksheet;
List <Row> rows = GetRows(worksheet, 1, 11);
foreach (Variable var in variables)
{
DataContainerManager CM = new DataContainerManager();
DataAttribute dataAttribute = CM.DataAttributeRepo.Get(var.DataAttribute.Id);
int indexVar = variables.ToList().IndexOf(var) + 1;
string columnIndex = GetClomunIndex(indexVar);
string cellRef = columnIndex + 1;
Cell cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(var.Label)
};
rows.ElementAt(0).AppendChild(cell);
cellRef = columnIndex + 2;
cell = new Cell()
{
CellReference = cellRef,
DataType = CellValues.String,
StyleIndex = getExcelStyleIndex(dataAttribute.DataType, styleIndex),
CellValue = new CellValue("")
};
rows.ElementAt(1).AppendChild(cell);
cellRef = columnIndex + 3;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(var.Id.ToString())
};
rows.ElementAt(2).AppendChild(cell);
cellRef = columnIndex + 4;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(dataAttribute.ShortName)
};
rows.ElementAt(3).AppendChild(cell);
// description from variable
// if not then from attribute
string description = "";
description = String.IsNullOrEmpty(var.Description) ? dataAttribute.Description : var.Description;
cellRef = columnIndex + 5;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(description)
};
rows.ElementAt(4).AppendChild(cell);
string classification = "";
if (dataAttribute.Classification != null)
{
classification = dataAttribute.Classification.Name;
}
cellRef = columnIndex + 6;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(classification)
};
rows.ElementAt(5).AppendChild(cell);
string unit = "";
if (var.Unit != null)
{
unit = var.Unit.Name;
}
cellRef = columnIndex + 7;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(unit)
};
rows.ElementAt(6).AppendChild(cell);
string dataType = "";
if (dataAttribute.DataType != null)
{
dataType = dataAttribute.DataType.Name;
}
cellRef = columnIndex + 8;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(dataType)
};
rows.ElementAt(7).AppendChild(cell);
cellRef = columnIndex + 9;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(var.IsValueOptional.ToString())
};
rows.ElementAt(8).AppendChild(cell);
cellRef = columnIndex + 10;
cell = new Cell()
{
CellReference = cellRef,
StyleIndex = (UInt32Value)4U,
DataType = CellValues.String,
CellValue = new CellValue(dataAttribute.IsMultiValue.ToString())
};
rows.ElementAt(9).AppendChild(cell);
}
foreach (DefinedName name in dataStructureFile.WorkbookPart.Workbook.GetFirstChild <DefinedNames>())
{
if (name.Name == "Data" || name.Name == "VariableIdentifiers")
{
string[] tempArr = name.InnerText.Split('$');
string temp = "";
tempArr[tempArr.Count() - 2] = GetClomunIndex(variables.Count());
foreach (string t in tempArr)
{
if (t == tempArr.First())
{
temp = temp + t;
}
else
{
temp = temp + "$" + t;
}
}
name.Text = temp;
}
}
//WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
//WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
dataStructureFile.WorkbookPart.Workbook.Save();
dataStructureFile.Close();
return(dataStructureFile);
}
public void GenerateSeedData()
{
#region ENTITIES
List <EntityStruct> entities = new List <EntityStruct>();
entities.Add(new EntityStruct("SingleResource", typeof(SingleResource), typeof(BExIS.Rbm.Services.Resource.SingleResourceStore)));
entities.Add(new EntityStruct("ResourceStructure", typeof(ResourceStructure), typeof(BExIS.Rbm.Services.ResourceStructure.ResourceStructureStore)));
entities.Add(new EntityStruct("ResourceStructureAttribute", typeof(ResourceStructureAttribute), typeof(BExIS.Rbm.Services.ResourceStructure.ResourceStructureAttributeStore)));
entities.Add(new EntityStruct("Activity", typeof(Activity), typeof(BExIS.Rbm.Services.Booking.ActivityStore)));
entities.Add(new EntityStruct("BookingEvent", typeof(BookingEvent), typeof(BExIS.Rbm.Services.Booking.BookingEventStore)));
entities.Add(new EntityStruct("Notification", typeof(Notification), typeof(BExIS.Rbm.Services.Booking.NotificationStore)));
entities.Add(new EntityStruct("Schedule", typeof(Schedule), typeof(BExIS.Rbm.Services.Booking.ScheduleStore)));
Dictionary <string, Type> rbmEntities = new Dictionary <string, Type>();
rbmEntities.Add("SingleResource", typeof(SingleResource));
rbmEntities.Add("ResourceStructure", typeof(ResourceStructure));
rbmEntities.Add("ResourceStructureAttribute", typeof(ResourceStructureAttribute));
rbmEntities.Add("Activity", typeof(Activity));
rbmEntities.Add("BookingEvent", typeof(BookingEvent));
rbmEntities.Add("Notification", typeof(Notification));
rbmEntities.Add("Schedule", typeof(Schedule));
using (var entityManager = new EntityManager())
{
foreach (var et in entities)
{
Entity entity = entityManager.Entities.Where(e => e.Name.ToUpperInvariant() == et.Name.ToUpperInvariant()).FirstOrDefault();
if (entity == null)
{
entity = new Entity();
entity.Name = et.Name;
entity.EntityType = et.Type;
entity.EntityStoreType = et.StoreType;
//entity.UseMetadata = true;
entity.Securable = true;
entityManager.Create(entity);
}
}
}
try
{
ResourceStructureAttribute rsa = new ResourceStructureAttribute();
using (var rsaManager = new ResourceStructureAttributeManager())
rsa = rsaManager.CreateResourceStructureAttribute("Exploratory", "Biodiversity Exploratories funded by DFG Priority Programme 1374. They serve as open research platform for all biodiversity and ecosystem research groups of Germany.");
var dcManager = new DataContainerManager();
string[] keys = { "Hainich-Dün", "Schorfheide-Chorin", "Schwäbische Alb" };
List <DomainItem> domainItems = CreateDomainItems(keys);
DomainConstraint dc = new DomainConstraint(ConstraintProviderSource.Internal, "", "en-US", "a simple domain validation constraint", false, null, null, null, domainItems);
dcManager.AddConstraint(dc, rsa);
ResourceStructureAttribute rsa2 = new ResourceStructureAttribute();
using (var rsaManager2 = new ResourceStructureAttributeManager())
rsa2 = rsaManager2.CreateResourceStructureAttribute("Type", "Type of resource.");
var dcManager2 = new DataContainerManager();
string[] keys2 = { "Area", "Equipment", "Sleeping place" };
List <DomainItem> domainItems2 = CreateDomainItems(keys2);
DomainConstraint dc2 = new DomainConstraint(ConstraintProviderSource.Internal, "", "en-US", "a simple domain validation constraint", false, null, null, null, domainItems2);
dcManager2.AddConstraint(dc2, rsa2);
ResourceStructureAttribute rsa3 = new ResourceStructureAttribute();
using (var rsaManager3 = new ResourceStructureAttributeManager())
rsa3 = rsaManager3.CreateResourceStructureAttribute("Information File", "Important information as file");
ResourceStructureManager rsManager = new ResourceStructureManager();;
ResourceStructure rs = rsManager.Create("Explo resources", "Resources related to exploratories.", null, null);
using (var rsaManager = new ResourceStructureAttributeManager())
rsaManager.CreateResourceAttributeUsage(rsa, rs, true, false);
using (var rsaManager = new ResourceStructureAttributeManager())
rsaManager.CreateResourceAttributeUsage(rsa2, rs, true, false);
using (var rsaManager = new ResourceStructureAttributeManager())
rsaManager.CreateResourceAttributeUsage(rsa3, rs, true, true);
ActivityManager aManager = new ActivityManager();
aManager.CreateActivity("Adding of material (litter, dead wood, chemicals ....)", "", false);
aManager.CreateActivity("Adding of organisms (seeds and others)", "", false);
aManager.CreateActivity("Conference", "", false);
aManager.CreateActivity("Contact stakeholder", "", false);
aManager.CreateActivity("Dismantling of experiments", "", false);
aManager.CreateActivity("Installation of equipment remaining for some time", "", false);
aManager.CreateActivity("Measuring and marking of subplots/experiments/study organisms", "", false);
aManager.CreateActivity("Observation/capture of organisms without removal", "", false);
aManager.CreateActivity("Plot maintenance", "", false);
aManager.CreateActivity("Removal of org. material without killing", "", false);
aManager.CreateActivity("Removal of organisms", "", false);
aManager.CreateActivity("Removal of soil samples", "", false);
aManager.CreateActivity("Visit without activity", "", false);
ResourceManager rManager = new ResourceManager();;
List <newResourceStructure> rs_new = new List <newResourceStructure>();
rs_new.Add(new newResourceStructure()
{
name = "Forest - all EPs (SCH)", color = "#ec5959", description = "Visit of all forest EPs in Schorfheide-Chorin", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all MIPs (SCH)", color = "#ec5959", description = "Visit of all forest MIPs in Schorfheide-Chorin", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all VIPs (SCH)", color = "#ec5959", description = "Visit of all forest VIPs in Schorfheide-Chorin", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Altenhof", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Arnimswalde", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Chorin", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Eichheide", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Glambeck", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Liepe", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Maienpfuhl", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Melzow", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Poratz", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Ringenwalde", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Senftenthal", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Theerofen", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Voigtswiese", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - Forstgut Altkuenkendorf", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - Fuerstliche Forstverwaltung Oettingen-Spielberg", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - Stiftung Schorfheide-Chorin", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - FOX (SCH)", color = "#ec5959", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - RP/UP (SCH)", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - ABP Landwirtschaft Neugrimnitz GmbH", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AEVG Stegelitz-Flieth", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Agrargemeinschaft Greiffenberg GmbH", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all EPs (SCH)", color = "#ff0000", description = "Visit of all grassland EPs in Schorfheide-Chorin", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all MIPs (SCH)", color = "#ff0000", description = "Visit of all grassland MIPs in Schorfheide-Chorin", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all VIPs (SCH)", color = "#ff0000", description = "Visit of all grassland VIPs in Schorfheide-Chorin", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Gut Biesenbrow", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Ingolf Limber", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Lehrschaeferei Friedrichsfelde", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - LW-Betrieb Haferkamp", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Naturrind GmbH Boeckenberg", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Reiner Wegner", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Weidewirtschaft Liepe", color = "#ff0000", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "no plot visit (SCH)", color = "#e28f8f", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Sleeping place (SCH)", color = "#9c3939", description = "Sleeping places in Schorfheide-Chorin", duration = 1, quantity = 8, withActivity = false, resourceStructure = rs, type = "Sleeping place", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Drying cabinet (SCH)", color = "#940b0b", description = "Drying cabinet in Schorfheide-Chorin", duration = 1, quantity = 5, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Fridge (SCH)", color = "#940b0b", description = "Fridge in Schorfheide-Chorin", duration = 1, quantity = 2, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Freezer (SCH)", color = "#940b0b", description = "Freezer in Schorfheide-Chorin", duration = 1, quantity = 2, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Metal detector (Magna Trak 100) (SCH)", color = "#940b0b", description = "Metal detector (Magna Trak 100) in Schorfheide-Chorin", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Binocular (SCH)", color = "#940b0b", description = "", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Chest freezer (SCH)", color = "#940b0b", description = "", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Helmet (SCH)", color = "#940b0b", description = "", duration = 1, quantity = 8, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schorfheide-Chorin"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all EPs (HAI)", color = "#8cca0d", description = "Visit of all forest EPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all GPs (HAI)", color = "#8cca0d", description = "Visit of all forestGPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all MIPs (HAI)", color = "#8cca0d", description = "Visit of all forest MIPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all VIPs (HAI)", color = "#8cca0d", description = "Visit of all forest VIPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - FOX (HAI)", color = "8cca0d", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Anrode", color = "#8cca0d", description = "Forest - district Anrode", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - city of Mühlhausen", color = "#8cca0d", description = "Forest - city of Mühlhausen", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Behringen", color = "#8cca0d", description = "Forest - district Behringen", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Geney", color = "#8cca0d", description = "Forest - district Geney", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Keula", color = "#8cca0d", description = "Forest - district Keula", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Langula", color = "#8cca0d", description = "Forest - district Langula", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Sollstedt", color = "#8cca0d", description = "Forest - district Sollstedt", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Zehnsberg", color = "#8cca0d", description = "Forest - district Zehnsberg", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - national park", color = "#8cca0d", description = "Forest - national park", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - national park Weberstedterholz (core zone)", color = "#8cca0d", description = "Forest - national park Weberstedterholz (core zone)", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - district Westerwald", color = "#8cca0d", description = "Forest - district Westerwald", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all GPs (HAI)", color = "#9acd32", description = "Visit of all grassland GPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all EPs (HAI)", color = "#9acd32", description = "Visit of all grassland EPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all MIPs (HAI)", color = "#9acd32", description = "Visit of all grassland MIPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all VIPs (HAI)", color = "#9acd32", description = "Visit of all grassland VIPs in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - RP/UP (HAI)", color = "9acd32", description = "Visit of all new landuse experiment plots in HAI (HEG1,2,3,6,14,15)", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Diedorf", color = "#9acd32", description = "Grassland - AG Diedorf", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Großenlupnitz", color = "#9acd32", description = "Grassland - AG Großenlupnitz", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Kirchheiligen", color = "#9acd32", description = "Grassland - AG Kirchheiligen", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Bollstedt", color = "#9acd32", description = "Grassland - AG Bollstedt", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Lengefeld", color = "#9acd32", description = "Grassland - AG Lengefeld", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Mülverstedt", color = "#9acd32", description = "Grassland - AG Mülverstedt", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Wartburgblick", color = "#9acd32", description = "Grassland - AG Wartburgblick", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG Wenigenlupnitz", color = "#9acd32", description = "Grassland - AG Wenigenlupnitz", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - AG-Struth-Eigenrieden", color = "#9acd32", description = "Grassland - AG-Struth-Eigenrieden", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - BEAG/TOA", color = "#9acd32", description = "Grassland - BEAG/TOA", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Bundesforst Dörnaerplatz", color = "#9acd32", description = "Grassland - Bundesforst Dörnaerplatz", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Gut Sambach", color = "#9acd32", description = "Grassland - Gut Sambach", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Thüringen Wagyu Becker&Becker", color = "#9acd32", description = "Grassland - Thüringen Wagyu Becker&Becker", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Heller", color = "#9acd32", description = "Grassland - Heller", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Schaeferei Effenberger", color = "#9acd32", description = "Grassland - Schaeferei Effenberger", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Nationalpark", color = "#9acd32", description = "Grassland - Nationalpark", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Nordagrar (Naturrind Unstruttal)", color = "#9acd32", description = "Grassland - Nordagrar (Naturrind Unstruttal)", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Schaeferei Goepfert", color = "#9acd32", description = "Grassland - Schaeferei Goepfert", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Börner", color = "#9acd32", description = "Grassland - Börner", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - Strewe-Winterberg", color = "#9acd32", description = "Grassland - Strewe-Winterberg", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - TUPAG (Hainich Weiderind)", color = "#9acd32", description = "Grassland - TUPAG (Hainich Weiderind)", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "no plot visit", color = "#a9fb00", description = "No plot visit in Hainich-Dün", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Sleeping place (HAI)", color = "#78ab0f", description = "Sleeping place in Hainich-Dün", duration = 1, quantity = 8, withActivity = false, resourceStructure = rs, type = "Sleeping place", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Drying cabinet (HAI)", color = "#6a8a27", description = "Drying cabinete in Hainich-Dün", duration = 1, quantity = 4, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Fridge (HAI)", color = "#6a8a27", description = "Fridge in Hainich-Dün", duration = 1, quantity = 2, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Freezer (HAI)", color = "#6a8a27", description = "Freezer in Hainich-Dün", duration = 1, quantity = 3, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Metal detector (Magna Trak 100) (HAI)", color = "#6a8a27", description = "Metal detector (Magna Trak 100) in Hainich-Dün", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Metal detector (Garrett ACE 150) (HAI)", color = "#6a8a27", description = "Metal detector (Garrett ACE 150) in Hainich-Dün", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Hainich-Dün"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - all EPs (ALB)", color = "#3a75e0", description = "Visit of all forest EPs in Schwäbische Alb", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - VIP AEW1-8 (ALB)", color = "#3a75e0", description = "Visit of all VIP AEW1-8 in Schwäbische Alb", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - VIP AEW9 (Alb)", color = "#3a75e0", description = "Visit of all VIP AEW9 in Schwäbische Alb", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Forest - FOX (ALB)", color = "#3a75e0", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all EPs excluding former military training area", color = "#6495ed", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all EPs including former military training area", color = "#6495ed", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - all VIPs (ALB)", color = "#6495ed", description = "Visit of all grassland VIPs in Schwäbische Alb", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Grassland - RP/UP (ALB)", color = "#6495ed", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "no plot visit (ALB)", color = "#0057f5", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "total Exploratory outside EP", color = "#0057f6", description = "", duration = 1, quantity = 0, withActivity = true, resourceStructure = rs, type = "Area", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Sleeping place (ALB)", color = "#27509a", description = "Sleeping places in Schwäbische Alb", duration = 1, quantity = 8, withActivity = false, resourceStructure = rs, type = "Sleeping place", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Drying cabinet (ALB)", color = "#7e95bf", description = "Drying cabinet in Schwäbische Alb", duration = 1, quantity = 5, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Binocular (ALB)", color = "#7e95bf", description = "", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schwäbische Alb"
});
rs_new.Add(new newResourceStructure()
{
name = "Metal detector (Magna Trak 100) (ALB)", color = "#7e95bf", description = "Metal detector (Magna Trak 100) in Schwäbische Alb", duration = 1, quantity = 1, withActivity = false, resourceStructure = rs, type = "Equipment", explo = "Schwäbische Alb"
});
//get/create admin group for entity rights
using (var groupManager = new GroupManager())
using (var permissionManager = new EntityPermissionManager())
using (var entityManager = new EntityManager())
using (var valueManager = new ResourceStructureAttributeManager())
{
var adminGroup = groupManager.Groups.Where(r => r.Name == "administrator").FirstOrDefault();
if (adminGroup == null)
{
// create new group
adminGroup = new Group
{
Name = "administrator",
Description = "administrator",
DisplayName = "administrator",
IsSystemGroup = false,
IsValid = true
};
groupManager.CreateAsync(adminGroup).Wait();
}
//create right type
int rights = (int)RightType.Read + (int)RightType.Write + (int)RightType.Delete + (int)RightType.Grant;
foreach (newResourceStructure rs_item in rs_new)
{
var duration = new TimeDuration();
duration.Value = rs_item.duration;
var resource = rManager.CreateResource(rs_item.name, rs_item.description, rs_item.quantity, rs_item.color, rs_item.withActivity, rs_item.resourceStructure, duration);
//add entity rights
permissionManager.Create(adminGroup,
entityManager.FindByName("SingleResource"),
resource.Id,
rights
);
ResourceAttributeUsage usage = valueManager.GetResourceAttributeUsageById(1);
valueManager.CreateResourceAttributeValue(rs_item.explo, rManager.GetResourceById(resource.Id), usage);
ResourceAttributeUsage usage2 = valueManager.GetResourceAttributeUsageById(2);
valueManager.CreateResourceAttributeValue(rs_item.type, rManager.GetResourceById(resource.Id), usage2);
}
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
#endregion
#region SECURITY
OperationManager operationManager = new OperationManager();
FeatureManager featureManager = new FeatureManager();
try
{
List <Feature> features = featureManager.FeatureRepository.Get().ToList();
Feature ResourceBooking = features.FirstOrDefault(f => f.Name.Equals("Resource Booking"));
if (ResourceBooking == null)
{
ResourceBooking = featureManager.Create("Resource Booking", "Resource Booking");
}
Feature NotificationBlackboard = features.FirstOrDefault(f => f.Name.Equals("Notification Blackboard"));
if (NotificationBlackboard == null)
{
NotificationBlackboard = featureManager.Create("Notification Blackboard", "Notification Blackboard", ResourceBooking);
}
Feature ResourceAdmin = features.FirstOrDefault(f => f.Name.Equals("Resource Administration"));
if (ResourceAdmin == null)
{
ResourceAdmin = featureManager.Create("Resource Administration", "Resource Administration");
}
Feature ResourceManagement = features.FirstOrDefault(f => f.Name.Equals("Resource Management"));
if (ResourceManagement == null)
{
ResourceManagement = featureManager.Create("Resource Management", "Resource Management", ResourceAdmin);
}
Feature ResourceStructureManagement = features.FirstOrDefault(f => f.Name.Equals("Resource Structure Management"));
if (ResourceStructureManagement == null)
{
ResourceStructureManagement = featureManager.Create("Resource Structure Management", "Resource Structure Management", ResourceAdmin);
}
Feature ResourceStructureAttributeManagement = features.FirstOrDefault(f => f.Name.Equals("Resource Structure Attribute Management"));
if (ResourceStructureAttributeManagement == null)
{
ResourceStructureAttributeManagement = featureManager.Create("Resource Structure Attribute Management", "Resource Structure Attribute Management", ResourceAdmin);
}
Feature NotificationManagement = features.FirstOrDefault(f => f.Name.Equals("Notification Management"));
if (NotificationManagement == null)
{
NotificationManagement = featureManager.Create("Notification Management", "Notification Management", ResourceAdmin);
}
Feature ActivityManagement = features.FirstOrDefault(f => f.Name.Equals("Activity Management"));
if (ActivityManagement == null)
{
ActivityManagement = featureManager.Create("Activity Management", "Activity Management", ResourceAdmin);
}
operationManager.Create("RBM", "Schedule", "*", ResourceBooking);
operationManager.Create("RBM", "Calendar", "*", ResourceBooking);
operationManager.Create("RBM", " NotificationBlackboard", "*", NotificationBlackboard);
operationManager.Create("RBM", "Resource", "*", ResourceManagement);
operationManager.Create("RBM", "ResourceStructure", "*", ResourceStructureManagement);
operationManager.Create("RBM", "ResourceStructure", "*", ResourceStructureAttributeManagement);
operationManager.Create("RBM", "Notification", "*", NotificationManagement);
operationManager.Create("RBM", "Activity", "*", ActivityManagement);
#region Help Workflow
if (!operationManager.Exists("RBM", "help", "*"))
{
operationManager.Create("RBM", "Help", "*");
}
#endregion Help Workflow
}
catch (Exception ex)
{
throw ex;
}
finally
{
operationManager.Dispose();
featureManager.Dispose();
}
#endregion
}
