|
public UpdateStructuredDataStructure ( |
||
| entity | The entity containing the changes. | |
| return | ||
public static XmlDocument setVariableOrder(StructuredDataStructure structuredDataStructure, List<long> orderList)
{
DataStructureManager dsm = new DataStructureManager();
XmlDocument doc = createOderNode(structuredDataStructure);
XmlNode order = doc.GetElementsByTagName("order")[0];
doc.FirstChild.RemoveChild(order);
order = doc.CreateNode(XmlNodeType.Element, "order", null);
foreach (long l in orderList)
{
XmlNode variable = doc.CreateNode(XmlNodeType.Element, "variable", null);
variable.InnerText = l.ToString();
order.AppendChild(variable);
}
doc.FirstChild.AppendChild(order);
structuredDataStructure.Extra = doc;
dsm.UpdateStructuredDataStructure(structuredDataStructure);
return doc;
}
public MessageModel storeDataStructure(long Id, string Name, bool isStructured, string Description ="", string cssId = "", bool inUse = false)
{
Name = Server.UrlDecode(Name);
Description = Server.UrlDecode(Description);
MessageModel DataStructureValidation = MessageModel.validateDataStructureInUse(Id);
if (DataStructureValidation.hasMessage && inUse == false)
{
return DataStructureValidation;
}
else
{
DataStructureValidation = MessageModel.validateDataStructureName(Id, Name, cssId);
if (DataStructureValidation.hasMessage)
{
return DataStructureValidation;
}
else
{
DataStructureManager dataStructureManager = new DataStructureManager();
DataStructure dataStructure;
if (isStructured)
{
if (Id == 0)
{
dataStructure = dataStructureManager.CreateStructuredDataStructure(Name.Trim(), Description.Trim(), null, null, DataStructureCategory.Generic);
LoggerFactory.LogData(dataStructure.Id.ToString(), typeof(DataStructure).Name, Vaiona.Entities.Logging.CrudState.Created);
return new MessageModel()
{
Message = dataStructure.Id.ToString(),
hasMessage = false,
CssId = "redirect"
};
}
else
{
StructuredDataStructure StructuredDataStructure = dataStructureManager.StructuredDataStructureRepo.Get(Id);
StructuredDataStructure.Name = Name;
StructuredDataStructure.Description = Description;
dataStructure = dataStructureManager.UpdateStructuredDataStructure(StructuredDataStructure);
LoggerFactory.LogData(dataStructure.Id.ToString(), typeof(DataStructure).Name, Vaiona.Entities.Logging.CrudState.Created);
return new MessageModel()
{
Message = Id.ToString(),
hasMessage = false,
CssId = "redirect"
};
}
}
else
{
if (Id == 0)
{
dataStructure = dataStructureManager.CreateUnStructuredDataStructure(Name.Trim(), Description.Trim());
LoggerFactory.LogData(dataStructure.Id.ToString(), typeof(DataStructure).Name, Vaiona.Entities.Logging.CrudState.Created);
return new MessageModel()
{
Message = "refresh DataStructureResultGrid",
hasMessage = false,
CssId = "refresh"
};
}
else
{
UnStructuredDataStructure unStructuredDataStructure = dataStructureManager.UnStructuredDataStructureRepo.Get(Id);
unStructuredDataStructure.Name = Name;
unStructuredDataStructure.Description = Description;
dataStructure = dataStructureManager.UpdateUnStructuredDataStructure(unStructuredDataStructure);
LoggerFactory.LogData(dataStructure.Id.ToString(), typeof(DataStructure).Name, Vaiona.Entities.Logging.CrudState.Created);
return new MessageModel()
{
Message = "refresh DataStructureResultGrid",
hasMessage = false,
CssId = "refresh"
};
}
}
}
}
}
public List<Variable> getOrderedVariables(StructuredDataStructure structuredDataStructure)
{
DataStructureManager dsm = new DataStructureManager();
XmlDocument doc = (XmlDocument)structuredDataStructure.Extra;
XmlNode order;
if (doc == null)
{
doc = new XmlDocument();
XmlNode root = doc.CreateNode(XmlNodeType.Element, "extra", null);
doc.AppendChild(root);
}
if (doc.GetElementsByTagName("order").Count == 0)
{
if (structuredDataStructure.Variables.Count > 0)
{
order = doc.CreateNode(XmlNodeType.Element, "order", null);
foreach (Variable v in structuredDataStructure.Variables)
{
XmlNode variable = doc.CreateNode(XmlNodeType.Element, "variable", null);
variable.InnerText = v.Id.ToString();
order.AppendChild(variable);
}
doc.FirstChild.AppendChild(order);
structuredDataStructure.Extra = doc;
dsm.UpdateStructuredDataStructure(structuredDataStructure);
}
}
order = doc.GetElementsByTagName("order")[0];
List<Variable> orderedVariables = new List<Variable>();
if (structuredDataStructure.Variables.Count != 0)
{
foreach (XmlNode x in order)
{
foreach (Variable v in structuredDataStructure.Variables)
{
if (v.Id == Convert.ToInt64(x.InnerText))
orderedVariables.Add(v);
}
}
}
return orderedVariables;
}
public ActionResult storeVariables(long Id, storeVariableStruct[] variables)
{
DataStructureManager dataStructureManager = new DataStructureManager();
StructuredDataStructure dataStructure = dataStructureManager.StructuredDataStructureRepo.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.Count() > 0)
{
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))
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 = new DataContainerManager().DataAttributeRepo.Get(svs.AttributeId);
if (dataAttribute != null)
{
variable = dataStructureManager.AddVariableUsage(dataStructure, dataAttribute, svs.isOptional, svs.Lable.Trim(), null, null, svs.Description.Trim(), new UnitManager().Repo.Get(svs.UnitId));
svs.Id = variable.Id;
}
else
{
returnObject = new MessageModel()
{
hasMessage = true,
Message = "Not all Variables are stored.",
CssId = "0"
};
}
}
dataStructure = dataStructureManager.StructuredDataStructureRepo.Get(Id);
variables = variables.Where(v => v.Id != 0).ToArray();
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 = new UnitManager().Repo.Get(svs.UnitId);
variable.DataAttribute = new DataContainerManager().DataAttributeRepo.Get(svs.AttributeId);
variable.IsValueOptional = svs.isOptional;
}
}
dataStructure = dataStructureManager.UpdateStructuredDataStructure(dataStructure);
DataStructureIO.setVariableOrder(dataStructure, variables.Select(svs => svs.Id).ToList());
}
else
{
foreach (Variable v in dataStructure.Variables)
{
dataStructureManager.RemoveVariableUsage(v);
}
}
LoggerFactory.LogCustom("Variables for Data Structure " + Id + " stored.");
return Json(returnObject, JsonRequestBehavior.AllowGet);
}
private static XmlDocument createOderNode(StructuredDataStructure structuredDataStructure)
{
DataStructureManager dsm = new DataStructureManager();
XmlDocument doc = (XmlDocument)structuredDataStructure.Extra;
XmlNode order;
if (doc == null)
{
doc = new XmlDocument();
XmlNode root = doc.CreateNode(XmlNodeType.Element, "extra", null);
doc.AppendChild(root);
}
if (doc.GetElementsByTagName("order").Count == 0)
{
if (structuredDataStructure.Variables.Count > 0)
{
order = doc.CreateNode(XmlNodeType.Element, "order", null);
foreach (Variable v in structuredDataStructure.Variables)
{
XmlNode variable = doc.CreateNode(XmlNodeType.Element, "variable", null);
variable.InnerText = v.Id.ToString();
order.AppendChild(variable);
}
doc.FirstChild.AppendChild(order);
structuredDataStructure.Extra = doc;
dsm.UpdateStructuredDataStructure(structuredDataStructure);
}
}
return doc;
}
public string CreateTemplate(StructuredDataStructure dataStructure)
{
DataStructureManager dataStructureManager = new DataStructureManager();
List<Variable> variables = getOrderedVariables(dataStructure);
string rgxPattern = "[<>?\":|\\\\/*]";
string rgxReplace = "-";
Regex rgx = new Regex(rgxPattern);
string filename = filename = dataStructure.Id + "_" + rgx.Replace(dataStructure.Name, rgxReplace) +".xlsm";
string path = Path.Combine("DataStructures", dataStructure.Id.ToString());
CreateTemplate(variables, path, filename);
XmlDocument resources = new XmlDocument();
resources.LoadXml("<Resources><Resource Type=\"Excel\" Edition=\"2010\" Path=\"" + Path.Combine(path, filename) + "\"></Resource></Resources>");
dataStructure.TemplatePaths = resources;
dataStructureManager.UpdateStructuredDataStructure(dataStructure);
return Path.Combine(path, filename);
}