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 MungesatButton_Click(object sender, EventArgs e)
{
MungesatButton.BackColor = Color.FromArgb(135, 190, 235);
VleresonxenesButton.BackColor = Color.FromArgb(135, 206, 235);
MungesaUC.BringToFront();
MungesaUC.Show();
vleresoNxenesitUC1.Hide();
fletTremujori1.Hide();
}
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();
}
