public List <StudentWithDept> GetAllStudents()
{
command = new SqlCommand();
command.CommandText = "SELECT * FROM StudentWithDept";
command.Connection = connection;
connection.Open();
reader = command.ExecuteReader();
List <StudentWithDept> students = new List <StudentWithDept>();
while (reader.Read())
{
StudentWithDept studentWithDept = new StudentWithDept();
studentWithDept.SId = Convert.ToInt32(reader["s_id"]);
studentWithDept.SName = reader["s_name"].ToString();
studentWithDept.SRollNo = reader["s_roll"].ToString();
studentWithDept.SAge = Convert.ToInt32(reader["s_age"]);
studentWithDept.SPhoneNo = reader["s_phone_no"].ToString();
studentWithDept.SEmail = reader["s_email"].ToString();
studentWithDept.DId = (int)reader["d_id"];
studentWithDept.DCode = reader["d_code"].ToString();
studentWithDept.DName = reader["d_name"].ToString();
students.Add(studentWithDept);
}
reader.Close();
connection.Close();
return(students);
}
public List <StudentWithDept> GetStudentsByName(string name)
{
query = "SELECT * FROM StudentWithDept WHERE s_name LIKE '%" + name + "%'";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
List <StudentWithDept> students = new List <StudentWithDept>();
while (reader.Read())
{
StudentWithDept studentWithDept = new StudentWithDept();
studentWithDept.SId = Convert.ToInt32(reader["s_id"]);
studentWithDept.SName = reader["s_name"].ToString();
studentWithDept.SRollNo = reader["s_roll"].ToString();
studentWithDept.SAge = Convert.ToInt32(reader["s_age"]);
studentWithDept.SPhoneNo = reader["s_phone_no"].ToString();
studentWithDept.SEmail = reader["s_email"].ToString();
studentWithDept.DId = (int)reader["d_id"];
studentWithDept.DCode = reader["d_code"].ToString();
studentWithDept.DName = reader["d_name"].ToString();
students.Add(studentWithDept);
}
reader.Close();
connection.Close();
return(students);
}
private void studentListView_DoubleClick(object sender, EventArgs e)
{
StudentWithDept student = (StudentWithDept)studentListView.SelectedItems[0].Tag; //As doubleclick so one item will be there
if (student != null)
{
nameTextBox.Text = student.SName;
rollNoTextBox.Text = student.SRollNo;
departmentComboBox.SelectedValue = student.DId;
ageTextBox.Text = student.SAge.ToString();
phoneNoTextBox.Text = student.SPhoneNo;
emailTextBox.Text = student.SEmail;
hiddenIdLabel.Text = student.SId.ToString();
saveButton.Text = "Update";
deleteButton.Enabled = true;
}
}
private void TakesCourseUI_Load(object sender, EventArgs e)
{
List <StudentWithDept> students = studentManager.GetAllStudents();
StudentWithDept defaultStudentWithDept = new StudentWithDept();
defaultStudentWithDept.SId = -1;
defaultStudentWithDept.SName = "--select--";
students.Insert(0, defaultStudentWithDept);
rollComboBox.DataSource = students;
rollComboBox.DisplayMember = "SName";
rollComboBox.ValueMember = "SId";
List <Course> courses = courseManager.GetAllCourses();
Course defaultCourse = new Course();
defaultCourse.Id = "-1";
defaultCourse.Name = "--select--";
courses.Insert(0, defaultCourse);
courseComboBox.DataSource = courses;
courseComboBox.DisplayMember = "Name";
courseComboBox.ValueMember = "Id";
PopulateTakesCourseListView(takesManager.GetFromTakes());
}
