コード例 #1
0
        private void ScheduleOfCourse_Load(object sender, EventArgs e)
        {
            label2.BackColor = Color.Lime;
            label3.BackColor = Color.Aqua;

            dataGridView1.EnableHeadersVisualStyles = false;
            dataGridView1.DataSource          = this.dtSchedule.dt;
            dataGridView1.ReadOnly            = true;
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            int               numOfHours, row;
            string            classId, lecType, col, CourseName = "";
            List <OConstrain> lstC = Queries.selectLessonsOfCourse(courseID, connectionString);

            foreach (OConstrain c in lstC)
            {
                CourseName = c.getName();
                if (c.getLecture_type().Trim() == "Lecture")
                {
                    numOfHours = c.getHoursLecture();
                }
                else
                {
                    numOfHours = c.getHoursPractice();
                }
                lecType = c.getLecture_type().Trim();
                classId = c.getClassID().Trim();
                for (int i = 0; i < numOfHours; i++)
                {
                    row = dtSchedule.checkRow(c.getStartTime());
                    col = dtSchedule.checkCol(c.getDay());
                    if (i == 0)
                    {
                        dataGridView1.Rows[row].Cells[col].Value = " In: " + classId;
                    }
                    if (c.getLecture_type().Trim() == "Lecture")
                    {
                        dataGridView1.Rows[row + i].Cells[col].Style.BackColor = Color.Lime;
                    }
                    else
                    {
                        dataGridView1.Rows[row + i].Cells[col].Style.BackColor = Color.Aqua;
                    }
                }
                label1.Text = CourseName;
            }
        }
コード例 #2
0
        private void StudentSchedule_Load(object sender, EventArgs e)
        {
            int approve = 0;

            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = connectionString;
                conn.Open();
                SqlCommand command = new SqlCommand("SELECT Approve_Schedule FROM Student WHERE ID LIKE '" + student.ID + "'", conn);
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        approve = reader.GetInt32(0);
                    }
                }
                conn.Close();
            }
            if (approve == 1)
            {
                approveLabel.Text = "Your schedule is approved by student coordinator";
            }
            else
            {
                approveLabel.Text = "Your schedule is not yet approved by student coordinator";
            }
            approveLabel.ForeColor = Color.Red;
            label2.BackColor       = Color.Lime;
            label3.BackColor       = Color.Aqua;

            dataGridView1.EnableHeadersVisualStyles = false;
            dataGridView1.DataSource          = this.dtSchedule.dt;
            dataGridView1.ReadOnly            = true;
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            int               numOfHours, row;
            string            classId, lecType, col, CourseName = "";
            List <OConstrain> lstC = Queries.selectScheduleOfStudent(student.ID, connectionString);

            foreach (OConstrain c in lstC)
            {
                CourseName = c.getName();
                if (c.getLecture_type().Trim() == "Lecture")
                {
                    numOfHours = c.getHoursLecture();
                }
                else
                {
                    numOfHours = c.getHoursPractice();
                }
                lecType = c.getLecture_type().Trim();
                classId = c.getClassID().Trim();
                for (int i = 0; i < numOfHours; i++)
                {
                    row = dtSchedule.checkRow(c.getStartTime());
                    col = dtSchedule.checkCol(c.getDay());
                    if (i == 0)
                    {
                        dataGridView1.Rows[row].Cells[col].Value = CourseName.Trim() + " in: " + classId;
                    }
                    if (c.getLecture_type().Trim() == "Lecture")
                    {
                        dataGridView1.Rows[row + i].Cells[col].Style.BackColor = Color.Lime;
                    }
                    else
                    {
                        dataGridView1.Rows[row + i].Cells[col].Style.BackColor = Color.Aqua;
                    }
                }
            }
        }