public List<Course> GetAllCourse()
{
List<Course> courseList = new List<Course>();
string query = "SELECT * FROM t_course";
aSqlCommand = new SqlCommand(query, aSqlConnection);
aSqlConnection.Open();
SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader();
while (aSqlDataReader.Read())
{
Course course = new Course();
course.Id = (int)aSqlDataReader["id"];
course.Name = aSqlDataReader["name"].ToString();
course.Code = aSqlDataReader["code"].ToString();
course.Credit =(decimal) aSqlDataReader["credit"];
course.Description = aSqlDataReader["description"].ToString();
course.Dept_id = (int)aSqlDataReader["dept_id"];
course.Semester_id = (int)aSqlDataReader["semester_id"];
courseList.Add(course);
}
aSqlDataReader.Close();
aSqlConnection.Close();
return courseList;
}
public Course FindName(string name)
{
string query = "SELECT * FROM t_course WHERE code='" + name + "'";
aSqlConnection.Open();
aSqlCommand = new SqlCommand(query, aSqlConnection);
SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader();
Course aCourse;
if (aSqlDataReader.HasRows)
{
aCourse = new Course();
aSqlDataReader.Read();
aCourse.Name = aSqlDataReader["name"].ToString();
aSqlDataReader.Close();
aSqlConnection.Close();
return aCourse;
}
else
{
aSqlDataReader.Close();
aSqlConnection.Close();
return null;
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (codeTextBox.Text == "")
{
MessageBox.Show("insert code value");
return;
}
else if (nameTextBox.Text == "")
{
MessageBox.Show("insert name value");
return;
}
else if (creditTextBox.Text=="")
{
MessageBox.Show("insert credit value");
return;
}
string code = codeTextBox.Text;
string name = nameTextBox.Text;
decimal credit = Convert.ToDecimal(creditTextBox.Text);
string description = descriptionRichTextBox.Text;
int deptId = (int)departmentComboBox.SelectedValue;
int semesterId = (int) semesterComboBox.SelectedValue;
Course aCourse = new Course(code, name, credit,description, deptId,semesterId);
string msg = aCourseManager.Save(aCourse);
MessageBox.Show(msg);
}
public CourseAssignToTeacher( int teacherId, int courseId, Department department, Teacher teacher, Course course)
{
Teacher_id = teacherId;
Course_id = courseId;
Department = department;
Teacher = teacher;
Course = course;
}
public string Save(Course aCourse)
{
if (aCourse.Code.Length >= 5)
{
if (aCourse.Credit >= (decimal) .5 && aCourse.Credit <= 5)
{
Course courseForCodeCheck = aCourseGateway.FindCode(aCourse.Code);
Course courseForNameCheck = aCourseGateway.FindName(aCourse.Name);
if (courseForCodeCheck == null)
{
if (courseForNameCheck == null)
{
aCourseGateway.Save(aCourse);
return "Course added.";
}
else
{
return "Course Name already exists.";
}
}
else
{
return "Course CODE already exists.";
}
}
else
{
return "Credit cannot be less than 0.5 and more than 5.0";
}
}
else
{
return "Code length must be 5 characters long.";
}
}
public void Save(Course aCourse)
{
string query = "INSERT INTO t_course VALUES('" + aCourse.Code + "', '" + aCourse.Name + "', '" + aCourse.Credit + "', '" + aCourse.Description + "', '" + aCourse.Dept_id + "', '" + aCourse.Semester_id + "')";
aSqlConnection.Open();
aSqlCommand = new SqlCommand(query, aSqlConnection);
aSqlCommand.ExecuteNonQuery();
aSqlConnection.Close();
}