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 !");
}
}
