protected void btnMAJ_Click(object sender, EventArgs e)
{
String selectedUsername = txtUsername.Text;
String password = txtPassword.Text;
String email = txtEmail.Text;
using (MySqlConnection con = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"))
{
using (MySqlCommand cmd = new MySqlCommand("UPDATE bachelor SET username = @Username WHERE id = @idUser"))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
/*
* cmd.Parameters.AddWithValue("@username", username);
* cmd.Parameters.AddWithValue("@password", password);
* cmd.Parameters.AddWithValue("@email", email);
*/
cmd.Parameters.AddWithValue("@Username", new LiteralControl(selectedUsername));
cmd.Parameters.AddWithValue("@idUser", ((Bachelor)Session["profile"]).Id);
cmd.Connection = con;
con.Open();
int nombreDeLignesAffectees = cmd.ExecuteNonQuery();
if (nombreDeLignesAffectees > 0)
{
bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-success\"><strong>BRAVO !</strong> Vos informations ont été modifiées.</div>"));
Bachelor temp = (Bachelor)Session["profile"];
temp.Username = txtUsername.Text;
temp.Password = txtPassword.Text;
temp.Email = txtEmail.Text;
Session["profile"] = temp;
}
else
{
bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-danger\"><strong>ERREUR !</strong> Vos informations n'ont pas pu être modifiées...</div>"));
}
con.Close();
}
}
}
/*//int x = 0;
* using (DbDataReader dbrdr = cmd.ExecuteReader())
* {
* if (dbrdr.Read())
* {
* }
* //Page_Load(object sender, EventArgs e);
* lblMessage.Text = "<h3 style=\"color:green\">Profile Updated !!</h3>"+cmd.CommandText;
* this.Load += this.Page_Load;
* }*/
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isConnected"] == null) Response.Redirect("login.aspx");
/*
if (IsPostBack)
{
int idMusicGenres = 0;
if (Request.Form["musicGenres"] != null)
{
int.TryParse(Request.Form["musicGenres"].ToString(), out idMusicGenres);
}
int idBookGenres;
if (Request.Form["bookGenres"] != null)
{
int.TryParse(Request.Form["bookGenres"].ToString(), out idBookGenres);
}
int idMovieGenres;
int.TryParse(Request.Form["movieGenres"].ToString(), out idMovieGenres);
int idBrands;
int.TryParse(Request.Form["brands"].ToString(), out idBrands);
int idHobbies;
int.TryParse(Request.Form["hobbies"].ToString(), out idHobbies);
int idSports;
int.TryParse(Request.Form["Sports"].ToString(), out idSports);
MySqlConnection cnx0 = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen");
cnx0.Open();
MySqlCommand cmd0 = cnx0.CreateCommand();
cmd0.CommandType = CommandType.Text;
cmd0.CommandText = "UPDATE bachelor SET idmusicgenres=@idMusicGenres WHERE id=@idUser";
cmd0.Parameters.AddWithValue("@idMusicGenres", idMusicGenres);
cmd0.Parameters.AddWithValue("@idUser", ((Bachelor)Session["profile"]).Id);
int nombreLignesAffectees = cmd0.ExecuteNonQuery();
if (nombreLignesAffectees > 0)
bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-success\"><strong>BRAVO !</strong> Vos intérêts ont été modifiés.</div>"));
else
bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-danger\"><strong>ERREUR !</strong> Vos intérêts n'ont pas pu être modifiés...</div>"));
cnx0.Close();
}
*/
if (Session["profile"] != null)
{
unBachelor = (Bachelor)Session["profile"];
txtId.Text = unBachelor.Id.ToString();
txtUsername.Text = unBachelor.Username;
txtPassword.Text = unBachelor.Password;
txtEmail.Text = unBachelor.Email;
txtNumberOfLikes.Text = unBachelor.NumberOfLikes.ToString();
pbxImage.ImageUrl = unBachelor.Image;
pbxImage.Height = 300;
pbxImage.Width = 530;
}
MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen");
cnx.Open();
MySqlCommand cmd = cnx.CreateCommand();
cmd.CommandType = CommandType.Text;
// Chercher les champs d'intérêt de l'utilisateur
cmd.CommandText = "SELECT * FROM bachelor WHERE id = @idBachelor";
cmd.Parameters.AddWithValue("@idBachelor", unBachelor.Id);
Bachelor temp = new Bachelor();
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
if (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["idbookgenres"].ToString(), out id);
temp.IdBookGenres = id;
int.TryParse(dbrdr["idbrands"].ToString(), out id);
temp.IdBrands = id;
int.TryParse(dbrdr["idhobbies"].ToString(), out id);
temp.IdHobbies = id;
int.TryParse(dbrdr["idmoviegenres"].ToString(), out id);
temp.IdMovieGenres = id;
int.TryParse(dbrdr["idmusicgenres"].ToString(), out id);
temp.IdMusicGenres = id;
int.TryParse(dbrdr["idsports"].ToString(), out id);
temp.IdSports = id;
}
}
// bookgenres
cmd.CommandText = "SELECT * FROM bookgenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlBooks.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdBookGenres))
{
ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom);
ddlBooks.SelectedIndex = ddlBooks.Items.IndexOf(ddlBooks.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
// brands
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM brands ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlBrands.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdBrands))
{
ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom);
ddlBrands.SelectedIndex = ddlBrands.Items.IndexOf(ddlBrands.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
// hobbies
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM hobbies ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlHobbies.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdHobbies))
{
ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom);
ddlHobbies.SelectedIndex = ddlHobbies.Items.IndexOf(ddlHobbies.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
// musicGenres
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM musicgenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
//LiteralControl chaineHtml = new LiteralControl();
//chaineHtml.Text = "<select id=\"musicGenres\" width=\"100%\" class=\"form-control\">";
if (ddlMusic.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdMusicGenres))
{
//chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\" selected=\"selected\">" + uneListeDeChampInterets[i].Nom + "</option>";
ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom);
ddlMusic.SelectedIndex = ddlMusic.Items.IndexOf(ddlMusic.Items.FindByText(uneListeDeChampInterets[i].Nom));// source de: http://stackoverflow.com/questions/3496456/setting-dropdownlist-selecteditem-programmatically
}
else
//chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
//chaineHtml.Text += "</select>";
//musicGenres.Controls.Add(chaineHtml);
}
// sports
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM sports ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlSports.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdSports))
{
ddlSports.Items.Add(uneListeDeChampInterets[i].Nom);
ddlSports.SelectedIndex = ddlSports.Items.IndexOf(ddlSports.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
ddlSports.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
// movieGenres
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM moviegenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlMovies.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdMovieGenres))
{
ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom);
ddlMovies.SelectedIndex = ddlMovies.Items.IndexOf(ddlMovies.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
cnx.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isConnected"] == null) Response.Redirect("login.aspx");
if (Session["profile"] != null)
{
unBachelor = (Bachelor)Session["profile"];
txtId.Text = unBachelor.Id.ToString();
txtUsername.Text = unBachelor.Username;
txtPassword.Text = unBachelor.Password;
txtEmail.Text = unBachelor.Email;
txtNumberOfLikes.Text = unBachelor.NumberOfLikes.ToString();
pbxImage.ImageUrl = unBachelor.Image;
pbxImage.Height=300;
pbxImage.Width = 530;
}
MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen");
cnx.Open();
MySqlCommand cmd = cnx.CreateCommand();
cmd.CommandType = CommandType.Text;
// bookgenres
cmd.CommandText = "SELECT * FROM bookgenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<select id=\"booksGenres\" width=\"100%\">";
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
//if(uneListeDeChampInterets[i].Id.Equals(unBachelor.);
chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
}
chaineHtml.Text += "</select>";
bookGenres.Controls.Add(chaineHtml);
}
// brands
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM brands ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<select id=\"brands\" width=\"100%\">";
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
chaineHtml.Text += "</select>";
brands.Controls.Add(chaineHtml);
}
// hobbies
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM hobbies ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<select id=\"hobbies\" width=\"100%\">";
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
chaineHtml.Text += "</select>";
hobbies.Controls.Add(chaineHtml);
}
// musicGenres
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM musicgenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<select id=\"musicGenres\" width=\"100%\">";
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
chaineHtml.Text += "</select>";
musicGenres.Controls.Add(chaineHtml);
}
// sports
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM sports ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<select id=\"sports\" width=\"100%\">";
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
chaineHtml.Text += "</select>";
sports.Controls.Add(chaineHtml);
}
// moveiGenres
uneListeDeChampInterets = new List<Interest>();
cmd.CommandText = "SELECT * FROM moviegenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<select id=\"movieGenres\" width=\"100%\">";
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
chaineHtml.Text += "</select>";
movieGenres.Controls.Add(chaineHtml);
}
cnx.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isConnected"] == null)
{
Response.Redirect("login.aspx");
}
if (Session["profile"] != null)
{
Bachelor unBachelor = (Bachelor)Session["profile"];
lblMessageDeBienvenue.Text = "<h1>Bonjour " + unBachelor.Username + ", bienvenue sur Amélia</h1>";
}
MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen");
cnx.Open();
MySqlCommand cmd = cnx.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM bachelor ORDER BY numberOfLikes DESC LIMIT 10";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String username = dbrdr["username"].ToString();
String password = dbrdr["password"].ToString();
String email = dbrdr["email"].ToString();
int numberOfLikes;
int.TryParse(dbrdr["numberOfLikes"].ToString(), out numberOfLikes);
String imagePath = dbrdr["image"].ToString();
int idBookGenres;
int.TryParse(dbrdr["idbookgenres"].ToString(), out idBookGenres);
int idBrands;
int.TryParse(dbrdr["idbrands"].ToString(), out idBrands);
int idHobbies;
int.TryParse(dbrdr["idHobbies"].ToString(), out idHobbies);
int idMovieGenres;
int.TryParse(dbrdr["idmoviegenres"].ToString(), out idMovieGenres);
int idMusicGenres;
int.TryParse(dbrdr["idmusicgenres"].ToString(), out idMusicGenres);
int idSports;
int.TryParse(dbrdr["idsports"].ToString(), out idSports);
uneListeDeBacheliers.Add(new Bachelor(id, username, password, email, numberOfLikes, imagePath, idBookGenres, idBrands, idHobbies, idMovieGenres, idMusicGenres, idSports));
//lblMessage.Text += id + username + password + email + numberOfLikes;
}
LiteralControl chaineHtml = new LiteralControl();
chaineHtml.Text = "<table border=\"1px solid black\" style=\"float:left;padding:10px\">";
chaineHtml.Text += "<tr><th>Rang</th><th>username</th><th>Likes</th></tr>";
for (int i = 0; i < uneListeDeBacheliers.Count; i++)
{
chaineHtml.Text += "<tr>";
chaineHtml.Text += "<td>" + (i + 1) + "</td>";
//chaineHtml.Text += "<td>" + uneListeDeBacheliers[i].Id + "</td>";
chaineHtml.Text += "<td>" + uneListeDeBacheliers[i].Username + "</td>";
chaineHtml.Text += "<td>" + uneListeDeBacheliers[i].NumberOfLikes + "</td>";
chaineHtml.Text += "</tr>";
}
chaineHtml.Text += "</table>";
leaderboard.Controls.Add(chaineHtml);
}
cnx.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isConnected"] == null)
{
Response.Redirect("login.aspx");
}
/*
* if (IsPostBack)
* {
* int idMusicGenres = 0;
* if (Request.Form["musicGenres"] != null)
* {
* int.TryParse(Request.Form["musicGenres"].ToString(), out idMusicGenres);
* }
* int idBookGenres;
* if (Request.Form["bookGenres"] != null)
* {
* int.TryParse(Request.Form["bookGenres"].ToString(), out idBookGenres);
* }
* int idMovieGenres;
* int.TryParse(Request.Form["movieGenres"].ToString(), out idMovieGenres);
* int idBrands;
* int.TryParse(Request.Form["brands"].ToString(), out idBrands);
* int idHobbies;
* int.TryParse(Request.Form["hobbies"].ToString(), out idHobbies);
* int idSports;
* int.TryParse(Request.Form["Sports"].ToString(), out idSports);
* MySqlConnection cnx0 = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen");
* cnx0.Open();
* MySqlCommand cmd0 = cnx0.CreateCommand();
* cmd0.CommandType = CommandType.Text;
* cmd0.CommandText = "UPDATE bachelor SET idmusicgenres=@idMusicGenres WHERE id=@idUser";
* cmd0.Parameters.AddWithValue("@idMusicGenres", idMusicGenres);
* cmd0.Parameters.AddWithValue("@idUser", ((Bachelor)Session["profile"]).Id);
* int nombreLignesAffectees = cmd0.ExecuteNonQuery();
* if (nombreLignesAffectees > 0)
* bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-success\"><strong>BRAVO !</strong> Vos intérêts ont été modifiés.</div>"));
* else
* bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-danger\"><strong>ERREUR !</strong> Vos intérêts n'ont pas pu être modifiés...</div>"));
* cnx0.Close();
* }
*/
if (Session["profile"] != null)
{
unBachelor = (Bachelor)Session["profile"];
txtId.Text = unBachelor.Id.ToString();
txtUsername.Text = unBachelor.Username;
txtPassword.Text = unBachelor.Password;
txtEmail.Text = unBachelor.Email;
txtNumberOfLikes.Text = unBachelor.NumberOfLikes.ToString();
pbxImage.ImageUrl = unBachelor.Image;
pbxImage.Height = 300;
pbxImage.Width = 530;
}
MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen");
cnx.Open();
MySqlCommand cmd = cnx.CreateCommand();
cmd.CommandType = CommandType.Text;
// Chercher les champs d'intérêt de l'utilisateur
cmd.CommandText = "SELECT * FROM bachelor WHERE id = @idBachelor";
cmd.Parameters.AddWithValue("@idBachelor", unBachelor.Id);
Bachelor temp = new Bachelor();
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
if (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["idbookgenres"].ToString(), out id);
temp.IdBookGenres = id;
int.TryParse(dbrdr["idbrands"].ToString(), out id);
temp.IdBrands = id;
int.TryParse(dbrdr["idhobbies"].ToString(), out id);
temp.IdHobbies = id;
int.TryParse(dbrdr["idmoviegenres"].ToString(), out id);
temp.IdMovieGenres = id;
int.TryParse(dbrdr["idmusicgenres"].ToString(), out id);
temp.IdMusicGenres = id;
int.TryParse(dbrdr["idsports"].ToString(), out id);
temp.IdSports = id;
}
}
// bookgenres
cmd.CommandText = "SELECT * FROM bookgenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlBooks.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdBookGenres))
{
ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom);
ddlBooks.SelectedIndex = ddlBooks.Items.IndexOf(ddlBooks.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
{
ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
}
// brands
uneListeDeChampInterets = new List <Interest>();
cmd.CommandText = "SELECT * FROM brands ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlBrands.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdBrands))
{
ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom);
ddlBrands.SelectedIndex = ddlBrands.Items.IndexOf(ddlBrands.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
{
ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
}
// hobbies
uneListeDeChampInterets = new List <Interest>();
cmd.CommandText = "SELECT * FROM hobbies ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlHobbies.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdHobbies))
{
ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom);
ddlHobbies.SelectedIndex = ddlHobbies.Items.IndexOf(ddlHobbies.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
{
ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
}
// musicGenres
uneListeDeChampInterets = new List <Interest>();
cmd.CommandText = "SELECT * FROM musicgenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
//LiteralControl chaineHtml = new LiteralControl();
//chaineHtml.Text = "<select id=\"musicGenres\" width=\"100%\" class=\"form-control\">";
if (ddlMusic.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdMusicGenres))
{
//chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\" selected=\"selected\">" + uneListeDeChampInterets[i].Nom + "</option>";
ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom);
ddlMusic.SelectedIndex = ddlMusic.Items.IndexOf(ddlMusic.Items.FindByText(uneListeDeChampInterets[i].Nom));// source de: http://stackoverflow.com/questions/3496456/setting-dropdownlist-selecteditem-programmatically
}
else
{
//chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\">" + uneListeDeChampInterets[i].Nom + "</option>";
ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
//chaineHtml.Text += "</select>";
//musicGenres.Controls.Add(chaineHtml);
}
// sports
uneListeDeChampInterets = new List <Interest>();
cmd.CommandText = "SELECT * FROM sports ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlSports.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdSports))
{
ddlSports.Items.Add(uneListeDeChampInterets[i].Nom);
ddlSports.SelectedIndex = ddlSports.Items.IndexOf(ddlSports.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
{
ddlSports.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
}
// movieGenres
uneListeDeChampInterets = new List <Interest>();
cmd.CommandText = "SELECT * FROM moviegenres ORDER BY id";
using (DbDataReader dbrdr = cmd.ExecuteReader())
{
while (dbrdr.Read())
{
int id;
int.TryParse(dbrdr["id"].ToString(), out id);
String nom = dbrdr["nom"].ToString();
uneListeDeChampInterets.Add(new Interest(id, nom));
}
if (ddlMovies.Items.Count <= 1)
{
for (int i = 0; i < uneListeDeChampInterets.Count; i++)
{
if (uneListeDeChampInterets[i].Id.Equals(temp.IdMovieGenres))
{
ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom);
ddlMovies.SelectedIndex = ddlMovies.Items.IndexOf(ddlMovies.Items.FindByText(uneListeDeChampInterets[i].Nom));
}
else
{
ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom);
}
}
}
}
cnx.Close();
}
