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