void InsertData () { string dbPath = System.IO.Path.Combine(Environment.GetFolderPath (Environment.SpecialFolder.Personal), "ormDMS.db3"); var db = new SQLiteConnection(dbPath); DBRepository dbr = new DBRepository (); datedujour = DateTime.Now.ToString("yyyyMMdd"); //récupération de donnée via le webservice string content_integdata = String.Empty; try { string _url = "http://dms.jeantettransport.com/api/commandeWSV3?codechauffeur=" + userTransics + "&datecommande=" + datedujour + ""; var webClient = new WebClient (); webClient.Headers [HttpRequestHeader.ContentType] = "application/json"; content_integdata = webClient.DownloadString (_url); Console.Out.WriteLine ("\nWebclient integdata Terminé"); //intégration des données dans la BDD JsonArray jsonVal = JsonArray.Parse (content_integdata) as JsonArray; var jsonArr = jsonVal; if (content_integdata != "[]") { foreach (var row in jsonArr) { bool checkpos = dbr.pos_AlreadyExist(row["numCommande"],row["groupage"]); if (!checkpos) { var IntegUser = dbr.InsertDataPosition(row["codeLivraison"],row["numCommande"],row["refClient"],row["nomPayeur"],row["nomExpediteur"],row["adresseExpediteur"],row["villeExpediteur"],row["CpExpediteur"],row["dateExpe"],row["nomClient"],row["adresseLivraison"],row["villeLivraison"],row["CpLivraison"],row["dateHeure"],row["poids"],row["nbrPallette"],row["nbrColis"],row["instrucLivraison"],row["typeMission"],row["typeSegment"],row["groupage"],row["ADRCom"],row["ADRGrp"],"0",row["CR"],DateTime.Now.Day,row["Datemission"],row["Ordremission"],row["planDeTransport"],userAndsoft,row["nomClientLivraison"],row["villeClientLivraison"],null); var resintegstatut = dbr.InsertDataStatutMessage (10,DateTime.Now,1,row["numCommande"],row["groupage"]); Console.WriteLine ("\n"+IntegUser); File.AppendAllText(log_file,"["+DateTime.Now.ToString("t")+"][TASK]Intégration d'une position "+IntegUser+" à "+DateTime.Now.ToString("t")+"\n"); } } } //SON if (content_integdata == "[]") { } else { alert (); } } catch (Exception ex) { content_integdata = "[]"; Console.WriteLine ("\n"+ex); File.AppendAllText(log_file,"[ERROR] InserData : "+ex+" à "+DateTime.Now.ToString("t")+"\n"); Insights.Report(ex); } //SET des badges dbr.SETBadges(Data.userAndsoft); //maj des badges fonctions //TODO //verification des groupages et suppression des cloturer //select des grp's string content_grpcloture = String.Empty; var tablegroupage = db.Query<TablePositions> ("SELECT groupage FROM TablePositions group by groupage"); foreach (var row in tablegroupage) { string numGroupage = row.groupage; try { string _urlb = "http://dms.jeantettransport.com/api/groupage?voybdx="+ numGroupage+""; var webClient = new WebClient (); webClient.Headers [HttpRequestHeader.ContentType] = "application/json"; content_grpcloture = webClient.DownloadString (_urlb); JsonValue jsonVal = JsonObject.Parse(content_grpcloture); //JsonArray jsonVal = JsonArray.Parse (content_grpcloture) as JsonArray; //var jsonArr = jsonVal; if (jsonVal["etat"].ToString() == "\"CLO\""){ //suppression du groupage en question si clo var suppgrp = dbr.supp_grp(numGroupage); } } catch (Exception ex) { content_grpcloture = "[]"; Console.WriteLine ("\n"+ex); Insights.Report(ex); File.AppendAllText(log_file,"["+DateTime.Now.ToString("t")+"]"+"[ERROR] Cloture : "+ex+" à "+DateTime.Now.ToString("t")+"\n"); } } Console.WriteLine ("\nTask InsertData done"); //File.AppendAllText(Data.log_file, "Task InsertData done"+DateTime.Now.ToString("t")+"\n"); }