Пример #1
0
        private void RefreshAllInfo()
        {
            studentsListManager = new StudentsListManager(dbPath);
            studentInfos        = studentsListManager.getAllStudentsInfo();
            List <string> stulentsNames = studentsListManager.getStudentsNames();

            comboBoxStudentsNames.Items.Clear();
            comboBoxStudentsNames.Text = "";
            comboBoxStudentsNames.Items.AddRange(stulentsNames.ToArray());
            //-------------------------------------------------------------
            stubjectListManager = new SubjectsListManager(dbPath);
            subjectInfos        = stubjectListManager.getAllSubjectInfo();
            List <string> subjectsNames = stubjectListManager.getSubjectsNames();

            comboBoxSubjects.Items.Clear();
            comboBoxSubjects.Text = "";
            comboBoxSubjects.Items.AddRange(subjectsNames.ToArray());
            //-------------------------------------------------------------
            lessonInfos = lessonsListManager.getLessonsList();
            listBox1.Items.Clear();
            foreach (var lesInfo in lessonInfos)
            {
                string dateTime    = lesInfo.DateAndTime.ToString();
                string studentName = lesInfo.studentInfo.name;
                string subjectName = lesInfo.subjectInfo.name;
                listBox1.Items.Add(dateTime + " " + studentName + " " + subjectName + " " + lesInfo.done);
            }
            //-------------------------------------------------------------
            dateTimePicker.Value                = DateTime.Now;
            numericUpDownDuration.Value         = 4;
            comboBoxStudentsNames.SelectedIndex = -1;
            comboBoxSubjects.SelectedIndex      = -1;
            textBoxTopic.Text        = "";
            checkBoxPaid.Checked     = false;
            checkBoxDone.Checked     = false;
            numericUpDownPrice.Value = 80;
            textBoxRemark.Text       = "";
        }
Пример #2
0
 public StudentsForm(string dbPath)
 {
     studentsList = new StudentsListManager(dbPath);
     InitializeComponent();
 }
        public List <LessonInfo> getLessonsList(DateTime from           = new DateTime(),
                                                DateTime to             = new DateTime(),
                                                StudentInfo studentInfo = new StudentInfo(),
                                                SubjectInfo subjectInfo = new SubjectInfo())
        {
            List <LessonInfo> list = new List <LessonInfo>();

            //---------------------------------------------
            DateTime def = new DateTime();

            if (to == def)
            {
                to = new DateTime(9999, to.Month, to.Day);
            }
            //---------------------------------------------

            SQLiteCommand cmd   = connection.CreateCommand();
            string        query = @"SELECT * FROM lessons WHERE @from <= DateAndTime and DateAndTime <= @to";
            //---------------------------------------------
            StudentInfo def_stud = new StudentInfo();

            if (!studentInfo.Equals(def_stud))
            {
                query += $" and student_id = {studentInfo.id}";
            }
            //---------------------------------------------
            SubjectInfo def_subj = new SubjectInfo();

            if (!subjectInfo.Equals(def_subj))
            {
                query += $" and subject_id = {subjectInfo.id}";
            }
            //---------------------------------------------
            query += ";";
            //---------------------------------------------

            cmd.CommandText = query;
            string fromS = from.ToString(@"yyyy/MM/dd HH:mm:ss");
            string toS   = to.ToString(@"yyyy/MM/dd HH:mm:ss");

            cmd.Parameters.AddWithValue("@from", fromS);
            cmd.Parameters.AddWithValue("@to", toS);

            SQLiteDataReader sqlReader = cmd.ExecuteReader();

            while (sqlReader.Read())
            {
                LessonInfo lessonInfo = new LessonInfo();

                lessonInfo.id = Convert.ToInt32(sqlReader["id"].ToString());
                //-------------
                string   formatString = "yyyyMMddHHmmss";
                string   sample       = sqlReader["DateAndTime"].ToString();
                string[] words        = sample.Split(new char[] { ' ', '.', ':' });
                sample = string.Join("", words);
                lessonInfo.DateAndTime = DateTime.ParseExact(sample, formatString, null);
                //-------------
                lessonInfo.duration = Int32.Parse(sqlReader["duration"].ToString());
                //-------------
                int student_id = Int32.Parse(sqlReader["student_id"].ToString());
                StudentsListManager studentsListManager = new StudentsListManager(dbPath);
                lessonInfo.studentInfo = studentsListManager.getStudentInfoById(student_id);
                //-------------
                int subject_id = Int32.Parse(sqlReader["subject_id"].ToString());
                SubjectsListManager subjectsListManager = new SubjectsListManager(dbPath);
                lessonInfo.subjectInfo = subjectsListManager.getSubjectInfoById(subject_id);
                //-------------
                lessonInfo.topic  = sqlReader["topic"].ToString();
                lessonInfo.done   = sqlReader["done"].ToString().Equals("0") ? false : true;
                lessonInfo.price  = Int32.Parse(sqlReader["price"].ToString());
                lessonInfo.paid   = sqlReader["paid"].ToString().Equals("0") ? false : true;
                lessonInfo.remark = sqlReader["remark"].ToString();

                list.Add(lessonInfo);
            }

            return(list);
        }