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");
}
