public void ReadExcelIntoObjects(string fileName, string productNum)
{
AllProducts.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;
AllProducts.Add(ep);
}
}
}
public void NewProduct()
{
Products p = new Products();
p.ProductName = "Nieuw Product";
p.Price = 0;
p.Edit = Visibility.Visible;
AllProducts.Add(p);
}
public void AddBlankProduct(string name)
{
Products product = new Products()
{
ProductName = name
};
AllProducts.Add(product);
}
public void AddProduct(Merchandise product)
{
AllProducts.Add(product);
}
//ввод информации о товаре
public Merchandise(string productName, double price, long barcode, string merchandiseName) : base(productName, price, barcode)
{
AllProducts.Add(product);
this.merchandiseName = merchandiseName;
}
