protected void Edit_Data(object sender, EventArgs e)
{
db = new SQLDatabase();
db.Connect();
list_users = db.ListUsers();
string sex = "";
string type = "";
if (!male.Checked && !female.Checked)
{
sex = list_users.ElementAt(id_i).sex;
}
else
{
if (male.Checked)
{
sex = "male";
}
else
{
sex = "female";
}
}
if (!volounteer.Checked && !needy.Checked)
{
type = list_users.ElementAt(id_i).type;
}
else
{
if (volounteer.Checked)
{
type = "volounteer";
}
else
{
type = "needy";
}
}
if (birthDate.Value == "")
{
birthDate.Value = list_users.ElementAt(id_i).birth_date.ToString("yyyy-MM-dd");
}
db.EditAccount(id, nickname.Value, pesel.Value, inputEmail.Value, telephone.Value, name.Value, surname.Value, birthDate.Value, sex, type);
if (!inputEmail.Value.Equals(email))
{
Session.RemoveAll();
Response.Redirect("Login.aspx");
}
else
{
Response.Redirect("MyAccount.aspx");
}
db.Disconnect();
}
protected void Form_Data(object sender, EventArgs e)
{
data_form.Visible = true;
password_form.Visible = false;
db = new SQLDatabase();
db.Connect();
list_users = db.ListUsers();
nickname.Value = list_users.ElementAt(id_i).nickname;
inputEmail.Value = list_users.ElementAt(id_i).email;
name.Value = list_users.ElementAt(id_i).name;
surname.Value = list_users.ElementAt(id_i).surname;
telephone.Value = list_users.ElementAt(id_i).telephone;
pesel.Value = list_users.ElementAt(id_i).pesel;
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();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id_e"] != null)
{
id_e = int.Parse(Request.QueryString["id_e"]);
}
db = new SQLDatabase();
html = new StringBuilder();
db.Connect();
list_users = db.ListUsers();
html.Append("<table border = '1' align='center'>");
html.Append("<tr>");
html.Append("<th>Id</th><th>Imię</th><th>Nazwisko</th><th>Nickname</th><th>E-mail</th><th>Płeć</th><th>Telefon</th>");
html.Append("</tr>");
for (int i = 0; i < list_users.Count; i++)
{
if (list_users.ElementAt(i).type.Equals("volounteer"))
{
html.Append("<tr>");
html.Append("<td>" + list_users.ElementAt(i).id + "</td>");
html.Append("<td>" + list_users.ElementAt(i).name + "</td>");
html.Append("<td>" + list_users.ElementAt(i).surname + "</td>");
html.Append("<td>" + list_users.ElementAt(i).nickname + "</td>");
html.Append("<td>" + list_users.ElementAt(i).email + "</td>");
html.Append("<td>" + list_users.ElementAt(i).sex + "</td>");
html.Append("<td>" + list_users.ElementAt(i).telephone + "</td>");
html.Append("<td><a href=\"Invite.aspx?id_u=" + list_users.ElementAt(i).id + "&id_e=" + id_e + "\">Zaproś</a></td>");
html.Append("</tr>");
}
}
html.Append("</table>");
html.Append("<br/><br/>");
PlaceHolder1.Controls.Add(new Literal {
Text = html.ToString()
});
db.Disconnect();
}
protected void Page_Load(object sender, EventArgs e)
{
db = new SQLDatabase();
html = new StringBuilder();
db.Connect();
list_users = db.ListUsers();
id = db.getId((string)Session["id"]);
html.Append("<table border = '1' align='center'>");
for (int i = 0; i < list_users.Count; i++)
{
if (list_users.ElementAt(i).id.Equals(id))
{
html.Append("<tr><td>Id</td> <td>" + list_users.ElementAt(i).id + "</td></tr>");
html.Append("<tr><td>Imię</td> <td>" + list_users.ElementAt(i).name + "</td></tr>");
html.Append("<tr><td>Nazwisko</td> <td>" + list_users.ElementAt(i).surname + "</td></tr>");
html.Append("<tr><td>Nickname</td> <td>" + list_users.ElementAt(i).nickname + "</td></tr>");
html.Append("<tr><td>E-mail</td> <td>" + list_users.ElementAt(i).email + "</td></tr>");
html.Append("<tr><td>Płeć</td> <td>" + list_users.ElementAt(i).sex + "</td></tr>");
html.Append("<tr><td>Telefon</td> <td>" + list_users.ElementAt(i).telephone + "</td></tr>");
html.Append("<tr><td>Data urodzenia</td> <td>" + list_users.ElementAt(i).birth_date.ToString("yyyy-MM-dd") + "</td></tr>");
html.Append("<tr><td>Typ użytkownika</td> <td>" + list_users.ElementAt(i).type + "</td></tr>");
html.Append("<tr><td>Pesel</td> <td>" + list_users.ElementAt(i).pesel + "</td></tr>");
email = list_users.ElementAt(i).email;
pass = list_users.ElementAt(i).password;
id_i = i;
}
}
html.Append("</table>");
html.Append("<br/><br/>");
PlaceHolder1.Controls.Add(new Literal {
Text = html.ToString()
});
db.Disconnect();
}
