static void Main(string[] args) { GeodatascanBHP_Entities context = new GeodatascanBHP_Entities(); List <int> listDatasets = context.TempROT99 .Select(x => x.DataSetId).ToList(); int total = listDatasets.Count(); int quantidade = 0; foreach (int dataset in listDatasets) { TempROT99 aux = context.TempROT99.Where(x => x.DataSetId == dataset).First(); System.Console.WriteLine("Processando {0} de {1}", ++quantidade, total); aux.FileExists = Alphaleonis.Win32.Filesystem.File.Exists(aux.CompleteName); context.TempROT99.Update(tr => tr.DataSetId == aux.DataSetId, tr => new TempROT99 { FileExists = aux.FileExists }); } }
private static string TreatDirectoryName(string path, Util.Enum.Action action) { string result = path; GeodatascanBHP_Entities dbContext = new GeodatascanBHP_Entities(); var sortedByActionListExpression = (from e in dbContext.Expression where e.Action == (int)action select e); foreach (Expression expressionAux in sortedByActionListExpression) { if (result.ToUpper().Contains(expressionAux.Description.ToUpper())) { switch (expressionAux.Action) { case (int)Util.Enum.Action.REPLACE: result = result.Replace(expressionAux.Description, expressionAux.Replacement); result = result.Replace(expressionAux.Description.ToLower(), expressionAux.Replacement); result = result.Replace(expressionAux.Description.ToUpper(), expressionAux.Replacement); break; case (int)Util.Enum.Action.DELETE: result = result.Replace(expressionAux.Description, string.Empty); result = result.Replace(expressionAux.Description.ToLower(), string.Empty); result = result.Replace(expressionAux.Description.ToUpper(), string.Empty); break; default: break; } } } result = result.Replace(@"\\", @"\"); return(result); }