/// <summary>
        /// Product data
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public List <MonitoringProductEntity> Adapt(DataTable dt)
        {
            List <MonitoringProductEntity> results = new List <MonitoringProductEntity>();

            foreach (DataRow rw in dt.Rows)
            {
                MonitoringProductEntity productDataEntity = new MonitoringProductEntity();
                productDataEntity = AdaptItem(rw, dt);
                results.Add(productDataEntity);
            }
            return(results);
        }
        public MonitoringProductEntity AdaptItem(DataRow rw, DataTable dt)
        {
            MonitoringProductEntity result = new MonitoringProductEntity();

            result.ProductID = SafeHelper.GetSafeint(rw["ProductID"]);
            if (dt.Columns.Contains("ProductCode"))
            {
                result.ProductCode = SafeHelper.GetSafestring(rw["ProductCode"]);
            }

            if (dt.Columns.Contains("ProductDescription"))
            {
                result.ProductDescription = SafeHelper.GetSafestring(rw["ProductDescription"]);
            }

            if (dt.Columns.Contains("IsActive"))
            {
                result.IsActive = SafeHelper.GetSafebool(rw["IsActive"]);
            }

            return(result);
        }