public void ReadExcelIntoTempObjects(string fileName, string productNum)
{
TempProducts.Clear();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(fileName)))
{
var firstSheet = package.Workbook.Worksheets["Configured Options"];
int row = 1, j = 1;
for (row = 2; row < firstSheet.Dimension.Rows; row++)
{
ExcelProduct ep = new ExcelProduct();
ep.ProductName = firstSheet.Cells[row, 1].Text;
ep.ProductNumber = firstSheet.Cells[row, 2].Text;
ep.FeatureName = firstSheet.Cells[row, 3].Text;
ep.FeatureRequired = firstSheet.Cells[row, 4].Text;
ep.FeatureCSROnly = firstSheet.Cells[row, 5].Text;
ep.OptionGroupName = firstSheet.Cells[row, 6].Text;
ep.OptionGroupRequired = firstSheet.Cells[row, 7].Text;
ep.OptionGroupCSRonly = firstSheet.Cells[row, 8].Text;
ep.SubOptionGroupName = firstSheet.Cells[row, 9].Text;
ep.SubOptionGroupRequired = firstSheet.Cells[row, 10].Text;
ep.OptionName = firstSheet.Cells[row, 11].Text;
ep.OptionCode = firstSheet.Cells[row, 12].Text;
ep.HCPCS = firstSheet.Cells[row, 13].Text;
ep.OptionRequired = firstSheet.Cells[row, 14].Text;
ep.OptionCSROnly = firstSheet.Cells[row, 15].Text;
ep.WorkTicketInput = firstSheet.Cells[row, 16].Text;
TempProducts.Add(ep);
}
}
}
private bool ValidateObjects()
{
if (TempProducts.Any(o => o.FeatureName.Contains("Billy")))
{
return(false);
}
if (TempProducts.Any(o => o.FeatureName.Length > 72))
{
return(false);
}
return(true);
}
