public bool addconstraint(constraints addthis) { SqlConnection con = new SqlConnection(constring); SqlCommand newcommand = new SqlCommand("INSERT INTO dbo.Constraints (StartTime,EndTime,Day,CourseID,LecturerID,Lecture_type,ClassID,CourseName,LecturerName,Year,Semester) VALUES (@StartTime,@EndTime,@Day,@CourseID,@LecturerID,@Lecture_type,@ClassID,@CourseName,@LecturerName,@Year,@Semester)", con); newcommand.Parameters.Add("@StartTime", addthis.getStart()); newcommand.Parameters.Add("@EndTime", addthis.getEnd()); newcommand.Parameters.Add("@Day", addthis.getday()); newcommand.Parameters.Add("@CourseID", addthis.getcourseid()); newcommand.Parameters.Add("@LecturerID", addthis.getlecturerid()); newcommand.Parameters.Add("@Lecture_type", addthis.gettype()); newcommand.Parameters.Add("@ClassID", addthis.getclassroom()); newcommand.Parameters.Add("@CourseName", addthis.getcoursename()); newcommand.Parameters.Add("@LecturerName", addthis.getlecturer()); newcommand.Parameters.Add("@Year", addthis.getyear()); newcommand.Parameters.Add("@Semester", addthis.getsemester()); con.Open(); if (con.State == System.Data.ConnectionState.Open) { newcommand.ExecuteNonQuery(); con.Close(); return(true); } return(false); }
private bool initialise_new_event(constraints initThis) { initThis.textbox.Multiline = true; initThis.textbox.Dock = DockStyle.Fill; initThis.textbox.ReadOnly = true; initThis.textbox.BackColor = Color.LightBlue; tableLayoutPanel1.Controls.Add(initThis.textbox, initThis.getday() - 64, initThis.getStart() - 7); tableLayoutPanel1.SetRowSpan(initThis.textbox, initThis.getEnd() - initThis.getStart()); return(false); }
private void chosen_event_form_Load(object sender, EventArgs e) { this.constCourse.Text = this.recived.getcoursename(); this.Constclassroom.Text = this.recived.getclassroom(); this.constDay.Text = this.recived.getday().ToString(); this.Conststart.Text = this.recived.getStart().ToString() + ":00"; this.Constend.Text = this.recived.getEnd().ToString() + ":00"; this.constID.Text = this.recived.get_id().ToString(); this.constType.Text = this.recived.gettype(); allconstraints = constraints.getallconstraints(); Teachers = newconnection.get_un_by_course(recived.getcoursename()); permissions = newconnection.get_permissions_by_un(Teachers); int ocupied; if (this.recived.gettype() == "Lecture") { for (int i = 0; i < Teachers.Count; i++) { ocupied = 0; if (Convert.ToInt32(permissions[i]) > 2) { for (int j = 0; j < allconstraints.Count; j++) { if ((allconstraints[j].getlecturer() == Teachers[i]) && recived.getday() == allconstraints[j].getday()) { if ((allconstraints[j].getStart() == recived.getStart() || (recived.getStart() < allconstraints[j].getStart() && recived.getEnd() > allconstraints[j].getStart()) || recived.getStart() < allconstraints[j].getEnd() && recived.getEnd() >= allconstraints[j].getEnd())) { ocupied = 1; break; } } } if (ocupied > 0) { continue; } Teacherscombox.Items.Add(Teachers[i]); } } } else { for (int i = 0; i < Teachers.Count; i++) { ocupied = 0; if (Convert.ToInt32(permissions[i]) >= 2) { for (int j = 0; j < allconstraints.Count; j++) { if ((allconstraints[j].getlecturer() == Teachers[i]) && recived.getday() == allconstraints[j].getday()) { if ((allconstraints[j].getStart() == recived.getStart() || (recived.getStart() < allconstraints[j].getStart() && recived.getEnd() > allconstraints[j].getStart()) || recived.getStart() < allconstraints[j].getEnd() && recived.getEnd() >= allconstraints[j].getEnd())) { ocupied = 1; break; } } } if (ocupied > 0) { continue; } Teacherscombox.Items.Add(Teachers[i]); } } } student_count.Text = recived.get_students_count().ToString(); }