Exemplo n.º 1
0
 protected async Task <Data.TableSet> FormatData(DataTableCollection tables)
 {
     Data.Table config = (new Config()).Learning();
     return(await Task.Run(() =>
     {
         Data.TableSet tableSet = new Data.TableSet();
         foreach (DataTable _temp in tables)
         {
             Data.TableList liTable = new Data.TableList();
             foreach (DataRow row in _temp.Rows)
             {
                 var obj = new Data.Object();
                 foreach (var attribute in row.Table.Columns)
                 {
                     obj.Add(attribute.ToString(), row[attribute.ToString()]);
                 }
                 ;
                 if (!String.IsNullOrEmpty(obj[config[row.Table.TableName]["key"].ToString()].ToString()))
                 {
                     liTable.Add(config[_temp.TableName.ToString()]["key"].ToString(), obj);
                 }
             }
             ;
             Data.Table tbl = new Data.Table();
             foreach (var list in liTable.Objects)
             {
                 var properties = new Dictionary <string, List <string> >();
                 foreach (var item in list)
                 {
                     foreach (var p in item)
                     {
                         if (properties.ContainsKey(p.Key) && !String.IsNullOrEmpty(p.Value.ToString()))
                         {
                             properties[p.Key.ToString()].Add(p.Value.ToString());
                             List <string> li = properties[p.Key]
                                                .Distinct()
                                                .ToList();
                             properties[p.Key.ToString()] = li;
                         }
                         else if (!String.IsNullOrEmpty(p.Value.ToString()))
                         {
                             List <string> li = new List <string>();
                             li.Add(p.Value.ToString());
                             properties.Add(p.Key.ToString(), li);
                         }
                     }
                 }
                 tbl.Add(config[_temp.TableName.ToString()]["key"].ToString(), new Data.Object()
                 {
                     { config[_temp.TableName.ToString()]["key"].ToString(), list.First()[config[_temp.TableName.ToString()]["key"].ToString()] }, { "properties", properties }
                 });
             }
             tableSet.Add(_temp.TableName.ToString(), tbl);
         }
         ;
         return tableSet;
     }));
 }
Exemplo n.º 2
0
        protected async Task <DataTable> AnalyzeData(Data.TableSet tblSet)
        {
            return(await Task.Run(() =>
            {
                List <string> CheckPropertyValue(string k, string v, string s, KeyValuePair <string, Data.Object> obj, Dictionary <string, List <string> > _properties)
                {
                    List <string> _defects = new List <string>();
                    List <string> _list = new List <string>();
                    bool _checker = true;
                    switch (k)
                    {
                    case "Allowed Instructor+":
                    case "Instructors*+*":
                        _checker = tblSet["instructors"].ContainsKey(v);
                        if (!_checker)
                        {
                            _defects.Add("Instructor not found in lookup table");
                        }
                        break;

                    case "Topic*+*":
                        _checker = tblSet["topics"].ContainsKey(v);
                        if (!_checker)
                        {
                            _defects.Add("Topic not found in lookup table");
                        }
                        break;

                    case "Effective Date*" when s == "Blended Courses" || s == "Digital Course":
                        _checker = (v == "01/01/1900" || v == "1/1/1900");
                        if (!_checker)
                        {
                            _defects.Add("Topic not found in lookup table");
                        }
                        break;

                    case "Blended Course*" when s == "Course Offerings":
                        _checker = tblSet["Blended Courses"].ContainsKey(v);
                        if (!_checker)
                        {
                            _defects.Add("Blended Course not found in lookup table");
                        }
                        if (_properties.ContainsKey("Min Enrollment Capacity") || _properties.ContainsKey("Max Enrollment Capacity") || _properties.ContainsKey("Enable Auto Enrollment from Waitlist") || _properties.ContainsKey("Waitlist Capacity"))
                        {
                            if (_properties.ContainsKey("Min Enrollment Capacity") && _properties.ContainsKey("Max Enrollment Capacity") && _properties.ContainsKey("Enable Auto Enrollment from Waitlist") && _properties.ContainsKey("Waitlist Capacity"))
                            {
                                _defects.Add("Min, Max, Auto, or Waitlist Enrollment is undefined");
                            }
                            foreach (var trackProperty in _properties["Enable Auto Enrollment from Waitlist"])
                            {
                                if (String.IsNullOrEmpty(trackProperty) || (trackProperty != "Y" && trackProperty != "N"))
                                {
                                    _defects.Add("Enable Auto Enrollment from Waitlist not properly defined");
                                }
                            }
                        }
                        break;

                    case "Unlimited Capacity" when s == "Course Offerings":
                        if (_properties.ContainsKey("Min Enrollment Capacity") || _properties.ContainsKey("Max Enrollment Capacity") || _properties.ContainsKey("Enable Auto Enrollment from Waitlist") || _properties.ContainsKey("Waitlist Capacity"))
                        {
                            if (String.IsNullOrEmpty(v) || v != "N")
                            {
                                _defects.Add("Unlimited Capacity not properly defined");
                            }
                        }
                        else
                        {
                            if (String.IsNullOrEmpty(v) || v != "Y")
                            {
                                _defects.Add("Unlimited Capacity not properly defined");
                            }
                        }
                        break;

                    case "Location" when s == "Course Offerings":
                        if (tblSet["Blended Courses"].ContainsKey(obj.Key))
                        {
                            var _luProperties = tblSet["Blended Courses"][obj.Key]["properties"] as Dictionary <string, List <string> >;
                            if (_luProperties.TryGetValue("Allowed Location+", out List <string> _location))
                            {
                                _checker = _location.Contains(v);
                            }
                        }
                        if (!_checker)
                        {
                            _defects.Add("Location for Blended Course not found in value list");
                        }
                        break;

                    case "Title*" when s == "Course Offerings":
                        if ((!_properties.ContainsKey("Start Date*") || _properties["Start Date*"].Count == 0) || (!_properties.ContainsKey("End Date*") || _properties["End Date*"].Count == 0))
                        {
                            _defects.Add("Start or end date undefined for classroom lesson");
                        }
                        if (_properties.ContainsKey("Start Date*") || _properties.ContainsKey("End Date*"))
                        {
                            if (_properties["Start Date*"].Count > 0)
                            {
                                _list.AddRange(_properties["Start Date*"]);
                            }
                            if (_properties["End Date*"].Count > 0)
                            {
                                _list.AddRange(_properties["End Date*"]);
                            }
                            foreach (var dDate in _list)
                            {
                                string[] formats =
                                {
                                    "MM/dd/yyyy hh:mm",       "MM/dd/yyyy h:mm",       "MM/d/yyyy hh:mm",       "MM/d/yyyy h:mm",
                                    "M/dd/yyyy hh:mm",        "M/dd/yyyy h:mm",        "M/d/yyyy hh:mm",        "M/d/yyyy h:mm",
                                    "MM/dd/yyyy hh:mm tt",    "MM/dd/yyyy h:mm tt",    "MM/d/yyyy hh:mm tt",    "MM/d/yyyy h:mm tt",
                                    "M/dd/yyyy hh:mm tt",     "M/dd/yyyy h:mm tt",     "M/d/yyyy hh:mm tt",     "M/d/yyyy h:mm tt",

                                    "MM/dd/yyyy hh:mm:ss",    "MM/dd/yyyy h:mm:ss",    "MM/d/yyyy hh:mm:ss",    "MM/d/yyyy h:mm:ss",
                                    "M/dd/yyyy hh:mm:ss",     "M/dd/yyyy h:mm:ss",     "M/d/yyyy hh:mm:ss",     "M/d/yyyy h:mm:ss",
                                    "MM/dd/yyyy hh:mm:ss tt", "MM/dd/yyyy h:mm:ss tt", "MM/d/yyyy hh:mm:ss tt", "MM/d/yyyy h:mm:ss tt",
                                    "M/dd/yyyy hh:mm:ss tt",  "M/dd/yyyy h:mm:ss tt",  "M/d/yyyy hh:mm:ss tt",  "M/d/yyyy h:mm:ss tt",
                                };
                                DateTime dateValue;
                                if (!DateTime.TryParseExact(dDate, formats, new CultureInfo("en-US"), DateTimeStyles.None, out dateValue))
                                {
                                    _defects.Add("Incorrect start or end date format");
                                }
                                _list = new List <string>();
                            }
                        }
                        if (_properties.ContainsKey("Instructor Led Unit Track Grades"))
                        {
                            if (_properties["Instructor Led Unit Track Grades"].First().ToString() == "Y")
                            {
                                if (_properties.ContainsKey("Learning Grading Scheme for Activity Offering"))
                                {
                                    _checker = _properties["Learning Grading Scheme for Activity Offering"].Contains("126ed79d86c01000101743d2b76e00c6");
                                }
                                else
                                {
                                    _checker = false;
                                }
                                if (!_checker)
                                {
                                    _defects.Add("Instructor Led Unit Track Learning Grading Scheme not properly defined");
                                }
                            }
                            else if (_properties.ContainsKey("Instructor Led Unit Track Grades"))
                            {
                                foreach (var trackProperty in _properties["Instructor Led Unit Track Grades"])
                                {
                                    if (String.IsNullOrEmpty(trackProperty) || (trackProperty != "Y" && trackProperty != "N"))
                                    {
                                        _defects.Add("Instructor Led Unit Track Grades not properly defined");
                                    }
                                }
                            }
                        }
                        if (_properties.ContainsKey("Instructor Led Unit Track Attendance"))
                        {
                            foreach (var trackProperty in _properties["Instructor Led Unit Track Attendance"])
                            {
                                if (obj.Key == "Student Living | Turn")
                                {
                                    Console.WriteLine("test");
                                }
                                if (String.IsNullOrEmpty(trackProperty) || (trackProperty != "Y" && trackProperty != "N"))
                                {
                                    _defects.Add("Instructor Led Unit Track Attendance not properly defined");
                                }
                            }
                        }
                        break;

                    case "Title*_1" when s == "Course Offerings":
                        if (!_properties.ContainsKey("Timezone*") || _properties["Timezone*"].Count == 0)
                        {
                            _defects.Add("Webinar timezone undefined");
                        }
                        if (!_properties.ContainsKey("Webinar URL*") || _properties["Webinar URL*"].Count == 0)
                        {
                            _defects.Add("Webinar URL undefined");
                        }
                        if ((_properties.ContainsKey("Webinar URL*") || _properties.ContainsKey("Instructors*+*_1") || _properties.ContainsKey("Title*_1")) && _properties.ContainsKey("Webinar Login Details"))
                        {
                            _defects.Add("Webinar Login details defined");
                        }
                        if (_properties.ContainsKey("Webinar URL*") && _properties.ContainsKey("Instructors*+*_1") && _properties.ContainsKey("Title*_1"))
                        {
                            if (_properties.ContainsKey("Start Date*_1") || _properties.ContainsKey("End Date*_1"))
                            {
                                if (_properties["Start Date*_1"].Count > 0)
                                {
                                    _list.AddRange(_properties["Start Date*_1"]);
                                }
                                if (_properties["End Date*_1"].Count > 0)
                                {
                                    _list.AddRange(_properties["End Date*_1"]);
                                }
                                foreach (var dDate in _list)
                                {
                                    string[] formats =
                                    {
                                        "MM/dd/yyyy hh:mm",       "MM/dd/yyyy h:mm",       "MM/d/yyyy hh:mm",       "MM/d/yyyy h:mm",
                                        "M/dd/yyyy hh:mm",        "M/dd/yyyy h:mm",        "M/d/yyyy hh:mm",        "M/d/yyyy h:mm",
                                        "MM/dd/yyyy hh:mm tt",    "MM/dd/yyyy h:mm tt",    "MM/d/yyyy hh:mm tt",    "MM/d/yyyy h:mm tt",
                                        "M/dd/yyyy hh:mm tt",     "M/dd/yyyy h:mm tt",     "M/d/yyyy hh:mm tt",     "M/d/yyyy h:mm tt",

                                        "MM/dd/yyyy hh:mm:ss",    "MM/dd/yyyy h:mm:ss",    "MM/d/yyyy hh:mm:ss",    "MM/d/yyyy h:mm:ss",
                                        "M/dd/yyyy hh:mm:ss",     "M/dd/yyyy h:mm:ss",     "M/d/yyyy hh:mm:ss",     "M/d/yyyy h:mm:ss",
                                        "MM/dd/yyyy hh:mm:ss tt", "MM/dd/yyyy h:mm:ss tt", "MM/d/yyyy hh:mm:ss tt", "MM/d/yyyy h:mm:ss tt",
                                        "M/dd/yyyy hh:mm:ss tt",  "M/dd/yyyy h:mm:ss tt",  "M/d/yyyy hh:mm:ss tt",  "M/d/yyyy h:mm:ss tt",
                                    };
                                    DateTime dateValue;
                                    if (!DateTime.TryParseExact(dDate, formats, new CultureInfo("en-US"), DateTimeStyles.None, out dateValue))
                                    {
                                        _defects.Add("Incorrect Webinar start or end date format");
                                    }
                                    _list = new List <string>();
                                }
                            }
                        }
                        if (_properties.ContainsKey("Instructors*+*_1"))
                        {
                            foreach (var instructor in _properties["Instructors*+*_1"])
                            {
                                _checker = tblSet["instructors"].ContainsKey(instructor);
                                if (!_checker)
                                {
                                    _defects.Add("Webinar Instructor not found in lookup table");
                                }
                            }
                        }
                        else
                        {
                            _defects.Add("Webinar Instructor not found in lookup table");
                        }
                        if (_properties.ContainsKey("Webinar Lesson Unit Track Grades"))
                        {
                            if (_properties["Webinar Lesson Unit Track Grades"].First().ToString() == "Y")
                            {
                                if (_properties.ContainsKey("Learning Grading Scheme for Activity Offering_1"))
                                {
                                    _checker = _properties["Learning Grading Scheme for Activity Offering_1"].Contains("126ed79d86c01000101743d2b76e00c6");
                                }
                                else
                                {
                                    _checker = false;
                                }
                                if (!_checker)
                                {
                                    _defects.Add("Webinar Learning Grading Scheme not properly defined");
                                }
                            }
                            else if (_properties.ContainsKey("Webinar Lesson Unit Track Grades"))
                            {
                                foreach (var trackProperty in _properties["Webinar Lesson Unit Track Grades"])
                                {
                                    if (String.IsNullOrEmpty(trackProperty) || (trackProperty != "Y" && trackProperty != "N"))
                                    {
                                        _defects.Add("Webinar Lesson Unit Track Grades not properly defined");
                                    }
                                }
                            }
                        }
                        if (_properties.ContainsKey("Webinar Lesson Unit Track Attendance"))
                        {
                            foreach (var trackProperty in _properties["Webinar Lesson Unit Track Attendance"])
                            {
                                if (String.IsNullOrEmpty(trackProperty) || (trackProperty != "Y" && trackProperty != "N"))
                                {
                                    _defects.Add("Webinar Lesson Unit Track Attendance not properly defined");
                                }
                            }
                        }
                        break;

                    case "External Content URL*" when s == "Course Offerings":
                        if (!(_properties.ContainsKey("Learning Course Lesson Title*") && _properties["Learning Course Lesson Title*"].Count > 0))
                        {
                            _checker = false;
                        }
                        if (!_checker)
                        {
                            _defects.Add("Learning course lession title undefined");
                        }
                        break;

                    case "Learning Course Lesson Title*" when s == "Course Offerings":
                        if (!(_properties.ContainsKey("External Content URL*") && _properties["External Content URL*"].Count > 0))
                        {
                            _checker = false;
                        }
                        if (!_checker)
                        {
                            _defects.Add("External Content URL undefined");
                        }
                        break;

                    case "Media*" when s == "Course Offerings":
                        if (_properties.ContainsKey("Row ID*_2"))
                        {
                            if (_properties["Row ID*_2"].Count < 2)
                            {
                                _defects.Add("Media file does not have unique lesson line");
                            }
                        }
                        if (!_properties.ContainsKey("Learning Course Lesson Title*_1"))
                        {
                            _defects.Add("Media file does not have unique lesson line");
                        }
                        break;

                    case "Registerable Status" when s == "Course Offerings":
                        if (!string.Equals(v, "Open", StringComparison.CurrentCultureIgnoreCase) && !string.Equals(v, "Closed", StringComparison.CurrentCultureIgnoreCase))
                        {
                            _defects.Add("Registerable status not properly defined");
                        }
                        break;

                    case "Update Status from Offering Dates" when s == "Course Offerings":
                        if (_properties.ContainsKey("Registerable Status"))
                        {
                            if (v == "Y" && _properties["Registerable Status"].Count > 0)
                            {
                                _defects.Add("Registerable status defined when Update Status from Offering Dates is true");
                            }
                        }
                        break;
                    }
                    return _defects;
                }
                using (DataTable dt = new DataTable())
                {
                    foreach (var col in new string[] { "sheet", "course", "defect", "property", "value" })
                    {
                        dt.Columns.Add(col);
                    }
                    Data.Table config = (new Config()).Learning();
                    foreach (var sheet in tblSet)
                    {
                        if ((dynamic)config[sheet.Key]["analyze"])
                        {
                            foreach (var obj in sheet.Value)
                            {
                                var properties = obj.Value["properties"] as Dictionary <string, List <string> >;
                                foreach (var property in properties)
                                {
                                    foreach (var p in property.Value)
                                    {
                                        List <string> _defects = CheckPropertyValue(property.Key, p.ToString(), sheet.Key, obj, properties);
                                        if (_defects.Count > 0)
                                        {
                                            foreach (var _defect in _defects)
                                            {
                                                DataRow dr = dt.NewRow();
                                                dr["sheet"] = sheet.Key;
                                                dr["course"] = obj.Key;
                                                dr["defect"] = _defect;
                                                dr["property"] = property.Key;
                                                dr["value"] = p.ToString();
                                                dt.Rows.Add(dr);
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                    return dt;
                }
            }));
        }