private void TutorWindow_Load(object sender, EventArgs e)
{
//uzupełniamy combo z przedmiotami:
SqlConnection connect = this.tutorConnection.con;
connect.Open();
string commandSubjects = "SELECT sub.subject_name " +
"FROM dbo.Subjects sub " +
"INNER JOIN dbo.SubjectToTutors stt ON " +
"sub.id = stt.subject_id " +
"INNER JOIN dbo.Tutors ON " +
"dbo.Tutors.id = stt.tutor_id " +
"where dbo.Tutors.username = '******'";
SqlDataAdapter sda1 = new SqlDataAdapter(commandSubjects, connect);
DataTable dt = new DataTable();
sda1.Fill(dt);
foreach (DataRow row in dt.Rows)
{
comboBoxSubjects.Items.Add(row["subject_name"]);
}
connect.Close();
//uzupelnic datagrid jego ocenami + przedmiotami
/*connect.Open();
* string commandMarks = "select m.mark_value[wartosc], " +
* "m.student_id[index number], sub.subject_name[subject's name], " +
* "concat(t.t_name, ' ', t.surname)[tutor], m.id[mark's id] " +
* "from Marks m inner join Subjects sub on sub.id = m.subject_id " +
* "left join SubjectToTutors stt on sub.id = stt.subject_id " +
* "left join Tutors t on t.id = stt.tutor_id " +
* "where t.username = '******'";
* SqlDataAdapter sda2 = new SqlDataAdapter(commandMarks, connect);
* DataTable dt_marks = new DataTable();
* sda2.Fill(dt_marks);
* dataGridView1.DataSource = dt_marks;
* connect.Close();*/
UczelniaEntities db = new UczelniaEntities();
var query = from vm in db.View_Marks
where vm.username == this.UsernameLabel.Text
select new { vm.subject_name,
vm.student_id,
vm.mark_value };
var dataTable = query.ToList();
dataGridView1.DataSource = dataTable;
//(nullowe wartosci tym bardziej wyswietlic left join lub riht)
}
private void searchStudent(object sender, EventArgs e)
{
UczelniaEntities db = new UczelniaEntities();
int buff = Convert.ToInt32(this.textBoxStudentIndex.Text);
var query = from vm in db.View_Marks
where vm.username == this.UsernameLabel.Text &&
vm.student_id == buff
select new
{
vm.subject_name,
vm.student_id,
vm.mark_value
};
var dataTable = query.ToList();
dataGridView1.DataSource = dataTable;
}
private void LoadTableToGrid(object sender, EventArgs e)
{
try
{
button1.Text = "Dodaj";
context = new UczelniaEntities();
if (comboBox1.Text == "tutors")
{
dataGridView1.DataSource = context.Tutors.ToList();
}
else if (comboBox1.Text == "administrators")
{
dataGridView1.DataSource = context.Administrators.ToList();
}
else if (comboBox1.Text == "students")
{
dataGridView1.DataSource = context.Students.ToList();
}
else if (comboBox1.Text == "marks")
{
dataGridView1.DataSource = context.Marks.ToList();
}
else if (comboBox1.Text == "subjects")
{
dataGridView1.DataSource = context.Subjects.ToList();
}
else if (comboBox1.Text == "faculties")
{
dataGridView1.DataSource = context.Faculties.ToList();
}
else if (comboBox1.Text == "studenttosubjects")
{
button1.Text = "Dodaj Stud<->Subject";
dataGridView1.DataSource = context.StudentToSubjects.ToList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
