public void main() { try { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); // Set filter for file extension and default file extension dlg.DefaultExt = ".txt"; dlg.Filter = "TXT Files (*.txt)|*.txt"; // Display OpenFileDialog by calling ShowDialog method Nullable <bool> result = dlg.ShowDialog(); // Get the selected file name and display in a TextBox if (result == true) { //clean timetable_temp DBConnection.Delete("timetable_temp"); // Open document string filename = dlg.FileName; List <string> myValues = new List <string>(); string line; // Read the file and display it line by line. StreamReader file = new StreamReader(filename); while ((line = file.ReadLine()) != null) { myValues.Add(line); } foreach (string item in myValues) { string row = string.Join(" ", item.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries)); string[] items = row.Split(' '); if ((items.Count() != 4) || !items[0].StartsWith("c") || !items[1].StartsWith("r")) { throw new Exception("Selected file is not on the correct format!"); } string values = "'" + items[0] + "', '" + items[1] + "', '" + items[2] + "', '" + items[3] + "'"; int res = DBConnection.Create("timetable_temp", "course_code, room_code, day, start_period", values); } TimetablingResultDisplay display = new TimetablingResultDisplay(); display.Show(); } } catch (Exception e) { MessageBox.Show(e.Message); } }
private string getCurrentPeriod(UControl position, int courseId) { string returnText = ""; Dictionary <string, string> first = new Dictionary <string, string>(); string name; ArrayList rec = DBConnection.Get("subPeriods", int.Parse(position.Row)); first = (Dictionary <string, string>)rec[0]; first.TryGetValue("name", out name); returnText = name + " to " + TimetablingResultDisplay.getEndingPeriod(name, courseId); return(returnText); }
private void validateTimetableOpen(LoadingPanel.LoadingPanel bar) { string Columns = " c.id AS course_id"; string From = "courses c" + " LEFT JOIN course_teacher_rel ctr ON c.id=ctr.course_id "; string Conditions = " c.parent_id IS NOT NULL AND ctr.teacher_id IS NULL "; DataTable unasignedCoursesT = DBConnection.Select(From, Columns, Conditions); if (unasignedCoursesT.Rows.Count != 0) { MessageBox.Show("Every course should have a teacher assigned! In order to open Timetable window, you have to assign teachers to these courses first!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); CourseTeacherRelation relationGrid = new CourseTeacherRelation(); relationGrid.Owner = this; relationGrid.checkBox.IsChecked = true; bar.Close(); relationGrid.ShowDialog(); } else { string ColumnsD = " c.id AS course_id"; string FromD = "courses c" + " LEFT JOIN course_department_rel cdr ON c.id=cdr.course_id "; string ConditionsD = " c.parent_id IS NOT NULL AND cdr.department_id IS NULL "; DataTable unasignedCoursesD = DBConnection.Select(FromD, ColumnsD, ConditionsD); if (unasignedCoursesD.Rows.Count != 0) { MessageBox.Show("Every course should have at least a study program assigned! In order to open Timetable window, you have to assign study programs to these courses first!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); CourseDepartmentRel relationGrid = new CourseDepartmentRel(); relationGrid.Owner = this; relationGrid.checkBox.IsChecked = true; bar.Close(); relationGrid.ShowDialog(); } else { TimetablingResultDisplay timetabling = new TimetablingResultDisplay(); timetabling.Owner = this; bar.Close(); timetabling.ShowDialog(); } } }