Esempio n. 1
0
    public static void UpdateFeuilleDeTemps(T_FeuilleDeTemps p_fdt)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();

        T_FeuilleDeTemps newFdt = BD.T_FeuilleDeTemps.Single(p => p.idFeuilleDeTemps == p_fdt.idFeuilleDeTemps);

        newFdt.idFeuilleDeTemps    = p_fdt.idFeuilleDeTemps;
        newFdt.idEmp               = p_fdt.idEmp;
        newFdt.idCategorie         = p_fdt.idCategorie;
        newFdt.dimanche            = p_fdt.dimanche;
        newFdt.lundi               = p_fdt.lundi;
        newFdt.mardi               = p_fdt.mardi;
        newFdt.mercredi            = p_fdt.mercredi;
        newFdt.jeudi               = p_fdt.jeudi;
        newFdt.vendredi            = p_fdt.vendredi;
        newFdt.samedi              = p_fdt.samedi;
        newFdt.commentaireDimanche = p_fdt.commentaireDimanche;
        newFdt.commentaireLundi    = p_fdt.commentaireLundi;
        newFdt.commentaireMardi    = p_fdt.commentaireMardi;
        newFdt.commentaireMercredi = p_fdt.commentaireMercredi;
        newFdt.commentaireJeudi    = p_fdt.commentaireJeudi;
        newFdt.commentaireVendredi = p_fdt.commentaireVendredi;
        newFdt.commentaireSamedi   = p_fdt.commentaireSamedi;
        newFdt.approbation         = p_fdt.approbation;

        BD.SubmitChanges();
        BD.Dispose();
    }
Esempio n. 2
0
    public static void AjouterDepKilometrage(T_Kilometrage km)
    {
        CoEco_BDDataContext bd = new CoEco_BDDataContext();

        bd.T_Kilometrage.InsertOnSubmit(km);
        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 3
0
    public static void AddDepense(T_Depense p_newDep)
    {
        CoEco_BDDataContext bd = new CoEco_BDDataContext();

        bd.T_Depense.InsertOnSubmit(p_newDep);
        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 4
0
    public static void ChangeStatusCategorie(int id, int etat)
    {
        CoEco_BDDataContext bd  = new CoEco_BDDataContext();
        T_CategoriePro      cat = bd.T_CategoriePro.Single(f => f.idCategorie == id);

        cat.idStatusCat = etat;
        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 5
0
    public static void ApprouverKilometrageById(int id, bool etat)
    {
        CoEco_BDDataContext bd   = new CoEco_BDDataContext();
        T_Kilometrage       kilo = bd.T_Kilometrage.Single(f => f.idKilo == id);

        kilo.approbation = etat;
        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 6
0
    public static void ApprouverDepenseByID(int id, bool etat)
    {
        CoEco_BDDataContext bd  = new CoEco_BDDataContext();
        T_Depense           dep = bd.T_Depense.Single(f => f.idDepense == id);

        dep.aprobation = etat;
        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 7
0
    /// <summary>
    /// Ajoute un nouveau taux
    /// </summary>
    /// <param name="newTaux">nouveau taux</param>
    /// <param name="type">1 = Auto, 2 = Camion</param>
    public static void AddTauxKilo(float newTaux, int type)
    {
        T_TauxKilo tauxKilo = new T_TauxKilo();

        tauxKilo.taux       = newTaux;
        tauxKilo.ddate      = DateTime.Today;
        tauxKilo.idTypeAuto = type;

        CoEco_BDDataContext bd = new CoEco_BDDataContext();

        bd.T_TauxKilo.InsertOnSubmit(tauxKilo);
        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 8
0
    public static void UpdateDepense(T_Depense depense)
    {
        CoEco_BDDataContext bd           = new CoEco_BDDataContext();
        T_Depense           depenseToMod = bd.T_Depense.Single(p => p.idDepense == depense.idDepense);

        depenseToMod.idProjet = depense.idProjet;
        //depenseToMod.idCategorie = depense.idCategorie;
        depenseToMod.idType     = depense.idType;
        depenseToMod.descript   = depense.descript;
        depenseToMod.montant    = depense.montant;
        depenseToMod.ddate      = depense.ddate;
        depenseToMod.idEmp      = depenseToMod.idEmp;
        depenseToMod.aprobation = depense.aprobation;

        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 9
0
    public static void UpdateProjet(T_Projet p_projet)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();

        T_Projet newProjet = BD.T_Projet.Single(p => p.idProjet == p_projet.idProjet);

        newProjet.nom         = p_projet.nom;
        newProjet.idStatus    = p_projet.idStatus;
        newProjet.heureAlloue = p_projet.heureAlloue;
        newProjet.responsable = p_projet.responsable;
        newProjet.descript    = p_projet.descript;
        newProjet.dateDebut   = p_projet.dateDebut;
        newProjet.dateFin     = p_projet.dateFin;

        BD.SubmitChanges();
        BD.Dispose();
    }
Esempio n. 10
0
    public static void CreateNewProjet(T_Projet p_projet)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();
        int?maxID = 0;

        BD.PS_GetMaxIdProjet(ref maxID);
        maxID++;
        if (maxID == null)
        {
            maxID = 1;
        }
        p_projet.idProjet = (int)maxID;

        BD.T_Projet.InsertOnSubmit(p_projet);
        BD.SubmitChanges();
        BD.Dispose();
    }
Esempio n. 11
0
    public static void UpdateKilometrage(T_Kilometrage newkilo)
    {
        CoEco_BDDataContext bd      = new CoEco_BDDataContext();
        T_Kilometrage       oldkilo = bd.T_Kilometrage.Single(o => o.idKilo == newkilo.idKilo);

        //oldkilo.idKilo = newkilo.idTaux;
        oldkilo.nbKilo      = newkilo.nbKilo;
        oldkilo.commentaire = newkilo.commentaire;
        oldkilo.ddate       = newkilo.ddate;
        oldkilo.approbation = newkilo.approbation;
        oldkilo.idTaux      = newkilo.idTaux;
        oldkilo.idEmp       = newkilo.idEmp;
        oldkilo.idPro       = newkilo.idPro;


        bd.SubmitChanges();
        bd.Dispose();
    }
Esempio n. 12
0
    public static void CreateNewEmploye(T_Employe p_employe)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();
        int?maxID = 0;

        BD.PS_GetMaxIdEmpolye(ref maxID);
        maxID++;
        if (maxID == null)
        {
            maxID = 1;
        }

        p_employe.idEmploye = (int)maxID;

        BD.T_Employe.InsertOnSubmit(p_employe);
        BD.SubmitChanges();
        BD.Dispose();
    }
Esempio n. 13
0
    public static void CreateNewFeuilleDeTemps(T_FeuilleDeTemps p_feuilleDeTemps)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();
        int?maxID = 0;

        BD.PS_GetMaxIdFeuilleTemps(ref maxID);
        maxID++;

        if (maxID == null)
        {
            maxID = 1;
        }

        p_feuilleDeTemps.idFeuilleDeTemps = (int)maxID;

        BD.T_FeuilleDeTemps.InsertOnSubmit(p_feuilleDeTemps);
        BD.SubmitChanges();
        BD.Dispose();
    }
Esempio n. 14
0
    public static void CreateNewCategorie(T_CategoriePro p_categorie)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();
        int?maxID = 0;

        BD.PS_GetMaxIdCategorie(ref maxID);
        maxID++;

        if (maxID == null)
        {
            maxID = 1;
        }

        p_categorie.idCategorie = (int)maxID;

        BD.T_CategoriePro.InsertOnSubmit(p_categorie);
        BD.SubmitChanges();
        BD.Dispose();
    }
Esempio n. 15
0
    public static void CreateNewEmpAtProject(T_EmployeProjet p_emp)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();
        int?maxID = 0;

        BD.PS_GetMaxIdEmpPro(ref maxID);
        maxID++;

        if (maxID == null)
        {
            maxID = 1;
        }

        p_emp.idEmpPro = (int)maxID;

        BD.T_EmployeProjet.InsertOnSubmit(p_emp);
        BD.SubmitChanges(); //Si ce bug survient, c'est qu'il n'y a pas pas de projet #3... a changer dans AjouterEmp.aspx.cs
        BD.Dispose();
    }
Esempio n. 16
0
    public static void UpdateEmploye(T_Employe p_employe)
    {
        CoEco_BDDataContext BD = new CoEco_BDDataContext();

        T_Employe newEmp = BD.T_Employe.Single(e => e.idEmploye == p_employe.idEmploye);

        newEmp.prenom     = p_employe.prenom;
        newEmp.nom        = p_employe.nom;
        newEmp.courriel   = p_employe.courriel;
        newEmp.mdp        = p_employe.mdp;
        newEmp.idFonction = p_employe.idFonction;
        newEmp.idStatus   = p_employe.idStatus;
        newEmp.loginName  = p_employe.loginName;

        newEmp.congesFeries                = p_employe.congesFeries;
        newEmp.congesMaladie               = p_employe.congesMaladie;
        newEmp.congesPersonnels            = p_employe.congesPersonnels;
        newEmp.heuresAccumuleesOuSansSolde = p_employe.heuresAccumuleesOuSansSolde;
        newEmp.vacances = p_employe.vacances;

        BD.SubmitChanges();
        BD.Dispose();
    }