static DateTime ToDateTime(string val) {
            var s = new StringBuilder();
            s.Append(val.Substring(6, 2));
            s.Append('.');
            s.Append(val.Substring(4, 2));
            s.Append('.');
            s.Append(val.Substring(0, 4));
            s.Append(val.Substring(8, 9));
            return DateTime.Parse(s.ToString());
        }