public static void GetEmailFile(string path, Page current) { ElevesHelper eh = new ElevesHelper(); System.Data.DataSet dsEmails = eh.EmailsLookup(); System.Data.DataTable dt = dsEmails.Tables[0]; String filepath = current.Server.MapPath(path); System.IO.StreamWriter sw = new System.IO.StreamWriter(filepath, false); int iColCount = dt.Columns.Count; foreach (System.Data.DataRow dr in dt.Rows) { for (int i = 0; i < iColCount; i++) { if (!Convert.IsDBNull(dr[i])) { sw.Write(dr[i].ToString()); } if (i < iColCount - 1) { sw.Write(","); } } sw.Write(";"); sw.Write(sw.NewLine); } sw.Close(); }
protected void Page_Load(object sender, EventArgs e) { int radiovalue = 0; if (!Page.IsPostBack) { if (!String.IsNullOrEmpty(HttpContext.Current.Request.QueryString["s"])) { radiovalue = Convert.ToInt32(HttpContext.Current.Request.QueryString["s"]); } switch (radiovalue) { case -1: RadioButtonList1.SelectedValue = "All"; break; case 0: RadioButtonList1.SelectedValue = "NotEnrolled"; break; case 1: RadioButtonList1.SelectedValue = "Enrolled"; break; } ElevesHelper eh = new ElevesHelper(); ddlFamilySearch.DataSource = eh.FamilyNamesLookup(); ddlFamilySearch.DataTextField = "Nom"; ddlFamilySearch.DataValueField = "ID"; ddlFamilySearch.DataBind(); } }
protected void Button2_Click(object sender, EventArgs e) { ElevesHelper eh = new ElevesHelper(); int executed = eh.Insert(tablename, CreateDictionary()); if (executed == 1) { Label1.Text = "Nouvelles infos enregistrées avec succès"; EmptyTextBoxes(); BindDataGrid(); } else { String message = "Une erreur est survenue."; Label1.Text = message; } }
protected void Emails_Click(object sender, EventArgs e) { ElevesHelper.GetEmailFile("fichiers.txt", Page); Response.Redirect("~/fichiers/emails.txt"); }
protected void Page_Load(object sender, EventArgs e) { HtmlGenericControl body = (HtmlGenericControl)Master.FindControl("master"); body.Attributes.Add("class", "admin"); tablename = HttpContext.Current.Request.QueryString["t"]; userrole = LoginHelper.UserRole(Page.User.Identity.Name); if (userrole != "admin") { AllPanel.Visible = false; Label1.Text = "Vous n'avez pas la permission d'utiliser cette page. Veuillez contacter [email protected] si vous pensez que c'est une erreur."; } else { eh = new ElevesHelper(); columns = new ArrayList(); if (tablename == "" | tablename == null) { Label1.Text = "Aucune table n'a été sélectionnée."; } else { litTableName.Text = tablename; tbs = PageHelper.CreateTextBoxes(PageHelper.ColumnNames(eh.GetContactsDataSet("SELECT * from " + tablename).Tables[0])); Table tbl = new Table(); InputPanel.Controls.Add(tbl); int counter = 0; foreach (TextBox tb in tbs) { columns.Add(tb.ID.Substring(PREFIX_LENGTH)); TableRow tr = new TableRow(); TableCell td1 = new TableCell(); TableCell td2 = new TableCell(); tbl.Controls.Add(tr); tr.Controls.Add(td1); tr.Controls.Add(td2); Label lb = new Label(); lb.Text = LoginHelper.GetColumnComment(tablename, tb.ID.Substring(PREFIX_LENGTH)); td1.Controls.Add(lb); td2.Controls.Add(tb); counter++; } if (!IsPostBack) { if (Page.User.Identity.Name == "*****@*****.**") { Label1.Text = "Super admin"; GridView1.AutoGenerateEditButton = true; GridView1.AutoGenerateDeleteButton = true; } else { GridView1.AutoGenerateEditButton = false; GridView1.AutoGenerateDeleteButton = false; } BindDataGrid(); } } } }