public void FillProductsFromXML()
{
string fullPath;
foreach (var chainPath in _chainsPath)
{
foreach (var storePath in _storesPath)
{
foreach (var xmlName in _xmlNames)
{
fullPath = HttpContext.Current.Server.MapPath($"{_xmlPath}{chainPath}{storePath}{_fullPricesPath}{xmlName}");
if (File.Exists(fullPath))
{
using (DataSet ds = new DataSet())
{
ds.ReadXml(fullPath);
foreach (DataRow row in ds.Tables["product"].Rows)
{
productMapper.AddProduct(
row["ItemCode"].ToString(),
row["ItemName"].ToString(),
row["ManufactureName"].ToString(),
row["UnitQty"].ToString(),
row["Quantity"].ToString(),
row["UnitMeasure"].ToString());
}
}
}
}
}
}
}