private Guid FindParameterForAssayTypeName(string pName)
{
Guid pid = new Guid();
Parameter xp = new Parameter();
using (var entityObj = new XODBC(BaseImportTools.XSTRING, null))
{
bool found = false;
IQueryable<Parameter> res = entityObj.Parameters.Where(c => c.ParameterType.Equals("AssayTypeName") && c.ParameterName.Equals(pName));
foreach (Parameter xx in res)
{
found = true;
pid = xx.ParameterID;
break;
}
if (!found)
{
Parameter pp = new Parameter();
pid = Guid.NewGuid();
pp.ParameterID = pid;
pp.ParameterType = "AssayTypeName";
pp.ParameterName = pName;
pp.Description = pName;
pp.VersionUpdated = DateTime.UtcNow;
entityObj.Parameters.AddObject(pp);
entityObj.SaveChanges();
}
return pid;
}
}
private AssayGroupWorkflowProcedure GetAssayGroupWorkflowProcedure(XODBC entityObj, string stage, AssayGroupWorkflow assayGroupWorkflow)
{
AssayGroupWorkflowProcedure agw = null;
//IQueryable<AssayGroupWorkflowProcedure> res = entityObj.AssayGroupWorkflowProcedures.Where(c => c.WorkflowStateName.Trim().Equals(stage.Trim()) && c.AssayGroupWorkflowID == assayGroupWorkflow.AssayGroupWorkflowID);
//foreach (AssayGroupWorkflowProcedure xx in res)
//{
// agw = xx;
//}
//if (agw == null)
//{
agw = new AssayGroupWorkflowProcedure();
agw.AssayGroupWorkflowID = assayGroupWorkflow.AssayGroupWorkflowID;
agw.AssayGroupWorkflow = assayGroupWorkflow;
agw.AssayGroupWorkflowProcedureID = Guid.NewGuid();
agw.WorkflowStateName = stage;
agw.Sequence = WorkflowProcedureSequenceNumber;
WorkflowProcedureSequenceNumber++;
entityObj.AssayGroupWorkflowProcedures.AddObject(agw);
entityObj.SaveChanges();
//}
return agw;
}
internal void AddAssayData(ModelImportStatus mos, Stream fileStream, FormatSpecification.ImportDataMap importMap,
int batchSize, Action<string, double> UpdateStatus, int approxNumLines,
string connectionString, Guid XODBProjectID, bool checkForDuplicates, bool doImportOverwrite)
{
bool commitToDB = true;
DateTime currentUpdateTimestamp = DateTime.UtcNow;
// first set up an assay group object - we can do this through the edm
using (var entityObj = new XODBC(connectionString, null))
{
//entityObj.Configuration.AutoDetectChangesEnabled = false;
Guid agGuid = Guid.NewGuid();
AssayGroup ag = new AssayGroup();
ag.AssayGroupID = agGuid;
ag.ProjectID = XODBProjectID;
ag.AssayGroupName = "Manual import";
ag.Comment = "From file " + importMap.mapOriginalDataFile;
ag.Entered = currentUpdateTimestamp;
ag.VersionUpdated = currentUpdateTimestamp;
entityObj.AssayGroups.AddObject(ag);
if (commitToDB)
{
entityObj.SaveChanges();
}
// set up the assay test columns - one of these for each test type
Dictionary<ColumnMap, Guid> resultsColumns = new Dictionary<ColumnMap, Guid>();
Dictionary<Guid, AssayGroupTest> assayGroups = new Dictionary<Guid, AssayGroupTest>();
foreach (ColumnMap cim in importMap.columnMap)
{
if (cim.targetColumnName.Trim().StartsWith("[ASSAY"))
{
// this is a test category
resultsColumns.Add(cim, Guid.NewGuid());
}
}
UpdateStatus("Setting up assay tests ", 2);
foreach (KeyValuePair<ColumnMap, Guid> kvp in resultsColumns)
{
ColumnMap cm = kvp.Key;
Guid g = kvp.Value;
AssayGroupTest xt = new AssayGroupTest();
string ss1 = "";
if (cm.sourceColumnName != null && cm.sourceColumnName.Length > 15)
{
ss1 = cm.sourceColumnName.Substring(0, 16);
}
else
{
ss1 = cm.sourceColumnName;
}
Guid pid = FindParameterForAssayTypeName(cm.sourceColumnName);
xt.ParameterID = pid;
xt.AssayTestName = ss1;
xt.AssayGroupID = agGuid;
xt.AssayGroupTestID = g;
xt.VersionUpdated = currentUpdateTimestamp;
entityObj.AssayGroupTests.AddObject(xt);
assayGroups.Add(g, xt);
if (commitToDB)
{
entityObj.SaveChanges();
}
}
// iterate through the data lines
int ct = 1;
int linesRead = 0;
SqlConnection connection = null;
SqlConnection secondaryConnection = null;
//List<string> uniqueDomains = new List<string>();
// get a connection to the database
try
{
int domainColIDX = -1;
connection = new SqlConnection(connectionString);
connection.Open();
secondaryConnection = new SqlConnection(connectionString);
secondaryConnection.Open();
bool hasDuplicateIntervals = false;
int numCommits = 0;
SqlTransaction trans;
trans = connection.BeginTransaction();
List<SqlCommand> commands = new List<SqlCommand>();
int tb = 0;
int transactionBatchLimit = batchSize;
// open the filestream and read the first line
StreamReader sr = null;
FileStream fs = null;
try
{
//fs = new FileStream(textInputDataFile, FileMode.Open, FileAccess.Read, FileShare.Read);
sr = new StreamReader(fileStream);
}
catch (Exception ex)
{
mos.AddErrorMessage("Error getting data stream for input data:\n" + ex.ToString());
mos.finalErrorCode = ModelImportStatus.ERROR_LOADING_FILE;
}
string line = null;
float pct = 0;
float bct = 1;
// report every X blocks
int repCount = 0;
//int reportOnBlock = 1000;
float fNumLines = (float)approxNumLines;
Dictionary<string, Guid> holeIDLookups = new Dictionary<string, Guid>();
Dictionary<string, int> columnIDX = new Dictionary<string, int>();
int fkLookupCount = 0;
PopulateCMapShortcut("HeaderID", importMap, columnIDX);
PopulateCMapShortcut("FromDepth", importMap, columnIDX);
PopulateCMapShortcut("ToDepth", importMap, columnIDX);
PopulateCMapShortcut("SampleNumber", importMap, columnIDX);
PopulateCMapShortcut("LabSampleNumber", importMap, columnIDX);
PopulateCMapShortcut("LabBatchNumber", importMap, columnIDX);
ColumnMap headerCmap = importMap.FindItemsByTargetName("HeaderID");
AssayQueries assayQueries = new AssayQueries();
if (sr != null)
{
while ((line = sr.ReadLine()) != null)
{
repCount++;
pct = ((float)linesRead / (float)approxNumLines) * 100.0f;
bct++;
linesRead++;
if (ct >= importMap.dataStartLine)
{
// digest a row of input data
List<string> items = parseTestLine(line, importMap.inputDelimiter);
Guid holeID = new Guid();
Decimal fromDepth = new Decimal(-9999999999);
Decimal toDepth = new Decimal(-9999999999);
string sampleNumber = null;
string labBatchNumber = null;
string labsampleNumber = null;
// find mapped values by name
//ColumnMap cmap = importMap.FindItemsByTargetName("HeaderID");
int idxVal = 0;
bool foundEntry = columnIDX.TryGetValue("HeaderID", out idxVal);
bool foundHole = false;
string holeName = "";
if (foundEntry)
{
string lookupByName = "HoleName";
string lookupValue = items[idxVal];
holeName = lookupValue;
bool lv = holeIDLookups.ContainsKey(lookupValue);
if (!lv)
{
string headerGUID = ForeignKeyUtils.FindFKValueInOther(lookupValue, headerCmap, secondaryConnection, false, lookupByName, XODBProjectID);
if (headerGUID == null)
{
// this means we have not found the specified records in the header table
// Report on issue and skip line
}
else
{
foundHole = true;
holeID = new Guid(headerGUID);
holeIDLookups.Add(lookupValue, holeID);
fkLookupCount++;
}
}
else
{
holeIDLookups.TryGetValue(lookupValue, out holeID);
foundHole = true;
}
}
if (!foundHole)
{
mos.AddErrorMessage("Failed to find hole " + holeName + ". Skipping record at line " + linesRead + ".");
mos.finalErrorCode = ModelImportStatus.DATA_CONSISTENCY_ERROR;
mos.recordsFailed++;
continue;
}
else
{
bool hasFrom = false;
idxVal = 0;
foundEntry = columnIDX.TryGetValue("FromDepth", out idxVal);
if (foundEntry)
//cmap = importMap.FindItemsByTargetName();
//if (cmap != null)
{
string ii = items[idxVal];
Decimal val = 0;
bool isOk = Decimal.TryParse(ii, out val);
if (isOk)
{
fromDepth = val;
hasFrom = true;
}
}
bool hasTo = false;
idxVal = 0;
foundEntry = columnIDX.TryGetValue("ToDepth", out idxVal);
if (foundEntry)
//cmap = importMap.FindItemsByTargetName("ToDepth");
//if (cmap != null)
{
string ii = items[idxVal];
Decimal val = 0;
bool isOk = Decimal.TryParse(ii, out val);
if (isOk)
{
toDepth = val;
hasTo = true;
}
}
List<Sample> duplicateList = null;
bool isDuplicateInterval = false;
if (checkForDuplicates)
{
if (hasFrom && hasTo)
{
// here we need to check that the hole is not duplicated
duplicateList = assayQueries.CheckForDuplicate(holeID, fromDepth, toDepth);
if (duplicateList.Count > 0)
{
isDuplicateInterval = true;
}
}
if (isDuplicateInterval)
{
hasDuplicateIntervals = true;
mos.AddWarningMessage("Duplicate interval for hole " + holeName + " at depth " + fromDepth + " to " + toDepth);
UpdateStatus("Duplicate interval at " + holeName + " " + fromDepth + ", " + toDepth, pct);
if (!doImportOverwrite)
{
mos.recordsFailed++;
continue;
}
}
}
//cmap = importMap.FindItemsByTargetName("SampleNumber");
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleNumber", out idxVal);
if (foundEntry)
// if (cmap != null)
{
string ii = items[idxVal];
sampleNumber = ii;
}
//cmap = importMap.FindItemsByTargetName("LabSampleNumber");
//if (cmap != null)
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleNumber", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
labsampleNumber = ii;
}
//cmap = importMap.FindItemsByTargetName("LabBatchNumber");
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleNumber", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
labBatchNumber = ii;
}
Sample xs = new Sample();
if (isDuplicateInterval == true)
{
xs = duplicateList.First();
}
else
{
xs.SampleID = Guid.NewGuid();
xs.FromDepth = fromDepth;
xs.ToDepth = toDepth;
xs.HeaderID = holeID;
xs.VersionUpdated = currentUpdateTimestamp;
entityObj.Samples.AddObject(xs);
}
// now pick out all the mapped values
// iterate over all [ASSAY RESULT] columns
bool assayUpdated = false;
bool assayAdded = false;
foreach (KeyValuePair<ColumnMap, Guid> kvp in resultsColumns)
{
ColumnMap cm = kvp.Key;
Guid g = kvp.Value; // this is the AssayGroupTestID
AssayGroupTestResult testResult = new AssayGroupTestResult();
/*bool assayResFound = false;
if (isDuplicateInterval)
{
List<AssayGroupTestResult> testResults = assayQueries.GetDuplicateResult(xs.SampleID, cm.sourceColumnName);
if (testResults.Count > 0)
{
testResult = testResults.First();
assayResFound = true;
}
}*/
//if(!assayResFound)
// {
testResult.AssayGroupTestResultID = Guid.NewGuid();
testResult.AssayGroupTestID = g;
testResult.SampleID = xs.SampleID;
testResult.VersionUpdated = currentUpdateTimestamp;
//}
testResult.LabBatchNumber = labBatchNumber;
// testResult.LabSampleName = labsampleNumber;
Decimal result = new Decimal();
if (items.Count >= cm.sourceColumnNumber)
{
bool parsedOK = Decimal.TryParse(items[cm.sourceColumnNumber], out result);
if (parsedOK)
{
testResult.LabResult = result;
}
else
{
testResult.LabResultText = items[cm.sourceColumnNumber];
}
}
else
{
mos.AddWarningMessage("Line " + linesRead + " contains too few columns to read " + cm.sourceColumnName);
}
//if (isDuplicateInterval == false)
//{
entityObj.AssayGroupTestResults.AddObject(testResult);
assayAdded = true;
//}else{
// if (!assayResFound)
// {
// entityObj.AssayGroupTestResult.Add(testResult);
// assayAdded = true;
// }
// else {
// assayUpdated = true;
// }
//}
}
if (assayAdded == true)
{
mos.recordsAdded++;
}
if (assayUpdated)
{
mos.recordsUpdated++;
}
tb++;
}
}
if (commitToDB)
{
if (tb == transactionBatchLimit)
{
entityObj.SaveChanges();
UpdateStatus("Writing assays to DB (" + ct + " entries)", pct);
tb = 0;
}
}
ct++;
//Console.WriteLine("Processing line "+ct);
}
entityObj.SaveChanges();
}
if (hasDuplicateIntervals)
{
mos.finalErrorCode = ModelImportStatus.DATA_CONSISTENCY_ERROR;
}
string numFKLookups = "FK lookups " + fkLookupCount;
mos.linesReadFromSource = ct - 1;
UpdateStatus("Finished writing assays to database.", 0);
}
catch (Exception ex)
{
UpdateStatus("Error writing assays to database ", 0);
mos.AddErrorMessage("Error writing assay data at line " + linesRead + ":\n" + ex.ToString());
mos.finalErrorCode = ModelImportStatus.ERROR_WRITING_TO_DB;
}
finally
{
try
{
connection.Close();
secondaryConnection.Close();
fileStream.Close();
}
catch (Exception ex)
{
mos.AddErrorMessage("Error closing conenction to database:\n" + ex.ToString());
mos.finalErrorCode = ModelImportStatus.ERROR_WRITING_TO_DB;
}
}
mos.linesReadFromSource = linesRead;
}
}
//private AssayGroupSubsample GetAssayGroupSubSample(XODBC entityObj, Guid agGuid, Guid? workflowID, Sample originalSample, int seqNum)
//{
// return agw;
//}
private AssayGroupSubsamplePrecondition GetAssayGroupPrecondition(XODBC entityObj, string preconditionName, string preconditionType, Guid ssGuid)
{
AssayGroupSubsamplePrecondition agw = null;
//IQueryable<AssayGroupSubsamplePrecondition> res = entityObj.AssayGroupSubsamplePreconditions.Where(c => c.PreconditionName.Trim().Equals(preconditionName.Trim()) && c.AssayGroupSubsampleID == ssGuid);
//foreach (AssayGroupSubsamplePrecondition xx in res)
//{
// agw = xx;
//}
if (agw == null)
{
agw = new AssayGroupSubsamplePrecondition();
agw.PreconditionName = preconditionName;
agw.AssayGroupSubsampleID = ssGuid;
agw.AssayGroupSubsamplePreconditionID = Guid.NewGuid();
//TODO - make this more efficient by storing the Parameters in a dicitonary so lookup is fast rather than
// hitting the DB for every record
Guid gParam = this.FindParameter("AssayPrecondition", preconditionType);
agw.PreconditionParameterID = gParam;
//agw.PreconditionParameterID = new Guid("6f49ded6-fe9b-487f-be48-eb8c88d9beef"); //Sixe mm TODO FIX
//+32 bigger than 32 (Size fractions)
//-32 smaller than 32
//+16 bigger than 16
//-16+8 smaller than 16, bigger than 8
//-8+4
//-4+2
//-2+1
//-1+0.5
//F1.45 Floatation (density floats)
//F1.45
//S1.45-F1.50
//S1.50-F1.55
//S1.55-F1.60
//S1.60-F1.70
//S1.70-F1.80
//S1.80-F2.00
//S2.00 (sinks)
//P2 Froth duration (30 sec)
//P3
//P4
//P5
//T2
//T1
entityObj.AssayGroupSubsamplePreconditions.AddObject(agw);
entityObj.SaveChanges();
}
return agw;
}
private AssayGroupWorkflow GetAssayGroupWorkflow(XODBC entityObj, string programType, Guid? assayGroupID)
{
AssayGroupWorkflow agw = null;
IQueryable<AssayGroupWorkflow> res = entityObj.AssayGroupWorkflows.Where(c => c.WorkflowName.Trim().Equals(programType.Trim()) && c.AssayGroupID == assayGroupID);
foreach (AssayGroupWorkflow xx in res)
{
agw = xx;
}
if (agw == null) {
agw = new AssayGroupWorkflow();
agw.AssayGroupID = assayGroupID;
agw.AssayGroupWorkflowID = Guid.NewGuid();
agw.WorkflowName = programType;
entityObj.AssayGroupWorkflows.AddObject(agw);
entityObj.SaveChanges();
}
return agw;
}
public void UpdateSecurity(ISecured secured)
{
//TODO!!!: When writing security check for antecedentid = referenceid &/or version=0
//First check user and owner rights, black list and white list against record
//Then get ok
if (secured.SecurityID.HasValue)
{
//Call Edit
if (CheckOwnership(secured, ActionPermission.Read | ActionPermission.Update))
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var c = new XODBC(ApplicationConnectionString,null);
if (secured.IsBlack)
{
var s = (from o in c.SecurityBlacklists where o.SecurityBlacklistID==secured.SecurityID && o.Version==0 && o.VersionDeletedBy==null select o).Single();
s.AccessorContactID = secured.AccessorContactID;
s.AccessorApplicationID = secured.AccessorApplicationID;
s.AccessorCompanyID = secured.AccessorCompanyID;
s.AccessorProjectID = secured.AccessorProjectID;
s.AccessorRoleID = secured.AccessorRoleID;
s.CanCreate = secured.CanCreate;
s.CanRead = secured.CanRead;
s.CanDelete = secured.CanDelete;
s.CanUpdate = secured.CanUpdate;
s.VersionUpdated = DateTime.UtcNow;
s.VersionUpdatedBy = secured.OwnerContactID;
}
else
{
var s = (from o in c.SecurityWhitelists where o.SecurityWhitelistID == secured.SecurityID && o.Version== 0 && o.VersionDeletedBy == null select o).Single();
s.AccessorContactID = secured.AccessorContactID;
s.AccessorApplicationID = secured.AccessorApplicationID;
s.AccessorCompanyID = secured.AccessorCompanyID;
s.AccessorProjectID = secured.AccessorProjectID;
s.AccessorRoleID = secured.AccessorRoleID;
s.CanCreate = secured.CanCreate;
s.CanRead = secured.CanRead;
s.CanDelete = secured.CanDelete;
s.CanUpdate = secured.CanUpdate;
s.VersionUpdated = DateTime.UtcNow;
s.VersionUpdatedBy = secured.OwnerContactID;
}
c.SaveChanges();
}
}
else
throw new AuthorityException(string.Format("Incorrect permission for action: \"Update\" Contact: {0} Record: {1}", secured.AccessorContactID, secured.OwnerReferenceID));
}
else
{
//Call New
if (CheckOwnership(secured, ActionPermission.Read | ActionPermission.Create))
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var c = new XODBC(ApplicationConnectionString,null);
if (secured.IsBlack)
{
var s = new SecurityBlacklist
{
SecurityBlacklistID = Guid.NewGuid(),
AccessorContactID = secured.AccessorContactID,
AccessorApplicationID = secured.AccessorApplicationID,
AccessorCompanyID = secured.AccessorCompanyID,
AccessorProjectID = secured.AccessorProjectID,
AccessorRoleID = secured.AccessorRoleID,
OwnerApplicationID = secured.OwnerApplicationID,
OwnerCompanyID = secured.OwnerCompanyID,
OwnerContactID = secured.OwnerContactID,
OwnerEntitySystemType = secured.OwnerEntitySystemType,
OwnerField = secured.OwnerField,
OwnerProjectID = secured.OwnerProjectID,
OwnerReferenceID = secured.OwnerReferenceID,
OwnerTableType = secured.OwnerTableType,
CanCreate = secured.CanCreate,
CanRead = secured.CanRead,
CanDelete = secured.CanDelete,
CanUpdate = secured.CanUpdate,
VersionOwnerContactID = secured.OwnerContactID,
VersionOwnerCompanyID = secured.OwnerCompanyID,
VersionUpdated = DateTime.UtcNow,
VersionUpdatedBy = secured.OwnerContactID
};
c.SecurityBlacklists.AddObject(s);
}
else
{
var s = new SecurityWhitelist
{
SecurityWhitelistID = Guid.NewGuid(),
AccessorContactID = secured.AccessorContactID,
AccessorApplicationID = secured.AccessorApplicationID,
AccessorCompanyID = secured.AccessorCompanyID,
AccessorProjectID = secured.AccessorProjectID,
AccessorRoleID = secured.AccessorRoleID,
OwnerApplicationID = secured.OwnerApplicationID,
OwnerCompanyID = secured.OwnerCompanyID,
OwnerContactID = secured.OwnerContactID,
OwnerEntitySystemType = secured.OwnerEntitySystemType,
OwnerField = secured.OwnerField,
OwnerProjectID = secured.OwnerProjectID,
OwnerReferenceID = secured.OwnerReferenceID,
OwnerTableType = secured.OwnerTableType,
CanCreate = secured.CanCreate,
CanRead = secured.CanRead,
CanDelete = secured.CanDelete,
CanUpdate = secured.CanUpdate,
VersionOwnerContactID = secured.OwnerContactID,
VersionOwnerCompanyID = secured.OwnerCompanyID,
VersionUpdated = DateTime.UtcNow,
VersionUpdatedBy = secured.OwnerContactID
};
c.SecurityWhitelists.AddObject(s);
}
c.SaveChanges();
}
}
else
throw new AuthorityException(string.Format("Incorrect permission for action: \"Create\" Contact: {0} Record: {1}", secured.AccessorContactID, secured.OwnerReferenceID));
}
}
internal void AddCoalQualityData(ModelImportStatus mos, Stream fileStream, FormatSpecification.ImportDataMap importMap,
int batchSize, Action<string, double> UpdateStatus, int approxNumLines,
string connectionString, Guid XODBProjectID, bool checkForDuplicates, bool doImportOverwrite)
{
WorkflowProcedureSequenceNumber = 1;
Guid? lastHoleID = new Guid();
string lastStage = "";
decimal lastFromDepth = -999999;
decimal lastToDepth = -999999;
bool commitToDB = true;
DateTime currentUpdateTimestamp = DateTime.UtcNow;
// first set up an assay group object - we can do this through the edm
using (var entityObj = new XODBC(connectionString, null))
{
Guid agGuid = Guid.NewGuid();
AssayGroup ag = new AssayGroup();
ag.AssayGroupID = agGuid;
ag.ProjectID = XODBProjectID;
ag.AssayGroupName = "Manual import";
ag.Comment = "From file " + importMap.mapOriginalDataFile;
ag.Entered = currentUpdateTimestamp;
ag.VersionUpdated = currentUpdateTimestamp;
entityObj.AssayGroups.AddObject(ag);
if (commitToDB)
{
entityObj.SaveChanges();
}
// set up the assay test columns - one of these for each test type
Dictionary<ColumnMap, Guid> resultsColumns = new Dictionary<ColumnMap, Guid>();
Dictionary<Guid, AssayGroupTest> assayGroups = new Dictionary<Guid, AssayGroupTest>();
ColumnMap cmProgram = null;
ColumnMap cmStage = null;
ColumnMap cmSizeFraction = null;
ColumnMap cmWashFraction = null;
foreach (ColumnMap cim in importMap.columnMap)
{
if (cim.targetColumnName.Trim().StartsWith("[RESULT"))
{
// this is a test category
resultsColumns.Add(cim, Guid.NewGuid());
}
else if (cim.targetColumnName.Trim().StartsWith("[PROGRAM"))
{
cmProgram = cim;
}
else if (cim.targetColumnName.Trim().StartsWith("[STAGE"))
{
cmStage = cim;
}
else if (cim.targetColumnName.Trim().StartsWith("[SIZE FRACTION"))
{
cmSizeFraction = cim;
}
else if (cim.targetColumnName.Trim().StartsWith("[WASH FRACTION"))
{
cmWashFraction = cim;
}
}
UpdateStatus("Setting up assay tests ", 2);
foreach (KeyValuePair<ColumnMap, Guid> kvp in resultsColumns)
{
ColumnMap cm = kvp.Key;
Guid g = kvp.Value;
AssayGroupTest xt = new AssayGroupTest();
string ss1 = "";
if (cm.sourceColumnName != null && cm.sourceColumnName.Length > 15)
{
ss1 = cm.sourceColumnName.Substring(0, 16);
}
else
{
ss1 = cm.sourceColumnName;
}
Guid pid = FindParameter("AssayTypeName", cm.sourceColumnName);
xt.ParameterID = pid;
xt.AssayTestName = ss1;
xt.AssayGroupID = agGuid;
xt.AssayGroupTestID = g;
xt.VersionUpdated = currentUpdateTimestamp;
entityObj.AssayGroupTests.AddObject(xt);
assayGroups.Add(g, xt);
if (commitToDB)
{
entityObj.SaveChanges();
}
}
// iterate through the data lines
int ct = 1;
int linesRead = 0;
SqlConnection connection = null;
SqlConnection secondaryConnection = null;
//List<string> uniqueDomains = new List<string>();
// get a connection to the database
try
{
connection = new SqlConnection(connectionString);
connection.Open();
secondaryConnection = new SqlConnection(connectionString);
secondaryConnection.Open();
bool hasDuplicateIntervals = false;
SqlTransaction trans;
trans = connection.BeginTransaction();
List<SqlCommand> commands = new List<SqlCommand>();
int tb = 0;
int transactionBatchLimit = batchSize;
// open the filestream and read the first line
StreamReader sr = null;
try
{
sr = new StreamReader(fileStream);
}
catch (Exception ex)
{
mos.AddErrorMessage("Error getting data stream for input data:\n" + ex.ToString());
mos.finalErrorCode = ModelImportStatus.ERROR_LOADING_FILE;
}
string line = null;
float pct = 0;
float bct = 1;
// report every X records
int repCount = 0;
float fNumLines = (float)approxNumLines;
Dictionary<string, Guid> holeIDLookups = new Dictionary<string, Guid>();
Dictionary<string, int> columnIDX = new Dictionary<string, int>();
int fkLookupCount = 0;
PopulateCMapShortcut("HeaderID", importMap, columnIDX);
PopulateCMapShortcut("FromDepth", importMap, columnIDX);
PopulateCMapShortcut("ToDepth", importMap, columnIDX);
PopulateCMapShortcut("SampleNumber", importMap, columnIDX);
PopulateCMapShortcut("SampleName", importMap, columnIDX);
PopulateCMapShortcut("LabSampleNumber", importMap, columnIDX);
PopulateCMapShortcut("LabBatchNumber", importMap, columnIDX);
ColumnMap headerCmap = importMap.FindItemsByTargetName("HeaderID");
AssayQueries assayQueries = new AssayQueries();
int seqNum = 1;
if (sr != null)
{
while ((line = sr.ReadLine()) != null)
{
repCount++;
pct = ((float)linesRead / (float)approxNumLines) * 100.0f;
bct++;
linesRead++;
if (ct >= importMap.dataStartLine)
{
// digest a row of input data
List<string> items = parseTestLine(line, importMap.inputDelimiter);
Guid holeID = new Guid();
Decimal fromDepth = new Decimal(-9999999999);
Decimal toDepth = new Decimal(-9999999999);
string sampleNumber = null;
string sampleName = null;
string labBatchNumber = null;
string labsampleNumber = null;
// find mapped values by name
int idxVal = 0;
// -- Get the hole ID foreign key relation
bool foundEntry = columnIDX.TryGetValue("HeaderID", out idxVal);
bool foundHole = false;
string holeName = "";
if (foundEntry)
{
string lookupByName = "HoleName";
string lookupValue = items[idxVal];
holeName = lookupValue;
bool lv = holeIDLookups.ContainsKey(lookupValue);
if (!lv)
{
string headerGUID = ForeignKeyUtils.FindFKValueInOther(lookupValue, headerCmap, secondaryConnection, false, lookupByName, XODBProjectID);
if (headerGUID == null)
{
// this means we have not found the specified records in the header table
// Report on issue and skip line
}
else
{
foundHole = true;
holeID = new Guid(headerGUID);
holeIDLookups.Add(lookupValue, holeID);
fkLookupCount++;
}
}
else
{
holeIDLookups.TryGetValue(lookupValue, out holeID);
foundHole = true;
}
}
if (!foundHole)
{
mos.AddErrorMessage("Failed to find hole " + holeName + ". Skipping record at line " + linesRead + ".");
mos.finalErrorCode = ModelImportStatus.DATA_CONSISTENCY_ERROR;
mos.recordsFailed++;
continue;
}
else
{
bool hasFrom = false;
idxVal = 0;
foundEntry = columnIDX.TryGetValue("FromDepth", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
Decimal val = 0;
bool isOk = Decimal.TryParse(ii, out val);
if (isOk)
{
fromDepth = val;
hasFrom = true;
}
}
bool hasTo = false;
idxVal = 0;
foundEntry = columnIDX.TryGetValue("ToDepth", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
Decimal val = 0;
bool isOk = Decimal.TryParse(ii, out val);
if (isOk)
{
toDepth = val;
hasTo = true;
}
}
List<Sample> duplicateList = null;
bool isDuplicateInterval = false;
//if (checkForDuplicates)
//{
// if (hasFrom && hasTo)
// {
// // here we need to check that the hole is not duplicated
// duplicateList = assayQueries.CheckForDuplicate(holeID, fromDepth, toDepth);
// if (duplicateList.Count > 0)
// {
// isDuplicateInterval = true;
// }
// }
// if (isDuplicateInterval)
// {
// hasDuplicateIntervals = true;
// mos.AddWarningMessage("Duplicate interval for hole " + holeName + " at depth " + fromDepth + " to " + toDepth);
// UpdateStatus("Duplicate interval at " + holeName + " " + fromDepth + ", " + toDepth, pct);
// if (!doImportOverwrite)
// {
// mos.recordsFailed++;
// continue;
// }
// }
//}
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleNumber", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
sampleNumber = ii;
}
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleName", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
sampleName = ii;
}
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleNumber", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
labsampleNumber = ii;
}
idxVal = 0;
foundEntry = columnIDX.TryGetValue("SampleNumber", out idxVal);
if (foundEntry)
{
string ii = items[idxVal];
labBatchNumber = ii;
}
Sample xs = new Sample();
if (isDuplicateInterval == true)
{
xs = duplicateList.First();
}
else
{
xs.SampleID = Guid.NewGuid();
xs.SampleName = sampleName;
xs.SampleNumber = sampleNumber;
xs.FromDepth = fromDepth;
xs.ToDepth = toDepth;
xs.HeaderID = holeID;
xs.VersionUpdated = currentUpdateTimestamp;
entityObj.Samples.AddObject(xs);
}
// Now iddentify the program, Stage, Size fraction and wash fraction
// get the program text
string programType = null;
if (cmProgram != null) {
programType = items[cmProgram.sourceColumnNumber];
}
string stage = null;
if (cmStage != null)
{
stage = items[cmStage.sourceColumnNumber];
}
string sizeFraction = null;
if (cmSizeFraction != null)
{
sizeFraction = items[cmSizeFraction.sourceColumnNumber];
}
string washFraction = null;
if (cmWashFraction != null)
{
washFraction = items[cmWashFraction.sourceColumnNumber];
}
// see if the interfal has changed, wherby we will need to reset the sequence ID
if (holeID != lastHoleID)
{
if (fromDepth != lastFromDepth && toDepth != lastToDepth)
{
// new interval
WorkflowProcedureSequenceNumber = 1;
}
}
if (!stage.Trim().Equals(lastStage))
{
WorkflowProcedureSequenceNumber = 1;
}
lastHoleID = holeID;
lastFromDepth = fromDepth;
lastToDepth = toDepth;
lastStage = stage;
AssayGroupWorkflow agWorkflowProgram = GetAssayGroupWorkflow(entityObj, programType, agGuid);
AssayGroupWorkflowProcedure agWorkflowStage = GetAssayGroupWorkflowProcedure(entityObj, stage, agWorkflowProgram);
AssayGroupSubsample agSS = new AssayGroupSubsample();
agSS.AssayGroupID = agGuid;
agSS.Sequence = seqNum;
agSS.AssayGroupSubsampleID = Guid.NewGuid();
agSS.SampleAntecedentID = xs.SampleID;
agSS.OriginalSample = xs;
agSS.AssayGroupWorkflowProcedureID = agWorkflowStage.AssayGroupWorkflowProcedureID;
agSS.AssayGroupWorkflowProcedure = agWorkflowStage;
entityObj.AssayGroupSubsamples.AddObject(agSS);
entityObj.SaveChanges();
seqNum++;
AssayGroupSubsamplePrecondition agSizeFraction = GetAssayGroupPrecondition(entityObj, sizeFraction, "Size fraction", agSS.AssayGroupSubsampleID);
AssayGroupSubsamplePrecondition agWashFraction = GetAssayGroupPrecondition(entityObj, washFraction, "Wash fraction", agSS.AssayGroupSubsampleID);
// now pick out all the mapped values
// iterate over all [ASSAY RESULT] columns
bool assayUpdated = false;
bool assayAdded = false;
foreach (KeyValuePair<ColumnMap, Guid> kvp in resultsColumns)
{
ColumnMap cm = kvp.Key;
Guid g = kvp.Value; // this is the AssayGroupTestID
AssayGroupTestResult testResult = new AssayGroupTestResult();
testResult.AssayGroupSubsampleID = agSS.AssayGroupSubsampleID;
testResult.AssayGroupTestResultID = Guid.NewGuid();
testResult.AssayGroupTestID = g;
testResult.SampleID = xs.SampleID;
testResult.VersionUpdated = currentUpdateTimestamp;
testResult.LabBatchNumber = labBatchNumber;
//testResult.LabSampleNumber = labsampleNumber;
Decimal result = new Decimal();
if (items.Count >= cm.sourceColumnNumber)
{
bool parsedOK = Decimal.TryParse(items[cm.sourceColumnNumber], out result);
if (parsedOK)
{
testResult.LabResult = result;
}
else
{
testResult.LabResultText = items[cm.sourceColumnNumber];
}
}
else
{
mos.AddWarningMessage("Line " + linesRead + " contains too few columns to read " + cm.sourceColumnName);
}
entityObj.AssayGroupTestResults.AddObject(testResult);
assayAdded = true;
}
if (assayAdded == true)
{
mos.recordsAdded++;
}
if (assayUpdated)
{
mos.recordsUpdated++;
}
tb++;
}
}
if (commitToDB)
{
if (tb == transactionBatchLimit)
{
entityObj.SaveChanges();
UpdateStatus("Writing assays to DB (" + ct + " entries)", pct);
tb = 0;
}
}
ct++;
}
entityObj.SaveChanges();
}
if (hasDuplicateIntervals)
{
mos.finalErrorCode = ModelImportStatus.DATA_CONSISTENCY_ERROR;
}
string numFKLookups = "FK lookups " + fkLookupCount;
mos.linesReadFromSource = ct - 1;
UpdateStatus("Finished writing coal quality data to database.", 0);
}
catch (Exception ex)
{
UpdateStatus("Error writing qualities to database ", 0);
mos.AddErrorMessage("Error writing data at line " + linesRead + ":\n" + ex.ToString());
mos.finalErrorCode = ModelImportStatus.ERROR_WRITING_TO_DB;
}
finally
{
try
{
connection.Close();
secondaryConnection.Close();
fileStream.Close();
}
catch (Exception ex)
{
mos.AddErrorMessage("Error closing conenction to database:\n" + ex.ToString());
mos.finalErrorCode = ModelImportStatus.ERROR_WRITING_TO_DB;
}
}
mos.linesReadFromSource = linesRead;
}
}
public void SyncUsers()
{
//Get Orchard Users & Roles
var orchardUsers = _contentManager.Query<UserPart, UserPartRecord>().List();
var orchardRoles = _roleService.GetRoles().ToArray();
var orchardUserRoles = (from xur in _userRolesRepository.Table.ToArray()
join xu in orchardUsers on xur.UserId equals xu.Id
join xr in orchardRoles on xur.Role.Id equals xr.Id
select new {xu.UserName, RoleName=xr.Name}).ToArray();
//Get Authmode & Then Update
if (AuthenticationMode == System.Web.Configuration.AuthenticationMode.Forms)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var c = new XODBC(ApplicationConnectionString,null);
var r = from o in c.Roles.Include("aspnet_Users") where o.ApplicationId == ApplicationID select o;
var u = from o in c.Users.Include("aspnet_Roles") where o.ApplicationId == ApplicationID select o;
var updated = DateTime.UtcNow;
//New User
var nu = (from o in orchardUsers where !(from ou in u select ou.UserName).Contains(o.UserName) select o);
foreach (var n in nu)
{
var user = new Users();
user.UserId = Guid.NewGuid();
user.UserName = n.UserName;
user.ApplicationId = ApplicationID;
user.LoweredUserName = n.UserName.ToLower();
user.LastActivityDate = updated;
c.Users.AddObject(user);
var contacts = (from o in c.Contacts where o.Username == user.UserName select o);
foreach (var nc in contacts)
{
nc.AspNetUserID = user.UserId;
}
if (!contacts.Any())
{
var contact = new Contact();
contact.ContactID = Guid.NewGuid();
contact.Username = user.UserName;
contact.AspNetUserID = user.UserId;
contact.DefaultEmail = n.Email;
contact.ContactName = string.Format("Orchard User: {0}", user.UserName);
contact.VersionUpdated = updated;
contact.Surname = "";
contact.Firstname = "";
c.Contacts.AddObject(contact);
}
}
//New Role
var nr = (from o in orchardRoles where !(from or in r select or.RoleName).Contains(o.Name) select o);
foreach (var n in nr)
{
var role = new Roles();
role.RoleName = n.Name;
role.ApplicationId = ApplicationID;
role.RoleId = Guid.NewGuid();
role.LoweredRoleName = n.Name.ToLower();
c.Roles.AddObject(role);
}
c.SaveChanges();
foreach (var role in r)
{
foreach (var user in role.aspnet_Users)
{
//Remove
if (!orchardUserRoles.Any(f => f.RoleName == role.RoleName && f.UserName == user.UserName))
user.aspnet_Roles.Remove(role);
}
foreach (var user in u)
{
//Add
if (orchardUserRoles.Any(f => f.RoleName == role.RoleName && f.UserName == user.UserName) && !role.aspnet_Users.Any(f=>f.UserName == user.UserName))
user.aspnet_Roles.Add(role);
}
}
c.SaveChanges();
var ru = (from o in u.ToArray() where !(from ou in orchardUsers select ou.UserName).Contains(o.UserName) select o); //can just delete from users table
foreach (var rem in ru)
{
c.Users.DeleteObject(rem);
}
c.SaveChanges();
}
}
else if (AuthenticationMode == System.Web.Configuration.AuthenticationMode.Windows)
{
//Module syncs only users - only all admin for now
//Get AD Users
// throw new NotImplementedException();
// get a DirectorySearcher object
DirectorySearcher search = new DirectorySearcher();
// specify the search filter
search.Filter = "(&(objectCategory=person)(objectClass=user))";
//search.Filter = "(&(objectClass=user)(anr=agrosser))"; //TEST
//// specify which property values to return in the search
search.PropertiesToLoad.Add("name"); // first name
search.PropertiesToLoad.Add("givenName"); // first name
search.PropertiesToLoad.Add("sn"); // last name
search.PropertiesToLoad.Add("mail"); // smtp mail address
search.PropertiesToLoad.Add("samaccountname"); // account name
search.PropertiesToLoad.Add("memberof"); // groups
search.PropertiesToLoad.Add("objectsid");
search.PropertiesToLoad.Add("objectguid");
search.PropertiesToLoad.Add("title");
// perform the search
SearchResultCollection results = search.FindAll(); //.FindOne();
var sessionRoleCache = new Dictionary<string, string>();
var adusers = from SearchResult o in results
select new
{
name = o.Properties["name"] != null && o.Properties["name"].Count > 0 ? string.Format("{0}", o.Properties["name"][0]) : null,
givenName = o.Properties["givenName"] != null && o.Properties["givenName"].Count > 0 ? string.Format("{0}", o.Properties["givenName"][0]) : null,
sn = o.Properties["sn"] != null && o.Properties["sn"].Count > 0 ? string.Format("{0}", o.Properties["sn"][0]) : null,
email = o.Properties["mail"] != null && o.Properties["mail"].Count > 0 ? string.Format("{0}", o.Properties["mail"][0]) : null,
samaccountname = o.Properties["samaccountname"] != null && o.Properties["samaccountname"].Count > 0 ? string.Format("{0}", o.Properties["samaccountname"][0]) : null,
username = o.Properties["objectsid"] != null && o.Properties["objectsid"].Count > 0 ? ((NTAccount)(new SecurityIdentifier((byte[])o.Properties["objectsid"][0], 0)).Translate(typeof(NTAccount))).ToString() : null,
guid = o.Properties["objectguid"] != null && o.Properties["objectguid"].Count > 0 ? new Guid((byte[])o.Properties["objectguid"][0]) : (Guid?)null,
title = o.Properties["title"] != null && o.Properties["title"].Count > 0 ? string.Format("{0}", o.Properties["title"][0]) : null,
roles = o.Properties["memberof"] != null ? (from string m in o.Properties["memberof"] select getNameFromFQDN(m, sessionRoleCache)).ToArray() : new string[] { }
};
//Get XODB Users
Contact[] xodbusers;
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var d = new XODBC(ApplicationConnectionString,null);
xodbusers = (from o in d.Contacts select o).ToArray();
//Sync AD, Orchard, XODB
//New into XODB
//We need firstname, surname
var ad_new = (from o in adusers where o.givenName != null && o.sn != null && (o.guid.HasValue && !(from x in xodbusers select x.ContactID).Contains((Guid)o.guid)) || (!o.guid.HasValue && !(from x in xodbusers select x.Username.ToLowerInvariant()).Contains(o.username.ToLowerInvariant())) select o);
foreach (var o in ad_new)
{
Contact c = new Contact();
c.ContactID = o.guid.HasValue ? o.guid.Value : Guid.NewGuid();
c.Username = o.username;
c.Firstname = o.givenName;
c.ContactName = string.Join(string.Empty, string.Format("{0} [{1}]", o.name, o.username).Take(120));
c.Surname = o.sn;
c.DefaultEmail = o.email;
d.Contacts.AddObject(c);
}
//Updates into XODB
var ad_diff = from o in adusers
from x in xodbusers
where ((o.guid.HasValue && o.guid.Value == x.ContactID) || (o.username != null && x.Username != null && o.username.ToLowerInvariant() == x.Username.ToLowerInvariant()))
//Things to update
&& (
o.givenName != x.Firstname
|| o.sn != x.Surname
|| o.email != x.DefaultEmail
|| o.name != x.ContactName
)
select new { x.ContactID, o.givenName, o.sn, o.email, o.name, o.username };
foreach (var o in ad_diff)
{
var c = xodbusers.First(x => x.ContactID == o.ContactID);
c.Firstname = o.givenName;
c.ContactName = string.Join(string.Empty, string.Format("{0} [{1}]", o.name, o.username).Take(120));
c.Surname = o.sn;
c.DefaultEmail = o.email;
}
d.SaveChanges();
}
}
}
public void DeleteSecurity(ISecured secured)
{
//TODO!!!: When writing security check for antecedentid = referenceid &/or version=0
if (secured.SecurityID.HasValue)
{
if (CheckOwnership(secured, ActionPermission.Read | ActionPermission.Delete))
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var c = new XODBC(ApplicationConnectionString,null);
if (secured.IsBlack)
{
var s = (from o in c.SecurityBlacklists where o.SecurityBlacklistID == secured.SecurityID && o.Version == 0 && o.VersionDeletedBy == null select o).Single();
c.SecurityBlacklists.DeleteObject(s);
}
else
{
var s = (from o in c.SecurityWhitelists where o.SecurityWhitelistID == secured.SecurityID && o.Version == 0 && o.VersionDeletedBy == null select o).Single();
c.SecurityWhitelists.DeleteObject(s);
}
c.SaveChanges();
}
}
else
throw new AuthorityException(string.Format("Incorrect permission for action: \"Delete\" Contact: {0} Record: {1}", secured.AccessorContactID, secured.OwnerReferenceID));
}
else
throw new NotSupportedException("Can not delete a security record without an ID.");
}
//private AssayGroupSubsample GetAssayGroupSubSample(XODBC entityObj, Guid agGuid, Guid? workflowID, Sample originalSample, int seqNum)
//{
// return agw;
//}
private AssayGroupSubsamplePrecondition GetAssayGroupPrecondition(XODBC entityObj, string preconditionName, string preconditionType, Guid ssGuid)
{
AssayGroupSubsamplePrecondition agw = null;
//IQueryable<AssayGroupSubsamplePrecondition> res = entityObj.AssayGroupSubsamplePreconditions.Where(c => c.PreconditionName.Trim().Equals(preconditionName.Trim()) && c.AssayGroupSubsampleID == ssGuid);
//foreach (AssayGroupSubsamplePrecondition xx in res)
//{
// agw = xx;
//}
if (agw == null)
{
agw = new AssayGroupSubsamplePrecondition();
agw.PreconditionName = preconditionName;
agw.AssayGroupSubsampleID = ssGuid;
agw.AssayGroupSubsamplePreconditionID = Guid.NewGuid();
//TODO - make this more efficient by storing the Parameters in a dicitonary so lookup is fast rather than
// hitting the DB for every record
Guid gParam = this.FindParameter("AssayPrecondition", preconditionType);
agw.PreconditionParameterID = gParam;
//agw.PreconditionParameterID = new Guid("6f49ded6-fe9b-487f-be48-eb8c88d9beef"); //Sixe mm TODO FIX
entityObj.AssayGroupSubsamplePreconditions.AddObject(agw);
entityObj.SaveChanges();
}
return agw;
}
/// <summary>
/// Set an item of meta data with the given types and cvalues
/// </summary>
/// <param name="blockModelID"></param>
/// <param name="metaDataType"></param>
/// <param name="tableType"></param>
/// <param name="cont"></param>
private static void SetMetaDataItem(Guid blockModelID, string metaDataType, string tableType, string cont)
{
try
{
using (var entityObj = new XODBC(BaseImportTools.XSTRING, null))
{
MetaData dt = new MetaData();
dt.MetaDataID = Guid.NewGuid();
dt.MetaDataType = metaDataType;
dt.ContentToIndex = cont;
MetaDataRelation rel = new MetaDataRelation();
rel.MetaDataRelationID = Guid.NewGuid();
rel.MetaDataID = dt.MetaDataID;
rel.TableType = tableType;
rel.ReferenceID = blockModelID;
entityObj.MetaDatas.AddObject(dt);
entityObj.SaveChanges();
entityObj.MetaDataRelations.AddObject(rel);
entityObj.SaveChanges();
}
}
catch (Exception ex) {
string msg = "Error setting domains list "+ex.ToString();
}
}
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;
}
}
