示例#1
0
        private void FrmAMDocEmploye_Load(object sender, EventArgs e)
        {
            string sql = "select *,concat(nom,' ',prenom) as nomComplete from employe where archive = 1";

            bsEmp = Fonctions.remplirList(cb_emps, sql, "Employe", "nomComplete", "id_employe");

            if (frm == "Modifier")
            {
                cmd = new SqlCommand("select * from document_employe where id_document = " + id, Fonctions.CnConnection());
                dr  = cmd.ExecuteReader();

                dr.Read();
                txt_nom.Text    = dr["nom"].ToString();
                lbl_chemin.Text = dr["fichier"].ToString();

                lbl_titre.Text = "Modifier Document";

                cb_emps.SelectedValue = id;

                pnl_ajouter.Visible  = false;
                pnl_modifier.Visible = true;
            }
            else
            {
                pnl_modifier.Visible = false;
                pnl_ajouter.Visible  = true;
                lbl_titre.Text       = "Ajouter Document";
            }
        }
示例#2
0
        private void btn_chercher_rubrique_Click(object sender, EventArgs e)
        {
            if (cb_type.SelectedIndex == -1)
            {
                MessageBox.Show("select un type s'il vous plaît.", "Type Est Vide", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                dt_grid.Rows.Clear();
                if (cb_type.Text == "Proprietaire")
                {
                    remplirGrilutilProp();
                }
                else
                {
                    string sql = "select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom+' '+e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join employe e on e.id_employe = u.id_table where  t.nom_type = '" + cb_type.Text + "' and u.archive = 1";


                    cmd = new SqlCommand(sql, Fonctions.CnConnection());
                    dr  = cmd.ExecuteReader();
                    dt_grid.Columns[0].Visible = false;
                    while (dr.Read())
                    {
                        dt_grid.Rows.Add(dr[0].ToString(), dr[5].ToString(), dr[1].ToString(), dr[2].ToString(), dr[4].ToString());
                    }
                    dr.Close();
                    dr = null;
                }
            }
        }
        private void btn_Recette_valider_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                Fonctions.ouvrireConnection();

                com = new SqlCommand("Insert into type_utilisateur values ('" + textBox1.Text + "',1)", CN);
                int a = -1;
                a = com.ExecuteNonQuery();
                if (a != -1)
                {
                    DialogResult d = MessageBox.Show("Enregistrer", "enregistrer", MessageBoxButtons.OK);
                    if (DialogResult.OK == d)
                    {
                        this.Close();
                    }
                }
                else
                {
                    MessageBox.Show("Erreur  !!");
                }
            }
            else
            {
                MessageBox.Show("il faut entre le type !!!!!");
            }
        }
示例#4
0
        private void btn_rubrique_Click(object sender, EventArgs e)
        {
            FrmRubrique f = new FrmRubrique();

            f.ShowDialog();
            bsRub = Fonctions.remplirList(cb_Rubrique, "rubrique", "nomrubrique", "id_rubrique");
        }
示例#5
0
        private void FrmAMRepos_Load(object sender, EventArgs e)
        {
            string sql = "select *,concat(prenom,' ',nom) as 'nomComplet' from employe where archive = 1";

            bsEmp = Fonctions.remplirList(cb_emps, sql, "Employe", "nomComplet", "id_employe");

            if (frm == "Modifier")
            {
                activier(false);
                lbl_titre.Text = "Modifier Repos";

                cb_emps.SelectedValue = idemp;

                cmd = new SqlCommand("select * from repos_employe where id_repos = " + idrep, Fonctions.CnConnection());
                dr  = cmd.ExecuteReader();
                dr.Read();

                txt_nb.Text    = dr["nb_jour"].ToString();
                txt_jours.Text = dr["jours"].ToString();

                dr.Close();
                dr = null;
            }
            else
            {
                activier(true);
                lbl_titre.Text = "Ajouter Repos";
            }
        }
        private void frm_cotisation_ajouter_Load(object sender, EventArgs e)
        {
            if (cn.State != ConnectionState.Open)
            {
                cn.ConnectionString = ConfigurationManager.ConnectionStrings["SyndicCS"].ToString();
                cn.Open();
            }


            BindingSource bscombo = Fonctions.remplirList(cmb_type, "Select * from type_cotisation where archive = 1", "type_cotisation", "nomType", "id_type");

            cmb_type.DataSource = bscombo;



            ch.Name = "check";
            dataGridView1.Columns.Add(ch);

            remplirLst();


            string sql2 = "Select concat(nom,' ',prenom) as nm , b.id_proprietaire as ids from proprietaire p join Bien b on b.id_proprietaire = p.id_proprietaire ";


            bsFac = Fonctions.remplirList(cmb_proprietaire, sql2, "proprietaire2", "nm", "ids");
            cmb_proprietaire.Focus();

            cmb_proprietaire.SelectedIndex = 0;
            remplirLst();


            pos = int.Parse(cmb_proprietaire.ValueMember);

            remplirLst();
        }
示例#7
0
        private void FrmAMConge_Load(object sender, EventArgs e)
        {
            string sql = "select *,concat(prenom,' ',nom) as nomComplet from employe where archive = 1";

            bsEmp = Fonctions.remplirList(cb_emps, sql, "Employe", "nomComplet", "id_employe");

            if (frm == "Modifier")
            {
                cb_emps.SelectedValue = idemp;
                cmd = new SqlCommand("select * from conge_employe where id_employe = " + idemp + " and id_conge = " + idcon, Fonctions.CnConnection());
                dr  = cmd.ExecuteReader();
                dr.Read();

                dt_debut.Value = Convert.ToDateTime(dr["date_sortie"].ToString());
                dt_fin.Value   = Convert.ToDateTime(dr["date_entree"].ToString());
                dr.Close();
                dr = null;

                lbl_titre.Text = "Modifier Conge";
                activier(false);
            }
            else
            {
                lbl_titre.Text = "Ajouter Conge";
                activier(true);
            }
        }
        private void frm_cotisationDocument_info_Load(object sender, EventArgs e)
        {
            string sql2 = "Select distinct Concat(nom,' ',prenom) as nm,c.id_cotisation as id from document_cotisation d join cotisation c on c.id_cotisation = d.id_cotisation join proprietaire p on p.id_proprietaire = c.id_proprietaire where c.archive = 1";



            bsFct = Fonctions.remplirList(cb_fct, sql2, "Cotisation", "nm", "id");
            if (lbl_titre.Text == "Modifier")
            {
                cmd = new SqlCommand("select * from document_cotisation where id_document = " + id, Fonctions.CnConnection());
                dr  = cmd.ExecuteReader();

                dr.Read();
                txt_nom.Text    = dr["nomDocument"].ToString();
                lbl_chemin.Text = dr["fichier"].ToString();

                lbl_titre.Text = "Modifier Document";

                cb_fct.SelectedValue = id;

                pnl_ajouter.Visible  = false;
                pnl_modifier.Visible = true;
            }
            else
            {
                pnl_modifier.Visible = false;
                pnl_ajouter.Visible  = true;
                lbl_titre.Text       = "Ajouter";
            }
        }
示例#9
0
        private void FrmAMContract_Load(object sender, EventArgs e)
        {
            string sql = "select id_employe,concat(prenom,' ',nom) as nomComplet from employe where archive = 1";
            bsEmp = Fonctions.remplirList(cb_emps, sql, "employe", "nomComplet", "id_employe");

            if (frm == "Modifier")
            {
                cb_emps.SelectedValue = idemp;

                cmd = new SqlCommand("select * from contrat where id_contrat = " + idcon, Fonctions.CnConnection());
                dr = cmd.ExecuteReader();
                dr.Read();

                ancien += "id_employe  = " + dr["id_employe"].ToString() + " date_debut = " + dr["date_debut"].ToString() + " date_fin = " + dr["date_fin"].ToString() + " salaire = " + dr["salaire"].ToString();
                dt_debut.Text = dr["date_debut"].ToString();
                dt_fin.Text = dr["date_fin"].ToString();
                txt_salaire.Text = dr["salaire"].ToString();
                dr.Close();
                dr = null;

                lbl_titre.Text = "Modifier Contract";
                activier(false);
            }
            else
            {
                lbl_titre.Text = "Ajouter Contract";
                activier(true);
            }
        }
示例#10
0
        private void FrmAMDocFacture_Load(object sender, EventArgs e)
        {
            bsFct = Fonctions.remplirList(cb_fct, "Facture", "designation", "id_facture");

            if (frm == "Modifier")
            {
                cmd = new SqlCommand("select * from document_facture where id_document = " + id, Fonctions.CnConnection());
                dr  = cmd.ExecuteReader();

                dr.Read();
                txt_nom.Text    = dr["nom"].ToString();
                lbl_chemin.Text = dr["fichier"].ToString();

                lbl_titre.Text = "Modifier Document";

                cb_fct.SelectedValue = id;

                pnl_ajouter.Visible  = false;
                pnl_modifier.Visible = true;
            }
            else
            {
                pnl_modifier.Visible = false;
                pnl_ajouter.Visible  = true;
                lbl_titre.Text       = "Ajouter Document";
            }
        }
示例#11
0
        private void FrmAchat_Load(object sender, EventArgs e)
        {
            bsAchat = Fonctions.remplirGrille(dt_grid, sql, "achat");

            dt_grid.Columns[0].Visible = false;
            dt_grid.Columns[1].Visible = false;
        }
示例#12
0
        private void Frm_Bien_Document_aj_Load(object sender, EventArgs e)
        {
            bsFct = Fonctions.remplirList(cb_doc, "bien", "NomApparetemnt", "id_bien");

            if (frm == "Modifier Document")
            {
                cmd = new SqlCommand("select * from document_bien where id_document = " + id, Fonctions.CnConnection());
                dr  = cmd.ExecuteReader();

                dr.Read();
                txt_nom.Text    = dr["nom"].ToString();
                lbl_chemin.Text = dr["fichier"].ToString();

                lbl_titre.Text = "Modifier Document";

                cb_doc.SelectedValue = id;

                pnl_ajouter.Visible  = false;
                pnl_modifier.Visible = true;
            }
            else
            {
                pnl_modifier.Visible = false;
                pnl_ajouter.Visible  = true;
                lbl_titre.Text       = "Ajouter Document";
            }
        }
示例#13
0
        private void lst_documents_DoubleClick(object sender, EventArgs e)
        {
            cmd = new SqlCommand("select fichier from document_employe where id_document = " + GetID(), Fonctions.CnConnection());
            string chemin = cmd.ExecuteScalar().ToString();

            Fonctions.OuvrirDocument(chemin);
        }
示例#14
0
        private void Frm_utilisateur_Load(object sender, EventArgs e)
        {
            Affiche();
            string sqlEmp = "select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom+' '+e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join employe e on e.id_employe = u.id_table where  t.nom_type = 'Employée' and u.archive = 1";
            string sqlPrp = "select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom+' '+e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join proprietaire e on e.id_proprietaire=u.id_table where t.nom_type = 'Proprietaire' and u.archive = 1";

            cmd = new SqlCommand(sqlEmp, Fonctions.CnConnection());
            dr  = cmd.ExecuteReader();
            dt_grid.Columns[0].Visible = false;
            while (dr.Read())
            {
                dt_grid.Rows.Add(dr[0].ToString(), dr[5].ToString(), dr[1].ToString(), dr[2].ToString(), dr[4].ToString());
            }
            dr.Close();
            dr = null;

            cmd = new SqlCommand(sqlPrp, Fonctions.CnConnection());
            dr  = cmd.ExecuteReader();
            dt_grid.Columns[0].Visible = false;
            while (dr.Read())
            {
                dt_grid.Rows.Add(dr[0].ToString(), dr[5].ToString(), dr[1].ToString(), dr[2].ToString(), dr[4].ToString());
            }
            dr.Close();
            dr = null;
        }
示例#15
0
        private void FrmDocEmploye_Load(object sender, EventArgs e)
        {
            string sql = "select *,concat(nom,' ',prenom) as nomComplete from employe where archive = 1";

            bsEmp = Fonctions.remplirList(lst_employes, sql, "Employe", "nomComplete", "id_employe");
            remplirDoc();
        }
        private void frm_cotisation_Document_Load(object sender, EventArgs e)
        {
            string sql2 = "Select distinct Concat(nom,' ',prenom) as nm,c.id_cotisation as id from document_cotisation d join cotisation c on c.id_cotisation = d.id_cotisation join proprietaire p on p.id_proprietaire = c.id_proprietaire where c.archive = 1";


            bsFact = Fonctions.remplirList(lst_cotisation, sql2, "Cotisation", "nm", "id");
            remplirDoc();
        }
示例#17
0
 private void lstArticleAchat()
 {
     if (lst_fournisseur.Items.Count > 0 && txt_ice.Text != "")
     {
         string sql = "select a.id_article,CONCAT(a.designation,' - ',a.qtestock) as Libelle,a.archive from article a inner join achat c on c.id_article = a.id_article inner join facture f on f.id_facture = c.id_facture inner join fournisseur r on r.id_fournisseur = f.id_fournisseur where r.ice = " + txt_ice.Text + " and a.archive = 1";
         bsAr = Fonctions.remplirList(lst_article, sql, "articleAchat", "Libelle", "a.id_article");
     }
 }
示例#18
0
        private void Frm_Bien_Remarque_Load(object sender, EventArgs e)
        {
            bsbien = Fonctions.remplirList(cb_bien, "bien", "NomApparetemnt", "id_bien");

            remplirLst();

            activier(true);
        }
示例#19
0
        private void btn_pays_Click(object sender, EventArgs e)
        {
            FrmPays f = new FrmPays();

            f.ShowDialog();
            string sql = "select * from pays";

            bsPay = Fonctions.remplirList(cb_pays, sql, "pays", "nom_pays", "id_pays");
        }
示例#20
0
        private void FrmRemFacture_Load(object sender, EventArgs e)
        {
            string sql = "select * from facture where archive = 1";

            bsFac = Fonctions.remplirList(cb_facture, sql, "facture", "designation", "id_facture");

            remplirLst();

            activier(true);
        }
示例#21
0
        private void frm_Cotisation_Remarque_Load(object sender, EventArgs e)
        {
            string sql2 = "Select distinct Concat(nom,' ',prenom) as nm,c.id_cotisation as id from remarque_cotisation d join cotisation c on c.id_cotisation = d.id_cotisation join proprietaire p on p.id_proprietaire = c.id_proprietaire where c.archive = 1";

            bsFac = Fonctions.remplirList(cb_facture, sql2, "cotisation", "nm", "id");

            remplirLst();

            activier(true);
        }
示例#22
0
        private void FrmArticleStock_Load(object sender, EventArgs e)
        {
            bsArt = Fonctions.remplirGrille(dt_grid, sql, "article");

            dt_grid.Columns[0].Width = 100;
            dt_grid.Columns[1].Width = 180;

            remplircombo();
            afficherpnl();
        }
        private void FrmRemEmploye_Load(object sender, EventArgs e)
        {
            string sql = "select *,concat(nom,' ',prenom) as nomComplet from employe where archive = 1";

            bsEmp = Fonctions.remplirList(cb_employes, sql, "Employe", "nomComplet", "id_employe");

            remplirLst();

            activier(true);
        }
示例#24
0
 private void cb_type_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (cb_type.Text == "Fournisseur")
     {
         string sql = "Select id_fournisseur,concat('[',ice,'] - ',prenom,' ',nom) as nomCP from fournisseur where archive = 1";
         bsFr = Fonctions.remplirList(cb_nom, sql, "fournisseur", "nomCP", "id_fournisseur");
     }
     else
     {
         string sql = "Select id_employe,concat(id_employe,' - ',prenom,' ',nom) as nomCP from employe where archive = 1";
         bsFr = Fonctions.remplirList(cb_nom, sql, "employe", "nomCP", "id_employe");
     }
 }
示例#25
0
        private void journal()
        {
            string sql = "select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom+' '+e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join employe e on e.id_employe = u.id_table where  t.nom_type = 'Employée' and u.archive = 1 and u.id_utilisateur =" + id +
                         "union select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom + ' ' + e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join proprietaire e on e.id_proprietaire = u.id_table where t.nom_type = 'Proprietaire' and u.archive = 1 and u.id_utilisateur= " + id;

            com = new SqlCommand(sql, Fonctions.CnConnection());
            dr  = com.ExecuteReader();
            dr.Read();
            nouvelles += "Id =" + dr["id_utilisateur"].ToString() + " Nom Complet =" + dr["Nom Complete"].ToString() + "Login = "******"login"].ToString() + "Password ="******"password"].ToString() + "type=" + dr["nom_type"].ToString();
            dr.Close();
            com = null;

            com = new SqlCommand("insert into journal values (1,GETDATE(),'Modifier','utilisateur','" + anciennes + "','" + nouvelles + "',1)", Fonctions.CnConnection());
            com.ExecuteNonQuery();
        }
示例#26
0
        private void Affiche()
        {
            if (rd_nom.Checked == true)
            {
                pnl_nom.Visible = true;
                //pnl_typ.Visible = false;
            }
            else
            {
                pnl_nom.Visible = false;
                //  pnl_typ.Visible = true;

                Fonctions.remplirList(cb_type, "type_utilisateur", "nom_type", "id_type");
            }
        }
示例#27
0
        private void btn_ajouter_Click(object sender, EventArgs e)
        {
            Button btn = (Button)sender;

            switch (btn.Name)
            {
            case "btn_ajouter":
                pos = lst_emps.Items.Count;
                bsEmp.AddNew();
                txt_archive.Text = "true";
                activer(false);
                break;

            case "btn_modifier":
                activer(false);
                pos = lst_emps.SelectedIndex;
                break;

            case "btn_supprimer":
                if (lst_emps.Items.Count > 0)
                {
                    if (DialogResult.Yes == MessageBox.Show("Voulez-vous Vraiment Supprimer Ce Employe ?", "Supprimer", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
                    {
                        pos = lst_emps.SelectedIndex - 1;
                        txt_archive.Text = "False";
                        bsEmp.EndEdit();
                        Fonctions.syncr("Employe", Fonctions.CnConnection(), Fonctions.ds);
                        remplirEmps();

                        lst_emps.SelectedIndex = pos;
                    }
                }
                break;

            case "btn_valider":
                bsEmp.EndEdit();
                Fonctions.syncr("Employe", Fonctions.CnConnection(), Fonctions.ds);
                remplirEmps();
                lst_emps.SelectedIndex = pos;
                activer(true);
                break;

            case "btn_annuler":
                bsEmp.CancelEdit();
                activer(true);
                break;
            }
        }
        private void frm_Echeance_Load(object sender, EventArgs e)
        {
            txt_search      = MyHint.LoadText(txt_search, "Nom de bien");
            rd_tous.Checked = true;

            //Fonctions.ouvrireConnection();
            cn = Fonctions.CnConnection();
            if (cn.State != ConnectionState.Open)
            {
                cn.Open();
            }

            ////les annee

            ////les Mois
            WhoChecked = "";

            sqlQuery = "Select id_echeance,mois,annee,montant,montant_recu,NomApparetemnt from echeance e inner join Bien b on b.id_bien = e.id_bien join immeuble i on i.id_immeuble = b.id_immeuble where e.archive = 1 and paiment like '%" + WhoChecked + "%' ";

            com    = new SqlCommand(sqlQuery, Fonctions.CnConnection());
            reader = com.ExecuteReader();

            dataGridView1.ColumnCount     = 6;
            dataGridView1.Columns[0].Name = "Id";
            dataGridView1.Columns[1].Name = "Mois";
            dataGridView1.Columns[2].Name = "Anne";
            dataGridView1.Columns[3].Name = "Montant";
            dataGridView1.Columns[4].Name = "Montant Recu";
            dataGridView1.Columns[5].Name = "Bien";
            /////////////////////////////////
            // com = new SqlCommand("Select montant from Bien",cn);
            //readerMontant = com.ExecuteReader();
            //while (readerMontant.Read())
            //{

            //}



            while (reader.Read())
            {
                dataGridView1.Rows.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString());
            }
            ////////// //////// ///////// /////////// ////////////// ////////////// ///////////

            reader.Close();
        }
示例#29
0
        private void btn_chercher_designation_Click(object sender, EventArgs e)
        {
            dt_grid.Rows.Clear();

            int a;

            if (txt_chercher.Text.Contains(' '))
            {
                a = txt_chercher.Text.IndexOf(' ');
            }
            else
            {
                a = txt_chercher.Text.Length;
            }

            string nom    = txt_chercher.Text.Substring(0, a);
            string prenom = txt_chercher.Text.Substring(a, (txt_chercher.Text.Length - a));

            if (prenom == "")
            {
                prenom = " ";
            }

            string sqlPrp = "select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom+' '+e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join proprietaire e on e.id_proprietaire=u.id_table where  t.nom_type = 'Proprietaire'  and (nom like '%" + nom + "%' or nom like '%" + prenom + "%' or prenom like '%" + nom + "%' or prenom like '%" + prenom + "%')";

            cmd = new SqlCommand(sqlPrp, Fonctions.CnConnection());
            dr  = cmd.ExecuteReader();
            dt_grid.Columns[0].Visible = false;
            while (dr.Read())
            {
                dt_grid.Rows.Add(dr[0].ToString(), dr[5].ToString(), dr[1].ToString(), dr[2].ToString(), dr[4].ToString());
            }
            dr.Close();
            dr = null;

            string sqlEmp = "select u.id_utilisateur,u.login,u.password,u.salt,t.nom_type,(e.prenom+' '+e.nom) as [Nom Complete] from utilisateur u inner join type_utilisateur t on t.id_type = u.id_type inner join employe e on e.id_employe = u.id_table where  t.nom_type = 'Employée' and (nom like '%" + nom + "%' or nom like '%" + prenom + "%' or prenom like '%" + nom + "%' or prenom like '%" + prenom + "%')";

            cmd = new SqlCommand(sqlEmp, Fonctions.CnConnection());
            dr  = cmd.ExecuteReader();
            dt_grid.Columns[0].Visible = false;
            while (dr.Read())
            {
                dt_grid.Rows.Add(dr[0].ToString(), dr[5].ToString(), dr[1].ToString(), dr[2].ToString(), dr[4].ToString());
            }
            dr.Close();
            dr = null;
        }
        private void Affiche()
        {
            if (rd_nom.Checked)
            {
                pnl_nom.Visible = true;
            }
            else
            {
                pnl_nom.Visible = false;


                Fonctions.remplirList(cm_et, "bien", "etage", "id_bien");


                Fonctions.remplirList(cm_ch_im, "immeuble", "nom", "id_immeuble");
            }
        }