private void supprimer_typeconge_btn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Gestion_Demande_Class gdd = new Gestion_Demande_Class();
String nomserv; int xx1;
gestion_Service gs = new gestion_Service();
type_conge tc = new type_conge();
gestion_type_conge gtc = new gestion_type_conge();
int indexDgpersonel = gridView1.FocusedRowHandle;
Demande_Conge_Class dem = new Demande_Conge_Class();
gdd.chercher_Demande_conge_emp(gridView1.GetRowCellValue(indexDgpersonel, "ID_DEMANDE_CONGE").ToString(), out erreur, out dem, out exist);
GestionPersonel gp = new GestionPersonel();
Personel_class perr = new Personel_class();
gp.chercher_Personel(gridView1.GetRowCellValue(indexDgpersonel, "MATRICULE") + "", out erreur, out perr, out exist);
String s1 = perr.Matricule + "";
var charArray = s1.ToCharArray(); //{'1','2','3','4','5'}
gs.chercher_Service3(perr.Services, out erreur, out nomserv, out xx1, out exist);
gtc.chercher_Type_conge_Valider(dem.ID_Conger, out erreur, out tc, out exist);
Impression2 imp2 = new Impression2(Convert.ToString(charArray[0]), Convert.ToString(charArray[1]), Convert.ToString(charArray[2]), Convert.ToString(charArray[3]), Convert.ToString(charArray[4]), Convert.ToString(charArray[5]), Convert.ToDateTime(dem.Date_Debut), Convert.ToDateTime(dem.Date_fin), dem.Heur_Debut, dem.Heur_Fin, perr.Nom + "", perr.Prenom, nomserv, Convert.ToString(dem.NombreJour), tc.Desgination, Convert.ToDateTime(dem.Date_Demande));
imp2.imprimer_fiche_deemande();
imp2.ShowDialog();
}
private void Dgpersonel_Click_1(object sender, EventArgs e)
{
if (Gestion_Paie_Oracle.Menu.pr.button_Employer_Depart_Responsable_WasClicked == true)
{
int index = gridView1.FocusedRowHandle;
Gestion_Paie_Oracle.Menu.pr.cin_dep.Text = gridView1.GetRowCellValue(index, "CIN").ToString();
Gestion_Paie_Oracle.Menu.pr.nom_dep.Text = gridView1.GetRowCellValue(index, "NOM").ToString();
Gestion_Paie_Oracle.Menu.pr.prenom_dep.Text = gridView1.GetRowCellValue(index, "PRENOM").ToString();
Gestion_Paie_Oracle.Menu.pr.mat_dep.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
Gestion_Paie_Oracle.Menu.pr.button_Employer_Depart_Responsable_WasClicked = false;
this.Close();
}
else if (Gestion_Paie_Oracle.Menu.pr.button_Employer_Service_Responsable_WasClicked)
{
int index = gridView1.FocusedRowHandle;
Gestion_Paie_Oracle.Menu.pr.cin_emp_sv.Text = gridView1.GetRowCellValue(index, "CIN").ToString();
Gestion_Paie_Oracle.Menu.pr.nom_emp_sv.Text = gridView1.GetRowCellValue(index, "NOM").ToString();
Gestion_Paie_Oracle.Menu.pr.prenom_emp_sv.Text = gridView1.GetRowCellValue(index, "PRENOM").ToString();
Gestion_Paie_Oracle.Menu.pr.mat_emp_sv.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
Gestion_Paie_Oracle.Menu.pr.button_Employer_Service_Responsable_WasClicked = false;
this.Close();
}
else if (Gestion_Paie_Oracle.Menu.pr.button_Employer_WasClicked == true)
{
int index = gridView1.FocusedRowHandle;
Gestion_Paie_Oracle.Menu.pr.cin_salaries_demande1.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
Gestion_Paie_Oracle.Menu.pr.nom_emp_demande.Text = gridView1.GetRowCellValue(index, "NOM").ToString();
Gestion_Paie_Oracle.Menu.pr.prenom_emp_demand.Text = gridView1.GetRowCellValue(index, "PRENOM").ToString();
Gestion_Historique_Cong ghc = new Gestion_Historique_Cong();
HISTORIQUE_CONGE hc;
String erreur = null;
Boolean exit = false;
ghc.chercher_Historique_conge_emp(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), Convert.ToString(DateTime.Now.Year), out erreur, out hc, out exit);
Gestion_Paie_Oracle.Menu.pr.arrierconge.Text = hc.Arrier_conge + "";
Gestion_Paie_Oracle.Menu.pr.droitannecourat.Text = hc.Droit_annner_courant + "";
Gestion_Paie_Oracle.Menu.pr.prisanne.Text = hc.Pris_anner_courant + "";
Gestion_Paie_Oracle.Menu.pr.sommehisto.Text = ((Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.arrierconge.Text) + Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.droitannecourat.Text)) - Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.prisanne.Text)).ToString();
// MessageBox.Show(hc.Arrier_conge + " " + hc.Anner_conge + " " + hc.Droit_annner_courant + " " + hc.Depasemment);
// Gestion_Paie_Oracle.Menu.pr.cin_employer = gridView1.GetRowCellValue(index, "CIN").ToString();
Gestion_Paie_Oracle.Menu.pr.matriculevisible.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
/* Gestion_Historique_Cong ghisto = new Gestion_Historique_Cong();
* HISTORIQUE_CONGE historique;
* ghisto.chercher_Historique_conge_emp("where CIN=" + gridView1.GetRowCellValue(index, "CIN"), out erreur, out historique, out exit);
*
* Gestion_Paie_Oracle.Menu.pr.arrierconge.Text = historique.Arrier_conge + "";
* Gestion_Paie_Oracle.Menu.pr.droitannecourat.Text = historique.Droit_annner_courant + "";
* Gestion_Paie_Oracle.Menu.pr.prisanne.Text = historique.Pris_anner_courant + "";
*/
Gestion_Paie_Oracle.Menu.pr.button_Employer_WasClicked = false;
this.Close();
}
else if (Gestion_Paie_Oracle.Menu.pr.button_Employer_WasClicked == false)
{
int index = gridView1.FocusedRowHandle;
gridView1.FocusedRowHandle = index;
gridView1.SelectRow(index);
Gestion_Paie_Oracle.Menu.pr.remplirDG3(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), Gestion_Paie_Oracle.Menu.pr.historique_dg);
for (int i = 0; i < Gestion_Paie_Oracle.Menu.pr.historique_dg.Rows.Count - 1; i++)
{
var cell = Gestion_Paie_Oracle.Menu.pr.historique_dg[0, i] = new DataGridViewTextBoxCell();
cell.ReadOnly = true;
}
Gestion_Paie_Oracle.Menu.pr.historique_dg.BackgroundColor = Gestion_Paie_Oracle.Menu.pr.historique_dg.DefaultCellStyle.BackColor;
// Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[0].HeaderText = "Ajouter";
Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[1].HeaderText = "Année Congé";
Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[0].Width = 20;
Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[2].HeaderText = "Droit courante d'année Congé";
Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[3].HeaderText = "Report Caclulé";
Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[4].HeaderText = "Report Valider";
Gestion_Paie_Oracle.Menu.pr.historique_dg.ClearSelection();
#region lorsque click sur une ligne du gridcontrol
if (gridView1.GetSelectedRows().Count() > 0)
{
#region remplir datagirdview list de congé accpeter dans fiche personel
Gestion_Paie_Oracle.Menu.pr.remplirDG2(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), Gestion_Paie_Oracle.Menu.pr.DgAlldemand);
decimal summ = 0;
for (int i = 0; i < Gestion_Paie_Oracle.Menu.pr.gridView5.RowCount; i++)
{
summ += Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.gridView5.GetRowCellValue(i, "NOMBREJOUR").ToString());
Gestion_Paie_Oracle.Menu.pr.sommenbjour.Text = summ + "";
}
Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[0].Caption = "Date Demande Congé";
Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[1].Caption = "Date Debut Congé";
Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[2].Caption = "Date Fin Congé";
Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[3].Caption = "Heur Debut Congé";
Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[4].Caption = "Heur Fin Congé";
Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[5].Caption = "Nombre de jours de congés pris";
#endregion
#region remplir datagridview historique de chaque anneéé
// historique_dg.DataSource = null;
gridView1.ClearSelection();
#endregion
#region le reste du travail quand on click sur une ligne !
Gestion_Paie_Oracle.Menu.pr.cin.Text = gridView1.GetRowCellValue(index, "CIN").ToString();
Gestion_Paie_Oracle.Menu.pr.matriculee.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
Gestion_Paie_Oracle.Menu.pr.nom.Text = gridView1.GetRowCellValue(index, "NOM").ToString();
Gestion_Paie_Oracle.Menu.pr.prenom.Text = gridView1.GetRowCellValue(index, "PRENOM").ToString();
Gestion_Paie_Oracle.Menu.pr.datenais.Text = gridView1.GetRowCellValue(index, "DATENAISSENCE").ToString();
Gestion_Paie_Oracle.Menu.pr.emaill.Text = gridView1.GetRowCellValue(index, "EMAIL").ToString();
if (gridView1.GetRowCellValue(index, "SEXE").ToString().Equals("Homme"))
{
Gestion_Paie_Oracle.Menu.pr.homme.Checked = true;
}
else
{
Gestion_Paie_Oracle.Menu.pr.femme.Checked = true;
}
String libellefn = "";
//gestion_fonction.chercher_fn3(Convert.ToInt32(gridView1.GetRowCellValue(index, "FONCTION").ToString()), out erreur, out libellefn, out exist);
//Gestion_Paie_Oracle.Menu.pr.combofonction.Text = libellefn;
gestion_Departement gd = new gestion_Departement();
gestion_Service gs = new gestion_Service();
String nomdep = "";
String nomserv = "";
int xx1;
gs.chercher_Service3(gridView1.GetRowCellValue(index, "SERVICE").ToString(), out erreur, out nomserv, out xx1, out exist);
int ss;
String s1;
gd.chercher_Departement3(gridView1.GetRowCellValue(index, "DEPARTEMENT").ToString(), out erreur, out nomdep, out ss, out s1, out exist);
Gestion_Paie_Oracle.Menu.pr.comb_depar.Text = nomdep;
Gestion_Paie_Oracle.Menu.pr.comb_serv.Text = nomserv;
if (gridView1.GetRowCellValue(index, "ETAT_CIVIL").ToString().Equals("Marié"))
{
Gestion_Paie_Oracle.Menu.pr.marie.Checked = true;
Gestion_Paie_Oracle.Menu.pr.groupboxEtat.Visible = false;
}
else
{
Gestion_Paie_Oracle.Menu.pr.celibataire.Checked = true;
Gestion_Paie_Oracle.Menu.pr.groupboxEtat.Visible = true;
}
Gestion_Paie_Oracle.Menu.pr.adresse.Text = gridView1.GetRowCellValue(index, "ADRESSE").ToString();
Gestion_Paie_Oracle.Menu.pr.daterecreutement.Text = gridView1.GetRowCellValue(index, "DATE_RECRUTEMENT").ToString();
Gestion_Paie_Oracle.Menu.pr.telephone_societe.Text = gridView1.GetRowCellValue(index, "TELEPHONESOCEITE").ToString();
Gestion_Paie_Oracle.Menu.pr.ville.Text = gridView1.GetRowCellValue(index, "VILLE").ToString();
Gestion_Paie_Oracle.Menu.pr.telephone_personel.Text = gridView1.GetRowCellValue(index, "TELEPHONEPRIVE").ToString();
Gestion_Paie_Oracle.Menu.pr.lieuuxx.Text = gridView1.GetRowCellValue(index, "LIEUNAISSENCE").ToString();
Gestion_Paie_Oracle.Menu.pr.login_utilsateur.Text = gridView1.GetRowCellValue(index, "LOGIN").ToString();
Gestion_Paie_Oracle.Menu.pr.Password_utlisateur.Text = gridView1.GetRowCellValue(index, "MOTPASS").ToString();
/* if (Gestion_Paie_Oracle.Menu.pr.celibataire.Checked)
* {
* }
* else if (Gestion_Paie_Oracle.Menu.pr.marie.Checked)
* {
* }*/
}
#endregion
#region remplir congé anner courante
HISTORIQUE_CONGE histo;
string nbjourdroit = "";
string pris = "";
string arrrier = "";
try
{
gestion_xdd.Droit_arrier_pris_conge_anner_precedent(DateTime.Now.Year, gridView1.GetRowCellValue(index, "MATRICULE").ToString(), out erreur, out nbjourdroit, out arrrier, out pris, out exist);
// MessageBox.Show("f" + arrrier + "" + nbjourdroit + "" + pris);
// gestion_historique_emp_conge.chercher_Historique_conge_emp(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), out erreur, out histo, out exist);
Gestion_Paie_Oracle.Menu.pr.arrier_courant_employer.Text = arrrier; //histo.Arrier_conge + "";
Gestion_Paie_Oracle.Menu.pr.droit_anner_employe.Text = nbjourdroit; //histo.Droit_annner_courant + "";
Gestion_Paie_Oracle.Menu.pr.pris_anner_employe.Text = pris; // histo.Pris_anner_courant + "";
Gestion_Paie_Oracle.Menu.pr.somme_hist_employe.Text = ((Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.arrier_courant_employer.Text) + Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.droit_anner_employe.Text)) - Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.pris_anner_employe.Text)).ToString();
}catch (Exception ee)
{
}
#endregion
#endregion
}
Gestion_Paie_Oracle.Menu.pr.BringToFront();
}
private void disponibilité_Load(object sender, EventArgs e)
{
#region remplir table database to gridview
sqlconnection = new OracleConnection(ConnectionString);
String d11 = Convert.ToString(debut);
String d22 = Convert.ToString(fin);
MessageBox.Show("tao ! :" + debut.ToShortDateString());
Query = "select count(*) as S1 from DEMANDE_CONGE where status='Non Encore Traité par GRH' and DATE_DEMANDE between '" + debut.ToShortDateString() + "' and'" + fin.ToShortDateString() + "' ";// and MATRICULE in (select MATRICULE from employe where SERVICE in(select id_service from service where RESPONSABLE_SERVICE ='" + Gestion_Paie_Oracle.Menu.pr.matricule_emp + "' ))";
sqlcommand = new OracleCommand(Query, sqlconnection);
sqladapter = new OracleDataAdapter();
datatable1 = new DataTable();
sqladapter.SelectCommand = sqlcommand;
sqladapter.Fill(datatable1);
dEMANDECONGEBindingSource1.DataSource = datatable1;
#endregion
#region fdf
sqlconnection = new OracleConnection(ConnectionString);
Query = "select count(*) as S2 from DEMANDE_CONGE where status = 'Accepter Par le GRH' or status = 'Accepter Par le GRH,mais avec changement du date a cause du disponibilité des employés' and DATE_DEMANDE between '" + debut.ToShortDateString() + "' and'" + fin.ToShortDateString() + "' ";// and MATRICULE in (select MATRICULE from employe where SERVICE in(select id_service from service where RESPONSABLe_service ='" + Gestion_Paie_Oracle.Menu.pr.matricule_emp + "' ))";
sqlcommand = new OracleCommand(Query, sqlconnection);
sqladapter = new OracleDataAdapter();
datatable2 = new DataTable();
sqladapter.SelectCommand = sqlcommand;
sqladapter.Fill(datatable2);
dEMANDECONGEBindingSource.DataSource = datatable2;
#endregion
String sum = "";
// chart1.ChartAreas[0].AxisY.Interval = 1.5;
String value1 = Convert.ToString(datatable1.Rows[0][0]);
String value2 = Convert.ToString(datatable2.Rows[0][0]);
MessageBox.Show(value1 + " " + value2);
try
{
// gestion_demande.Somme_demandes_conges(Convert.ToDateTime(debut.Date.ToShortDateString()), Convert.ToDateTime(fin.Date.ToShortDateString()), Gestion_Paie_Oracle.Menu.pr.matricule_emp, out erreur, out sum, out exist);
chart1.Series[0].YValueMembers = "S1";
String nom_sv = "";
int Seuill = 0;
gestion_servie.chercher_Service3(Gestion_Paie_Oracle.Menu.pr.sv, out erreur, out nom_sv, out Seuill, out exist);
// chart1.Series[0].IsVisibleInLegend = false;
chart1.Titles[1].Text = "Periode : Du :" + debut.ToShortDateString() + "Au :" + fin.ToShortDateString() + "";
chart1.Titles[2].Text = "Service : " + nom_sv;
chart1.Titles[3].Text = "Nombre d'employés : " + value1 + " " + "Seuile =" + Seuill;
chart1.ChartAreas[0].AxisX.Maximum = 1;
}catch (Exception eee)
{
MessageBox.Show(eee + "");
}
try
{
// gestion_demande.Somme_demandes_conges(Convert.ToDateTime(debut.Date.ToShortDateString()), Convert.ToDateTime(fin.Date.ToShortDateString()), Gestion_Paie_Oracle.Menu.pr.matricule_emp, out erreur, out sum, out exist);
chart2.Series[0].YValueMembers = "S2";
String nom_sv = "";
int Seuill = 0;
gestion_servie.chercher_Service3(Gestion_Paie_Oracle.Menu.pr.sv, out erreur, out nom_sv, out Seuill, out exist);
// chart1.Series[0].IsVisibleInLegend = false;
chart2.Titles[1].Text = "Periode : Du :" + debut.ToShortDateString() + "Au :" + fin.ToShortDateString() + "";
chart2.Titles[2].Text = "Service : " + nom_sv;
chart2.Titles[3].Text = "Nombre d'employés : " + value2 + " " + "Seuile =" + Seuill;
chart2.ChartAreas[0].AxisX.Maximum = 1;
}
catch (Exception eee)
{
MessageBox.Show(eee + "");
}
}