private bool ExtractExcelTriggers(Workbook xlWorkbook)
{
log.Log("Extract Triggers to local variables - start");
//THIS IS NEW PROCESSING TO USE XLS INSTEAD OF TXT FORMAT
_Worksheet sheet = xlWorkbook.Sheets[1];
Range xlRange = sheet.UsedRange;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
log.Log("Importing Triggers - start");
try
{
//iterate through all columns/rows in xls
for (int i = 2; i != rowCount + 1; i++)
{
TriggerDefinition trigger = new TriggerDefinition();
int count = 3;
trigger.Name = sheet.Cells[i, count].Value2.ToString();
count++;
trigger.Type = sheet.Cells[i, count].Value2.ToString();
count++;
trigger.TriggeringEvent = sheet.Cells[i, count].Value2.ToString();
count++;
count++;
trigger.BaseObjectType = sheet.Cells[i, count].Value2.ToString();
count++;
trigger.TableName = sheet.Cells[i, count].Value2.ToString();
count++;
count++;
count++;
trigger.WhenClause = sheet.Cells[i, count].Value2.ToString();
count++;
count++;
count++;
count++;
trigger.Body = sheet.Cells[i, count].Value2.ToString();
//trigger.Unit = bucketSheet.Cells[i, count].Value2.ToString();
//write processing output to same line
log.Log(String.Format("Reading trigger {0} \r", trigger.Name));
_triggers.Add(trigger);
}
log.Log("Extract Triggers to local variables - complete");
}
catch (Exception e)
{
log.Log(string.Format("Error reading trigger file: {0}", e));
return false;
}
return true;
}
private bool ExtractTriggers()
{
string triggerFile = "";
string line;
int lineNo = 0;
int triggerCount = 0;
log.Log("Extract Triggers to local variables - start");
if (File.Exists(triggerFile))
{
StreamReader triggersFile = new StreamReader(triggerFile);
try
{
while ((line = triggersFile.ReadLine()) != null) // loop through all extract lines
{
lineNo++;
if (lineNo > Common.Constants.triggerLinesToSkip)
{
triggerCount++;
TriggerDefinition trigger = new TriggerDefinition();
trigger.TableName = line.Substring(Common.Constants.posTriggerTableName, Common.Constants.posTriggerRuleName - Common.Constants.posTriggerTableName).Trim();
trigger.RuleName = line.Substring(Common.Constants.posTriggerRuleName, Common.Constants.lenTriggerRuleName).Trim();
trigger.Access = line.Substring(Common.Constants.posTriggerAccess).Trim();
foreach (TableDefinition table in _tables)
{
if (table.Name.Equals(trigger.TableName.ToString()))
{
trigger.TableSourceId = table.Id;
trigger.Unit = table.Unit;
}
}
foreach (RuleDefinition rule in _rules)
{
if (rule.Name.Equals(trigger.RuleName.ToString()))
{
trigger.RuleSourceId = rule.Id;
break;
}
}
//write processing output to same line
log.Log(string.Format("Reading trigger for {0} \r", trigger.TableName));
_triggers.Add(trigger);
}
}
triggersFile.Close();
log.Log("Extract Triggers to local variables - complete");
}
catch (Exception e)
{
triggersFile.Close();
log.Log(string.Format("Incorrect format of the Triggers file. Error:{0}", e.Message));
return false;
}
}
else
{
log.Log("Triggers Data file is missing");
return false;
}
return true;
}