public void ApproveModel(Guid modelID, Guid approverID, string note)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var d = new NKDC(_users.ApplicationConnectionString, null);
var o = d.BlockModels.Where(f => f.BlockModelID == modelID).Single();
o.ApproverContactID = approverID;
if (o.AuthorContactID.HasValue)
{
_users.EmailUsers(_users.GetUserEmails(new Guid[] { o.AuthorContactID.Value }), "Model approved", note);
}
var n = new BlockModelMetadata();
n.BlockModelMetadataID = Guid.NewGuid();
n.BlockModelID = modelID;
n.ParameterID = _privateServices.NKD_GUID_LOG;
var oc = new Occurrence();
oc.ID = Guid.NewGuid();
oc.ContactID = o.ApproverContactID.Value;
oc.Occurred = DateTime.UtcNow;
oc.Status = (uint)Occurrence.StatusCode.OK;
n.BlockModelMetadataText = oc.ToJson();
d.BlockModelMetadatas.AddObject(n);
d.SaveChanges();
}
}
public void UpdateStage(Guid blockModelGUID, Guid stageMetaID, string stage)
{
if (stage != null && stage.Length > 0)
{
try
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var d = new NKDC(_users.ApplicationConnectionString, null);
Parameter dt = new Parameter();
dt.ParameterID = stageMetaID;
dt.ParameterName = "Stage";
dt.ParameterType = "Metadata";
BlockModelMetadata rel = new BlockModelMetadata();
rel.BlockModelID = blockModelGUID;
rel.BlockModelMetadataID = Guid.NewGuid();
rel.ParameterID = stageMetaID;
rel.IsColumnData = false;
rel.BlockModelMetadataText = stage;
d.Parameters.AddObject(dt);
d.SaveChanges();
d.BlockModelMetadatas.AddObject(rel);
d.SaveChanges();
}
}
catch
{
}
}
}
internal List <BlockModelMetadata> SetBlockModelMetaData(Guid blockModelGUID, ImportDataMap testMap, string connString)
{
using (var entityObj = new NKDC(connString, null))
{
List <BlockModelMetadata> metaDataItems = new List <BlockModelMetadata>();
foreach (ColumnMap cmap in testMap.columnMap)
{
BlockModelMetadata metaData = new BlockModelMetadata();
metaData.BlockModelID = blockModelGUID;
metaData.BlockModelMetadataID = Guid.NewGuid();
metaData.IsColumnData = true;
string colName = cmap.sourceColumnName;
string columnValue = cmap.defaultValue;
Parameter param1 = new Parameter();
param1.ParameterName = cmap.targetColumnName; // source column
param1.ParameterType = "FieldName";
if (entityObj.BlockModelMetadatas.Where(f => f.BlockModelID == blockModelGUID && f.Parameter.Description == cmap.sourceColumnName).Any())
{
param1.Description = cmap.sourceColumnName = string.Format("{0}_{1}", cmap.sourceColumnName, Guid.NewGuid());
}
else
{
param1.Description = cmap.sourceColumnName; // target column
}
param1.ParameterID = Guid.NewGuid();
if (cmap.sourceColumnName != null && cmap.sourceColumnName.ToLower().Contains("ppm"))
{
param1.UnitID = new Guid("E91773A4-2762-4EDE-8510-38F78FAF981D");// TODO: HACK - get the proper guid for the current unit type by querying database
}
else if (cmap.sourceColumnName != null && cmap.sourceColumnName.ToLower().Contains("pct"))
{
param1.UnitID = new Guid("AEDBBE0A-6A94-419F-8B43-A98CE942669A");// TODO: HACK - get the proper guid for the current unit type by querying database
}
metaData.BlockModelMetadataText = cmap.targetColumnName;
metaData.ParameterID = param1.ParameterID;
entityObj.Parameters.AddObject(param1);
entityObj.BlockModelMetadatas.AddObject(metaData);
metaDataItems.Add(metaData);
entityObj.SaveChanges();
}
return(metaDataItems);
}
}
public void DenyModel(Guid modelID, Guid denierID, string error)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var d = new NKDC(_users.ApplicationConnectionString, null);
var o = d.BlockModels.Where(f => f.BlockModelID == modelID && f.AuthorContactID != null).Select(f => (Guid)f.AuthorContactID).ToArray();
_users.EmailUsers(_users.GetUserEmails(o), "Model not accepted", error);
var n = new BlockModelMetadata();
n.BlockModelMetadataID = Guid.NewGuid();
n.BlockModelID = modelID;
n.ParameterID = _privateServices.NKD_GUID_LOG;
var oc = new Occurrence();
oc.ID = Guid.NewGuid();
oc.ContactID = denierID;
oc.Occurred = DateTime.UtcNow;
oc.Status = (uint)Occurrence.StatusCode.Notified;
n.BlockModelMetadataText = oc.ToJson();
d.BlockModelMetadatas.AddObject(n);
d.SaveChanges();
}
}
internal List<BlockModelMetadata> SetBlockModelMetaData(Guid blockModelGUID, ImportDataMap testMap, string connString)
{
using (var entityObj = new XODBC(connString, null))
{
List<BlockModelMetadata> metaDataItems = new List<BlockModelMetadata>();
foreach (ColumnMap cmap in testMap.columnMap)
{
BlockModelMetadata metaData = new BlockModelMetadata();
metaData.BlockModelID = blockModelGUID;
metaData.BlockModelMetadataID = Guid.NewGuid();
metaData.IsColumnData = true;
string colName = cmap.sourceColumnName;
string columnValue = cmap.defaultValue;
Parameter param1 = new Parameter();
param1.ParameterName = cmap.targetColumnName; // source column
param1.ParameterType = "FieldName";
if (entityObj.BlockModelMetadatas.Where(f => f.BlockModelID == blockModelGUID && f.Parameter.Description == cmap.sourceColumnName).Any())
param1.Description = cmap.sourceColumnName = string.Format("{0}_{1}", cmap.sourceColumnName, Guid.NewGuid());
else
param1.Description = cmap.sourceColumnName; // target column
param1.ParameterID = Guid.NewGuid();
if (cmap.sourceColumnName != null && cmap.sourceColumnName.ToLower().Contains("ppm"))
{
param1.UnitID = new Guid("E91773A4-2762-4EDE-8510-38F78FAF981D");// TODO: HACK - get the proper guid for the current unit type by querying database
}
else if (cmap.sourceColumnName != null && cmap.sourceColumnName.ToLower().Contains("pct"))
{
param1.UnitID = new Guid("AEDBBE0A-6A94-419F-8B43-A98CE942669A");// TODO: HACK - get the proper guid for the current unit type by querying database
}
metaData.BlockModelMetadataText = cmap.targetColumnName;
metaData.ParameterID = param1.ParameterID;
entityObj.Parameters.AddObject(param1);
entityObj.BlockModelMetadatas.AddObject(metaData);
metaDataItems.Add(metaData);
entityObj.SaveChanges();
}
return metaDataItems;
}
}
