public Form1(string username, login parentForm)
{
InitializeComponent();
connetionString = "Data Source=WHYNOT-KOMPUTER\\SQLEXPRESS;Initial Catalog=PTproject;Integrated Security=True";
sql = "select id, imie, nazwisko, indeks from studenci";
connection = new SqlConnection(connetionString);
List <string> nList = new List <string>();
nList.Add("Moje Przedmioty");
nList.Add("Przedmioty");
// nList.Add("Obecnosci");
// nList.Add("Moj Profil");
listBox1.DataSource = nList;
//Controls.Add(listBox1);
details_btn.Visible = true;
check_btn.Enabled = false;
save_btn.Enabled = false;
back_btn.Enabled = false;
dataGridView1.Visible = true;
dataGridView2.Visible = true;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
label1.Text = "Zalogowany: ";
label2.Text = "Przemyslaw Walkowiak";
//label3.Text = "Przedmiot";
label4.Text = "";
//label5.Text = "Widoki";
label6.Text = "";
label7.Text = "";
}
public Form3(string username, login parentForm)
{
InitializeComponent();
_ParentForm = parentForm;
// label2.Text = _ParentForm.czytajAtr();
dataGridView1.ReadOnly = true;
dataGridView2.ReadOnly = true;
dataGridView1.Enabled = true;
dataGridView2.Enabled = false;
dataGridView1.AllowUserToAddRows = false;
dataGridView2.AllowUserToAddRows = false;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
label1.Text = "SZCEGÓŁY OBECNOŚCI";
label1.Text = _ParentForm.czytajAtr();
String student = null;
sconnetionString = "Data Source=WHYNOT-KOMPUTER\\SQLEXPRESS;Initial Catalog=PTproject;Integrated Security=True";
ssql = "select imie, nazwisko, indeks from studenci"
+ " where indeks=" + username;
ssql2 = "select p.id, p.nazwa as Przedmiot, p.typ as Rodzaj, w.nazwa as Wydzial, k.nazwa as Kierunek,"
+ " kadra.imie+\' \'+kadra.nazwisko as Prowadzacy, count(*) as LiczbaZajec, SUM(CASE WHEN ls.obecny=1 THEN 1 ELSE 0 END) as Obecny from przedmioty as p"
+ " join kierunki as k on k.id = p.kierunek "
+ " join wydzialy as w on w.id = k.wydzial_id "
+ " join kadra on kadra.id = p.prowadzacy_id"
+ " join zapisani_na_przedmiot as zap on p.id = zap.przedmiot_id"
+ " join studenci as s on s.id=zap.student_id "
+ " join lista_obecnosci as ls on s.id=ls.student_id "
+ " where s.indeks =" + username
+ " group by p.id,p.nazwa, p.typ, w.nazwa, k.nazwa, kadra.imie+\' \'+kadra.nazwisko";
//dodaj frekwencje
ssql3 = "";
try
{
sconnection = new SqlConnection(sconnetionString);
sconnection.Open();
scommand = new SqlCommand(ssql, sconnection);
sadapter = new SqlDataAdapter(scommand);
sbuilder = new SqlCommandBuilder(sadapter);
sds = new DataSet();
sadapter.Fill(sds, "student");
stable = sds.Tables["student"];
sconnection.Close();
foreach (DataRow row in stable.Rows)
{
if (row["indeks"].ToString() == username)
{
student = row["imie"].ToString() + " " + row["nazwisko"].ToString();
}
}
nazwa_studenta.Text = student;
}
catch { }
try
{
// sconnection = new SqlConnection(sconnetionString);
sconnection.Open();
scommand = new SqlCommand(ssql2, sconnection);
sadapter = new SqlDataAdapter(scommand);
sbuilder = new SqlCommandBuilder(sadapter);
sds2 = new DataSet();
sadapter.Fill(sds2, "student przedmioty");
stable = sds2.Tables["student przedmioty"];
sconnection.Close();
//dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
//dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.DataSource = sds2.Tables["student przedmioty"];
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
