public void getinfoEtud(string numr)
{
dt = cnxdata.GetInfo("select * from etudiant where NUM_INSCRIPTION='" + numr + "'");
label1.Text = dt.Rows[0][1] + " " + dt.Rows[0][2];
label6Email.Text = dt.Rows[0][4].ToString();
label7Numero.Text = dt.Rows[0][3].ToString();
label8Filiere.Text = dt.Rows[0][6].ToString();
try
{
DataTable dtAbsProf = cnxdata.GetInfo("select count(*) from absence where n_prof='" + Cco.cin + "' and n_etudiant='" + numr + "' group by n_prof");
label10absence.Text = dtAbsProf.Rows[0][0].ToString();
}
catch (Exception)
{
label10absence.Text = "0";
}
////////////////////////
try
{
DataTable dtAbsYear = cnxdata.GetInfo("select count(*) from absence where n_prof = '" + Cco.cin + "' and n_etudiant = '" + numr + "' and extract(year from datea)=extract(Year from SYSDATE) group by n_prof");
label18nombretotalabs.Text = dtAbsYear.Rows[0][0].ToString();
}
catch (Exception)
{
label18nombretotalabs.Text = "0";
}
MemoryStream ms = new MemoryStream((byte[])dt.Rows[0][11]);
pb_Photo.Image = Image.FromStream(ms);
dt.Rows.Clear();
}
private void add_Load(object sender, EventArgs e)
{
ClassConnexion cnx = new ClassConnexion();
label1.Text = Form1.p1.label15.Text;
label7.Text = Cco.cin;
bunifuDropdown1.AddItem("8");
bunifuDropdown1.AddItem("9");
bunifuDropdown1.AddItem("10");
bunifuDropdown1.AddItem("11");
bunifuDropdown1.AddItem("12");
bunifuDropdown1.AddItem("13");
bunifuDropdown1.AddItem("14");
bunifuDropdown1.AddItem("15");
bunifuDropdown1.AddItem("16");
bunifuDropdown1.AddItem("17");
bunifuDropdown1.AddItem("18");
bunifuDropdown2.AddItem("8");
bunifuDropdown2.AddItem("9");
bunifuDropdown2.AddItem("10");
bunifuDropdown2.AddItem("11");
bunifuDropdown2.AddItem("12");
bunifuDropdown2.AddItem("13");
bunifuDropdown2.AddItem("14");
bunifuDropdown2.AddItem("15");
bunifuDropdown2.AddItem("16");
bunifuDropdown2.AddItem("17");
bunifuDropdown2.AddItem("18");
bunifuDropdown5.AddItem("cours");
bunifuDropdown5.AddItem("TP");
bunifuDropdown5.AddItem("TD");
bunifuDropdown1._BorderRadius = 50;
/////////////////filiere//////////////
DataTable dtt = cnx.GetInfo("select * from Filiere");
foreach (DataRow dr in dtt.Rows)
{
bunifuDropdown4.AddItem(dr[0].ToString());
}
DataTable dt = cnx.GetInfo("select * from matiere");
foreach (DataRow dr in dt.Rows)
{
bunifuDropdown3.AddItem(dr[1].ToString());
}
bunifuDropdown1.selectedIndex = 0;
bunifuDropdown2.selectedIndex = 0;
bunifuDropdown3.selectedIndex = 0;
bunifuDropdown4.selectedIndex = 0;
bunifuDropdown5.selectedIndex = 0;
}
public void GetDGV()
{
dt = cnxdata.GetInfo("select * from emplois ");
bunifuCustomDataGrid1.DataSource = dt;
((DataGridViewImageColumn)bunifuCustomDataGrid1.Columns[2]).ImageLayout = DataGridViewImageCellLayout.Stretch;
}
private void Etudiant_Load(object sender, EventArgs e)
{
pnl_Panel.Visible = false;
///Remplissage DGV
///
getDGVinfo();
///Remplissage Combobox
///
DataTable dtt = cnxdata.GetInfo("select * from Filiere");
foreach (DataRow dr in dtt.Rows)
{
ComboBox2.Items.Add(dr[0]);
}
}
public void DoThis()
{
dt = datacnx.GetInfo("select * from historique ");
dt.Columns[0].ColumnName = "Numero";
dt.Columns[1].ColumnName = "Carte Identification National";
dt.Columns[3].ColumnName = "Date de Visite";
dv = new DataView(dt);
bunifuCustomDataGrid1.DataSource = dt;
}
public void getinfoDGV()
{
dt = cnxdata.GetInfo("select * from utilisateur");
bunifuCustomDataGrid1.DataSource = dt;
bunifuCustomDataGrid1.Refresh();
}
public void GetinfoDGV()
{
dt = cnxdata.GetInfo("select * from absence");
bunifuCustomDataGrid1.DataSource = dt;
bunifuCustomDataGrid1.Refresh();
}
private void getDGVinfo()
{
dt = cnxdata.GetInfo("select * from professeur");
bunifuCustomDataGrid1.DataSource = dt;
((DataGridViewImageColumn)bunifuCustomDataGrid1.Columns[7]).ImageLayout = DataGridViewImageCellLayout.Stretch;
}