public RepAnalyseFichiers AnalyseFichiers(ParamAnalyseFichiers param) { repAnalyseFichiers = new RepAnalyseFichiers() { listIdFichiers = new List <IdFichiers>() }; string sPathDirectory = System.AppDomain.CurrentDomain.BaseDirectory; sPathDirectory += "\\Files\\UpLoad\\Relevé digital détail mensuel"; var listFiles = Directory.GetFiles(sPathDirectory).ToList(); int idxinc = 0; foreach (var v in listFiles) { IdFichiers idFichiers = new IdFichiers() { Id = idxinc++, sPAth = v, sFileName = Path.GetFileName(v), extension = Path.GetExtension(v) }; if (idFichiers.extension == ".xlsx") { Stopwatch sw = Stopwatch.StartNew(); var res = SingleExcel.Instance().GetPeriodFile(v); idFichiers.sPeriode = res.sPeriode; idFichiers.sMessage = res.Message; idFichiers.delayMs = sw.ElapsedMilliseconds; } else { idFichiers.Error = 1; idFichiers.sMessage = "Bad Extension must be xlsx "; } repAnalyseFichiers.listIdFichiers.Add(idFichiers); } return(repAnalyseFichiers); }
public RepTest AnalyseFichier(ParamTest param) { RepTest rep = new RepTest() { listInfosArtiste = new List <InfosArtiste>() }; string sPathDirectory = System.AppDomain.CurrentDomain.BaseDirectory; sPathDirectory += "\\Files\\UpLoad\\Relevé digital détail mensuel\\"; string sPathFile = sPathDirectory + param.NomFichier; var repExcel = SingleExcel.Instance().AnalyseFichier(sPathFile, param.NomFichier); CurrentlistLinePayLoad = repExcel.listLinePayLoad; rep.sMessage = repExcel.Message; string sPeriode = repExcel.sPeriode; if (CurrentlistLinePayLoad != null) { var listArtiste = CurrentlistLinePayLoad.Select(c => c.Artist).Distinct().ToList(); foreach (var art in listArtiste) { InfosArtiste infosArtiste = new InfosArtiste() { NomArtiste = art, UrlImage = "" }; infosArtiste.UrlImage = GetUrlImageArtiste(art, ref infosArtiste.NomRecherche); if (param.WithDetails) { var listInfos = CurrentlistLinePayLoad.Where(c => c.Artist == art).ToList(); infosArtiste.DownLoadQuantity = listInfos.Sum(c => c.DownloadQty); infosArtiste.GrossRevenue = listInfos.Sum(c => c.GrossRevenue); infosArtiste.NetRevenue = listInfos.Sum(c => c.NetRevenue); infosArtiste.TotalFee = listInfos.Sum(c => c.TotalFee); infosArtiste.TotalPayable = listInfos.Sum(c => c.TotalPayable); rep.TotalDownload += infosArtiste.DownLoadQuantity; rep.TotalTotalGrossRevenue += infosArtiste.GrossRevenue; rep.TotalTotalNetRevenue += infosArtiste.NetRevenue; rep.TotalTotalFee += infosArtiste.TotalFee; rep.TotalTotalPayable += infosArtiste.TotalPayable; } rep.listInfosArtiste.Add(infosArtiste); } int CptUpdate = 0; if (globalLinePayLoad != null && globalLinePayLoad.listLine != null) { var prelist = globalLinePayLoad.listLine.Where(c => c.sFile == param.NomFichier && c.sPeriode == sPeriode).ToList(); foreach (var line in CurrentlistLinePayLoad) { var exist = prelist.Where(c => c.Line == line.Line && c.TotalPayable == line.TotalPayable).FirstOrDefault(); if (exist == null) { globalLinePayLoad.listLine.Add(line); CptUpdate++; } } if (CptUpdate > 0) { SaveRepository(); } } } return(rep); }