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); }
public Teacher_movecon_request(object input_constraint) { InitializeComponent(); sending_constraint = input_constraint as constraints; Sender_name_label.Text = "Username: "******"\nID: " + sending_constraint.getlecturerid(); Subject_fixed_text.Text = "ID: " + sending_constraint.get_id() + "\nCourse ID: " + sending_constraint.getcourseid() + "\nCourse Name: " + sending_constraint.getcoursename() + "\nClass: " + sending_constraint.getclassroom(); }
public void Rebuild_for_teacher(String Lecturer) { constID.Enabled = false; constCourse.Enabled = false; constType.Enabled = false; Constclassroom.Enabled = false; constDay.Enabled = false; Conststart.Enabled = false; Constend.Enabled = false; Teacherscombox.Visible = false; delete_const.Visible = false; System.Windows.Forms.TextBox Teachers_un_textbox = new System.Windows.Forms.TextBox(); Teachers_un_textbox.BackColor = System.Drawing.SystemColors.Info; Teachers_un_textbox.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; Teachers_un_textbox.Location = new System.Drawing.Point(178, 150); Teachers_un_textbox.Name = "Teachers_un_textbox"; Teachers_un_textbox.ReadOnly = true; Teachers_un_textbox.Size = new System.Drawing.Size(100, 20); Teachers_un_textbox.TabIndex = 1; Teachers_un_textbox.Visible = true; Teachers_un_textbox.Text = recived.getlecturer(); Teachers_un_textbox.Enabled = false; Controls.Add(Teachers_un_textbox); System.Windows.Forms.Button Classroom_request = new System.Windows.Forms.Button(); Classroom_request.Location = new System.Drawing.Point(15, 12); Classroom_request.Name = "Classroom Request"; Classroom_request.Size = new System.Drawing.Size(150, 23); Classroom_request.TabIndex = 3; Classroom_request.Text = "בקשה לשינוי כיתה"; Classroom_request.UseVisualStyleBackColor = true; Classroom_request.Visible = true; Classroom_request.Click += new System.EventHandler(this.Classroom_request_click); Controls.Add(Classroom_request); System.Windows.Forms.Button Move_Request = new System.Windows.Forms.Button(); Move_Request.Location = new System.Drawing.Point(15, 51); Move_Request.Name = "Move Request"; Move_Request.Size = new System.Drawing.Size(150, 23); Move_Request.TabIndex = 3; Move_Request.Text = "בקשה להזזת האילוץ"; Move_Request.UseVisualStyleBackColor = true; Move_Request.Visible = true; Move_Request.Click += new System.EventHandler(this.Move_Request_click); Controls.Add(Move_Request); }
private String make_the_letter() { String Letter = "\tSubject:\n\n" + make_the_subject() + "\n\n\n\tLetter: " + "\n\nSender: " + sending_constraint.getlecturer() + "\nSender`s ID: " + sending_constraint.getlecturerid() + "\nConstrant`s ID: " + sending_constraint.get_id() + "\nCourse`s name: " + sending_constraint.getcoursename() + "\nCourse`s ID: " + sending_constraint.getcourseid() + "\nYear: " + sending_constraint.getyear() + "\nSemester: " + sending_constraint.getsemester() + "\nClassroom: " + sending_constraint.getclassroom(); if (FreeText.Text == String.Empty) { Letter += "\n\n\n\t***No attached message***"; } else { Letter += "\n\n\n\tAttached message: \n\n" + FreeText.Text; } return(Letter); }