public GenericConversionRule(GenericConversionRuleInfo conversionRule)
{
ConversionRule = conversionRule;
RuleName = ConversionRule.RuleName;
RuleType = ConversionRule.RuleType;
RuleTypePriority = ConversionRule.RuleTypePriority;
GlobalPriority = ConversionRule.GlobalPriority;
RuleApplicablePattern = ConversionRule.RuleApplicablePattern;
}
public void LoadRuleList()
{
FileInfo newFile = new FileInfo(ConfigurationManager.AppSettings.Get("EXCEL_FILE"));
using (ExcelPackage pck = new ExcelPackage(newFile))
{
var sheet = pck.Workbook.Worksheets.FirstOrDefault();
if (sheet == null)
{
return;
}
GenericConversionRuleInfoList = new List <GenericConversionRuleInfo>();
var start = sheet.Dimension.Start;
var end = sheet.Dimension.End;
// Skip header row
for (int row = start.Row + 1; row <= end.Row; row++)
{
GenericConversionRuleInfo conversionMethod = new GenericConversionRuleInfo();
conversionMethod.RuleName = sheet.Cells[row, 1].Text;
conversionMethod.RuleType = sheet.Cells[row, 2].Text;
conversionMethod.RuleTypePriority = sheet.Cells[row, 3].Text.ConvertToInt32();
conversionMethod.GlobalPriority = sheet.Cells[row, 4].Text.ConvertToInt32();
conversionMethod.TrimLeftBeforeMatch = sheet.Cells[row, 5].Text.ConvertToBool();
conversionMethod.TrimRightBeforeMatch = sheet.Cells[row, 6].Text.ConvertToBool();
conversionMethod.RuleApplicablePattern = sheet.Cells[row, 7].Text;
conversionMethod.ReplacePattern = sheet.Cells[row, 8].Text;
GenericConversionRuleInfoList.Add(conversionMethod);
}
}
GenericConversionRuleList = new List <GenericConversionRule>();
// Create GenericConversionMethods
foreach (var conversionMethodModel in GenericConversionRuleInfoList)
{
GenericConversionRuleList.Add(new GenericConversionRule(conversionMethodModel));
}
}
