public static void Sql()
{
Thread.Sleep(2000); //Le thread à besoin d'attendre que la liste finale se remplisse
#region Connexion
connection = new MySqlConnection(connectionString);
try
{
connection.Open(); //Ouverture de la connection
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Impossible de se conncter, verifiez les parametres de la connexion");
}
#endregion
while (!_quitter)
{
InstaSharp.Model.Media m = new InstaSharp.Model.Media();
try
{
m = listefinale[placemedia]; //on choisit le media dans la liste
}
catch (Exception el)
{ }
string requete; //va contenir la requete
MySqlCommand command; //variable pour éxécuter la commande
try
{
//ici on rentre les users
requete = "INSERT INTO `isngr9`.`user` (`idUser`, `username`, `fullname`, `profilPicture`) VALUES ('" + m.User.Id + "', '" + m.User.Username + "', '" + m.User.FullName + "','" + m.User.ProfilePicture + "');";
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
compteurSql++;
}
catch (Exception ex) { }
try
{
if (m.Location.Name != null) // on teste si la location possède une place (un nom et un id, car sinon ceux ci sont nul et on à une erreur
{
try
{
requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "', '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');";
//MessageBox.Show(requete);
command = new MySqlCommand(requete, connection);
System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime); //On écrit dans un fichier texte le temps de la dernière photo entré, pour reprendre en cas de crash;
command.ExecuteNonQuery();
requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `latitude`, `idLieu`, `longitude`, `name`,`idMedia`) VALUES (NULL, '" + m.Location.Latitude + "', '" + m.Location.Id + "', '" + m.Location.Longitude + "', '" + m.Location.Name + "','" + m.Id + "');";
//MessageBox.Show(requete);
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
}
catch (Exception ex) { }
}
else
{
try
{
requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "' , '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');";
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime);
requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `idLieu`, `latitude`, `longitude`, `name`, `idMedia`) VALUES (NULL, '0', '" + m.Location.Latitude + "', '" + m.Location.Longitude + "', 'null','" + m.Id + "');";
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
}
catch (Exception ex) { }
}
placemedia++; //on va au media suivant
}
catch (Exception el) { }
}
}
public static List<InstaSharp.Model.Media> lirexml(string fichier)
{
List<InstaSharp.Model.Media> listmedia = new List<InstaSharp.Model.Media>();
XmlDocument doc = new XmlDocument();
doc.Load(fichier);
XmlNode noeud = doc.FirstChild.FirstChild;
while (noeud != null)
{
switch (noeud.Name)
{
case "data":
InstaSharp.Model.Media media = new InstaSharp.Model.Media();
List<InstaSharp.Model.Tag> listtag = new List<InstaSharp.Model.Tag>();
media.Tags = listtag;
int compteurenfant = 0;
while (compteurenfant < noeud.ChildNodes.Count)
{
try
{
//string s = noeud.FirstChild.NextSibling.Name;
switch (noeud.ChildNodes[compteurenfant].Name)
{
#region Location
case "location":
InstaSharp.Model.Location location = new InstaSharp.Model.Location();
if (noeud.ChildNodes[compteurenfant].ChildNodes.Count == 4)
{
location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
location.Name = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText.Replace("'", "''");
location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText;
location.Id = Convert.ToInt32(noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText);
media.Location = location;
}
else
{
location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText;
media.Location = location;
}
break;
#endregion
#region Tag
case "tags":
InstaSharp.Model.Tag t = new InstaSharp.Model.Tag();
t.Name = noeud.ChildNodes[compteurenfant].InnerText;
listtag.Add(t);
media.Tags = listtag;
string s = media.Tags.Count.ToString();
break;
#endregion
#region Time
case "created_time":
media.CreatedTime = noeud.ChildNodes[compteurenfant].InnerText;
break;
#endregion
#region Id
case "id":
media.Id = noeud.ChildNodes[compteurenfant].InnerText;
break;
#endregion
#region Like
case "likes":
InstaSharp.Model.Like like = new InstaSharp.Model.Like();
like.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
media.Likes = like;
break;
#endregion
#region Coomments
case "comments":
InstaSharp.Model.Comments comments = new InstaSharp.Model.Comments();
comments.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
media.Comments = comments;
break;
#endregion
#region Type
case "type":
media.Type = noeud.ChildNodes[compteurenfant].InnerText;
break;
#endregion
#region User
case "user":
InstaSharp.Model.User user = new InstaSharp.Model.User();
user.Username = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText.Replace("'", "''");
user.ProfilePicture = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText;
user.Id = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText;
user.FullName = noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText.Replace("'", "''");
media.User = user;
break;
#endregion
}
}
catch (Exception e)
{
}
compteurenfant++;
}
listmedia.Add(media);
break;
}
noeud = noeud.NextSibling;
}
// XmlNodeList elements = doc.DocumentElement.SelecSingletNodes("//data");
return listmedia;
}
public static void Sql()
{
Thread.Sleep(2000); //Le thread à besoin d'attendre que la liste finale se remplisse
#region Connexion
connection = new MySqlConnection(connectionString);
try
{
connection.Open(); //Ouverture de la connection
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Impossible de se conncter, verifiez les parametres de la connexion");
}
#endregion
while (!_quitter)
{
InstaSharp.Model.Media m = new InstaSharp.Model.Media();
try
{
m = listefinale[placemedia]; //on choisit le media dans la liste
}
catch (Exception el)
{ }
string requete; //va contenir la requete
MySqlCommand command; //variable pour éxécuter la commande
try
{
//ici on rentre les users
requete = "INSERT INTO `isngr9`.`user` (`idUser`, `username`, `fullname`, `profilPicture`) VALUES ('" + m.User.Id + "', '" + m.User.Username + "', '" + m.User.FullName + "','" + m.User.ProfilePicture + "');";
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
compteurSql++;
}
catch (Exception ex) { }
try
{
if (m.Location.Name != null) // on teste si la location possède une place (un nom et un id, car sinon ceux ci sont nul et on à une erreur
{
try
{
requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "', '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');";
//MessageBox.Show(requete);
command = new MySqlCommand(requete, connection);
System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime); //On écrit dans un fichier texte le temps de la dernière photo entré, pour reprendre en cas de crash;
command.ExecuteNonQuery();
requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `latitude`, `idLieu`, `longitude`, `name`,`idMedia`) VALUES (NULL, '" + m.Location.Latitude + "', '" + m.Location.Id + "', '" + m.Location.Longitude + "', '" + m.Location.Name + "','" + m.Id + "');";
//MessageBox.Show(requete);
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
}
catch (Exception ex) { }
}
else
{
try
{
requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "' , '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');";
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime);
requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `idLieu`, `latitude`, `longitude`, `name`, `idMedia`) VALUES (NULL, '0', '" + m.Location.Latitude + "', '" + m.Location.Longitude + "', 'null','" + m.Id + "');";
command = new MySqlCommand(requete, connection);
command.ExecuteNonQuery();
}
catch (Exception ex) { }
}
placemedia++; //on va au media suivant
}
catch (Exception el) { }
}
}
public static List <InstaSharp.Model.Media> lirexml(string fichier)
{
List <InstaSharp.Model.Media> listmedia = new List <InstaSharp.Model.Media>();
XmlDocument doc = new XmlDocument();
doc.Load(fichier);
XmlNode noeud = doc.FirstChild.FirstChild;
while (noeud != null)
{
switch (noeud.Name)
{
case "data":
InstaSharp.Model.Media media = new InstaSharp.Model.Media();
List <InstaSharp.Model.Tag> listtag = new List <InstaSharp.Model.Tag>();
media.Tags = listtag;
int compteurenfant = 0;
while (compteurenfant < noeud.ChildNodes.Count)
{
try
{
//string s = noeud.FirstChild.NextSibling.Name;
switch (noeud.ChildNodes[compteurenfant].Name)
{
#region Location
case "location":
InstaSharp.Model.Location location = new InstaSharp.Model.Location();
if (noeud.ChildNodes[compteurenfant].ChildNodes.Count == 4)
{
location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
location.Name = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText.Replace("'", "''");
location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText;
location.Id = Convert.ToInt32(noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText);
media.Location = location;
}
else
{
location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText;
media.Location = location;
}
break;
#endregion
#region Tag
case "tags":
InstaSharp.Model.Tag t = new InstaSharp.Model.Tag();
t.Name = noeud.ChildNodes[compteurenfant].InnerText;
listtag.Add(t);
media.Tags = listtag;
string s = media.Tags.Count.ToString();
break;
#endregion
#region Time
case "created_time":
media.CreatedTime = noeud.ChildNodes[compteurenfant].InnerText;
break;
#endregion
#region Id
case "id":
media.Id = noeud.ChildNodes[compteurenfant].InnerText;
break;
#endregion
#region Like
case "likes":
InstaSharp.Model.Like like = new InstaSharp.Model.Like();
like.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
media.Likes = like;
break;
#endregion
#region Coomments
case "comments":
InstaSharp.Model.Comments comments = new InstaSharp.Model.Comments();
comments.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText;
media.Comments = comments;
break;
#endregion
#region Type
case "type":
media.Type = noeud.ChildNodes[compteurenfant].InnerText;
break;
#endregion
#region User
case "user":
InstaSharp.Model.User user = new InstaSharp.Model.User();
user.Username = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText.Replace("'", "''");
user.ProfilePicture = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText;
user.Id = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText;
user.FullName = noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText.Replace("'", "''");
media.User = user;
break;
#endregion
}
}
catch (Exception e)
{
}
compteurenfant++;
}
listmedia.Add(media);
break;
}
noeud = noeud.NextSibling;
}
// XmlNodeList elements = doc.DocumentElement.SelecSingletNodes("//data");
return(listmedia);
}
