public void LoadProductionRecords(DataTable currentMonth, DPSFile ms, DateTime currentDay) { foreach (var row in currentMonth.AsEnumerable()) { string productionCode = row["Plant"].ToString() + "_" + row["Material Description OR Product Code in DPS"].ToString(); string uom = row["Display Unit of Measure"].ToString(); DateTime?day = row["transaction date"] as DateTime?; decimal quantity = DPSFile.ParseDecimal(row["production"].ToString()); try { quantity = AzureModel.ConvertQuantityToStandardUnit(uom, quantity); } catch (Exception ex) { ms.Warnings.Add(new WarningMessage(productionCode, ex.Message)); continue; } ms.AddTagBalance(currentDay, "DPS", productionCode, day.Value, quantity); } }