private void fqbutton_Click(object sender, EventArgs e) { mesuesDashboardUC1.Show(); mesuesDashboardUC1.BringToFront(); vleresoNxenesitUC1.Hide(); MungesaUC.Hide(); }
private void MesuesMain_Load(object sender, EventArgs e) { hideSubMenu(); MungesaUC.Hide(); vleresoNxenesitUC1.Hide(); fletTremujori1.Hide(); justifikoMungesatUC1.Hide(); mesuesDashboardUC1.Show(); }
private void DeftesaButton_Click(object sender, EventArgs e) { DeftesaButton.BackColor = Color.FromArgb(135, 190, 235); JustifikomungesatButton.BackColor = Color.FromArgb(135, 206, 235); fletTremujori1.Show(); fletTremujori1.BringToFront(); mesuesDashboardUC1.Hide(); MungesaUC.Hide(); vleresoNxenesitUC1.Hide(); }
private void MesuesMain_Load(object sender, EventArgs e) { var connectionString = "server=remotemysql.com;userid=gBh6InugME;password=NSGsLG2ITM;database=gBh6InugME"; using (var connection = new MySqlConnection(connectionString)) { connection.Open(); var query = "SELECT * FROM Mesues Where LoginID in (SELECT LoginID From Login WHERE User_Name = '" + loginID + "')"; using (var command = new MySqlCommand(query, connection)) { using (var reader = command.ExecuteReader()) { //Iterate through the rows and add it to the combobox's items while (reader.Read()) { label2.Text = reader.GetString("Emri") + " " + reader.GetString("Mbiemri"); mID = reader.GetString("MesuesID"); CookieClass.MesuesID = mID; mesuesDashboardUC1.MesuestextBox.Text = reader.GetString("Emri") + " " + reader.GetString("Mbiemri"); } } } connection.Close(); } //SHAQFJA E NJOFTIMEVE PER MESUESIT MySqlConnection conn = new MySqlConnection(connectionString); conn.Open(); string query2 = "SELECT Emri, DataEvent, Pershkrim FROM Njoftime WHERE Kategori = 'te dyve' OR Kategori = 'mesues' "; MySqlDataAdapter sda = new MySqlDataAdapter(query2, conn); DataTable dt = new DataTable(); sda.Fill(dt); mesuesDashboardUC1.dataGridView1.DataSource = dt; conn.Close(); using (var connection = new MySqlConnection(connectionString)) { connection.Open(); var query = "Select Emri from Klasa where MesuesID = '" + mID + "' "; using (var command = new MySqlCommand(query, connection)) { using (var reader = command.ExecuteReader()) { //Iterate through the rows and add it to the combobox's items while (reader.Read()) { mesuesDashboardUC1.KlasatextBox.Text = reader.GetString("Emri"); justifikoMungesatUC1.textBox4.Text = reader.GetString("Emri"); MungesaUC.label4.Text = reader.GetString("Emri"); fletTremujori1.label6.Text = reader.GetString("Emri"); chatUC1.label5.Text = reader.GetString("Emri"); } } } connection.Close(); } // NR I mungesave te klases kujdestare using (var connection = new MySqlConnection(connectionString)) { connection.Open(); var query = "Select count(*) from Mungesat where KlasaID IN (SELECT KlasaID FROM Klasa WHERE EMRI = '" + mesuesDashboardUC1.KlasatextBox.Text + "') "; using (var command = new MySqlCommand(query, connection)) { object count = command.ExecuteScalar(); if (count != null) { mesuesDashboardUC1.Mungesa_textBox.Text = count.ToString(); } else { mesuesDashboardUC1.Mungesa_textBox.Text = "0"; } } connection.Close(); } // NR I NXENSEVE QE KA NE KLASEN KUJDESTARE TE MESUESES/IT using (var connection = new MySqlConnection(connectionString)) { connection.Open(); var query = "Select count(*) from Nxenes where Gjinia = 'femer' and KlasaID in (select KlasaID from Klasa where Emri = '" + mesuesDashboardUC1.KlasatextBox.Text + "') "; using (var command = new MySqlCommand(query, connection)) { object count = command.ExecuteScalar(); if (count != null) { mesuesDashboardUC1.NxenesetextBox.Text = count.ToString(); } else { mesuesDashboardUC1.NxenesetextBox.Text = " --- "; } } connection.Close(); } // NR I NXENESVE QE KA NE KLASEN KUJDESTARE TE MESUESES/IT using (var connection = new MySqlConnection(connectionString)) { connection.Open(); var query = "Select count(*) from Nxenes where Gjinia = 'mashkull' and KlasaID in (select KlasaID from Klasa where Emri = '" + mesuesDashboardUC1.KlasatextBox.Text + "') "; using (var command = new MySqlCommand(query, connection)) { object count = command.ExecuteScalar(); if (count != null) { mesuesDashboardUC1.NxenestextBox.Text = count.ToString(); } else { mesuesDashboardUC1.NxenestextBox.Text = " --- "; } } connection.Close(); } // LLOGARITJA E NOTES MESATARE TE KLASES using (var connection = new MySqlConnection(connectionString)) { connection.Open(); var query = "Select avg(NotaShkrim) from NotaTremujor where KlasaID IN(SELECT KlasaID FROM Klasa WHERE EMRI = '" + mesuesDashboardUC1.KlasatextBox.Text + "') "; using (var command = new MySqlCommand(query, connection)) { object count = command.ExecuteScalar(); if (count != null) { mesuesDashboardUC1.KalueshmeriaMtextBox.Text = count.ToString(); } else { mesuesDashboardUC1.KalueshmeriaMtextBox.Text = " --- "; } } connection.Close(); } CookieClass.MesuesID = mID; hideSubMenu(); MungesaUC.Hide(); vleresoNxenesitUC1.Hide(); fletTremujori1.Hide(); justifikoMungesatUC1.Hide(); mesuesDashboardUC1.Show(); notaTremujoriUC1.Hide(); chatUC1.Hide(); }