protected void Page_Load(object sender, EventArgs e)
{
this.countMe();
DataSet tmpDs = new DataSet();
tmpDs.ReadXml(Server.MapPath("~/res/xml/counter.xml"));
visitcounter.Text = tmpDs.Tables[0].Rows[0]["hitcounter"].ToString();
//CHECK COOKIES CONSENT
if (Request.Cookies["CookieConsent"] != null)
{
cookieConsent.Visible = false;
}
if (Session["id"] == null)
{
login.Visible = true;
logout.Visible = false;
account.Visible = false;
list_users.Visible = false;
newsletter.Visible = false;
my_activities.Visible = false;
invitations.Visible = false;
}
else
{
db = new SQLDatabase();
db.Connect();
login.Visible = false;
logout.Visible = true;
account.Visible = true;
reg.Visible = false;
list_users.Visible = false;
newsletter.Visible = false;
my_activities.Visible = true;
invitations.Visible = true;
hello_user.Text = "Hello " + db.getNickname_email((string)Session["id"]);
if (db.getType_User(db.getId((string)Session["id"])).Equals("administrator"))
{
list_users.Visible = true;
newsletter.Visible = true;
my_activities.Visible = false;
invitations.Visible = false;
}
db.Disconnect();
}
}
protected void Prepare_Email(object sender, EventArgs e)
{
db = new SQLDatabase();
db.Connect();
List <String> lists_email = new List <string>();
list_users = db.ListUsers();
if (volounteers.Checked)
{
for (int i = 0; i < list_users.Count(); i++)
{
if (list_users.ElementAt(i).type.Equals("volounteer"))
{
lists_email.Add(list_users.ElementAt(i).email);
}
}
}
if (needies.Checked)
{
for (int i = 0; i < list_users.Count(); i++)
{
if (list_users.ElementAt(i).type.Equals("needy"))
{
lists_email.Add(list_users.ElementAt(i).email);
}
}
}
if (all.Checked)
{
for (int i = 0; i < list_users.Count(); i++)
{
lists_email.Add(list_users.ElementAt(i).email);
}
}
for (int i = 0; i < lists_email.Count(); i++)
{
Send_Email(lists_email.ElementAt(i), db.getNickname_email(lists_email.ElementAt(i)), subject.Value, TextArea1.Text);
}
db.Disconnect();
}
