Esempio n. 1
0
        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
                });
            }
        }
Esempio n. 2
0
        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);
        }