예제 #1
0
    //SUPPRESSION
    protected void Delete(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
    {
        List <int> selectedIds = GridView.GetSelectedFieldValues("ID").ConvertAll(id => (int)id);

        foreach (int item in selectedIds)
        {
            int code = (int)item;
            try
            {
                //string code = e.Keys[0].ToString();
                ArrayList cle = new ArrayList();
                ArrayList val = new ArrayList();

                cle.Add("@ID"); val.Add(code);
                cle.Add("@INDEX"); val.Add(2);

                Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMETRE_UPLOAD", cle, val);
                GridView.JSProperties["cpShowPopup"] = "Success";
                e.Cancel = true;

                chargerGrid();
            }
            catch (Exception Ex)
            {
                e.Cancel = true;
                GridView.JSProperties["cpShowPopup"] = "Error";
            }
        }
    }
예제 #2
0
        protected void ApplicationMenu_Load(object sender, EventArgs e)
        {
            try
            {
                if (user != null && ApplicationMenu.Items.Count == 0)
                {
                    DataTable dt  = new DataTable();
                    ArrayList cle = new ArrayList();
                    ArrayList val = new ArrayList();
                    cle.Add("@LOGIN"); val.Add(user.UserName);
                    cle.Add("@SENDER"); val.Add(2);
                    dt = Cl_Fonction.Extraction_ds("PS_E_LIENSOUSMENU", cle, val, ref dt);

                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        MenuItem menuItem = new MenuItem();
                        menuItem.Name         = dt.Rows[i]["ID_MENU"].ToString();
                        menuItem.Text         = dt.Rows[i]["LIBELLE_MENU"].ToString();
                        menuItem.Image.IconID = dt.Rows[i]["ICONE"].ToString();
                        ApplicationMenu.Items.Add(menuItem);
                    }
                }
                if (user == null && ApplicationMenu.Items.Count != 0)
                {
                    HttpContext.Current.Response.RedirectLocation = System.Web.VirtualPathUtility.ToAbsolute("~/Account/SignIn.aspx");
                }
            }
            catch (Exception ex)
            {
                log.Info("Error : " + ex + "; Method : " + Cl_Fonction.GetCurrentMethod());
            }
        }
    //SUPPRESSION
    protected void Delete(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
    {
        try
        {
            string    code = e.Keys[0].ToString();
            ArrayList cle  = new ArrayList();
            ArrayList val  = new ArrayList();

            cle.Add("@Site_ID");
            val.Add(code);

            cle.Add("@SENDER");
            val.Add(3);

            Cl_Fonction.Execute_Commande_StoreProc("LISTE_JOURNALCONNECT_SITE", cle, val);

            string code_message = message.CodeMessage.DELETE_SUCCES.ToString();
            string lib_message  = Cl_Fonction.message_defini(code_message);
            MainGridView.JSProperties["cpShowPopup"] = code_message + "|" + lib_message;

            e.Cancel = true;

            chargerGrid();
        }
        catch (Exception ex)
        {
            e.Cancel = true;
            string code_message = message.CodeMessage.UNEXPECTED_ERROR.ToString();
            string lib_message  = Cl_Fonction.message_defini(code_message);
            MainGridView.JSProperties["cpShowPopup"] = code_message + "|" + lib_message;
        }
    }
예제 #4
0
    protected void GridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
    {
        if (e.Parameters == "delete")
        {
            List <int> selectedIds = GridView.GetSelectedFieldValues("ID").ConvertAll(id => (int)id);
            foreach (int item in selectedIds)
            {
                try
                {
                    int       code = (int)item;
                    ArrayList cle  = new ArrayList();
                    ArrayList val  = new ArrayList();

                    cle.Add("@INDEX");
                    val.Add("2");
                    cle.Add("@ID");
                    val.Add(code);

                    Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMETRE_UPLOAD", cle, val);
                    GridView.JSProperties["cpShowPopup"] = "Success";
                    //e.Cancel = true;

                    chargerGrid();
                }
                catch (Exception ex)
                {
                    //e.Cancel = true;
                    GridView.JSProperties["cpShowPopup"] = "Error";
                }
            }
            GridView.DataBind();
        }
    }
        private void LoadGridView()
        {
            DataSet   ds  = new DataSet();
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();

            cle.Add("@ApplicationName"); val.Add("/");

            ds = Cl_Fonction.Extraction_ds("aspnet_Roles_GetAllRoles", cle, val);
            MainGridView.DataSource = ds;
            MainGridView.DataBind();
        }
예제 #6
0
        protected void RegisterButton_Click(object sender, EventArgs e)
        {
            // DXCOMMENT: Your Registration logic
            //MembershipUser u = Membership.GetUser(User.Identity.Name);
            //MembershipUser u = Membership.CreateUser(login, "educative");

            try
            {
                if (Cl_Fonction.Verification_Code("aspnet_Users", "UserName", RegisterUserNameTextBox.Text))
                {
                    RegisterUserNameTextBox.ValidationSettings.ErrorDisplayMode = DevExpress.Web.ErrorDisplayMode.ImageWithText;
                    RegisterUserNameTextBox.ValidationSettings.ErrorText        = "Ce username est déjà utilisé";
                }
                else
                {
                    if (Cl_Fonction.IsValidEmail(EmailTextBox.Text.Trim()))
                    {
                        ArrayList cle = new ArrayList();
                        ArrayList val = new ArrayList();

                        //string activationCode = Guid.NewGuid().ToString();
                        cle.Add("@CODE_PERSONNE"); val.Add(MatriculeTextBox.Text.Trim());
                        cle.Add("@NOM_PERSONNE"); val.Add(LastNameTextBox.Text.Trim());
                        cle.Add("@PRENOMS_PERSONNE"); val.Add(FirstNameTextBox.Text.Trim());
                        cle.Add("@USERNAME"); val.Add(RegisterUserNameTextBox.Text.Trim());
                        cle.Add("@SITE_ID"); val.Add(1);
                        cle.Add("@CONFIRMA"); val.Add("");
                        //cle.Add("@ACTIVATIONCODE");val.Add(activationCode);
                        cle.Add("@EMAIL"); val.Add(EmailTextBox.Text.Trim());
                        cle.Add("@SENDER"); val.Add(2);

                        Cl_Fonction.Extraction_ds("PS_USERCONFIRM", cle, val);

                        MembershipUser u = Membership.CreateUser(RegisterUserNameTextBox.Text.Trim(), ConfirmPasswordButtonEdit.Text, EmailTextBox.Text.Trim());

                        //SendActivationEmail(activationCode, txtEmail.Text.Trim());

                        ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Enregistrement effectué avec succès! Veuillez consulter l'administrateur pour accéder à la solution');", true);

                        Response.Redirect("~/");
                    }
                    else
                    {
                        EmailTextBox.ValidationSettings.ErrorText = "Veuillez SVP saisir une adresse mail valide";
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
                //ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Echec de l'enregistrement !');", true);
            }
        }
예제 #7
0
        protected void chargerGrid()
        {
            DataSet   ds  = new DataSet();
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();

            cle.Add("@SENDER"); val.Add(0);

            Cl_Fonction.Extraction_ds("PS_E_SOUSMENU", cle, val);
            MainGridView.DataSource = ds;
            MainGridView.DataBind();
        }
예제 #8
0
        protected void cmbSite_Load(object sender, EventArgs e)
        {
            DataSet   ds  = new DataSet();
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();

            cle.Add("@INDEX");
            val.Add("4");

            ds = Cl_Fonction.Extraction_ds("PS_SITE", cle, val);
            cmbSite.DataSource = ds;
            cmbSite.DataBind();
        }
예제 #9
0
    //AJOUTER

    protected void Enregistrer(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        string libelle     = Cl_Fonction.GetStringTxt("lib", GridView);
        string observation = Cl_Fonction.GetStringMemo("com", GridView);


        if (Cl_Fonction.Verification_Code("Daf.TYPE_RESSOURCES", "LIBELLE", libelle.ToLower()))
        {
            GridView.JSProperties["cpShowPopup"] = "Caution";
            e.Cancel = true;
        }
        else
        {
            try
            {
                ArrayList cle = new ArrayList();
                ArrayList val = new ArrayList();

                cle.Add("@INDEX");
                val.Add("1");

                cle.Add("@ID");
                val.Add("0");

                cle.Add("@COMMENTAIRE");
                val.Add(observation);

                cle.Add("@LIBELLE");
                val.Add(libelle);

                cle.Add("@DATE");
                val.Add(DateTime.Now);

                cle.Add("@USER");
                val.Add(AuthHelper.GetLoggedInUserInfo().UserName.ToString());

                Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMETRE_UPLOAD", cle, val);
                GridView.JSProperties["cpShowPopup"] = "Success";
                e.Cancel = true;
                GridView.CancelEdit();
                chargerGrid();
            }
            catch (Exception ex)
            {
                e.Cancel = true;

                GridView.JSProperties["cpShowPopup"] = "Error";
            }
        }
    }
    protected void chargerGrid()
    {
        DataSet   ds  = new DataSet();
        ArrayList cle = new ArrayList();
        ArrayList val = new ArrayList();

        cle.Add("@Site_ID");
        val.Add(user.SiteID);


        ds = Cl_Fonction.Extraction_ds("LISTE_JOURNALCONNECT_SITE", cle, val);
        MainGridView.DataSource = ds;
        MainGridView.DataBind();
    }
예제 #11
0
    protected void chargerGrid()
    {

        DataSet ds = new DataSet();
        ArrayList cle = new ArrayList();
        ArrayList val = new ArrayList();

        cle.Add("@SENDER");
        val.Add(0);
        

        ds = Cl_Fonction.Extraction_ds("PS_AFFECTATION_TYPEDOC_PROFILE", cle, val);
        MainGridView.DataSource = ds;
        MainGridView.DataBind();
    }
예제 #12
0
    protected void chargerGrid()
    {
        ArrayList cle = new ArrayList();
        ArrayList val = new ArrayList();

        cle.Add("@INDEX");
        val.Add("3");
        cle.Add("@ID");
        val.Add("");

        var emplacements = Cl_Fonction.Extraction_ds("PS_PARAMETRE_UPLOAD", cle, val);

        GridView.DataSource = emplacements;
        GridView.DataBind();
    }
예제 #13
0
    protected void chargerGrid()
    {
        ArrayList cle = new ArrayList();
        ArrayList val = new ArrayList();

        cle.Add("@INDEX");
        val.Add("3");
        cle.Add("@SITE_ID");
        val.Add(AuthHelper.GetLoggedInUserInfo().SiteID.ToString());

        var emplacements = Cl_Fonction.Extraction_ds("PS_PARAMCOMPTABLE", cle, val);

        GridView.DataSource = emplacements;
        GridView.DataBind();
    }
예제 #14
0
    //MODIFIER
    protected void Modifier(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
    {
        // int index = Convert.ToInt32(GridView.FocusedRowIndex.ToString());
        var    selectedIds = GridView.GetSelectedFieldValues("ID");
        string index       = selectedIds[0].ToString();
        string libelle     = Cl_Fonction.GetStringTxt("lib", GridView);
        string observation = Cl_Fonction.GetStringMemo("com", GridView);


        try
        {
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();


            cle.Add("@INDEX");
            val.Add("1");

            cle.Add("@ID");
            val.Add(index);

            cle.Add("@COMMENTAIRE");
            val.Add(observation);

            cle.Add("@LIBELLE");
            val.Add(libelle);

            cle.Add("@DATE");
            val.Add(DateTime.Now);

            cle.Add("@USER");
            val.Add(AuthHelper.GetLoggedInUserInfo().UserName.ToString());

            Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMETRE_UPLOAD", cle, val);
            GridView.JSProperties["cpShowPopup"] = "Success";
            e.Cancel = true;
            GridView.CancelEdit();
            chargerGrid();
        }
        catch (Exception ex)
        {
            e.Cancel = true;

            GridView.JSProperties["cpShowPopup"] = "Error";
        }
    }
예제 #15
0
        protected void ASPxCallbackPage_Callback(object sender, CallbackEventArgsBase e)
        {
            if (e.Parameter == "")
            {
                PageContent.Controls.Clear();
            }
            else
            {
                if (user != null)
                {
                    PageContent.Controls.Clear();
                    string menu     = e.Parameter.ToString().Split('|')[0];
                    string statut   = e.Parameter.ToString().Split('|')[1];
                    string idtypdoc = e.Parameter.ToString().Split('|')[2];
                    string idLien   = e.Parameter.ToString().Split('|')[3];

                    string affichermontant = e.Parameter.ToString().Split('|')[4];
                    string accederdate     = e.Parameter.ToString().Split('|')[5];

                    DataTable dt = new DataTable();
                    dt = Cl_Fonction.getLinkDetail(idLien, user.Rolename);

                    Session["DROIT"]            = dt.Rows[0]["DROIT"].ToString();
                    Session["JOURNAUX"]         = dt.Rows[0]["JOURNAUX"].ToString();
                    Session["TIERS"]            = dt.Rows[0]["TIERS"].ToString();
                    Session["TYPEDOCUMENT"]     = dt.Rows[0]["TYPEDOCUMENT"].ToString();
                    Session["ID_LIENSOUSMENU"]  = idLien;
                    Session["STATUT_TYPEDOC"]   = statut;
                    Session["ID_TYPEDOCUMENT "] = idtypdoc;

                    Session["AFFICHER_MONTANT"] = affichermontant;
                    Session["ACCEDER_DATE "]    = accederdate;

                    string link = "<iframe src=\"" + menu + "\" scrolling='yes' frameborder='0' style='border:none; overflow:hidden; width:100%; height:1000px;' allowTransparency='true'></%iframe><br />";
                    PageContent.Controls.Add(new LiteralControl(link));
                }
                else
                {
                    HttpContext.Current.Response.RedirectLocation = System.Web.VirtualPathUtility.ToAbsolute("~/Account/SignIn.aspx");
                }
            }
        }
예제 #16
0
        private static ApplicationUser CreateDefaultUser(string userName)
        {
            DataTable dt = new DataTable(); ArrayList cle = new ArrayList(); ArrayList val = new ArrayList();

            cle.Add("@userName"); val.Add(userName);
            cle.Add("@sender"); val.Add(0);
            Cl_Fonction.Extraction_ds("PS_USERCONFIRM", cle, val, ref dt);

            return(new ApplicationUser
            {
                UserName = userName,
                FirstName = dt.Rows[0]["PRENOMS_PERSONNE"].ToString(),
                LastName = dt.Rows[0]["NOM_PERSONNE"].ToString(),
                Email = dt.Rows[0]["EMAIL"].ToString(),
                AvatarUrl = dt.Rows[0]["AVATAR"].ToString(),
                Rolename = dt.Rows[0]["ROLENAME"].ToString(),
                SiteID = dt.Rows[0]["SITE_ID"].ToString(),
                Exercice = "2019",
            });
        }
예제 #17
0
        protected void RightAreaMenu_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
        {
            if (e.Item.Name == "SignOutItem")
            {
                AuthHelper.SignOut(); // DXCOMMENT: Your Signing out logic

                if (Session["ConectMou"] == "1")
                {
                    ArrayList cle7 = new ArrayList();
                    ArrayList val7 = new ArrayList();

                    cle7.Add("@UNIQUE");
                    val7.Add(Session["ConectUnique"].ToString());

                    Cl_Fonction.Execute_Commande_StoreProc("MAJ_PROFILCONNECTFIN", cle7, val7);
                    Session["ConectMou"] = null;
                }

                Response.Redirect("~/");
            }
        }
예제 #18
0
        private void GestionConnexion(string roles, int sendmou, int site_id)
        {
            DataSet   data7 = new DataSet();
            ArrayList cle7  = new ArrayList();
            ArrayList val7  = new ArrayList();

            cle7.Add("@LOGIN");
            val7.Add(UserNameTextBox.Text);

            cle7.Add("@ROLE");
            val7.Add(roles);

            string adres = HttpContext.Current.Request.UserHostAddress;

            cle7.Add("@ADRESSEID");
            val7.Add(adres);

            string nomnavig = HttpContext.Current.Request.UserAgent;

            cle7.Add("@NAVIGATEUR");
            val7.Add(nomnavig);

            string nommachine = HttpContext.Current.Request.UserHostName;

            cle7.Add("@NOMMACHINE");
            val7.Add(nommachine);

            cle7.Add("@EXO");
            val7.Add("2019");

            cle7.Add("@SITE_ID");
            val7.Add(site_id);

            cle7.Add("@SENDER");
            val7.Add(sendmou);

            data7 = Cl_Fonction.Extraction_ds("MAJ_PROFILCONNECT", cle7, val7);
            Session["ConectUnique"] = data7.Tables[0].Rows[0].ItemArray[0].ToString();
            Session["ConectMou"]    = "1";
        }
예제 #19
0
    protected void Enregistrer(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        try
        {
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();

            cle.Add("@INDEX");
            val.Add("1");

            cle.Add("@ID");
            val.Add(AuthHelper.GetLoggedInUserInfo().SiteID.ToString());

            cle.Add("@ADRESSE");
            val.Add(Cl_Fonction.GetStringTxt("adr", GridView, "pgControl"));

            cle.Add("@ADR_COMP");
            val.Add(Cl_Fonction.GetStringTxt("adrcom", GridView, "pgControl"));

            cle.Add("@POST");
            val.Add(Cl_Fonction.GetStringTxt("pos", GridView, "pgControl"));

            cle.Add("@TEL1");
            val.Add(Cl_Fonction.GetStringTxt("tel1", GridView, "pgControl"));

            cle.Add("@TEL2");
            val.Add(Cl_Fonction.GetStringTxt("tel2", GridView, "pgControl"));

            cle.Add("@TEL3");
            val.Add(Cl_Fonction.GetStringTxt("tel3", GridView, "pgControl"));

            cle.Add("@CEL1");
            val.Add(Cl_Fonction.GetStringTxt("cel1", GridView, "pgControl"));

            cle.Add("@CEL2");
            val.Add(Cl_Fonction.GetStringTxt("cel2", GridView, "pgControl"));

            cle.Add("@CEL3");
            val.Add(Cl_Fonction.GetStringTxt("cel3", GridView, "pgControl"));

            cle.Add("@REG");
            val.Add(Cl_Fonction.GetStringTxt("reg", GridView, "pgControl"));

            cle.Add("@CMPT_CON");
            val.Add(Cl_Fonction.GetStringTxt("cmpt_con", GridView, "pgControl"));

            cle.Add("@STA");
            val.Add(Cl_Fonction.GetIntCmb("sta", GridView, "pgControl"));

            cle.Add("@RAI");
            val.Add(Cl_Fonction.GetStringTxt("rai", GridView, "pgControl"));

            cle.Add("@ACT");
            val.Add(Cl_Fonction.GetStringTxt("act", GridView, "pgControl"));

            cle.Add("@REGI");
            val.Add(Cl_Fonction.GetIntCmb("regi", GridView, "pgControl"));

            //cle.Add("@EFF");
            //val.Add(Cl_Fonction.GetStringTxt("eff",GridView, "pgControl"));

            cle.Add("@CNPS");
            val.Add(Cl_Fonction.GetStringTxt("cnps", GridView, "pgControl"));

            cle.Add("@CON1");
            val.Add(Cl_Fonction.GetIntCmb("con1", GridView, "pgControl"));
            cle.Add("@CON2");
            val.Add(Cl_Fonction.GetIntCmb("con2", GridView, "pgControl"));

            cle.Add("@CON3");
            val.Add(Cl_Fonction.GetIntCmb("con3", GridView, "pgControl"));

            /*
             * cle.Add("@LOG");
             * val.Add(Cl_Fonction.GetStringTxt("log",GridView, "pgControl"));
             *
             * cle.Add("@IMG");
             * val.Add(Cl_Fonction.GetStringTxt("img",GridView, "pgControl"));
             */
            cle.Add("@DES");
            val.Add(Cl_Fonction.GetMemo("des", GridView, "pgControl"));

            cle.Add("@BAN");
            val.Add(Cl_Fonction.GetStringTxt("ban", GridView, "pgControl"));

            cle.Add("@CODBAN");
            val.Add(Cl_Fonction.GetStringTxt("codban", GridView, "pgControl"));

            cle.Add("@CODGUI");
            val.Add(Cl_Fonction.GetStringTxt("codgui", GridView, "pgControl"));

            cle.Add("@NUMBAN");
            val.Add(Cl_Fonction.GetStringTxt("ncmpt", GridView, "pgControl"));

            cle.Add("@CLE_RIB");
            val.Add(Cl_Fonction.GetStringTxt("rib", GridView, "pgControl"));

            cle.Add("@IBAN");
            val.Add(Cl_Fonction.GetStringTxt("iban", GridView, "pgControl"));

            cle.Add("@EMAIL1");
            val.Add(Cl_Fonction.GetStringTxt("ema1", GridView, "pgControl"));

            cle.Add("@EMAIL2");
            val.Add(Cl_Fonction.GetStringTxt("ema2", GridView, "pgControl"));

            cle.Add("@LOG");
            val.Add(Session["logo"]);

            cle.Add("@WEB");
            val.Add(Cl_Fonction.GetStringTxt("web", GridView, "pgControl"));

            Cl_Fonction.Execute_Commande_StoreProc("PS_SITE", cle, val);
            //e.Cancel = true;
            GridView.CancelEdit();
            chargerGrid();
        }
        catch (Exception ex)
        {
        }
    }
예제 #20
0
    protected void Enregistrer(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        try
        {
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();

            cle.Add("@INDEX");
            val.Add("1");

            cle.Add("@ID");
            val.Add(0);

            cle.Add("@SITE_ID");
            val.Add(AuthHelper.GetLoggedInUserInfo().SiteID.ToString());

            cle.Add("@JACH");
            val.Add(Cl_Fonction.GetIntCmb("jach", GridView, "pgControl"));

            cle.Add("@JVEN");
            val.Add(Cl_Fonction.GetIntCmb("jven", GridView, "pgControl"));

            cle.Add("@JNOU");
            val.Add(Cl_Fonction.GetIntCmb("jnou", GridView, "pgControl"));

            cle.Add("@RACH");
            val.Add(Cl_Fonction.GetIntCmb("rach", GridView, "pgControl"));

            cle.Add("@RVEN");
            val.Add(Cl_Fonction.GetIntCmb("rven", GridView, "pgControl"));

            cle.Add("@ACH1");
            val.Add(Cl_Fonction.GetStringMemo("ach1", GridView, "pgControl"));

            cle.Add("@VEN1");
            val.Add(Cl_Fonction.GetStringMemo("ven1", GridView, "pgControl"));

            cle.Add("@ACH2");
            val.Add(Cl_Fonction.GetStringMemo("ach2", GridView, "pgControl"));

            cle.Add("@VEN2");
            val.Add(Cl_Fonction.GetStringMemo("ven2", GridView, "pgControl"));

            cle.Add("@STO1");
            val.Add(Cl_Fonction.GetStringMemo("sto1", GridView, "pgControl"));

            cle.Add("@PRO1");
            val.Add(Cl_Fonction.GetStringMemo("pro1", GridView, "pgControl"));

            cle.Add("@STO2");
            val.Add(Cl_Fonction.GetStringMemo("sto2", GridView, "pgControl"));

            cle.Add("@PRO2");
            val.Add(Cl_Fonction.GetStringMemo("pro2", GridView, "pgControl"));

            cle.Add("@PRE");
            val.Add(Cl_Fonction.GetStringMemo("pre", GridView, "pgControl"));

            Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMCOMPTABLE", cle, val);
            //e.Cancel = true;
            GridView.CancelEdit();
            chargerGrid();
        }
        catch (Exception ex)
        {
        }
    }
예제 #21
0
    //AJOUTER

    protected void Enregistrer(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        string idrole = Cl_Fonction.GetstringCmb("cmbrole", MainGridView);
        int idtypedoc = Cl_Fonction.GetIntCmb("cmbtypedoc", MainGridView);
        int statut = Cl_Fonction.GetIntCmb("cmbStatut", MainGridView);
        
       
        try
        {
            // on vérifie si les différents champs obligatoires ne sont pas vide
            if ((idrole.ToString() != "") && (idtypedoc.ToString() != "") && (statut.ToString() != ""))
            {
                ArrayList cle = new ArrayList();
                ArrayList val = new ArrayList();

                cle.Add("@ID_ROLE");
                val.Add(idrole);

                cle.Add("@ID_TYPEDOC");
                val.Add(idtypedoc);

                cle.Add("@STATUT");
                val.Add(statut);

                cle.Add("@SENDER");
                val.Add(1);

                cle.Add("@ID_AFFECT_ROLE");
                val.Add(0);
                

                Cl_Fonction.Execute_Commande_StoreProc("PS_AFFECTATION_ROLE_TYPEDOC", cle, val);

                string code_message = message.CodeMessage.SUCCES.ToString();
                string lib_message = Cl_Fonction.message_defini(code_message);
                MainGridView.JSProperties["cpShowPopup"] = code_message + "|" + lib_message;

                e.Cancel = true;
                MainGridView.CancelEdit();
                chargerGrid();

            }
            else
            {
                e.Cancel = true;

                string code_message = message.CodeMessage.ECHEC.ToString();
                string lib_message = Cl_Fonction.message_defini(code_message);
                MainGridView.JSProperties["cpShowPopup"] = code_message + "|" + lib_message;
            }

        }
        catch (Exception ex)
        {
            e.Cancel = true;

            string code_message = message.CodeMessage.UNEXPECTED_ERROR.ToString();
            string lib_message = Cl_Fonction.message_defini(code_message);
            MainGridView.JSProperties["cpShowPopup"] = code_message + "|" + lib_message;
        }
    }
예제 #22
0
        protected void LeftCallbackPanel_Callback(object sender, CallbackEventArgsBase e)
        {
            try
            {
                if (user != null)
                {
                    DataTable dt  = new DataTable();
                    ArrayList cle = new ArrayList();
                    ArrayList val = new ArrayList();
                    cle.Add("@LOGIN"); val.Add(user.UserName);
                    cle.Add("@ID_MENU"); val.Add(e.Parameter);
                    cle.Add("@SENDER"); val.Add(3);
                    dt = Cl_Fonction.Extraction_ds("PS_E_LIENSOUSMENU", cle, val, ref dt);

                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        string Libelle      = dt.Rows[i]["LIBELLE_SOUSMENU"].ToString();
                        string id_sous_menu = dt.Rows[i]["ID_SOUSMENU"].ToString();

                        NavBarGroup nbg = new NavBarGroup();
                        nbg.Text = Libelle;
                        navbarMain.Groups.Add(nbg);

                        ////**************Lien************************//
                        DataTable dtlien  = new DataTable();
                        ArrayList clelien = new ArrayList();
                        ArrayList vallien = new ArrayList();
                        clelien.Add("@LOGIN"); vallien.Add(user.UserName);
                        clelien.Add("@ID_SOUSMENU"); vallien.Add(Convert.ToInt32(id_sous_menu));
                        clelien.Add("@SENDER"); vallien.Add(1);
                        dtlien = Cl_Fonction.Extraction_ds("PS_E_LIENSOUSMENU", clelien, vallien, ref dtlien);

                        for (int ilien = 0; ilien < dtlien.Rows.Count; ilien++)
                        {
                            string LibelleLien = dtlien.Rows[ilien]["LIBELLE_LIENSOUSMENU"].ToString();
                            string idLien      = dtlien.Rows[ilien]["ID_LIENSOUSMENU"].ToString();
                            string Chemin      = dtlien.Rows[ilien]["CHEMIN"].ToString();
                            string Icone       = dtlien.Rows[ilien]["ICONE"].ToString();

                            string Libellestatut   = dtlien.Rows[ilien]["STATUT"].ToString();
                            string ID_TYPEDOCUMENT = dtlien.Rows[ilien]["ID_LIENSOUSMENU"].ToString();

                            string affichermontant = dtlien.Rows[ilien]["AFFICHER_MONTANT"].ToString();
                            string accederdate     = dtlien.Rows[ilien]["ACCEDER_DATE"].ToString();

                            //DataTable dtlienstatut = new DataTable();
                            //ArrayList clelienstatut = new ArrayList();
                            //ArrayList vallienstatut = new ArrayList();
                            //clelienstatut.Add("@LIEN_SOUSMENU");
                            //vallienstatut.Add(idLien);
                            //clelienstatut.Add("@USERNAME");
                            //vallienstatut.Add(user.UserName);
                            //dtlienstatut = Cl_Fonction.Extraction_ds("PS_STATUT_USER", clelienstatut, vallienstatut, ref dtlienstatut);

                            //string ID_TYPEDOCUMENT = dtlienstatut.Rows[0]["ID_TYPEDOCUMENT"].ToString();

                            navbarMain.Groups.FindByText(Libelle.Trim()).Items.Add(LibelleLien.Trim()).Name             = Chemin + "|" + Libellestatut + "|" + ID_TYPEDOCUMENT + "|" + idLien + "|" + affichermontant + "|" + accederdate;
                            navbarMain.Groups.FindByText(Libelle.Trim()).Items.FindByText(LibelleLien.Trim()).Image.Url = Icone.Trim();
                        }
                        //**************Fin Lien*******************//
                    }
                }
                else
                {
                    HttpContext.Current.Response.RedirectLocation = System.Web.VirtualPathUtility.ToAbsolute("~/Account/SignIn.aspx");
                }
            }
            catch (Exception ex)
            {
                log.Info("Error : " + ex + "; Method : " + Cl_Fonction.GetCurrentMethod());
            }
        }