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