//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"; } } }
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; } }
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(); }
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); } }
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(); }
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(); }
//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(); }
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(); }
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(); }
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(); }
//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"; } }
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"); } } }
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", }); }
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("~/"); } }
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"; }
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) { } }
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) { } }
//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; } }
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()); } }