public int InserIntoCourseInfoTable(AddCourseClass addCourseObj) { string ID = null; connection.Open(); string queryString = "SELECT Course_No FROM Course_Info_Table WHERE Course_No=('" + addCourseObj.CourseNo + "') AND Dept_ID=('" + Call_DeptID(addCourseObj.DeptName) + "') AND Year=('" + addCourseObj.Year + "') AND Semester=('" + addCourseObj.Semester + "') "; SqlCommand cmd = new SqlCommand(queryString, connection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ID = reader["Course_No"].ToString(); } connection.Close(); if (ID == addCourseObj.CourseNo) { return(0); } else { connection.Open(); string insertString = "INSERT INTO Course_Info_Table VALUES('" + addCourseObj.CourseNo + "', '" + addCourseObj.CourseName + "','" + Call_DeptID(addCourseObj.DeptName) + "','" + addCourseObj.Year + "','" + addCourseObj.Semester + "')"; SqlCommand command = new SqlCommand(insertString, connection); command.ExecuteNonQuery(); connection.Close(); return(1); } }
private void courseAddButton_Click(object sender, EventArgs e) { addCourseObj = new AddCourseClass(); addCourseObj.CourseNo = courseNoTextBox.Text; addCourseObj.CourseName = courseNameTextBox.Text; addCourseObj.DeptName = dNameComboBox.Text; addCourseObj.Year = yearComboBox.Text; addCourseObj.Semester = semesterComboBox.Text; if (courseNoTextBox.Text == "" || courseNameTextBox.Text == "" || dNameComboBox.Text == "" || yearComboBox.Text == "" || semesterComboBox.Text == "") { MessageBox.Show("Please Fill-Up all field!!!"); this.Update(); } else { ob = new Gateway(); if (ob.InserIntoCourseInfoTable(addCourseObj) == 1) { MessageBox.Show("Information Added Successfully!!"); courseResetButton_Click(sender, e); } else { MessageBox.Show("Already Added this course."); } } }
public void UpdateCourseInfoTable(AddCourseClass addCourseOb) { connection.Open(); string insertString = "UPDATE Course_Info_Table SET Course_Name='" + addCourseOb.CourseName + "', Dept_ID='" + Call_DeptID(addCourseOb.DeptName) + "',Year='" + addCourseOb.Year + "',Semester='" + addCourseOb.Semester + "' WHERE Course_No='" + addCourseOb.CourseNo + "'"; SqlCommand command = new SqlCommand(insertString, connection); command.ExecuteNonQuery(); connection.Close(); }
private void courseUpdateButton_Click(object sender, EventArgs e) { addCourseObj = new AddCourseClass(); addCourseObj.CourseNo = courseNoTextBox.Text; addCourseObj.CourseName = courseNameTextBox.Text; addCourseObj.DeptName = dNameComboBox.Text; addCourseObj.Year = yearComboBox.Text; addCourseObj.Semester = semesterComboBox.Text; if (courseNoTextBox.Text != "" || courseNameTextBox.Text != "" || dNameComboBox.Text != "" || yearComboBox.Text != "" || semesterComboBox.Text != "") { ob.UpdateCourseInfoTable(addCourseObj); MessageBox.Show("Information Updated Successfully!"); courseResetButton_Click(sender, e); } else { MessageBox.Show("Could not Update !"); } }