Inheritance: FileSystemInfo
    private void ExportChart(string fileName, ISymbolicDataAnalysisSolution solution, string formula) {
      FileInfo newFile = new FileInfo(fileName);
      if (newFile.Exists) {
        newFile.Delete();
        newFile = new FileInfo(fileName);
      }
      var formulaParts = formula.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);

      using (ExcelPackage package = new ExcelPackage(newFile)) {
        ExcelWorksheet modelWorksheet = package.Workbook.Worksheets.Add("Model");
        FormatModelSheet(modelWorksheet, solution, formulaParts);

        ExcelWorksheet datasetWorksheet = package.Workbook.Worksheets.Add("Dataset");
        WriteDatasetToExcel(datasetWorksheet, solution.ProblemData);

        ExcelWorksheet inputsWorksheet = package.Workbook.Worksheets.Add("Inputs");
        WriteInputSheet(inputsWorksheet, datasetWorksheet, formulaParts.Skip(2), solution.ProblemData.Dataset);

        if (solution is IRegressionSolution) {
          ExcelWorksheet estimatedWorksheet = package.Workbook.Worksheets.Add("Estimated Values");
          WriteEstimatedWorksheet(estimatedWorksheet, datasetWorksheet, formulaParts, solution as IRegressionSolution);

          ExcelWorksheet chartsWorksheet = package.Workbook.Worksheets.Add("Charts");
          AddCharts(chartsWorksheet);
        }
        package.Workbook.Properties.Title = "Excel Export";
        package.Workbook.Properties.Author = "HEAL";
        package.Workbook.Properties.Comments = "Excel export of a symbolic data analysis solution from HeuristicLab";

        package.Save();
      }
    }
Ejemplo n.º 2
2
		public static string UpdateStatus(string status, TwUser user, string replyId)
		{
			Regex regex = new Regex(@"\[(.*?)\]");
			List<FileInfo> media = new List<FileInfo>();
			foreach (System.Text.RegularExpressions.Match match in regex.Matches(status))
			{
				status = status.Replace(match.Value, "");
				FileInfo file = new FileInfo(match.Value.Replace("[", "").Replace("]", ""));
				if (!file.Exists)
					throw new FileNotFoundException("File not found", file.FullName);
				media.Add(file);
            }

			if (media.Count > 4) //limited by the twitter API
				throw new ArgumentOutOfRangeException("media", "Up to 4 media files are allowed per tweet");

			if (user == null)
				user = TwUser.LoadCredentials();
			string encodedStatus = Util.EncodeString(status);
			
			if (media.Count == 0)
				return InternalUpdateStatus(user, encodedStatus, replyId);
			else
				return InternalUpdateWithMedia(user, encodedStatus, replyId, media);
		}
Ejemplo n.º 3
2
        /// <summary>
        /// Writes the database to the location defined in the configuration file if it doesn't exist.
        /// </summary>
        public static void CheckForDatabase()
        {
            // A LocalSqlServer connection string get's added by default. Don't look at that one.
            foreach (ConnectionStringSettings connection in ConfigurationManager.ConnectionStrings.OfType<ConnectionStringSettings>().Where(c => c.Name != "LocalSqlServer"))
            {
                try
                {
                    EntityConnectionStringBuilder builder = new EntityConnectionStringBuilder(connection.ConnectionString);
                    SqlCeConnectionStringBuilder sqlCEBuilder = new SqlCeConnectionStringBuilder(builder.ProviderConnectionString);

                    if (!File.Exists(sqlCEBuilder.DataSource))
                    {
                        FileInfo info = new FileInfo(sqlCEBuilder.DataSource);

                        if (!Directory.Exists(info.Directory.FullName))
                        {
                            Directory.CreateDirectory(info.Directory.FullName);
                        }

                        File.WriteAllBytes(info.FullName, EncounterTracker.Properties.Resources.EncounterTracker);
                    }

                    break;
                }
                catch
                {
                }
            }
        }
Ejemplo n.º 4
1
        /// <summary>
        /// Экспортирует массив данных в XLSX формат с учетом выбранной локали
        /// </summary>
        /// <param name="path">Путь к файлу, в который нужно сохранить данные</param>
        /// <param name="localisation">Локализация</param>
        /// <returns>Успешное завершение операции</returns>
        public override bool Export(String path, Localisation localisation)
        {
            try
            {
                if (!path.EndsWith(".xlsx"))
                    path += ".xlsx";

                log.Info(String.Format("Export to .xlsx file to: {0}", path));
                var timer = new Stopwatch();
                timer.Start();
                var file = new FileInfo(path);
                using (var pck = new ExcelPackage(file))
                {
                    ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet1");
                    ws.Cells["A1"].LoadFromDataTable(dataTable, true);
                    ws.Cells.AutoFitColumns();
                    pck.Save();
                }

                timer.Stop();
                log.Info(String.Format("Export complete! Elapsed time: {0} ms", timer.Elapsed.Milliseconds));
                return true;
            }
            catch (Exception ex)
            {
                log.Error("Can't export to .xlsx file!", ex);
                return false;
            }
        }
        /// <summary>
        /// Archives the exception report.
        /// The name of the PDF file is modified to make it easier to identify.
        /// </summary>
        /// <param name="pdfFile">The PDF file.</param>
        /// <param name="archiveDirectory">The archive directory.</param>
        public static void ArchiveException(FileInfo pdfFile, string archiveDirectory)
        {
            // Create a new subdirectory in the archive directory
            // This is based on the date of the report being archived
            DirectoryInfo di = new DirectoryInfo(archiveDirectory);
            string archiveFileName = pdfFile.Name;
            string newSubFolder = ParseFolderName(archiveFileName);
            try
            {
                di.CreateSubdirectory(newSubFolder);
            }
            catch (Exception ex)
            {
                // The folder already exists so don't create it
            }

            // Create destination path
            // Insert _EXCEPT into file name
            // This will make it easier to identify as an exception in the archive folder
            string destFileName = archiveFileName.Insert(archiveFileName.IndexOf("."), "_EXCEPT");
            string destFullPath = archiveDirectory + "\\" + newSubFolder + "\\" + destFileName;

            // Move the file to the archive directory
            try
            {
                pdfFile.MoveTo(destFullPath);
            }
            catch (Exception ex)
            {
            }
        }
Ejemplo n.º 6
1
 private void ExecuteScript(FileInfo code)
 {
     this.progressLabel.Text = "Evaluating: " + code.Name;
     Application.DoEvents();
     this.Client.CodeManager.Execute<Object>(code, Make.Dictionary<Object>(host => this.Client));
     this.progressBar.Increment(1);
 }
Ejemplo n.º 7
1
        public static void SortLogs(string[] logs)
        {
            foreach (var logfile in logs)
            {
                FileInfo info = new FileInfo(logfile);

                if (info.Length <= 1024)
                {
                    try
                    {
                        string destdir = Path.GetDirectoryName(logfile) + Path.DirectorySeparatorChar
                 + "SMALL" + Path.DirectorySeparatorChar;

                        if (!Directory.Exists(destdir))
                            Directory.CreateDirectory(destdir);

                        File.Move(logfile, destdir + Path.GetFileName(logfile));
                        File.Move(logfile.Replace(".tlog", ".rlog"), destdir + Path.GetFileName(logfile).Replace(".tlog", ".rlog"));
                    }
                    catch { }
                    continue;
                }

                MAVLinkInterface mine = new MAVLinkInterface();

                try
                {
                    using (mine.logplaybackfile = new BinaryReader(File.Open(logfile, FileMode.Open, FileAccess.Read, FileShare.Read)))
                    {
                        mine.logreadmode = true;

                        byte[] hbpacket = mine.getHeartBeat();

                        if (hbpacket.Length == 0)
                            continue;

                        MAVLink.mavlink_heartbeat_t hb = (MAVLink.mavlink_heartbeat_t)mine.DebugPacket(hbpacket);

                        mine.logreadmode = false;
                        mine.logplaybackfile.Close();

                        string destdir = Path.GetDirectoryName(logfile) + Path.DirectorySeparatorChar
                            + mine.MAV.aptype.ToString() + Path.DirectorySeparatorChar
                            + hbpacket[3] + Path.DirectorySeparatorChar;

                        if (!Directory.Exists(destdir))
                            Directory.CreateDirectory(destdir);

                        File.Move(logfile, destdir + Path.GetFileName(logfile));

                        try
                        {
                            File.Move(logfile.Replace(".tlog", ".rlog"), destdir + Path.GetFileName(logfile).Replace(".tlog", ".rlog"));
                        }
                        catch { }
                    }
                }
                catch { continue; }
            }
        }
        internal static bool ExtractArchive(string archive, string destination)
        {

            //REFACTOR: Only create RAR and ZIP classes after discovering that the file actually has a .zip or .rar extension
            FileInfo archiveFI = new FileInfo(archive);
            Rar rar = new Rar();
            FastZip fz = new FastZip();

            double archivesize = archiveFI.Length * 2;
            char driveLetter = archiveFI.FullName[0];


            if (!CheckDiskSpaceQuota(archivesize, driveLetter)) return false;


            if (archiveFI.Extension == ".rar" || archiveFI.Extension == ".RAR")
                return ExtractRarArchive(archive, destination, archiveFI, rar);

            // ReSharper disable ConvertIfStatementToReturnStatement
            if (archiveFI.Extension == ".zip" || archiveFI.Extension == ".ZIP")
            // ReSharper restore ConvertIfStatementToReturnStatement
                return ExtractZipArchive(archive, destination, fz);

            //TODO: Should this return false?
            return true;

        }
        public void Execute()
        {
            var files = Directory.GetFiles(SourceFolder, "*.jpg");
            foreach (var file in files)
            {
                try
                {
                    DateTime dt;
                    using (var em = new ExifManager(file))
                    {
                        dt = em.DateTimeOriginal;
                    }

                    if (dt == DateTime.MinValue) continue;

                    var fi = new FileInfo(file);
                    var newName = Path.Combine(DestinantionFolder,
                                               string.Format("{0}.jpg", dt.ToString("yyyy-MM-dd_HH.mm.ss")));
                    fi.MoveTo(newName);
                }
                catch
                {
                }
            }

        }
Ejemplo n.º 10
1
Archivo: Utils.cs Proyecto: niv/catflap
        // http://stackoverflow.com/questions/12811850/setting-a-files-acl-to-be-inherited
        private static void RemoveCustomACLs(string destination)
        {
            FileInfo fileInfo;
            FileSecurity fileSecurity;
            AuthorizationRuleCollection fileRules;

            fileInfo = new FileInfo(destination);
            fileSecurity = fileInfo.GetAccessControl();
            fileSecurity.SetAccessRuleProtection(false, false);

            fileSecurity.SetOwner(WindowsIdentity.GetCurrent().User);

            /*
             * Only fetch the explicit rules since I want to keep the inherited ones. Not
             * sure if the target type matters in this case since I am not examining the
             * IdentityReference.
             */
            fileRules = fileSecurity.GetAccessRules(includeExplicit: true,
                                     includeInherited: false, targetType: typeof(NTAccount));
            /*
             * fileRules is a AuthorizationRuleCollection object, which can contain objects
             * other than FileSystemAccessRule (in theory), but GetAccessRules should only
             * ever return a collection of FileSystemAccessRules, so we will just declare
             * rule explicitly as a FileSystemAccessRule.
             */
            foreach (FileSystemAccessRule rule in fileRules)
            {
                /*
                 * Remove any explicit permissions so we are just left with inherited ones.
                 */
                fileSecurity.RemoveAccessRule(rule);
            }

            fileInfo.SetAccessControl(fileSecurity);
        }
Ejemplo n.º 11
1
		/// <summary>
		/// The process for backing up a directory index is simple:
		/// a) create hard links to all the files in the lucene directory in a temp director
		///	   that gives us the current snapshot, and protect us from lucene's
		///    deleting files.
		/// b) copy the hard links to the destination directory
		/// c) delete the temp directory
		/// </summary>
		public void Execute()
		{
			foreach (var file in Directory.EnumerateFiles(tempPath))
			{
				Notify("Copying " + Path.GetFileName(file), BackupStatus.BackupMessageSeverity.Informational);
				var fullName = new FileInfo(file).FullName;
				FileCopy(file, Path.Combine(destination, Path.GetFileName(file)), fileToSize[fullName]);
				Notify("Copied " + Path.GetFileName(file), BackupStatus.BackupMessageSeverity.Informational);
			}

			try
			{
				IOExtensions.DeleteDirectory(tempPath);
			}
			catch (Exception e) //cannot delete, probably because there is a file being written there
			{
				logger.WarnException(
					string.Format("Could not delete {0}, will delete those on startup", tempPath),
					e);

				foreach (var file in Directory.EnumerateFiles(tempPath))
				{
					MoveFileEx(file, null, MoveFileDelayUntilReboot);
				}
				MoveFileEx(tempPath, null, MoveFileDelayUntilReboot);
			}
		}
Ejemplo n.º 12
1
		public void LoadPlugins(string pluginPath, bool checkSubDirs)
		{
			if(!Directory.Exists(pluginPath))
				return;
			if(Plugins.Any())
				UnloadPlugins();
			var dirInfo = new DirectoryInfo(pluginPath);

			var files = dirInfo.GetFiles().Select(f => f.FullName).ToList();
			if(checkSubDirs)
			{
				foreach(var dir in dirInfo.GetDirectories())
					files.AddRange(dir.GetFiles().Select(f => f.FullName));
			}

			foreach(var file in files)
			{
				var fileInfo = new FileInfo(file);

				if(fileInfo.Extension.Equals(".dll"))
				{
					var plugins = GetModule(file, typeof(IPlugin));
					foreach(var p in plugins)
						Plugins.Add(p);
				}
			}
			Logger.WriteLine("Loading Plugins...", "PluginManager");
			LoadPluginSettings();
		}
        public void TestWriteStructures(string file)
        {
            var structureReader = new StructureParsingManager();
            var fileInfo = new FileInfo(file);
            IStructureWorkspace structureWorkspace;
            using (var readable = new FileReadableDataLocation(fileInfo))
            {
                structureWorkspace = structureReader.ParseStructures(readable);
            }

            ISdmxObjects structureBeans = structureWorkspace.GetStructureObjects(false);

            string output = string.Format(CultureInfo.InvariantCulture, "test-sdmxv2.1-{0}", fileInfo.Name);
            var writtingManager = new StructureWriterManager();
            using (var outputStream = new FileStream(output, FileMode.Create))
            {
                writtingManager.WriteStructures(structureBeans, new SdmxStructureFormat(StructureOutputFormat.GetFromEnum(StructureOutputFormatEnumType.SdmxV21StructureDocument)), outputStream);
            }

            using (var readable = new FileReadableDataLocation(output))
            {
                XMLParser.ValidateXml(readable, SdmxSchemaEnumType.VersionTwoPointOne);
                var structures = structureReader.ParseStructures(readable);
                Assert.NotNull(structures);
            }
        }
        public static ProcessStartInfo CreateTestAndCoverageProcessStartInfo(Settings settings, string[] fileNames)
        {
            ProcessStartInfo startInfo = new ProcessStartInfo();
            startInfo.CreateNoWindow = true;
            startInfo.UseShellExecute = false;
            startInfo.FileName = @"""" + settings.PartCoverPath + @"""";

            startInfo.Arguments += " --target ";
            startInfo.Arguments += @"""" + settings.MSTestPath + @"""";
            startInfo.Arguments += " --target-work-dir ";
            startInfo.Arguments += @"""" + settings.OutputPath + @"""";    // trim trailing slash?
            startInfo.Arguments += " --target-args ";

            startInfo.Arguments += @"""";
            foreach (string fileName in fileNames)
            {
                FileInfo f = new FileInfo(fileName);
                startInfo.Arguments += " /testcontainer:";
                startInfo.Arguments += f.Name;
            }
            startInfo.Arguments += " /noisolation";
            startInfo.Arguments += " /nologo";
            startInfo.Arguments += " /resultsfile:";
            startInfo.Arguments += settings.TestLogFileName;
            startInfo.Arguments += @"""";

            startInfo.Arguments += " --include " + settings.CoverageReportingAssembliesRegEx;
            startInfo.Arguments += " --output " + @"""" + Path.Combine(settings.OutputPath, settings.CoverageLogFileName) + @"""";

            return startInfo;
        }
Ejemplo n.º 15
1
		public WebViewer(FileInfo file)
		{
			InitializeComponent();
			File = file;
			Text = Path.GetFileNameWithoutExtension(File.FullName);

			_childBrowser = new WebControl();
			_childBrowser.WebView = new WebView();
			_childBrowser.WebView.FileDialog += OnProcessFileDialog;
			_childBrowser.WebView.BeforeDownload += OnWebViewBeforeDownload;
			_childBrowser.WebView.DownloadUpdated += OnWebViewDownloadUpdated;
			_childBrowser.WebView.DownloadCompleted += OnWebViewDownloadCompleted;
			_childBrowser.WebView.DownloadCanceled += OnWebViewDownloadCanceled;
			_childBrowser.WebView.CustomUserAgent = "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Essential Objects Chrome/41.0.2272.16 Safari/537.36";
			Controls.Add(_childBrowser);

			_browser = new WebControl();
			_browser.WebView = new WebView();
			_browser.Dock = DockStyle.Fill;
			_browser.WebView.LoadCompleted += OnMainWebViewLoadComplete;
			_browser.WebView.NewWindow += OnMainWebViewNewWindow;
			_browser.WebView.BeforeDownload += OnWebViewBeforeDownload;
			_browser.WebView.CustomUserAgent = "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Essential Objects Chrome/41.0.2272.16 Safari/537.36";
			Controls.Add(_browser);

			_browser.BringToFront();
		}
        private static bool ExtractRarArchive(string archive, string destination, FileInfo archiveFI, Rar rar)
        {

            Debugger.LogMessageToFile("[Archive extractor] Found RAR archive: " + archiveFI.FullName);

            #region Open
            if (!rar.Open(archive))
            {
                Debugger.LogMessageToFile("[Archive extractor] Failed to open archive: " + rar.LastErrorText);
                //MessageBox.Show("Failed to open archive " + rar.LastErrorText);
                return false;
            }
            Debugger.LogMessageToFile("[Archive extractor] Archive opened succesfully.");
            #endregion

            #region Extract
            //TODO: Check if destination directory exists and if not, create it
            if (!rar.Unrar(destination))
            {
                Debugger.LogMessageToFile("[Archive extractor] Failed to extract archive: " + rar.LastErrorText);
                //MessageBox.Show("Failed to extract archive " + rar.LastErrorText);
                return false;
            }
            Debugger.LogMessageToFile("[Archive extractor] Archive was extracted succesfully.");
            #endregion

            rar.Close();

            DeleteLeftOfMultiparts(rar);

            return true;

        }
Ejemplo n.º 17
1
        public DecryptFile(FileInfo decryptedFile, FileInfo encryptedFile)
            : this()
        {
            if (decryptedFile != null)
            {
                ID = System.IO.Path.GetFileNameWithoutExtension(decryptedFile.Name);
                Name = decryptedFile.Name;
                Path = decryptedFile.DirectoryName;
                FileDateTime = decryptedFile.LastWriteTime.ToString();
                Exists = decryptedFile.Exists;
            }
            else
            {
                Exists = false;
            }

            if (encryptedFile != null)
            {
                if (ID == null)
                {
                    ID = System.IO.Path.GetFileNameWithoutExtension(encryptedFile.Name);
                }
                EncryptName = encryptedFile.Name;
                EncryptPath = encryptedFile.DirectoryName;
                EncryptDateTime = encryptedFile.LastWriteTime.ToString();
                EncryptExists = encryptedFile.Exists;
            }
            else
            {
                EncryptExists = false;
            }
        }
Ejemplo n.º 18
1
        public void test000_FirstPack()
        {
            FileInfo packFile = getPack("pack-34be9032ac282b11fa9babdc2b2a93ca996c9c2f.pack");
            Stream @is = packFile.Open(System.IO.FileMode.Open, FileAccess.Read);
            try
            {
                FileInfo tmppack = new FileInfo(Path.Combine(trash.ToString(), "tmp_pack1"));
                FileInfo idxFile = new FileInfo(Path.Combine(trash.ToString(), "tmp_pack1.idx"));
                FileInfo tmpPackFile = new FileInfo(Path.Combine(trash.ToString(), "tmp_pack1.pack"));

                tmppack.Create().Close();
                idxFile.Create().Close();
                tmpPackFile.Create().Close();

                IndexPack pack = new IndexPack(db, @is, tmppack);
                pack.index(new TextProgressMonitor());
                PackFile file = new PackFile(idxFile, tmpPackFile);

                Assert.IsTrue(file.HasObject(ObjectId.FromString("4b825dc642cb6eb9a060e54bf8d69288fbee4904")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("540a36d136cf413e4b064c2b0e0a4db60f77feab")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("5b6e7c66c276e7610d4a73c70ec1a1f7c1003259")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("6ff87c4664981e4397625791c8ea3bbb5f2279a3")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("82c6b885ff600be425b4ea96dee75dca255b69e7")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("902d5476fa249b7abc9d84c611577a81381f0327")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("aabf2ffaec9b497f0950352b3e582d73035c2035")));
                Assert.IsTrue(file.HasObject(ObjectId.FromString("c59759f143fb1fe21c197981df75a7ee00290799")));
            }
            finally
            {
                @is.Close();
            }
        }
Ejemplo n.º 19
1
        public DisassembleResult Disassemble(string compiledFilePath, string additionalArguments = null)
        {
            if (!File.Exists(compiledFilePath))
            {
                throw new ArgumentException(
                    $"Compiled file not found in: {compiledFilePath}.",
                    nameof(compiledFilePath));
            }

            var workingDirectory = new FileInfo(this.DisassemblerPath).DirectoryName;

            var arguments = this.BuildDisassemblerArguments(compiledFilePath, additionalArguments);

            var disassemblerProcessStartInfo =
                new ProcessStartInfo(this.DisassemblerPath)
                {
                    RedirectStandardOutput = true,
                    UseShellExecute = false,
                    CreateNoWindow = true,
                    WindowStyle = ProcessWindowStyle.Hidden,
                    WorkingDirectory = workingDirectory,
                    Arguments = arguments
                };

            this.UpdateDisassemblerProcessStartInfo(disassemblerProcessStartInfo);

            string disassambledCode;
            var isDisassembledSuccessfully =
                this.ExecuteDisassemblerProcess(disassemblerProcessStartInfo, out disassambledCode);

            return new DisassembleResult(isDisassembledSuccessfully, disassambledCode);
        }
		public void Load(FileInfo file)
		{
			using (var stream = new FileStream(file.FullName, FileMode.Open, FileAccess.Read))
			{
				Load(stream);
			}
		}
Ejemplo n.º 21
1
Archivo: Test.cs Proyecto: hcesar/Chess
        internal static IList<Test> LoadAll()
        {
            var file = new FileInfo("tests.xml");

            if (!file.Exists)
                return new Test[0];

            XmlDocument xml = new XmlDocument();
            using (var fs = file.OpenRead())
                xml.Load(fs);

            var ret = new List<Test>();
            foreach (XmlNode node in xml.SelectNodes("/Tests/*"))
            {
                var n = node.SelectSingleNode("./Type");

                if (n == null)
                    throw new InvalidOperationException("Test Type must be informed.");

                var typeName = n.InnerText;
                var type = FindType(typeName);

                if (type == null)
                    throw new InvalidOperationException(string.Format("'{0}' is not a valid Test.", typeName));

                var obj = (Test)Activator.CreateInstance(type);
                node.ToEntity(obj);

                ret.Add(obj);
            }

            return ret;
        }
Ejemplo n.º 22
1
        /// <summary>
        /// Explores the content of the folder using the given set of file masks.
        /// </summary>
        /// <param name="path">The root folder to explore.</param>
        /// <param name="masks">A collection of file masks to match against.</param>
        private void ExploreFolderWithMasks(String path, String[] masks)
        {
            this.knownPathes.Add(path);

            //checks the directory for each mask provided
            foreach (String mask in masks)
            {
                String[] files = Directory.GetFiles(path, mask);
                foreach (String file in files)
                {
                    //prevents the addition of the same file multiple times if it happens to match multiple masks
                    if (!this.foundFiles.Contains(file))
                    {
                        this.foundFiles.Add(file);
                    }
                }
            }
            if (!recursive) return;
            String[] dirs = Directory.GetDirectories(path);
            foreach (String dir in dirs)
            {
                try
                {
                    if (!this.knownPathes.Contains(dir))
                    {
                        FileInfo info = new FileInfo(dir);
                        if ((info.Attributes & FileAttributes.Hidden) == 0)
                            this.ExploreFolderWithMasks(dir, masks);
                    }
                }
                catch { /* Might be system folder.. */ };
            }
        }
 public string Save(FileInfo file)
 {
     using (FileStream fileStream = new FileStream(file.FullName, FileMode.Open))
     {
         return Save(file.Name, fileStream);
     }
 }
Ejemplo n.º 24
0
 public CmsProcessableFile(
     FileInfo	file,
     int			bufSize)
 {
     _file = file;
     _bufSize = bufSize;
 }
Ejemplo n.º 25
0
        public Credentials()
        {
            string desktop = Environment.GetFolderPath(Environment.SpecialFolder.Desktop)
                          + Path.DirectorySeparatorChar + "Gradians.com" ;
             string    local = desktop + Path.DirectorySeparatorChar + ".local" ;
             FileInfo  localCnfg = new FileInfo(local) ;

             remote = !localCnfg.Exists ;
             if (remote) {
            ftpServer = "109.74.201.62" ;
            username = "******" ;
            password = "******" ;
            bankRelPath = "bank" ;
             } else {
            // parse the local configuration file
            string[]  lines = File.ReadAllLines(local) ;
            foreach (string line in lines) {
               string[] tokens = line.Split('=') ;
               if (tokens.Length != 2) continue ;

               if (String.Compare(tokens[0],"username", true) == 0) {
                  username = tokens[1];
               } else if (String.Compare(tokens[0],"password", true) == 0) {
                  password = tokens[1] ;
               } else if (String.Compare(tokens[0], "bank", true) == 0) {
                  bankRelPath = tokens[1] ;
               }
            }
            ftpServer = "localhost" ;
             }
        }
        /// <summary>
        /// The normal PDF archival method.
        /// </summary>
        /// <param name="pdfFile">The PDF file.</param>
        /// <param name="archiveDirectory">The archive directory.</param>
        public static void ArchiveNormal(FileInfo pdfFile, string archiveDirectory)
        {
            // Create a new subdirectory in the archive directory
            // This is based on the date of the report being archived
            DirectoryInfo di = new DirectoryInfo(archiveDirectory);
            string archiveFileName = pdfFile.Name;
            string newSubFolder = ParseFolderName(archiveFileName);
            try
            {
                di.CreateSubdirectory(newSubFolder);
            }
            catch (Exception ex)
            {
                // The folder already exists so don't create it
            }

            // Create destination path
            string destFullPath = archiveDirectory + "\\" + newSubFolder + "\\" + pdfFile.Name;

            // Move the file to the archive directory
            try
            {
                pdfFile.MoveTo(destFullPath);
            }
            catch (Exception ex)
            {
                // Unable to move the PDF to the archive
            }
        }
		public byte[] FilenameToBytes(string filename)
		{
			byte[] data = null;

			// get the file information form the selected file
			FileInfo fInfo = new FileInfo(filename);

			// get the length of the file to see if it is possible
			// to upload it (with the standard 4 MB limit)
			long numBytes = fInfo.Length;
			double dLen = Convert.ToDouble(fInfo.Length / 1000000);

			// set up a file stream and binary reader for the
			// selected file
			FileStream fStream = new FileStream(filename, FileMode.Open, FileAccess.Read);
			BinaryReader br = new BinaryReader(fStream);

			// convert the file to a byte array
			data = br.ReadBytes((int)numBytes);
			br.Close();

			fStream.Close();
			fStream.Dispose();

			return data;
		}
        internal static void Main(string[] args)
        {
            if (args.Length < 1)
            {
                System.Console.WriteLine(String.Format(CultureInfo.InvariantCulture,
                    "Usage: SetFileModifiedDate \"FilePath\""));
                return;

            }
            string filePath = args[0];

            if (!File.Exists(filePath))
            {
                System.Console.WriteLine("File: \"" + filePath + "\" doesn't exist!");
                return;

            }
            FileAttributes attr = File.GetAttributes(filePath);

            if ((attr & FileAttributes.ReadOnly) > 0)
            {
                System.Console.WriteLine("File: \"" + filePath + "\" is readonly!");
                return;
            }
            FileInfo fi = new FileInfo(filePath);
            fi.LastWriteTime = DateTime.Now.AddDays(-1);

            System.Console.WriteLine("Modified date is now set to: " + fi.LastWriteTime.ToString("ddMMMyyTHH:mm:ss fff"));
        }
Ejemplo n.º 29
0
 public void Load()
 {
     // If configuration file exists then...
     if (System.IO.File.Exists(FileName))
     {
         SettingsFile data;
         // Deserialize and load data.
         lock (saveReadFileLock)
         {
             data = Serializer.DeserializeFromXmlFile<SettingsFile>(FileName);
         }
         if (data == null) return;
         //Programs.Clear();
         //if (data.Programs != null) for (int i = 0; i < data.Programs.Count; i++) Programs.Add(data.Programs[i]);
         Games.Clear();
         if (data.Games != null) for (int i = 0; i < data.Games.Count; i++) Games.Add(data.Games[i]);
         Pads.Clear();
         if (data.Pads != null) for (int i = 0; i < data.Pads.Count; i++) Pads.Add(data.Pads[i]);
     }
     // Check if current app doesn't exist in the list then...
     var currentFile = new System.IO.FileInfo(Application.ExecutablePath);
     var currentGame = Games.FirstOrDefault(x => x.FileName == currentFile.Name);
     if (currentGame == null)
     {
         // Add x360ce.exe
         var item = x360ce.Engine.Data.Game.FromDisk(currentFile.Name);
         var program = Programs.FirstOrDefault(x => x.FileName == currentFile.Name);
         item.LoadDefault(program);
         SettingsFile.Current.Games.Add(item);
     }
     else
     {
         currentGame.FullPath = currentFile.FullName;
     }
 }
Ejemplo n.º 30
0
        /// <summary>
        /// Gets the file fingerprints from the application folder
        /// As the sha1 is calculated based on the content of the file, 
        /// there is a possibility that one key can have multiple fingerprints (duplicate files)
        /// </summary>
        /// <param name="appPath">The path to the application folder</param>
        /// <param name="cancellationToken">The cancellation token.</param>
        /// <returns>Return a dictionary of file fingerprints, with sha1 as key and a list of file fingerprints as value.</returns>
        public async Task<Dictionary<string, List<FileFingerprint>>> GetFileFingerprints(string appPath, System.Threading.CancellationToken cancellationToken)
        {
            Dictionary<string, List<FileFingerprint>> fingerprints = new Dictionary<string, List<FileFingerprint>>();

            appPath = Path.GetFullPath(appPath);

            foreach (string file in Directory.GetFiles(appPath, "*", SearchOption.AllDirectories))
            {
                FileInfo fileInfo = new FileInfo(file);
                FileFingerprint print = new FileFingerprint();
                print.Size = fileInfo.Length;
                print.FileName = fileInfo.FullName.Replace(appPath, string.Empty).TrimStart('\\');
                print.SHA1 = await this.CalculateSHA1(fileInfo.FullName, cancellationToken);

                if (fingerprints.ContainsKey(print.SHA1))
                {
                    fingerprints[print.SHA1].Add(print);
                }
                else
                {
                    fingerprints.Add(print.SHA1, new List<FileFingerprint>() { print });
                }
            }

            return fingerprints;
        }
Ejemplo n.º 31
0
        // Add image generation logic here and return an instance of ImageInfo
        public override ImageInfo GenerateImage(NameValueCollection parameters)
        {
            SetupCulture();

            //which type of image should be generated ?
            string mode = string.IsNullOrEmpty(parameters["mode"]) ? "profilepic" : parameters["mode"].ToLower();

            // We need to determine the output format
            string format = string.IsNullOrEmpty(parameters["format"]) ? "jpg" : parameters["format"].ToLower();

            // Lets retrieve the color
            Color color     = string.IsNullOrEmpty(parameters["color"]) ? Color.White : (parameters["color"].StartsWith("#") ? ColorTranslator.FromHtml(parameters["color"]) : Color.FromName(parameters["color"]));
            Color backColor = string.IsNullOrEmpty(parameters["backcolor"]) ? Color.White : (parameters["backcolor"].StartsWith("#") ? ColorTranslator.FromHtml(parameters["backcolor"]) : Color.FromName(parameters["backcolor"]));

            // Do we have a border ?
            int border = string.IsNullOrEmpty(parameters["border"]) ? 0 : Convert.ToInt32(parameters["border"]);

            // Do we have a resizemode defined ?
            var resizeMode = string.IsNullOrEmpty(parameters["resizemode"]) ? ImageResizeMode.Fit : (ImageResizeMode)Enum.Parse(typeof(ImageResizeMode), parameters["ResizeMode"], true);

            // Maximum sizes
            int maxWidth  = string.IsNullOrEmpty(parameters["MaxWidth"]) ? 0 : Convert.ToInt32(parameters["MaxWidth"]);
            int maxHeight = string.IsNullOrEmpty(parameters["MaxHeight"]) ? 0 : Convert.ToInt32(parameters["MaxHeight"]);

            // Any text ?
            string text = string.IsNullOrEmpty(parameters["text"]) ? "" : parameters["text"];

            // Default Image
            _defaultImageFile = string.IsNullOrEmpty(parameters["NoImage"]) ? string.Empty : parameters["NoImage"];

            // Do we override caching for this image ?
            if (!string.IsNullOrEmpty(parameters["NoCache"]))
            {
                EnableClientCache = false;
                EnableServerCache = false;
            }

            try
            {
                ContentType = GetImageFormat(format);

                switch (mode)
                {
                case "profilepic":
                    int uid;
                    if (!int.TryParse(parameters["userid"], out uid) || uid <= 0)
                    {
                        uid = -1;
                    }
                    var uppTrans = new UserProfilePicTransform
                    {
                        UserID = uid
                    };

                    IFileInfo photoFile;
                    ContentType = !uppTrans.TryGetPhotoFile(out photoFile)
                            ? ImageFormat.Gif
                            : GetImageFormat(photoFile?.Extension ?? "jpg");

                    ImageTransforms.Add(uppTrans);
                    break;

                case "placeholder":
                    var placeHolderTrans = new PlaceholderTransform();
                    int width, height;
                    if (TryParseDimension(parameters["w"], out width))
                    {
                        placeHolderTrans.Width = width;
                    }
                    if (TryParseDimension(parameters["h"], out height))
                    {
                        placeHolderTrans.Height = height;
                    }
                    if (!string.IsNullOrEmpty(parameters["Color"]))
                    {
                        placeHolderTrans.Color = color;
                    }
                    if (!string.IsNullOrEmpty(parameters["Text"]))
                    {
                        placeHolderTrans.Text = text;
                    }
                    if (!string.IsNullOrEmpty(parameters["BackColor"]))
                    {
                        placeHolderTrans.BackColor = backColor;
                    }

                    ImageTransforms.Add(placeHolderTrans);
                    break;

                case "securefile":
                    var secureFileTrans = new SecureFileTransform();
                    if (!string.IsNullOrEmpty(parameters["FileId"]))
                    {
                        var fileId = Convert.ToInt32(parameters["FileId"]);
                        var file   = FileManager.Instance.GetFile(fileId);
                        if (file == null)
                        {
                            return(GetEmptyImageInfo());
                        }
                        var folder = FolderManager.Instance.GetFolder(file.FolderId);
                        if (!secureFileTrans.DoesHaveReadFolderPermission(folder))
                        {
                            return(GetEmptyImageInfo());
                        }
                        ContentType = GetImageFormat(file.Extension);
                        secureFileTrans.SecureFile = file;
                        secureFileTrans.EmptyImage = EmptyImage;
                        ImageTransforms.Add(secureFileTrans);
                    }
                    break;

                case "file":
                    var imgFile = string.Empty;
                    var imgUrl  = string.Empty;

                    // Lets determine the 2 types of Image Source: Single file, file url
                    var filePath = parameters["File"];
                    if (!string.IsNullOrEmpty(filePath))
                    {
                        filePath = filePath.Trim();
                        var fullFilePath = HttpContext.Current.Server.MapPath(filePath);
                        if (!File.Exists(fullFilePath) || !IsAllowedFilePathImage(filePath))
                        {
                            return(GetEmptyImageInfo());
                        }
                        imgFile = fullFilePath;
                    }
                    else if (!string.IsNullOrEmpty(parameters["Url"]))
                    {
                        if (!parameters["Url"].StartsWith("http"))
                        {
                            return(GetEmptyImageInfo());
                        }
                        imgUrl = parameters["Url"];
                    }

                    if (string.IsNullOrEmpty(parameters["format"]))
                    {
                        string extension;
                        if (string.IsNullOrEmpty(parameters["Url"]))
                        {
                            var fi = new System.IO.FileInfo(imgFile);
                            extension = fi.Extension.ToLower();
                        }
                        else
                        {
                            string[] parts = parameters["Url"].Split('.');
                            extension = parts[parts.Length - 1].ToLower();
                        }
                        ContentType = GetImageFormat(extension);
                    }
                    var imageFileTrans = new ImageFileTransform {
                        ImageFilePath = imgFile, ImageUrl = imgUrl
                    };
                    ImageTransforms.Add(imageFileTrans);
                    break;

                default:

                    string   imageTransformClass      = ConfigurationManager.AppSettings["DnnImageHandler." + mode];
                    string[] imageTransformClassParts = imageTransformClass.Split(',');
                    var      asm = Assembly.LoadFrom(Globals.ApplicationMapPath + @"\bin\" +
                                                     imageTransformClassParts[1].Trim() + ".dll");
                    var t = asm.GetType(imageTransformClassParts[0].Trim());
                    var imageTransform = (ImageTransform)Activator.CreateInstance(t);

                    foreach (var key in parameters.AllKeys)
                    {
                        var pi = t.GetProperty(key, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance);
                        if (pi != null && key != "mode")
                        {
                            switch (key.ToLower())
                            {
                            case "color":
                                pi.SetValue(imageTransform, color, null);
                                break;

                            case "backcolor":
                                pi.SetValue(imageTransform, backColor, null);
                                break;

                            case "border":
                                pi.SetValue(imageTransform, border, null);
                                break;

                            default:
                                switch (pi.PropertyType.Name)
                                {
                                case "Int32":
                                    pi.SetValue(imageTransform, Convert.ToInt32(parameters[key]), null);
                                    break;

                                case "String":
                                    pi.SetValue(imageTransform, parameters[key], null);
                                    break;
                                }
                                break;
                            }
                        }
                    }
                    ImageTransforms.Add(imageTransform);
                    break;
                }
            }
            catch (Exception ex)
            {
                Exceptions.Exceptions.LogException(ex);
                return(GetEmptyImageInfo());
            }

            // Resize-Transformation
            if (mode != "placeholder")
            {
                int width, height;

                TryParseDimension(parameters["w"], out width);
                TryParseDimension(parameters["h"], out height);

                var size = string.IsNullOrEmpty(parameters["size"]) ? "" : parameters["size"];

                switch (size)
                {
                case "xxs":
                    width  = 16;
                    height = 16;
                    break;

                case "xs":
                    width  = 32;
                    height = 32;
                    break;

                case "s":
                    width  = 50;
                    height = 50;
                    break;

                case "l":
                    width  = 64;
                    height = 64;
                    break;

                case "xl":
                    width  = 128;
                    height = 128;
                    break;

                case "xxl":
                    width  = 256;
                    height = 256;
                    break;
                }

                if (mode == "profilepic")
                {
                    resizeMode = ImageResizeMode.FitSquare;
                    if (width > 0 && height > 0 && width != height)
                    {
                        resizeMode = ImageResizeMode.Fill;
                    }
                }

                if (width > 0 || height > 0)
                {
                    var resizeTrans = new ImageResizeTransform
                    {
                        Mode      = resizeMode,
                        BackColor = backColor,
                        Width     = width,
                        Height    = height,
                        MaxWidth  = maxWidth,
                        MaxHeight = maxHeight,
                        Border    = border
                    };
                    ImageTransforms.Add(resizeTrans);
                }
            }

            // Gamma adjustment
            if (!string.IsNullOrEmpty(parameters["Gamma"]))
            {
                var    gammaTrans = new ImageGammaTransform();
                double gamma;
                if (double.TryParse(parameters["Gamma"], NumberStyles.AllowDecimalPoint, CultureInfo.InvariantCulture, out gamma) && gamma >= 0.2 && gamma <= 5)
                {
                    gammaTrans.Gamma = gamma;
                    ImageTransforms.Add(gammaTrans);
                }
            }

            // Brightness adjustment
            if (!string.IsNullOrEmpty(parameters["Brightness"]))
            {
                var brightnessTrans = new ImageBrightnessTransform();
                int brightness;
                if (int.TryParse(parameters["Brightness"], out brightness))
                {
                    brightnessTrans.Brightness = brightness;
                    ImageTransforms.Add(brightnessTrans);
                }
            }

            // Contrast adjustment
            if (!string.IsNullOrEmpty(parameters["Contrast"]))
            {
                var    contrastTrans = new ImageContrastTransform();
                double contrast;
                if (double.TryParse(parameters["Contrast"], NumberStyles.AllowDecimalPoint, CultureInfo.InvariantCulture, out contrast) && (contrast >= -100 && contrast <= 100))
                {
                    contrastTrans.Contrast = contrast;
                    ImageTransforms.Add(contrastTrans);
                }
            }

            // Greyscale
            if (!string.IsNullOrEmpty(parameters["Greyscale"]))
            {
                var greyscaleTrans = new ImageGreyScaleTransform();
                ImageTransforms.Add(greyscaleTrans);
            }

            // Invert
            if (!string.IsNullOrEmpty(parameters["Invert"]))
            {
                var invertTrans = new ImageInvertTransform();
                ImageTransforms.Add(invertTrans);
            }

            // Rotate / Flip
            if (!string.IsNullOrEmpty(parameters["RotateFlip"]))
            {
                var rotateFlipTrans = new ImageRotateFlipTransform();
                var rotateFlipType  = (RotateFlipType)Enum.Parse(typeof(RotateFlipType), parameters["RotateFlip"]);
                rotateFlipTrans.RotateFlip = rotateFlipType;
                ImageTransforms.Add(rotateFlipTrans);
            }

            // We start the chain with an empty image
            var dummy = new Bitmap(1, 1);

            using (var ms = new MemoryStream())
            {
                dummy.Save(ms, ContentType);
                return(new ImageInfo(ms.ToArray()));
            }
        }
Ejemplo n.º 32
0
        private void SetViewImage(System.IO.FileInfo fi, string requestedName)
        {
            if (fi != null)
            {
                lblInternalName.Text      = "";
                lblInternalReference.Text = "";
                string   varname = "";
                fileType ft      = LoadFile(fi, requestedName, out varname, out currentBitmap);

                pictureBox1.Image = currentBitmap;

                switch (ft)
                {
                case fileType.Image:
                    Viewer1.Visible           = false; Viewer1.Dock = DockStyle.None;
                    lstInternalImages.Visible = false; lstInternalImages.Dock = DockStyle.None;
                    txtBinaryHeader.Dock      = DockStyle.Fill; txtBinaryHeader.Visible = true;
                    pbPreviewImage.Dock       = DockStyle.Fill; pbPreviewImage.Visible = true;
                    WriteImageFileInfo();
                    break;

                case fileType.TextMdl:
                    Viewer1.Visible         = false; Viewer1.Dock = DockStyle.None;
                    txtBinaryHeader.Visible = false; txtBinaryHeader.Dock = DockStyle.None;
                    lstInternalImages.Dock  = DockStyle.Fill; lstInternalImages.Visible = true;
                    pbPreviewImage.Dock     = DockStyle.Fill; pbPreviewImage.Visible = true;

                    // deteremine if we need to reload the list.
                    WriteTextFileInfo(varname);
                    break;

                case fileType.ImageMdl:
                    Viewer1.Visible           = false; Viewer1.Dock = DockStyle.None;
                    lstInternalImages.Visible = false; lstInternalImages.Dock = DockStyle.None;
                    txtBinaryHeader.Dock      = DockStyle.Fill; txtBinaryHeader.Visible = true;
                    pbPreviewImage.Dock       = DockStyle.Fill; pbPreviewImage.Visible = true;
                    WriteBinaryFileInfo(currentBinaryMDL.header.ImportedSymbols[0].Name);
                    break;

                case fileType.ModelMdl:
                    pbPreviewImage.Visible    = false; pbPreviewImage.Dock = DockStyle.None;
                    lstInternalImages.Visible = false; lstInternalImages.Dock = DockStyle.None;
                    WriteBinaryFileInfo(currentBinaryMDL.header.NameSpaces[0]);
                    if (currentBinaryMDL.RootObject.Where(x => x.type == MDLType.mdl_mesh).Count() > 0)
                    {
                        // Lets load up any referenced Images Namespaces
                        List <Bitmap> referencedImages = GetReferencedImages(currentBinaryMDL);
                        // Lets send our file to the 3DViewer!!
                        MDLViewer mv = Viewer1.Child as MDLViewer;
                        mv.LoadMDLFile(currentBinaryMDL, referencedImages);
                    }

                    txtBinaryHeader.Dock = DockStyle.Fill; txtBinaryHeader.Visible = true;
                    Viewer1.Dock         = DockStyle.Fill; Viewer1.Visible = true;
                    break;

                default:
                    break;
                }


                if (currentBitmap != null)
                {
                    if (ft != fileType.ModelMdl)
                    {
                        lblDetails.Text = string.Format("w:{0} h:{1} {2}", currentBitmap.Width, currentBitmap.Height, currentBitmap.PixelFormat.ToString());
                        // fill info on the details tab.
                        lblFormat.Text = "Pixel: " + currentBitmap.PixelFormat.ToString();
                        lblWidth.Text  = "Width: " + currentBitmap.Width.ToString();
                        lblHeight.Text = "Height: " + currentBitmap.Height.ToString();
                        if (numericUpDown1.Value == 100 || Properties.Settings.Default.RememberZoom == false)
                        {
                            pictureBox1.Width    = pictureBox1.Image.Width;
                            pictureBox1.Height   = pictureBox1.Image.Height;
                            numericUpDown1.Value = 100;
                        }
                        else
                        {
                            pictureBox1.Image  = Scale(currentBitmap, Convert.ToSingle(numericUpDown1.Value) / 100, Convert.ToSingle(numericUpDown1.Value) / 100);
                            pictureBox1.Width  = pictureBox1.Image.Width;
                            pictureBox1.Height = pictureBox1.Image.Height;
                        }

                        pbPreviewImage.Image = pictureBox1.Image;
                    }
                }
                else
                {
                    lblDetails.Text = "No Images Found";
                    // fill info on the details tab.
                    lblFormat.Text = "Pixel: ";
                    lblWidth.Text  = "Width: ";
                    lblHeight.Text = "Height: ";
                    lstInternalImages.Items.Clear();
                    pictureBox1.Image    = null;
                    pbPreviewImage.Image = null;
                }
                this.Text = windowTitle + " .. " + currentFile.Name;
                // the status label
                lblFileName.Text = "File Name: " + currentFile.Name;
            }
        }
Ejemplo n.º 33
0
        public virtual string ToHTML(string htmlFileName = "", int count = 0, bool includeImage = true, bool includeFullData = false, bool ForWeb = false)
        {
            StringBuilder htmlBuilder = new StringBuilder();
            StringBuilder _color      = new StringBuilder();
            StringBuilder _Groups     = new StringBuilder();
            string        Composition = "";

            if (!ForWeb)
            {
                string imageFileName = string.Empty;

                if (htmlFileName.EndsWith(".html"))
                {
                    imageFileName = htmlFileName.Remove(htmlFileName.Length - 5, 5);
                }
                else if (htmlFileName.EndsWith(".htm"))
                {
                    imageFileName = htmlFileName.Remove(htmlFileName.Length - 4, 4);
                }

                imageFileName = imageFileName + "_" + count.ToString() + ".png";

                System.IO.FileInfo fi = new System.IO.FileInfo(imageFileName);

                ToImageFile(imageFileName, false);

                htmlBuilder.AppendLine("<h3>" + this.StrataTitle + "</h3>");
                if (includeImage)
                {
                    htmlBuilder.AppendLine("<img src=\"" + fi.Name + "\" />");
                }

                htmlBuilder.AppendLine("<p>&nbsp;</p>");
                htmlBuilder.AppendLine("<p>&nbsp;</p>");
                htmlBuilder.AppendLine("<p>&nbsp;</p>");
            }
            else
            {
                List <string> color     = new List <string>();
                var           ChartType = this.GetType().Name;

                if (ChartType == "LineChart")
                {
                    htmlBuilder.AppendLine("<h2  class=\"gadgetHeading\">" + ((EpiDashboard.Controls.Charting.LineChartBase) this).LineChartParameters.GadgetTitle + "</h2>");
                    color = ((EpiDashboard.Controls.Charting.LineChartBase) this).LineChartParameters.PaletteColors;
                }
                else if (ChartType == "ParetoChart")
                {
                    htmlBuilder.AppendLine("<h2  class=\"gadgetHeading\">" + ((EpiDashboard.Controls.Charting.ParetoChart) this).ParetoChartParameters.GadgetTitle + "</h2>");
                    color = ((EpiDashboard.Controls.Charting.ParetoChart) this).ParetoChartParameters.PaletteColors;
                }
                else if (ChartType == "ColumnChart")
                {
                    htmlBuilder.AppendLine("<h2  class=\"gadgetHeading\">" + ((EpiDashboard.Controls.Charting.ColumnChartBase) this).ColumnChartParameters.GadgetTitle + "</h2>");
                    color       = ((EpiDashboard.Controls.Charting.ColumnChartBase) this).ColumnChartParameters.PaletteColors;
                    Composition = ((EpiDashboard.Controls.Charting.ColumnChartBase) this).ColumnChartParameters.Composition.ToString();
                    bool UseDiffColors = ((EpiDashboard.Controls.Charting.ColumnChartBase) this).ColumnChartParameters.UseDiffColors;
                    if (UseDiffColors)
                    {
                        _color.AppendLine(" var colors =  [");
                        for (int i = 0; i < color.Count(); i++)
                        {
                            if (color[i].Length == 9)
                            {
                                _color.AppendLine(" '" + color[i].Remove(1, 2) + "' ,");
                            }
                        }


                        _color.AppendLine(" ];");
                    }
                }
                else if (ChartType == "AreaChart")
                {
                    htmlBuilder.AppendLine("<h2  class=\"gadgetHeading\">" + ((EpiDashboard.Controls.Charting.AreaChartBase) this).AreaChartParameters.GadgetTitle + "</h2>");
                    color = ((EpiDashboard.Controls.Charting.AreaChartBase) this).AreaChartParameters.PaletteColors;
                }
                else if (ChartType == "HistogramChart")
                {
                    color = ((EpiDashboard.Controls.Charting.HistogramChartBase) this).HistogramChartParameters.PaletteColors;

                    htmlBuilder.AppendLine("<h2 class=\"gadgetHeading\">" + ((EpiDashboard.Controls.Charting.HistogramChartBase) this).HistogramChartParameters.GadgetTitle + "</h2>");
                }
                htmlBuilder.AppendLine("<div id=\"Linechart" + count + "\" style=\"float:left\"></div>");

                if (!string.IsNullOrEmpty(_color.ToString()))
                {
                    htmlBuilder.AppendLine("<script>  " + _color.ToString());
                }
                else
                {
                    htmlBuilder.AppendLine("<script> ");
                }



                htmlBuilder.AppendLine(" var Linechart" + count + " = c3.generate({bindto: '#Linechart" + count + "',data: {  columns: [");

                try{
                    try
                    {
                        if (ChartType == "HistogramChart")
                        {
                            List <EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData> _HChartdataList = (List <EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData>) this.Chart.DataSource;
                            var HChartGroups = _HChartdataList.GroupBy(x => x.X);

                            foreach (var DataItem in HChartGroups)
                            {
                                htmlBuilder.AppendLine("['" + DataItem.ToList()[0].X + "', ");
                                _Groups.AppendLine("'" + DataItem.ToList()[0].X + "', ");
                                foreach (var item in DataItem)
                                {
                                    htmlBuilder.AppendLine(item.Y + ", ");
                                }


                                htmlBuilder.AppendLine("],");
                            }

                            htmlBuilder.AppendLine("]");
                        }
                        else if (ChartType == "ParetoChart")
                        {
                            List <EpiDashboard.Gadgets.Charting.XYParetoChartData> _ParetoChartList = (List <EpiDashboard.Gadgets.Charting.XYParetoChartData>) this.Chart.DataSource;
                            var ParetoChartList = _ParetoChartList.GroupBy(x => x.X);
                            htmlBuilder.AppendLine("['Percentage', ");
                            foreach (var DataItem in ParetoChartList)
                            {
                                foreach (var item in DataItem)
                                {
                                    htmlBuilder.AppendLine(item.Z + ", ");
                                }
                            }
                            htmlBuilder.AppendLine("],");
                            htmlBuilder.AppendLine("['Count', ");
                            foreach (var DataItem in ParetoChartList)
                            {
                                foreach (var item in DataItem)
                                {
                                    htmlBuilder.AppendLine(item.Y + ", ");
                                }
                            }
                            htmlBuilder.AppendLine("]");
                            htmlBuilder.AppendLine("]");
                        }
                        else
                        {
                            List <EpiDashboard.Gadgets.Charting.XYColumnChartData> _dataList = (List <EpiDashboard.Gadgets.Charting.XYColumnChartData>) this.Chart.DataSource;
                            var Groups = _dataList.GroupBy(x => x.X);

                            foreach (var DataItem in Groups)
                            {
                                htmlBuilder.AppendLine("['" + DataItem.ToList()[0].X + "', ");
                                _Groups.AppendLine("'" + DataItem.ToList()[0].X + "', ");
                                foreach (var item in DataItem)
                                {
                                    htmlBuilder.AppendLine(item.Y + ", ");
                                }


                                htmlBuilder.AppendLine("],");
                            }

                            htmlBuilder.AppendLine("]");
                        }
                        if (ChartType == "LineChart")
                        {
                            htmlBuilder.AppendLine(" ,  type : 'line'  }, legend: { show: true }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " },");
                        }
                        else if (ChartType == "ColumnChart")
                        {
                            bool UseDiffColors = ((EpiDashboard.Controls.Charting.ColumnChartBase) this).ColumnChartParameters.UseDiffColors;

                            if (UseDiffColors)
                            {
                                htmlBuilder.AppendLine(" ,  type : 'bar' ,color: function (color, d) { return colors[d.index];} }, legend: { show: true }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " },bar: {width: {ratio: .8}},");
                            }
                            else
                            {
                                htmlBuilder.AppendLine(" ,  type : 'bar'   }, legend: { show: true }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " },bar: {width: {ratio: .8}},");
                            }
                        }
                        else if (ChartType == "ParetoChart")
                        {
                            htmlBuilder.AppendLine(" ,  type : 'bar' ,axes: { Percentage: 'y2'},types: {Percentage: 'line'}  }, legend: { show: true }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " },");
                        }
                        else if (ChartType == "AreaChart")
                        {
                            htmlBuilder.AppendLine(" ,  type : 'area'  }, legend: { show: true }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " },");
                        }
                        else if (ChartType == "HistogramChart")
                        {
                            htmlBuilder.AppendLine(" ,  type : 'bar'   }, legend: { show: true }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " }, bar: {width: {ratio: .8}},");
                        }

                        if (ChartType == "HistogramChart")
                        {
                            List <EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData> _HChartdataList = (List <EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData>) this.Chart.DataSource;
                            HistogramChartParameters HistogramChartParameters = new HistogramChartParameters();
                            //  (List<EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData>)this.Parameters.Parameters = new HistogramChartParameters();
                            //this.Parameters = new HistogramChartParameters();
                            EpiDashboard.Controls.Charting.HistogramChart _HCharList = (EpiDashboard.Controls.Charting.HistogramChart) this;
                            if (color.Count() > 0)
                            {
                                htmlBuilder.AppendLine(" color: { pattern: [");
                                for (int i = 0; i < color.Count(); i++)
                                {
                                    if (color[i].Length == 9)
                                    {
                                        htmlBuilder.AppendLine(" '" + color[i].Remove(1, 2) + "' ,");
                                    }
                                }


                                htmlBuilder.AppendLine(" ]},");
                            }
                            // htmlBuilder.AppendLine("axis: { x : {type: 'timeseries',  tick:  {  format: '%m/%d/%Y', rotate: 90, multiline: false}}}");
                            htmlBuilder.AppendLine("axis: { x : {type: 'category' ,tick:  {   rotate: 90, multiline: false} , categories:  [");
                            foreach (var item in _HChartdataList)
                            {
                                htmlBuilder.AppendLine("'" + item.S + "', ");
                            }
                        }

                        else if (ChartType == "ParetoChart")
                        {
                            List <EpiDashboard.Gadgets.Charting.XYParetoChartData> _dataList = (List <EpiDashboard.Gadgets.Charting.XYParetoChartData>) this.Chart.DataSource;
                            htmlBuilder.AppendLine(" color: { pattern: [");
                            for (int i = 0; i < color.Count(); i++)
                            {
                                if (color[i].Length == 9)
                                {
                                    htmlBuilder.AppendLine(" '" + color[i].Remove(1, 2) + "' ,");
                                }
                            }


                            htmlBuilder.AppendLine(" ]},");

                            htmlBuilder.AppendLine("axis: { x : { label:{ text:'" + ((EpiDashboard.Controls.Charting.ParetoChart) this).ParetoChartParameters.XAxisLabel + "' , position: 'outer-center'}, type: 'category'  , categories:  [");
                            foreach (var item in _dataList)
                            {
                                htmlBuilder.AppendLine("'" + item.X + "', ");
                            }
                        }

                        else
                        {
                            List <EpiDashboard.Gadgets.Charting.XYColumnChartData> _dataList = (List <EpiDashboard.Gadgets.Charting.XYColumnChartData>) this.Chart.DataSource;
                            htmlBuilder.AppendLine(" color: { pattern: [");
                            for (int i = 0; i < color.Count(); i++)
                            {
                                if (color[i].Length == 9)
                                {
                                    htmlBuilder.AppendLine(" '" + color[i].Remove(1, 2) + "' ,");
                                }
                            }


                            htmlBuilder.AppendLine(" ]},");

                            htmlBuilder.AppendLine("axis: { x : {show:false,type: 'category'  , categories:  [");
                            foreach (var item in _dataList)
                            {
                                htmlBuilder.AppendLine("'" + item.S + "', ");
                            }
                        }



                        htmlBuilder.AppendLine("]}");
                        if (ChartType == "LineChart")
                        {
                            htmlBuilder.AppendLine(" , y: {  label: { text:'" + ((EpiDashboard.Controls.Charting.LineChartBase) this).LineChartParameters.YAxisLabel + "' , position: 'outer-middle'}}");
                        }
                        else if (ChartType == "ColumnChart")
                        {
                            htmlBuilder.AppendLine(", y: {  label: { text: '" + ((EpiDashboard.Controls.Charting.ColumnChartBase) this).ColumnChartParameters.YAxisLabel + "', position: 'outer-middle'}}");
                        }
                        else if (ChartType == "AreaChart")
                        {
                            htmlBuilder.AppendLine(", y: {  label: { text:'" + ((EpiDashboard.Controls.Charting.AreaChartBase) this).AreaChartParameters.YAxisLabel + "', position: 'outer-middle'}}");
                        }
                        else if (ChartType == "ParetoChart")
                        {
                            htmlBuilder.AppendLine(", y: {  label:{ text:'" + ((EpiDashboard.Controls.Charting.ParetoChart) this).ParetoChartParameters.YAxisLabel + "' , position: 'outer-middle'}},y2: {show: true,label: {text: 'Percentage',position: 'outer-middle'},tick:{format:d3.format('100.0%')} }");
                        }
                        // tick:  {  format: '%m/%d/%Y', rotate: 90, multiline: false}
                        // htmlBuilder.AppendLine(",tick: {  x:{ multiline:true, culling: { max: 1 }, }, label : { text: 'Days', position: 'center-bottom', }, },");
                        // htmlBuilder.AppendLine(",tick:  {  format: '%m/%d/%Y', rotate: 90, multiline: false},");
                        htmlBuilder.AppendLine("}}); ");
                        if (!string.IsNullOrEmpty(_Groups.ToString()) && Composition == "Stacked")
                        {
                            htmlBuilder.AppendLine("setTimeout(function() {  Linechart" + count + ".groups([[" + _Groups + "]])}, 000);");
                        }

                        htmlBuilder.AppendLine("</script> ");
                    }
                    catch (Exception ex) {
                        //var _dataList = this.Chart.DataSource;
                        //    if (ChartType == "HistogramChart")
                        //    {
                        //        List<EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData> _dataList = (List<EpiDashboard.Controls.Charting.HistogramChart.XYHistogramChartData>)this.Chart.DataSource;

                        //        htmlBuilder.AppendLine("<h2 class=\"gadgetHeading\">" + this.ChartTitle + "</h2>");
                        //        htmlBuilder.AppendLine("<div id=\"piechart" + count + "\"></div>");

                        //        htmlBuilder.AppendLine("<script>");


                        //        htmlBuilder.AppendLine(" var piechart" + count + " = c3.generate({bindto: '#piechart" + count + "',data: { columns: [");
                        //        var temp = _dataList;

                        //        foreach (var item in _dataList)
                        //        {
                        //            htmlBuilder.AppendLine("['" + item.S + "', " + item.Y + "], ");

                        //        }
                        //        //string colorString = "";

                        //        htmlBuilder.AppendLine(" ],  type : 'bar'  },");

                        //        htmlBuilder.AppendLine(" color: { pattern: [");
                        //        if (color.Count() > 0)
                        //        {
                        //            for (int i = 0; i < _dataList.Count(); i++)
                        //        {


                        //            htmlBuilder.AppendLine(" '" + color[i].Remove(1,2) + "' ,");
                        //        }
                        //        }


                        //        htmlBuilder.AppendLine(" ]},");

                        //        htmlBuilder.AppendLine(" legend: { show: true , position: top }, size: { width: " + this.ActualWidth + ", height: " + this.ActualHeight + " },label: { format: function(value, ratio, id){return d3.format('$')(value);}}});");

                        //        htmlBuilder.AppendLine(" </script> ");



                        //    }
                    }
                }
                catch (Exception ex) { throw ex; }
            }
            return(htmlBuilder.ToString());
        }
Ejemplo n.º 34
0
        private void ActualizarePoze()
        {
            imagini.Clear();
            listaFisiere.Clear();
            Alignment Ax = comboBoxAx.SelectedItem as Alignment;

            if (Ax == null)
            {
                WF.MessageBox.Show((string)comboBoxAx.SelectedItem);
            }

            var fisiere = from string fisier in IO.Directory.GetFiles(textBoxDir.Text, "*.*", IO.SearchOption.AllDirectories)
                          where ".jpg.bmp.png.gif.jpeg.tiff".Contains(new IO.FileInfo(fisier).Extension.ToLower())
                          orderby fisier
                          select fisier;


            if (fisiere.Count() == 0)
            {
                WF.MessageBox.Show("Directorul nu contine imagini!");
                return;
            }
            else
            {
                listaFisiere.AddRange(fisiere);
            }


            double lungimeAx = Ax.EndingStation - Ax.StartingStation;

            if (imaginiCheie.Count == 0)
            {
                imaginiCheie.Add((int)(Ax.StartingStation * 1000), fisiere.First());
                imaginiCheie.Add((int)(Ax.EndingStation * 1000), fisiere.Last());
                //double interval = (Ax.EndingStation - Ax.StartingStation) / (fisiere.Count() - 1);
                //for (int i = 0; i < fisiere.Count(); i++)
                //{
                //    double km = i * interval;
                //    //WF.MessageBox.Show(string.Format("Lungime ax: {0}\nInterval intre poze: {1}\nPozitia curenta:{2}", lungimeAx, interval, km)); //Raport individual imagini
                //    imagini.Add((int)(km * 1000), fisiere.ElementAt(i));
                //}
            }
            else if (imaginiCheie.Count == 1)
            {
                if (imaginiCheie.First().Key < (int)(Ax.EndingStation * 1000))
                {
                    imaginiCheie.Add((int)(Ax.EndingStation * 1000), fisiere.Last());
                }
                else
                {
                    imaginiCheie.Add((int)(Ax.StartingStation * 1000), fisiere.First());
                }
            }
            for (int j = 1; j < imaginiCheie.Count; j++)
            {
                double interval = (double)(imaginiCheie.ElementAt(j).Key - imaginiCheie.ElementAt(j - 1).Key) /
                                  (listaFisiere.IndexOf(imaginiCheie.ElementAt(j).Value) - listaFisiere.IndexOf(imaginiCheie.ElementAt(j - 1).Value) - 0);
                if (j == 1 && listaFisiere.IndexOf(imaginiCheie.ElementAt(j - 1).Value) > 0)
                {
                    for (int nr = 1; nr < listaFisiere.IndexOf(imaginiCheie.ElementAt(j - 1).Value) - 1; nr++)
                    {
                        int index = listaFisiere.IndexOf(imaginiCheie.ElementAt(j - 1).Value) - nr;
                        imagini.Add((int)(imaginiCheie.ElementAt(j - 1).Key - nr * interval), listaFisiere[index]);
                    }
                }
                for (int nr = 0; nr <= (listaFisiere.IndexOf(imaginiCheie.ElementAt(j).Value) - listaFisiere.IndexOf(imaginiCheie.ElementAt(j - 1).Value) - 0); nr++)
                {
                    int index = listaFisiere.IndexOf(imaginiCheie.ElementAt(j - 1).Value) + nr;
                    int cheie = (int)(imaginiCheie.ElementAt(j - 1).Key + nr * interval);
                    if (!imagini.Keys.Contains(cheie))
                    {
                        imagini.Add((int)(imaginiCheie.ElementAt(j - 1).Key + nr * interval), listaFisiere[index]);
                    }
                }
                if (j == imaginiCheie.Count - 1 && listaFisiere.IndexOf(imaginiCheie.ElementAt(j).Value) < listaFisiere.Count - 1)
                {
                    for (int nr = 1; nr < listaFisiere.Count - listaFisiere.IndexOf(imaginiCheie.ElementAt(j).Value) - 0; nr++)
                    {
                        int index = listaFisiere.IndexOf(imaginiCheie.ElementAt(j).Value) + nr;
                        imagini.Add((int)(imaginiCheie.ElementAt(j).Key + nr * interval), listaFisiere[index]);
                    }
                }
            }


            //Scriere rezultat calibrare
            IO.FileInfo calibrare = new IO.FileInfo(textBoxDir.Text + @"\CALIBRARE.TXT");
            using (IO.StreamWriter SR = calibrare.CreateText())
            {
                foreach (int cheie in imagini.Keys)
                {
                    string fix = string.Empty;
                    if (imaginiCheie.Keys.Contains(cheie))
                    {
                        fix = "********";
                    }
                    SR.WriteLine(string.Format("Km: {0} -> {1}{2}", cheie, imagini[cheie], fix));
                }
            }



            //WF.Binding Bind = new WF.Binding("Value", imagini, "Keys");
            //trackBar1.DataBindings.Add(Bind);
            //    trackBar1.Minimum = (int)(Ax.StartingStation * 1000);
            //trackBar1.Maximum = (int)(Ax.EndingStation * 1000) + 1000;
            trackBar1.Minimum     = imagini.ElementAt(0).Key;
            trackBar1.Maximum     = imagini.Last().Key;
            trackBar1.Value       = trackBar1.Minimum;
            trackBar1.SmallChange = 5000;
            try
            {
                trackBar1.LargeChange = int.Parse(textBoxInterval.Text) * 1000;
            }
            catch
            {
                trackBar1.LargeChange = trackBar1.SmallChange * 5;
            }
            //trackBar1.SmallChange = (int)(interval * 1000);
            trackBar1.LargeChange = int.Parse(textBoxInterval.Text) * 1000;
            //trackBar1.LargeChange = trackBar1.SmallChange * 5;
            trackBar1.TickFrequency = trackBar1.SmallChange;
            trackBar1.TickStyle     = System.Windows.Forms.TickStyle.BottomRight;

            textBoxKm.Leave      += TextBoxKm_Leave;
            textBoxKm.KeyPress   += TextBoxKm_KeyPress;
            textBoxSalt.KeyPress += TextBoxSalt_KeyPress;

            AfisarePoza();
        }
Ejemplo n.º 35
0
        static void Main(string[] args)
        {
            try
            {
                string startPath;
                string INIfolderPath;
                string INIfilePath;

                INIfolderPath = System.IO.Directory.GetCurrentDirectory();
                INIfolderPath = INIfolderPath + "\\data.ini";

                string zipPath;
                string fileNames = "";
                string extractPath;
                string s  = "";
                string dt = DateTime.Now.ToShortDateString();
                dt = dt.Replace(".", "_");
                dt = dt.Replace(":", "_");
                using (StreamReader sr = File.OpenText(INIfolderPath))
                {   //ini data file
                    //1st line: source log files folder
                    s = sr.ReadLine();
                    var rx    = new System.Text.RegularExpressions.Regex(";");
                    var array = rx.Split(s);

                    //if we have several log folders
                    if (array.Length > 1)
                    {
                        for (int i = 0; i < array.Length; i++)
                        {
                            startPath   = array[i];
                            fileNames   = Environment.NewLine + fileNames + Environment.NewLine;
                            zipPath     = startPath + "\\" + "archive_" + dt + "_" + i + ".zip";
                            fileNames   = fileNames + zipPath + ":" + Environment.NewLine;
                            s           = sr.ReadLine();
                            extractPath = s;

                            string newFile;

                            using (ZipArchive archive = ZipFile.Open(zipPath, ZipArchiveMode.Update))
                            {
                                //archive.CreateEntryFromFile(newFile, "NewEntry.txt");
                            }
                            DateTime TodayDate = DateTime.Now;
                            DateTime WeekAgo   = TodayDate.AddDays(-7);
                            foreach (string file in Directory.EnumerateFiles(startPath, "*.*"))
                            {
                                newFile = file;
                                using (ZipArchive archive = ZipFile.Open(zipPath, ZipArchiveMode.Update))
                                {
                                    string fileName = file.ToString().TrimEnd();

                                    string result;

                                    result = Path.GetFileName(fileName);
                                    DateTime fileCreatedDate = File.GetLastWriteTime(fileName);
                                    if (fileCreatedDate < WeekAgo)

                                    {
                                        long length = new System.IO.FileInfo(file).Length;
                                        if (length < 300000000)
                                        {
                                            archive.CreateEntryFromFile(newFile, result);
                                            File.Delete(file);
                                            fileNames = fileNames + Environment.NewLine + file + "; ";
                                        }
                                    }
                                }
                            }
                        }
                    }
                    else
                    {
                        startPath = array[0];
                        s         = sr.ReadLine();
                        //3rd line: zip file
                        zipPath     = startPath + "\\" + "archive_" + dt + ".zip";
                        fileNames   = Environment.NewLine + fileNames + zipPath + ":" + Environment.NewLine;
                        s           = sr.ReadLine();
                        extractPath = s;
                        string newFile;



                        using (ZipArchive archive = ZipFile.Open(zipPath, ZipArchiveMode.Update))
                        {
                            //archive.CreateEntryFromFile(newFile, "NewEntry.txt");
                        }
                        DateTime TodayDate = DateTime.Now;
                        DateTime WeekAgo   = TodayDate.AddDays(-7);
                        foreach (string file in Directory.EnumerateFiles(startPath, "*.*"))
                        {
                            newFile = file;


                            //if (Directory.Exists("FOLDER_PATH"))
                            //{
                            //    var directory = new DirectoryInfo("FOLDER_PATH");
                            //    foreach (FileInfo file1 in directory.GetFiles())
                            //    {
                            //        if (!IsFileLocked(file1)) file1.Delete();
                            //    }
                            //}


                            using (ZipArchive archive = ZipFile.Open(zipPath, ZipArchiveMode.Update))
                            {
                                string fileName = file.ToString().TrimEnd();

                                string result;

                                result = Path.GetFileName(fileName);
                                DateTime fileCreatedDate = File.GetLastWriteTime(fileName);
                                //string str = null;
                                //string retString = null;

                                //retString = fileName.Substring(fileName.Length - startPath.Length-2);
                                //retString = str.Substring(0, 3);
                                if (fileCreatedDate < WeekAgo)

                                {
                                    var directory = new DirectoryInfo(startPath);
                                    // foreach (FileInfo file1 in directory.GetFiles())
                                    {
                                        //if (!IsFileLocked(file1) //&& (result ==file1.ToString()))

                                        //file1.Delete();
                                        {
                                            long length = new System.IO.FileInfo(file).Length;
                                            if (length < 300000000)
                                            {
                                                archive.CreateEntryFromFile(newFile, result);
                                                File.Delete(file);
                                                fileNames = fileNames + Environment.NewLine + file + "; ";
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }



                SendEmail("Server:" + Environment.MachineName + " " + (char)13 + (char)10 + fileNames);
            }
            catch (IOException e)
            {
                // Extract some information from this exception, and then
                // throw it to the parent method.
                if (e.Source != null)
                {
                    Console.WriteLine("IOException source: {0}", e.Source);
                }
                throw;
            }
        }
Ejemplo n.º 36
0
        //------------------------------------------------------------
        // CSConsoleArgs.wcstoul64
        //------------------------------------------------------------
        // to \Utilities

        //------------------------------------------------------------
        // CSConsoleArgs.ExamineNoConfigOption
        //
        /// <summary>
        /// <para>(ConsoleArgs::ProcessAutoConfig in sscli)</para>
        /// <para>Process '/noconfig', and CSC.CFG, modifying the argument list</para>
        /// <para>Process Auto Config options:
        /// #1 search for '/noconfig'
        /// if not present and csc.cfg exists in EXE dir, inject after env var stuff</para>
        /// <para>/noconfig が指定されていなければ、
        /// csc.rsp ファイルの内容をオプションリストに追加する。</para>
        /// </summary>
        //------------------------------------------------------------
        private void ExamineNoConfigOption()
        {
            this.NoConfig = false;

            //--------------------------------------------------
            // Scan the argument list for the "/noconfig" options. If present, just kill it and bail.
            // /noconfig または -noconfig が指定されていれば foundNoConfig に true をセットする。
            //--------------------------------------------------
            for (int i = 0; i < this.OptionList.Count; ++i)
            {
                string[] opt = this.OptionList[i];

                // Skip everything except options
                if ((opt.Length < 3 || opt[1] != "/"))
                {
                    continue;
                }

                if (String.Compare(opt[2], "noconfig", true) == 0)
                {
                    this.NoConfig = true;
                    // /noconfig オプションは引数リストから削除する。
                    // 複数回指定されている可能性もあるので break しない。
                    this.OptionList[i] = null;
                }
            }

            // /noconfig が指定されている場合は終了する。
            if (this.NoConfig)
            {
                return;
            }

            //--------------------------------------------------
            // 指定されていない場合は csc.rsp をレスポンスファイルとしてオプションに追加する。
            // まずこのアセンブリと同じディレクトリに csc.rsp があるか調べる。
            //--------------------------------------------------
            string rspFullName = null;

            System.IO.FileInfo finfo = null;
            Exception          excp  = null;

            try
            {
                rspFullName = Path.Combine(
                    Path.GetDirectoryName(Assembly.GetAssembly(typeof(Util)).Location),
                    @"csc.rsp");
            }
            catch (ArgumentException ex)
            {
                this.Controller.ReportError(ERRORKIND.ERROR, ex);
                return;
            }
            catch (PathTooLongException ex)
            {
                this.Controller.ReportError(ERRORKIND.ERROR, ex);
                return;
            }

            if (!IOUtil.CreateFileInfo(rspFullName, out finfo, out excp) || finfo == null)
            {
                if (excp != null)
                {
                    this.Controller.ReportError(ERRORKIND.ERROR, excp);
                }
                else
                {
                    this.Controller.ReportInternalCompilerError("ExamineNoConfigOption");
                }
                return;
            }

            if (!finfo.Exists)
            {
                // In this project, mscorlib.dll and system.dll are always imported.
                // So, it is not an error that csc.rsp is not found.
                this.Controller.WriteLine("no csc.rsp");
                return;
            }
            // If cannot open csc.rsp, show warning.
            if ((finfo.Attributes & (
                     System.IO.FileAttributes.Compressed |
                     System.IO.FileAttributes.Directory |
                     System.IO.FileAttributes.Encrypted)) != 0)
            {
                this.Controller.ReportError(ERRORKIND.WARNING, "csc.rsp could not be opened.");
                return;
            }

            //--------------------------------------------------
            // この時点では実際に csc.rsp が存在し読み取り可能である。
            // 先頭に @ をつけてオプションリストの先頭に追加する。
            //--------------------------------------------------
            this.OptionList.Insert(0, new string[3] {
                "@" + rspFullName, "@", rspFullName
            });
        }
Ejemplo n.º 37
0
        public static bool CheckIfFileIsReadOnly(string filePath)
        {
            System.IO.FileInfo fi = new System.IO.FileInfo(filePath);

            return(fi.Attributes == System.IO.FileAttributes.ReadOnly);
        }
Ejemplo n.º 38
0
        static void Main(string[] args)
        {
            Console.WriteLine("Starting video drop...");
            // TODO: Make fileList -> argList and then make fileList a List(Of FileInfo), that way other parameters can be passed
            // from the command line
            List <string> fileList  = new List <string>(args);
            bool          noArchive = false;

            WriteInfo(GetMethodName(), "Video files to convert:", DEBUGLEVEL.INFO);
            if (fileList.Count == 0)
            {
                fileList = new List <string>()
                {
                    "test.mp4"
                };                                           //, "hevc_test.mp4" };
                //noArchive = true;
            }
            string startTag  = "StartTag";
            string middleTag = "MiddleTag";
            string endTag    = "EndTag";
            var    line      = "<" + startTag + "> --colormatrix bt709 --range pc --input - range pc <" + middleTag + "^ --seek 2500 --frames 300 <" + endTag + ">";
            var    tagList   = VideoDropSettings.GetTags(line, new string[] { "<", ">" });

            INIReader.iniPath = DirectoryToString(Directory.GetCurrentDirectory()) + "VideoDrop.ini";
            Dictionary <string, string> newSettings = ReadINI();

            VideoDropSettings vdSettings = new VideoDropSettings(ref newSettings);

            vdSettings.SetDebugLevel();
            WriteInfo("ConsoleUI", "Settings List:", DEBUGLEVEL.DEBUG);
            foreach (string key in vdSettings.GlobalSettings.Keys)
            {
                WriteInfo("   ConsoleUI", "Key: " + key + "=" + vdSettings.GlobalSettings[key], DEBUGLEVEL.DEBUG);
            }
            List <string> activeProfiles = vdSettings.ActiveProfiles;
            int           totalVideos    = activeProfiles.Count * fileList.Count;
            int           numFinished    = 0;
            int           numFailed      = 0;
            // Setup_Encoder()
            VideoDropJob vjob = null; /* TODO: Change to default(_) if this is not a reference type */

            foreach (var arg in fileList)
            {
                bool successful = true;
                Console.WriteLine("   Current file: " + arg);
                foreach (var profile in activeProfiles)
                {
                    // Generate AVS and set paths
                    FileInfo file = new System.IO.FileInfo(arg);
                    Console.WriteLine("   Starting video #" + (numFinished + 1) + " of " + totalVideos);

                    vjob = new VideoDropJob(arg, vdSettings, profile);

                    Console.WriteLine("   Using profile: " + vjob.ActiveProfile);
                    vjob.GeneratePaths();
                    vjob.PrintPaths();
                    if (!vjob.Run())
                    {
                        successful = false;
                        numFailed += 1;
                    }

                    numFinished += 1;
                }

                // Done with all jobs for this video, archive it
                if (successful && !noArchive)
                {
                    vjob.ArchiveSource();
                }
            }

            Console.WriteLine("Finished...");
            if (numFailed > 0)
            {
                Console.WriteLine("   Failed " + numFailed + " jobs.");
            }
            Console.Read();
        }
Ejemplo n.º 39
0
        void handleFile(string fullPath)
        {
            try
            {
                // In case this is data-url download, at least Chrome will not rename file, but instead write to it
                // directly. This mean we may catch it in the act. Let's leave it some time to finish writing.
                Thread.Sleep(500);

                var info = new System.IO.FileInfo(fullPath);
                Trace.WriteLine("download: " + info.FullName);

                if (info.Extension != ".hex")
                {
                    return;
                }

                var infoName = info.Name;
                Trace.WriteLine("download name: " + info.Name);
                if (!infoName.StartsWith("microbit-", StringComparison.OrdinalIgnoreCase))
                {
                    return;
                }
                if (info.Name.EndsWith(".uploaded.hex", StringComparison.OrdinalIgnoreCase))
                {
                    return;
                }
                if (info.Length > 1000000)
                {
                    return;                        // make sure we don't try to copy large files
                }
                // already copying?
                if (Interlocked.Exchange(ref this.copying, 1) == 1)
                {
                    return;
                }

                try
                {
                    var           driveletters = getMicrobitDrives();
                    List <String> drives       = new List <String>();
                    foreach (var d in driveletters)
                    {
                        drives.Add(d.RootDirectory.FullName);
                    }
                    if (!String.IsNullOrEmpty(customcopypath) && Directory.Exists(customcopypath))
                    {
                        drives.Add(customcopypath);
                    }
                    if (drives.Count == 0)
                    {
                        this.updateStatus("no board found");
                        this.trayIcon.ShowBalloonTip(3000, "cancelled uploading...", "no board found", ToolTipIcon.None);
                        return;
                    }

                    this.updateStatus("uploading .hex file");
                    this.trayIcon.ShowBalloonTip(3000, "uploading...", "uploading .hex file", ToolTipIcon.None);

                    // copy to all boards
                    copyFirmware(info.FullName, drives);

                    // move away hex file
                    var temp = System.IO.Path.ChangeExtension(info.FullName, ".uploaded.hex");
                    try
                    {
                        File.Copy(info.FullName, temp, true);
                        File.Delete(info.FullName);
                    }
                    catch (IOException) { }
                    catch (NotSupportedException) { }
                    catch (UnauthorizedAccessException) { }
                    catch (ArgumentException) { }

                    // update ui
                    this.updateStatus("uploading done");
                    this.waitingForHexFileStatus();
                }
                finally
                {
                    Interlocked.Exchange(ref this.copying, 0);
                }
            }
            catch (IOException) { }
            catch (NotSupportedException) { }
            catch (UnauthorizedAccessException) { }
            catch (ArgumentException) { }
        }
Ejemplo n.º 40
0
        private void LoadToMfiles(string nameOrTitle, string documentDate, string ferretDocumentClass, string accountNumber, string clientName, string description, string extension, int docID, string filepath)
        {
            #region
            // Which vault are we connecting to?
            var vaultGuid = ((VaultComboBoxItem)vaultComboBox.SelectedItem).VaultGUID;//"{C840BE1A-5B47-4AC0-8EF7-835C166C8E24}";

            // Connect to the vault using a client connection.
            // ref: http://developer.m-files.com/APIs/COM-API/#api-modes-client-vs-server
            // Note: this code will just return the first connection to the vault.
            var clientApplication = new MFilesClientApplication();
            var vault             =
                clientApplication
                .GetVaultConnectionsWithGUID(vaultGuid)
                .Cast <VaultConnection>()
                .FirstOrDefault()?
                .BindToVault(IntPtr.Zero, true, true);
            if (null == vault)
            {
                throw new NotImplementedException("Vault connection not found");
            }

            long length = new System.IO.FileInfo("C:\\temp\\New_Sample.txt").Length;

            // Define the property values for the new object.
            var propertyValues = new MFilesAPI.PropertyValues();

            // Class.
            var classPropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)MFBuiltInPropertyDef.MFBuiltInPropertyDefClass
            };
            classPropertyValue.Value.SetValue(
                MFDataType.MFDatatypeLookup,  // This must be correct for the property definition.
                                              //(int)MFBuiltInDocumentClass.MFBuiltInDocumentClassOtherDocument
                (int)vault.ClassOperations.GetObjectClassIDByAlias("Class.FerretArchiveDocument")
                );
            propertyValues.Add(-1, classPropertyValue);

            // Name or title.
            var nameOrTitlePropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)MFBuiltInPropertyDef.MFBuiltInPropertyDefNameOrTitle
            };
            nameOrTitlePropertyValue.Value.SetValue(
                MFDataType.MFDatatypeText,  // This must be correct for the property definition.
                nameOrTitle
                );
            propertyValues.Add(-1, nameOrTitlePropertyValue);

            //Douument Date
            var docDatePropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)vault.PropertyDefOperations.GetPropertyDefIDByAlias("Prop.DocumentDate")
            };
            docDatePropertyValue.Value.SetValue(
                MFDataType.MFDatatypeDate,
                documentDate
                );
            propertyValues.Add(-1, docDatePropertyValue);

            // Ferret Document Class
            var ferretDocumentClassPropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)vault.PropertyDefOperations.GetPropertyDefIDByAlias("Prop.FerretDocumentClass")
            };
            ferretDocumentClassPropertyValue.Value.SetValue(
                MFDataType.MFDatatypeText,
                ferretDocumentClass
                );
            propertyValues.Add(-1, ferretDocumentClassPropertyValue);

            // Account Number
            var accountNumberPropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)vault.PropertyDefOperations.GetPropertyDefIDByAlias("Prop.AccountNumber")
            };
            accountNumberPropertyValue.Value.SetValue(
                MFDataType.MFDatatypeText,
                accountNumber
                );
            propertyValues.Add(-1, accountNumberPropertyValue);

            // Client Name
            var clientNamePropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)vault.PropertyDefOperations.GetPropertyDefIDByAlias("Prop.ClientName")
            };
            clientNamePropertyValue.Value.SetValue(
                MFDataType.MFDatatypeText,
                clientName
                );
            propertyValues.Add(-1, clientNamePropertyValue);

            // Description
            var descriptionPropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)vault.PropertyDefOperations.GetPropertyDefIDByAlias("Prop.Description")
            };
            descriptionPropertyValue.Value.SetValue(
                MFDataType.MFDatatypeText,
                description
                );
            propertyValues.Add(-1, descriptionPropertyValue);

            //Ferret Doc Id
            var docIdPropertyValue = new MFilesAPI.PropertyValue()
            {
                PropertyDef = (int)vault.PropertyDefOperations.GetPropertyDefIDByAlias("Prop.FerretDocId")
            };
            docIdPropertyValue.Value.SetValue(
                MFDataType.MFDatatypeInteger,
                docID
                );
            propertyValues.Add(-1, docIdPropertyValue);

            // Define the source files to add.
            var sourceFiles = new MFilesAPI.SourceObjectFiles();

            // Add one file.
            var myFile = new MFilesAPI.SourceObjectFile();
            myFile.SourceFilePath = @"C:\temp\\New_Sample.txt";
            myFile.Title          = "My test document"; // For single-file-documents this is ignored.
            myFile.Extension      = extension.Replace(".", "");
            sourceFiles.Add(-1, myFile);

            // What object type is being created?
            var objectTypeID = (int)MFBuiltInObjectType.MFBuiltInObjectTypeDocument;

            // A "single file document" must be both a document and contain exactly one file.
            var isSingleFileDocument =
                objectTypeID == (int)MFBuiltInObjectType.MFBuiltInObjectTypeDocument && sourceFiles.Count == 1;
            #endregion
            // Create the object and check it in.
            try
            {
                if (length != 0)
                {
                    var objectVersion = vault.ObjectOperations.CreateNewObjectEx(
                        objectTypeID,
                        propertyValues,
                        sourceFiles,
                        SFD: isSingleFileDocument,
                        CheckIn: true);
                    string msg = string.Format("Record {0}", docID);
                    WriteLog("Success:", msg);
                }
                else
                {
                    // Define the source files to add.
                    //var sourceFiles1 = new MFilesAPI.SourceObjectFiles();

                    //// Add one file.
                    //var myFile1 = new MFilesAPI.SourceObjectFile();
                    //myFile1.SourceFilePath = filepath;
                    //myFile1.Title = "My test document"; // For single-file-documents this is ignored.
                    //myFile1.Extension = extension.Replace(".", "");
                    //sourceFiles1.Add(-1, myFile1);

                    //var objectVersion = vault.ObjectOperations.CreateNewObjectEx(
                    //    objectTypeID,
                    //    propertyValues,
                    //    sourceFiles1,
                    //    SFD: isSingleFileDocument,
                    //    CheckIn: true);
                    //string msg = string.Format("Record {0}", docID);
                    //WriteLog("Success:", msg);
                    string ErrorMsg = string.Format("Record {0}, Document Name {1} dated {2} for account {3}. Msg is {4} ", docID, nameOrTitle, documentDate, accountNumber, "File size 0"); // e.Message);
                    WriteLog("Error:", ErrorMsg);
                    // string loadLog = string.Format("{0},(1},{2},{3},{4},{5},{6}", nameOrTitle, documentDate, ferretDocumentClass, accountNumber, clientName, description, filepath);
                    //  WriteErrorLog(loadLog);
                }
            }
            catch (System.IO.IOException e)
            {
                //try
                //{
                //    // Define the source files to add.
                //    var sourceFiles1 = new MFilesAPI.SourceObjectFiles();

                //    // Add one file.
                //    var myFile1 = new MFilesAPI.SourceObjectFile();
                //    myFile1.SourceFilePath = filepath;
                //    myFile1.Title = "My test document"; // For single-file-documents this is ignored.
                //    myFile1.Extension = extension.Replace(".", "");
                //    sourceFiles1.Add(-1, myFile1);

                //    var objectVersion = vault.ObjectOperations.CreateNewObjectEx(
                //        objectTypeID,
                //        propertyValues,
                //        sourceFiles1,
                //        SFD: isSingleFileDocument,
                //        CheckIn: true);
                //    string msg = string.Format("Record {0}", docID);
                //    WriteLog("Success:", msg);
                //}
                //catch
                {
                    string ErrorMsg = string.Format("Record {0}, Document Name {1} dated {2} for account {3}. Msg is {4} ", docID, nameOrTitle, documentDate, accountNumber, e.Message);
                    WriteLog("Error:", ErrorMsg);
                    string loadLog = string.Format("{0},(1},{2},{3},{4},{5},{6}", nameOrTitle, documentDate, ferretDocumentClass, accountNumber, clientName, description, filepath);
                    WriteErrorLog(loadLog);
                }
            }
        }
Ejemplo n.º 41
0
    public void OnPostprocessBuild(BuildReport report)
    {
#if UNITY_ANDROID
        if (autoIncrementVersion)
        {
            if ((report.summary.options & BuildOptions.Development) == 0)
            {
                PlayerSettings.Android.bundleVersionCode++;
                UnityEngine.Debug.Log("Incrementing version code to " + PlayerSettings.Android.bundleVersionCode);
            }
        }

        bool isExporting = true;
        foreach (var step in report.steps)
        {
            if (step.name.Contains("Compile scripts") ||
                step.name.Contains("Building scenes") ||
                step.name.Contains("Writing asset files") ||
                step.name.Contains("Preparing APK resources") ||
                step.name.Contains("Creating Android manifest") ||
                step.name.Contains("Processing plugins") ||
                step.name.Contains("Exporting project") ||
                step.name.Contains("Building Gradle project"))
            {
                OVRPlugin.SendEvent("build_step_" + step.name.ToLower().Replace(' ', '_'),
                                    step.duration.TotalSeconds.ToString(), "ovrbuild");
#if BUILDSESSION
                UnityEngine.Debug.LogFormat("build_step_" + step.name.ToLower().Replace(' ', '_') + ": {0}", step.duration.TotalSeconds.ToString());
#endif
                if (step.name.Contains("Building Gradle project"))
                {
                    isExporting = false;
                }
            }
        }
        OVRPlugin.AddCustomMetadata("build_step_count", report.steps.Length.ToString());
        if (report.summary.outputPath.Contains("apk"))         // Exclude Gradle Project Output
        {
            var fileInfo = new System.IO.FileInfo(report.summary.outputPath);
            OVRPlugin.AddCustomMetadata("build_output_size", fileInfo.Length.ToString());
        }
#endif
        if (!report.summary.outputPath.Contains("OVRGradleTempExport"))
        {
            OVRPlugin.SendEvent("build_complete", (System.DateTime.Now - buildStartTime).TotalSeconds.ToString(), "ovrbuild");
#if BUILDSESSION
            UnityEngine.Debug.LogFormat("build_complete: {0}", (System.DateTime.Now - buildStartTime).TotalSeconds.ToString());
#endif
        }

#if UNITY_ANDROID
        if (!isExporting)
        {
            // Get the hosts path to Android SDK
            if (adbTool == null)
            {
                adbTool = new OVRADBTool(OVRConfig.Instance.GetAndroidSDKPath(false));
            }

            if (adbTool.isReady)
            {
                // Check to see if there are any ADB devices connected before continuing.
                List <string> devices = adbTool.GetDevices();
                if (devices.Count == 0)
                {
                    return;
                }

                // Clear current logs on device
                Process adbClearProcess;
                adbClearProcess = adbTool.RunCommandAsync(new string[] { "logcat --clear" }, null);

                // Add a timeout if we cannot get a response from adb logcat --clear in time.
                Stopwatch timeout = new Stopwatch();
                timeout.Start();
                while (!adbClearProcess.WaitForExit(100))
                {
                    if (timeout.ElapsedMilliseconds > 2000)
                    {
                        adbClearProcess.Kill();
                        return;
                    }
                }

                // Check if existing ADB process is still running, kill if needed
                if (adbProcess != null && !adbProcess.HasExited)
                {
                    adbProcess.Kill();
                }

                // Begin thread to time upload and install
                var thread = new Thread(delegate()
                {
                    TimeDeploy();
                });
                thread.Start();
            }
        }
#endif
    }
Ejemplo n.º 42
0
 /// <summary>
 /// Get file last access
 /// </summary>
 /// <param name="filename">file name</param>
 /// <returns></returns>
 public static System.DateTime GetLastAccess(string filename)
 {
     System.IO.FileInfo fi = new System.IO.FileInfo(filename);
     //get Create Time
     return(fi.LastAccessTime);
 }
Ejemplo n.º 43
0
        private KeyValuePair <Dictionary <int, bool>, bool> solveCNF(FileInfo file)
        {
            //For omega3, threshold only works on existing pair, currently the new pair in D_N will all have constant cost,
            //so, no need to filter, either accept them all or not at all
            //Thus, we can use one threshold for both omega2 and omega3 (with option to accept new pair in D_N or not)
            //if (autoThreshold > 0)
            //    omega2Threshold = autoThreshold;
            double threshold2 = 1000000000 * autoThreshold;// omega2Threshold;
            //double threshold3 = 100000000000 + (1000000000 * omega3Threshold);

            Dictionary <int, bool> inducedPairs = new Dictionary <int, bool>();
            long time = DateTime.Now.Ticks;

            //solve
            string solverPath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "SATSolverConsole.jar");
            string strCmdText = string.Format("/C java -jar {0} {1}", solverPath, file.FullName);

            System.Diagnostics.Process          process   = new System.Diagnostics.Process();
            System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo();
            startInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
            startInfo.FileName    = "cmd.exe";
            startInfo.Arguments   = strCmdText;
            process.StartInfo     = startInfo;
            time = DateTime.Now.Ticks;
            process.Start();
            process.WaitForExit();
            long timeToSolve = (DateTime.Now.Ticks - time) / TimeSpan.TicksPerMillisecond;
            bool decision    = false;

            System.IO.FileInfo solFile  = new System.IO.FileInfo(file.FullName + ".sol");
            System.IO.FileInfo costFile = new System.IO.FileInfo(file.FullName + ".inf");
            string             solution = System.IO.File.ReadAllText(solFile.FullName);

            if (string.IsNullOrEmpty(solution.Trim()))
            {
                return(new KeyValuePair <Dictionary <int, bool>, bool>(new Dictionary <int, bool>(), decision)); //unsatisfiable
            }
            else
            {
                string[] lines = System.IO.File.ReadAllLines(file.FullName + ".inf");
                if (lines.Length > 1)
                {
                    totalCost = long.Parse(lines[1]);

                    currentCost      = totalCost - totalCostHistory;
                    totalCostHistory = totalCost;

                    /*if (omega3Threshold > 0)
                     *  if (currentCost <= threshold3)
                     *      Debug.WriteLine("ACCEPTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                     *  else
                     *      Debug.WriteLine("REJECTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                     * else if (omega2Threshold > 0)
                     *  if (currentCost <= threshold2)
                     *      Debug.WriteLine("ACCEPTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                     *  else
                     *      Debug.WriteLine("REJECTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                     */
                }
            }

            foreach (var item in solution.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries))
            {
                int    varValue         = int.Parse(item);
                bool   b                = varValue > 0 ? true : false;
                double currentThreshold = threshold2;

                /*bool useThreshold = false;
                 * if (omega3Threshold > 0 && omega2Threshold == 0)
                 * {
                 *  currentThreshold = threshold3;
                 *  useThreshold = true;// totalCost < omega3Threshold ? false : true;
                 * }
                 * else if (omega2Threshold > 0 && omega3Threshold == 0)
                 * {
                 *  currentThreshold = threshold2;
                 *  useThreshold = true;// totalCost < omega2Threshold ? false : true;
                 * }
                 * if (b && varPairMap.ContainsKey(varValue))
                 * {
                 *  Debug.WriteLine("CurrentCost: " + currentCost);
                 *  if (!useThreshold && currentCost == 100000000000)
                 *  {
                 *      inducedPairs[varValue] = true;
                 *      Debug.WriteLine("#ACCEPTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                 *  }
                 *  else// if (currentCost <= currentThreshold)
                 *  {
                 *      inducedPairs[varValue] = false;
                 *      //Debug.WriteLine("ACCEPTED PAIR: " + currentCost);
                 *      Debug.WriteLine("REJECTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                 *  }
                 *  //else
                 *  //    Debug.WriteLine("REJECTED PAIR: " + currentCost + "     totalCost: " + totalCost);
                 *  //if (totalCost > 100000000000)
                 *  //    Debug.WriteLine(totalCost);
                 * }*/
                if (b && varPairMap.ContainsKey(varValue))
                {
                    //if (languageOption == 2) //Change threshold
                    //    currentThreshold = 100000000000 + (1000000000 * omega2Threshold);
                    if (currentCost > highestCost)
                    {
                        highestCost = currentCost;
                    }
                    if (autoThreshold < 0 || (autoThreshold >= 0 && currentCost <= currentThreshold))
                    {
                        inducedPairs[varValue] = true;
                    }
                    else
                    {
                        inducedPairs[varValue] = false;
                    }

                    /*if (autoThreshold == 0 || (autoThreshold > 0 && currentCost <= currentThreshold))
                     * {
                     *  if (acceptOmega3NewPair) //Expecting Omega3 results with new pairs
                     *      inducedPairs[varValue] = true;
                     *  else //Expecting Omega2 results
                     *  {
                     *      double newPairsThreshold = 100000000000 + (1000000000 * autoThreshold);
                     *      if (currentCost <= newPairsThreshold)
                     *          inducedPairs[varValue] = true;
                     *      else
                     *          inducedPairs[varValue] = false;
                     *  }
                     * }*/
                }
            }

            return(new KeyValuePair <Dictionary <int, bool>, bool>(inducedPairs, decision));
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        CtlLib.SetUser(Session["APP_DBUSER"].ToString());

        string l_dtfrm = Request["p_dtfrom"];
        string l_dtto  = Request["p_dtto"];


        string TemplateFile = "rpt_60240100_Allotment_Occupancy_Details.xls";
        string TempFile     = "../../../../system/temp/rpt_60240100_Allotment_Occupancy_Details_" + Session["User_ID"].ToString() + ".xls";

        TemplateFile = Server.MapPath(TemplateFile);
        TempFile     = Server.MapPath(TempFile);

        //Create a new workbook
        IWorkbook exBook = NativeExcel.Factory.OpenWorkbook(TemplateFile);

        //Add worksheet
        IWorksheet exSheet = exBook.Worksheets[1];

        IRange range;

        //bind data to excel file
        string    para = "";
        DataTable dt;

        para = "'" + l_dtfrm + "','" + l_dtto + "'";

        dt = CtlLib.TableReadOpenCursor("ht_rpt_60240100_allotment_occ", para);
        //-----header---

        //---end--header---
        //--set-----DataBind--in---Master---
        if (dt.Rows.Count == 0)
        {
            exSheet.Cells[2, 3].Value = "There is not data!";
        }
        if (dt.Rows.Count > 0)
        {
            exSheet.Cells[2, 7].Value = dt.Rows[0]["print_time"].ToString();
            exSheet.Cells[2, 1].Value = dt.Rows[0]["para_date"].ToString();

            /*exSheet.Cells[2, 1].Select();
             *
             * byte[] MyData = new byte[0];
             * MyData = (byte[])dt.Rows[0]["logo_lotus"];
             * MemoryStream stream = new MemoryStream(MyData);
             * exSheet.Shapes.AddPicture(stream);*/
        }

        //----------------------
        ////end-set-----DataBind--in---Master---

        for (int l_addrow = 1; l_addrow < dt.Rows.Count; l_addrow++)
        {
            exSheet.Range["A5"].Rows.EntireRow.Insert();//insert row new of sheet
        }
        //set date title of year
        //exSheet.Cells[2, 1].Value = "Income Statement Year" + " " + l_year;

        //set data to detail.
        // loop detail not percent
        double l_total_vnd = 0;
        float  l_total_usd = 0;
        int    l_cnt       = dt.Rows.Count;

        for (int l_row = 1; l_row <= dt.Rows.Count; l_row++)
        {
            for (int col = 0; col <= 9; col++)
            {
                if (col == 5 || col == 7 || col == 8 || col == 9)
                {
                    if (dt.Rows[l_row - 1][col].ToString() == "")
                    {
                        exSheet.Cells[3 + l_row, col + 1].Value = dt.Rows[l_row - 1][col].ToString();
                    }
                    else
                    {
                        exSheet.Cells[3 + l_row, col + 1].Value = double.Parse(dt.Rows[l_row - 1][col].ToString());
                        exSheet.Cells[3, col + 1, l_row + 3, col + 1].NumberFormat = "#,##0";
                        exSheet.Cells[l_row + 3, col + 1].HorizontalAlignment      = XlHAlign.xlHAlignRight;
                    }
                }
                else
                {
                    exSheet.Cells[3 + l_row, col + 1].Value = dt.Rows[l_row - 1][col].ToString();
                    exSheet.Cells[l_row + 3, col + 1].HorizontalAlignment = XlHAlign.xlHAlignLeft;
                }
                if (dt.Rows[l_row - 1][0].ToString() != "" && dt.Rows[l_row - 1][1].ToString() == "")
                {
                    exSheet.Cells[l_row + 3, 1, l_row + 3, 10].Interior.Color = Color.Silver;
                }
                if (dt.Rows[l_row - 1][0].ToString() == "" && dt.Rows[l_row - 1][1].ToString() == "")
                {
                    exSheet.Cells[l_row + 3, 1, l_row + 3, 10].Interior.Color = Color.Orange;
                }
            }
        }

        // end loop detail percent
        if (File.Exists(TempFile))
        {
            File.Delete(TempFile);
        }


        // hide row firts

        range = exSheet.Range["A1"];
        // hide row A5
        range.Rows.Hidden = true;

        // font bold header

        exBook.SaveAs(TempFile);
        //CtlLib.ExcelToPdf(TempFile);
        //string pdfFilePath = TempFile.Replace(".xls", ".pdf");
        //write out to client broswer
        System.IO.FileInfo file = new System.IO.FileInfo(TempFile);
        //System.IO.FileInfo file = new System.IO.FileInfo(pdfFilePath);
        Response.Clear();
        Response.Charset         = "UTF-8";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        //Add header, give a default file name for "File Download/Store as"
        Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name));
        //Add header, set file size to enable browser display download progress
        Response.AddHeader("Content-Length", file.Length.ToString());
        //Set the return string is unavailable reading for client, and must be downloaded
        Response.ContentType = "application/ms-exSheet";
        //Response.ContentType = "application/pdf";
        //Send file string to client
        Response.WriteFile(TempFile);
        //Response.WriteFile(pdfFilePath);
        //Stop execute
        Response.End();
    }
Ejemplo n.º 45
0
 private void ExtractFile(SIO.FileInfo fileName, ExtendedDirectoryInfo targetDir)
 {
     Middle.Helpers.CompressionHelpers.Compression.Decompress(fileName, targetDir, string.Empty);
     //File.Delete(fileName.FullName);
 }
Ejemplo n.º 46
0
        private async Task httpGet(string URL, string localpath)
        {
            string fileName = Path.GetFileName(localpath);

            if (fileName.EndsWith(".stream%7E"))
            {
                fileName = fileName.Remove(fileName.Length - 3);
                fileName = fileName + "~";
            }

            filesToDownload.Add(localpath);
            numberOfActiveParallelDownloads++;

            if (!File.Exists(localpath))
            {
                DownloadStatus dl = new DownloadStatus();
                dl.File    = localpath;
                dl.percent = 0.0;
                dl.active  = true;
                statusOfDownloads.Add(dl);

                try
                {
                    Action EmptyDelegate = delegate() { };
                    control.ShadowBoxText.Text               = "Downloading '" + fileName + "'";
                    control.ShadowBox.Visibility             = Visibility.Visible;
                    control.shadowBoxCancelButton.Visibility = Visibility.Visible;
                    control.UpdateLayout();
                    control.Dispatcher.Invoke(DispatcherPriority.Render, EmptyDelegate);
                    // Create a new WebClient instance.

                    WebClient client = new WebClient();

                    client.DownloadProgressChanged += (s, e) =>
                    {
                        dl.percent = ((double)e.BytesReceived / (double)e.TotalBytesToReceive) * 100.0;
                        control.Dispatcher.BeginInvoke(new Action <DownloadStatus>(UpdateOnDownload), DispatcherPriority.Normal, dl);
                    };

                    client.DownloadFileCompleted += (s, e) =>
                    {
                        try
                        {
                            //control.Dispatcher.BeginInvoke(new Action<string>(FinishedDownload), DispatcherPriority.Normal, localpath);

                            string[] files = new string[filesToDownload.Count];
                            int      i     = 0;
                            foreach (string path in filesToDownload)
                            {
                                long length = new System.IO.FileInfo(path).Length;
                                if (length == 0)
                                {
                                    if (File.Exists(path))
                                    {
                                        File.Delete(path);
                                    }
                                }
                                else
                                {
                                    files[i] = path;
                                    i++;
                                }
                            }


                            loadFile(localpath);
                        }
                        catch
                        {
                            //Could happen when we cancel the download.
                        }
                    };

                    //tokenSource = new CancellationTokenSource();

                    CancellationToken token = tokenSource.Token;

                    await Task.Run(() =>
                    {
                        token.Register(() => { client.CancelAsync(); CanceledDownload(); return; });
                        client.DownloadFileAsync(new Uri(URL), localpath);
                    }, token);
                }
                catch (Exception ex)
                {
                    MessageTools.Error(ex.ToString());
                }
            }
            else
            {
                await control.Dispatcher.BeginInvoke(new Action <string>(FinishedDownload), DispatcherPriority.Normal, "");
            }
        }
Ejemplo n.º 47
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string from = Request.QueryString["from"];
                string to = Request.QueryString["to"];
                string role, state, vids, yr, mon, folderpath;
                //string atmid = Request.QueryString["atmid"];
                string user  = Request.QueryString["user"];
                string fname = Session["sess_userid"] + "_" + System.DateTime.Now.ToString("ddMMyyhhmmss");


                if (Request.QueryString["role"] == "%")
                {
                    role = "u.role in ('AO','DE','CM')";
                }
                else
                {
                    role = "u.role like '" + Request.QueryString["role"] + "'";
                }

                if (Request.QueryString["state"] == "")
                {
                    state = "a.state like '%'";
                }
                else
                {
                    state = "a.state in (" + Request.QueryString["state"] + ")";
                }

                conn.ConnectionString = ConfigurationManager.ConnectionStrings["SQLConnstr"].ConnectionString;
                string query = @"select vid,d.atmid from dr_ctp d inner join atms a on d.atmid=a.atmid join users u on u.userid=d.userid where 
                            convert(date,vdate) between  '" + from + "' and '" + to + "' and " + state + " and " + role +
                               " and  d.userid like '" + user + "'";
                // Response.Write(query);
                SqlCommand cmd1 = new SqlCommand(query, conn);
                conn.Open();
                SqlDataReader dr = cmd1.ExecuteReader();
                while (dr.Read())
                {
                    string path = Server.MapPath("~/BulkDownload/" + fname + "/" + dr[1].ToString() + "/" + dr[0].ToString());
                    //System.IO.Directory.CreateDirectory(Server.MapPath("~/BulkDownload/" + fname));

                    if (!Directory.Exists(path))
                    {
                        System.IO.Directory.CreateDirectory(path);
                    }

                    vids       = dr[0].ToString(); yr = getvalue(vids, 2); mon = getvalue(vids, 1);
                    folderpath = yr + @"\" + mon + @"\";


                    for (int i = 1; i <= 41; i++)
                    {
                        /*Add Files*/

                        try
                        {
                            if (File.Exists("C:\\Development\\CommonStorage\\Mphasis\\TransientStorage\\" + folderpath.Replace(@"\\", @"\\") + "PhotoQ" + i.ToString() + "_" + vids + ".jpg") == true)
                            {
                                File.Copy(@"C:\Development\CommonStorage\Mphasis\TransientStorage\" + folderpath + "PhotoQ" + i.ToString() + "_" + vids + ".jpg",
                                          @"C:\Development\v6_Mphasis\BulkDownload\" + fname + @"\" + dr[1].ToString() + @"\" + vids + @"\" + "PhotoQ" + i.ToString() + "_" + vids + ".jpg");
                            }
                        }
                        catch (Exception er)
                        {
                            //  Response.Write(er.Message.ToString());
                        }
                    }

                    for (int i = 0; i <= 5; i++)
                    {
                        /*Add Files*/

                        try
                        {
                            if (File.Exists("C:\\Development\\CommonStorage\\Mphasis\\TransientStorage\\" + folderpath.Replace(@"\\", @"\\") + "Photo" + vids + "_" + i.ToString() + ".jpg") == true)
                            {
                                File.Copy(@"C:\Development\CommonStorage\Mphasis\TransientStorage\" + folderpath + "Photo" + vids + "_" + i.ToString() + ".jpg",
                                          @"C:\Development\v6_Mphasis\BulkDownload\" + fname + @"\" + dr[1].ToString() + @"\" + vids + @"\" + "Photo" + vids + "_" + i.ToString() + ".jpg");
                            }
                        }
                        catch (Exception er)
                        {
                            //  Response.Write(er.Message.ToString());
                        }
                    }
                }

                conn.Close();
                /*Add Zip*/

                using (ZipFile zip = new ZipFile())
                {
                    try
                    {
                        zip.AddDirectory(@"C:\Development\v6_Mphasis\BulkDownload\" + fname);



                        //user = Session["sess_userid"].ToString() + "_" + System.DateTime.Now.ToString("hhmmss");
                        zip.Save(@"C:\Development\v6_Mphasis\BulkDownload\" + fname + ".zip");

                        /*Delete Folder*/
                        var dir = new DirectoryInfo(@"C:\Development\v6_Mphasis\BulkDownload\" + fname);
                        dir.Attributes = dir.Attributes & ~FileAttributes.ReadOnly;
                        dir.Delete(true);

                        System.IO.FileInfo file = new System.IO.FileInfo(@"C:\Development\v6_Mphasis\BulkDownload\" + fname + ".zip");
                        Response.ClearContent();
                        Response.AddHeader("Content-Disposition", String.Format("attachment; filename=" + fname + ".zip", file.Name));
                        Response.AddHeader("Content-Length", file.Length.ToString());
                        Response.ContentType = "application/zip";
                        this.EnableViewState = false;
                        Response.TransmitFile(file.FullName);
                        Response.Flush();

                        File.Delete(@"C:\Development\v6_Mphasis\BulkDownload\" + fname + ".zip");

                        Response.End();
                    }


                    catch { }
                }
            }
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        CtlLib.SetUser(Session["APP_DBUSER"].ToString());


        string TemplateFile = "rpt_60280120_payment_report.xls";
        string TempFile     = "../../../../system/temp/rpt_60280120_payment_report_" + Session["User_ID"].ToString() + ".xls";

        TemplateFile = Server.MapPath(TemplateFile);
        TempFile     = Server.MapPath(TempFile);

        //Create a new workbook
        IWorkbook exBook = NativeExcel.Factory.OpenWorkbook(TemplateFile);

        //Add worksheet
        IWorksheet exSheet = exBook.Worksheets[1];

        IRange range;

        //bind data to excel file


        string p_date           = Request["p_date"];
        string p_date_to        = Request["p_date_to"];
        string p_room           = Request["p_room"];
        string p_payment_method = Request["p_payment_method"];
        string p_partner_PK     = Request["p_partner_PK"];
        string p_time_frm       = Request["p_time_frm"];
        string p_time_to        = Request["p_time_to"];
        string p_cashier        = Request["p_cashier"];

        string    para = "'" + p_date + "','" + p_date_to + "','" + p_room + "','" + p_payment_method + "','" + p_partner_PK + "','" + p_time_frm + "','" + p_time_to + "','" + p_cashier + "'";
        DataTable dt   = CtlLib.TableReadOpenCursor("ht_sel_60280120", para);

        // MASTER



        // INSERT ROWS

        for (int l_addrow = 1; l_addrow < dt.Rows.Count; l_addrow++)
        {
            exSheet.Range["A9"].Rows.EntireRow.Insert();//insert row new of sheet
        }

        // SET DATA
        int pos = 8;
        int i   = 0;

        for (i = 0; i < dt.Rows.Count; i++)
        {
            exSheet.Cells[pos + i, 1].Value = i + 1;
            exSheet.Cells[pos + i, 2].Value = dt.Rows[i]["room_no"];
            exSheet.Cells[pos + i, 3].Value = dt.Rows[i]["invoice_no"];
            exSheet.Cells[pos + i, 4].Value = dt.Rows[i]["pay_date"];
            exSheet.Cells[pos + i, 5].Value = dt.Rows[i]["guest_name"];
            exSheet.Cells[pos + i, 6].Value = dt.Rows[i]["checkin_date"];
            exSheet.Cells[pos + i, 7].Value = dt.Rows[i]["checkout_date"];
            exSheet.Cells[pos + i, 8].Value = dt.Rows[i]["partner_name"];
            // exSheet.Cells[pos + i, 9 ].Value = dt.Rows[i]["description"];
        }
        //---------
        //exSheet.Cells[pos + i, 6 ].Value = "=sum(F10:F"+(pos+i-1)+")";
        //exSheet.Cells[pos + i, 7].Value = "=sum(G10:G"+(pos+i-1)+")";
        //---------
        if (File.Exists(TempFile))
        {
            File.Delete(TempFile);
        }
        // hide row firts
        range = exSheet.Range["A1"];
        // hide row A5
        // range.Rows.Hidden = true;
        // font bold header

        /*range = exSheet.Range["A1:AC1"];
         * range.Rows[4].Font.Bold = true;*/

        exBook.SaveAs(TempFile);
        //write out to client broswer
        System.IO.FileInfo file = new System.IO.FileInfo(TempFile);
        //System.IO.FileInfo file = new System.IO.FileInfo(pdfFilePath);
        Response.Clear();
        Response.Charset         = "UTF-8";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        //Add header, give a default file name for "File Download/Store as"
        Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name));
        //Add header, set file size to enable browser display download progress
        Response.AddHeader("Content-Length", file.Length.ToString());
        //Set the return string is unavailable reading for client, and must be downloaded
        Response.ContentType = "application/ms-exSheet";
        //Response.ContentType = "application/pdf";
        //Send file string to client
        //Response.WriteFile(pdfFilePath);
        Response.WriteFile(TempFile);
        //Stop execute
        Response.End();
    }
Ejemplo n.º 49
0
        private void textBoxDir_TextChanged(object sender, EventArgs e)
        {
            imagini.Clear();
            imaginiCheie.Clear();
            listaFisiere.Clear();
            pictureBox1.Image = null;

            if (IO.Directory.Exists(textBoxDir.Text))
            {
                //Asociere director cu aliniamentul
                using (acadDoc.LockDocument())
                    using (Transaction trdir = db.TransactionManager.StartTransaction())
                        using (ResultBuffer RB = new ResultBuffer(new TypedValue(1001, "OVIDIU"), new TypedValue(1000, "POZE->" + textBoxDir.Text)))
                        {
                            //Alignment Ax = (Alignment)trans.GetObject(((Alignment)comboBoxAx.SelectedItem).Id, OpenMode.ForWrite);
                            string    nume = ((Alignment)comboBoxAx.SelectedItem).Name;
                            Alignment Ax   = null;
                            foreach (ObjectId idAx in civDoc.GetAlignmentIds())
                            {
                                Ax = (Alignment)trdir.GetObject(idAx, OpenMode.ForRead);
                                if (Ax.Name == nume)
                                {
                                    Ax.UpgradeOpen();
                                    Ax.XData = RB;
                                }
                            }
                            //Ax.UpgradeOpen();
                            //Ax.XData = RB;


                            //Capturare Senzor
                            CapturaSenzor();
                            //CapturaSenzor(trans, Ax);
                            //TypedValue[] TVs = new TypedValue[]
                            //{
                            //    new TypedValue(0, "SOLID"),
                            //    new TypedValue(8, "AR-MArker"),
                            //    new TypedValue(62, "3")
                            //};
                            //SelectionFilter SF = new SelectionFilter(TVs);
                            //PromptSelectionResult PSR = ed.SelectAll(SF);
                            //if (PSR.Status != PromptStatus.OK) return;
                            //SelectionSet SS = PSR.Value;
                            //foreach (SelectedObject SO in SS)
                            //{
                            //    Solid S = (Solid)trans.GetObject(SO.ObjectId, OpenMode.ForRead);
                            //    double[] Xs = { S.GetPointAt(0).X, S.GetPointAt(1).X, S.GetPointAt(2).X };
                            //    double[] Ys = { S.GetPointAt(0).Y, S.GetPointAt(1).Y, S.GetPointAt(2).Y };
                            //    double km = double.NaN;
                            //    double offset = double.NaN;
                            //    try
                            //    {
                            //        Ax.StationOffset(Xs.Average(), Ys.Average(), ref km, ref offset);
                            //    }
                            //    catch { }
                            //    if (offset != double.NaN)
                            //    {
                            //        if (Senzor == null) Senzor = S;
                            //        else
                            //        {
                            //            double[] SenzorXs = { Senzor.GetPointAt(0).X, Senzor.GetPointAt(1).X, Senzor.GetPointAt(2).X };
                            //            double[] SenzorYs = { Senzor.GetPointAt(0).Y, Senzor.GetPointAt(1).Y, Senzor.GetPointAt(2).Y };
                            //            double SenzorKm = double.NaN;
                            //            double SenzorOffset = double.NaN;
                            //            try
                            //            {
                            //                Ax.StationOffset(SenzorXs.Average(), SenzorYs.Average(), ref SenzorKm, ref SenzorOffset);
                            //                if (offset < SenzorOffset) Senzor = S;
                            //            }
                            //            catch { }
                            //        }
                            //    }
                            //}
                            //if (Senzor != null) checkBoxSincr.Checked = true; //

                            trdir.Commit();
                        }//

                //Inregistrare vedere curenta
                VTRcur = ed.GetCurrentView().Clone() as ViewTableRecord;

                //Citire imaginiCheie din fisierul CALIBRARE.TXT daca acesta exista
                if (IO.File.Exists(textBoxDir.Text + @"\CALIBRARE.TXT"))
                {
                    using (IO.StreamReader reader = new IO.FileInfo(textBoxDir.Text + @"\CALIBRARE.TXT").OpenText())
                    {
                        string linie = null;
                        while ((linie = reader.ReadLine()) != null)
                        {
                            if (linie.Contains("********"))
                            {
                                try
                                {
                                    string[] componente = linie.Remove(0, 4).Replace("********", "").Split(new string[] { "-> " }, StringSplitOptions.None);
                                    imaginiCheie.Add(int.Parse(componente[0]), componente[1]);
                                }
                                catch { }
                            }
                        }
                    }
                    //WF.MessageBox.Show("Numar chei citite: " + imaginiCheie.Count.ToString() + ": " + imaginiCheie.ToString());
                }

                ActualizarePoze();
            }
            else
            {
                textBoxDir.Text = @"-";
            }
        }
Ejemplo n.º 50
0
 public virtual string GetAppSettingsPath()
 {
     //Used to determine where to store the settings
     System.IO.FileInfo fi = new System.IO.FileInfo(Application.ExecutablePath);
     return(fi.DirectoryName);
 }
Ejemplo n.º 51
0
        private void webGateway_ProcessRequest(object gwRequest)
        {
            var    request      = (WebServiceGatewayRequest)gwRequest;
            var    context      = request.Context;
            string requestedUrl = request.UrlRequest;
            bool   wroteBytes   = false;

            var migRequest = new MIGClientRequest()
            {
                Context        = context,
                RequestOrigin  = context.Request.RemoteEndPoint.Address.ToString(),
                RequestMessage = requestedUrl,
                SubjectName    = "HTTP",
                SubjectValue   = context.Request.HttpMethod,
                InputStream    = context.Request.InputStream,
                OutputStream   = context.Response.OutputStream
            };

            // we are expecting url in the forms http://<hgserver>/<hgservicekey>/<servicedomain>/<servicegroup>/<command>/<opt1>/.../<optn>
            // arguments up to <command> are mandatory.
            string migCommand = requestedUrl.Substring(requestedUrl.IndexOf('/', 1) + 1);
            //string section = requestedurl.Substring (0, requestedurl.IndexOf ('/', 1) - 1); TODO: "api" section keyword, ignored for now
            //TODO: implement "api" keyword in MIGInterfaceCommand?
            var command = new MIGInterfaceCommand(migCommand);


            //PREPROCESS request: if domain != html, execute command
            if (ServiceRequestPreProcess != null)
            {
                ServiceRequestPreProcess(migRequest, command);
                // request was handled by preprocess listener
                if (!string.IsNullOrEmpty(command.Response))
                {
                    // simple automatic json response type detection
                    if (command.Response.StartsWith("[") && command.Response.EndsWith("]") || (command.Response.StartsWith("{") && command.Response.EndsWith("}")))
                    {
                        // TODO: check the reason why this cause ajax/json error on some browser
                        context.Response.ContentType     = "application/json";
                        context.Response.ContentEncoding = defaultWebFileEncoding;
                    }
                    WebServiceUtility.WriteStringToContext(context, command.Response);
                    return;
                }
            }

            if (command.Domain == "MIGService.Interfaces")
            {
                // This is a MIGService namespace Web API
                context.Response.ContentType = "application/json";
                switch (command.Command)
                {
                case "IsEnabled.Set":
                    if (command.GetOption(0) == "1")
                    {
                        configuration.GetInterface(command.NodeId).IsEnabled = true;
                        EnableInterface(command.NodeId);
                    }
                    else
                    {
                        configuration.GetInterface(command.NodeId).IsEnabled = false;
                        DisableInterface(command.NodeId);
                    }
                    WebServiceUtility.WriteStringToContext(context, "[{ \"ResponseValue\" : \"OK\" }]");
                    //
                    if (InterfacePropertyChanged != null)
                    {
                        InterfacePropertyChanged(new InterfacePropertyChangedAction()
                        {
                            Domain     = "MIGService.Interfaces",
                            SourceId   = command.NodeId,
                            SourceType = "MIG Interface",
                            Path       = "Status.IsEnabled",
                            Value      = command.GetOption(0)
                        });
                    }
                    break;

                case "IsEnabled.Get":
                    WebServiceUtility.WriteStringToContext(
                        context,
                        "[{ \"ResponseValue\" : \"" + (configuration.GetInterface(command.NodeId).IsEnabled ? "1" : "0") + "\" }]"
                        );
                    break;

                case "Options.Set":
                    Interfaces[command.NodeId].SetOption(command.GetOption(0), command.GetOption(1));
                    WebServiceUtility.WriteStringToContext(context, "[{ \"ResponseValue\" : \"OK\" }]");
                    //
                    if (InterfacePropertyChanged != null)
                    {
                        InterfacePropertyChanged(new InterfacePropertyChangedAction()
                        {
                            Domain     = "MIGService.Interfaces",
                            SourceId   = command.NodeId,
                            SourceType = "MIG Interface",
                            Path       = "Options." + command.GetOption(0),
                            Value      = command.GetOption(1)
                        });
                    }
                    break;

                case "Options.Get":
                    string optionValue = Interfaces[command.NodeId].GetOption(command.GetOption(0)).Value;
                    WebServiceUtility.WriteStringToContext(
                        context,
                        "[{ \"ResponseValue\" : \"" + Uri.EscapeDataString(optionValue) + "\" }]"
                        );
                    break;

                default:
                    break;
                }
            }
            else if (requestedUrl.StartsWith(webServiceConfig.BaseUrl))
            {
                // If request begins /hg/html, process as standard Web request
                string requestedFile = GetWebFilePath(requestedUrl);
                if (!System.IO.File.Exists(requestedFile))
                {
                    context.Response.StatusCode = 404;
                    //context.Response.OutputStream.WriteByte();
                }
                else
                {
                    bool isText = false;
                    if (requestedUrl.EndsWith(".js")) // || requestedurl.EndsWith(".json"))
                    {
                        context.Response.ContentType = "text/javascript";
                        isText = true;
                    }
                    else if (requestedUrl.EndsWith(".css"))
                    {
                        context.Response.ContentType = "text/css";
                        isText = true;
                    }
                    else if (requestedUrl.EndsWith(".zip"))
                    {
                        context.Response.ContentType = "application/zip";
                    }
                    else if (requestedUrl.EndsWith(".png"))
                    {
                        context.Response.ContentType = "image/png";
                    }
                    else if (requestedUrl.EndsWith(".jpg"))
                    {
                        context.Response.ContentType = "image/jpeg";
                    }
                    else if (requestedUrl.EndsWith(".gif"))
                    {
                        context.Response.ContentType = "image/gif";
                    }
                    else if (requestedUrl.EndsWith(".mp3"))
                    {
                        context.Response.ContentType = "audio/mp3";
                    }
                    else if (requestedUrl.EndsWith(".appcache"))
                    {
                        context.Response.ContentType = "text/cache-manifest";
                    }
                    else
                    {
                        context.Response.ContentType = "text/html";
                        isText = true;
                    }

                    var file = new System.IO.FileInfo(requestedFile);
                    context.Response.AddHeader("Last-Modified", file.LastWriteTimeUtc.ToString("r"));
                    context.Response.Headers.Set(HttpResponseHeader.LastModified, file.LastWriteTimeUtc.ToString("r"));
                    // PRE PROCESS text output
                    //TODO: add callback for handling caching (eg. function that returns true or false with requestdfile as input and that will return false for widget path)
                    if (isText)
                    {
                        try
                        {
                            WebFileCache cachedItem = GetWebFileCache(requestedFile);
                            context.Response.ContentEncoding = cachedItem.Encoding;
                            context.Response.ContentType    += "; charset=" + cachedItem.Encoding.BodyName;
                            string body = cachedItem.Content;
                            //
                            // expand preprocessor tags
                            body = body.Replace("{hostos}", Environment.OSVersion.Platform.ToString());
                            //
                            bool tagFound;
                            do
                            {
                                tagFound = false;
                                int ts = body.IndexOf("{include ");
                                if (ts > 0)
                                {
                                    int te = body.IndexOf("}", ts);
                                    if (te > ts)
                                    {
                                        string rs = body.Substring(ts + (te - ts) + 1);
                                        string cs = body.Substring(ts, te - ts + 1);
                                        string ls = body.Substring(0, ts);
                                        //
                                        try
                                        {
                                            if (cs.StartsWith("{include "))
                                            {
                                                string fileName = cs.Substring(9).TrimEnd('}').Trim();
                                                fileName = GetWebFilePath(fileName);
                                                //
                                                Encoding fileEncoding = DetectWebFileEncoding(fileName);
                                                if (fileEncoding == null)
                                                {
                                                    fileEncoding = defaultWebFileEncoding;
                                                }
                                                body = ls + System.IO.File.ReadAllText(fileName, fileEncoding) + rs;
                                            }
                                        }
                                        catch
                                        {
                                            body = ls + "<h5 style=\"color:red\">Error processing '" + cs.Replace(
                                                "{",
                                                "["
                                                ).Replace(
                                                "}",
                                                "]"
                                                ) + "'</h5>" + rs;
                                        }
                                        tagFound = true;
                                    }
                                }
                            } while (tagFound); // pre processor tag found
                            //
                            if (webServiceConfig.CacheEnable)
                            {
                                PutWebFileCache(requestedFile, body, context.Response.ContentEncoding);
                            }
                            //
                            WebServiceUtility.WriteStringToContext(context, body);
                        }
                        catch (Exception ex)
                        {
                            // TODO: report internal mig interface  error
                            context.Response.StatusCode = 500;
                            WebServiceUtility.WriteStringToContext(context, ex.Message + "\n" + ex.StackTrace);
                            Console.WriteLine("\nMIGService ERROR: " + ex.Message + "\n" + ex.StackTrace + "\n");
                        }
                    }
                    else
                    {
                        WebServiceUtility.WriteBytesToContext(context, System.IO.File.ReadAllBytes(requestedFile));
                    }
                }
            }
            else
            {
                // Try processing as MigInterface Api or Web Service Dynamic Api
                object responseObject = null;
                //domain == HomeAutomation._Interface_ call InterfaceControl
                var result = (from miginterface in Interfaces.Values
                              let ns = miginterface.GetType().Namespace
                                       let domain = ns.Substring(ns.LastIndexOf(".") + 1) + "." + miginterface.GetType().Name
                                                    where (command.Domain != null && command.Domain.StartsWith(domain))
                                                    select miginterface).FirstOrDefault();
                if (result != null)
                {
                    try
                    {
                        responseObject = result.InterfaceControl(command);
                    }
                    catch (Exception ex)
                    {
                        // TODO: report internal mig interface  error
                        context.Response.StatusCode = 500;
                        responseObject = ex.Message + "\n" + ex.StackTrace;
                    }
                }
                //
                if (responseObject == null || responseObject.Equals(String.Empty))
                {
                    var postData = new StreamReader(context.Request.InputStream).ReadToEnd();
                    if (!String.IsNullOrEmpty(postData))
                    {
                        command.OriginalRequest += "/" + postData;
                    }
                    responseObject = WebServiceDynamicApiCall(command);
                }
                //
                if (responseObject != null && responseObject.GetType().Equals(typeof(string)))
                {
                    command.Response = (string)responseObject;
                    //
                    // simple automatic json response type detection
                    if (command.Response.StartsWith("[") && command.Response.EndsWith("]") || (command.Response.StartsWith("{") && command.Response.EndsWith("}")))
                    {
                        context.Response.ContentType     = "application/json";
                        context.Response.ContentEncoding = defaultWebFileEncoding;
                    }
                }
                else
                {
                    WebServiceUtility.WriteBytesToContext(context, (Byte[])responseObject);
                    wroteBytes = true;
                }
            }
            //
            //POSTPROCESS
            if (ServiceRequestPostProcess != null)
            {
                ServiceRequestPostProcess(migRequest, command);
                if (!string.IsNullOrEmpty(command.Response) && !wroteBytes)
                {
                    // request was handled by postprocess listener
                    WebServiceUtility.WriteStringToContext(context, command.Response);
                    return;
                }
            }
        }
Ejemplo n.º 52
0
        static void Main(string[] args)
        {
            Console.WriteLine("***** Write the location *****\n");

            string path = Console.ReadLine();

            string[] files = Directory.GetFiles(path);
            for (int i = 0; i < files.Length; i++)
            {
                files[i] = Path.GetFileName(files[i]);
            }
            Console.WriteLine(path);
            foreach (var x in files)
            {
                Console.WriteLine(x);
            }

            Episode_det temp = new Episode_det();

            for (int i = 0; i < files.Length; i++)
            {
                if (files[i].Substring(files[i].Length - 3) == "srt")
                {
                    string[] ssize = files[i].Split(null);
                    temp.series_name  = ssize[0];
                    temp.series_no    = Int32.Parse(ssize[2].Substring(0, 1));
                    temp.episode_no   = Int32.Parse(ssize[2].Substring(2, 2));
                    temp.episode_name = ssize[4].Substring(0, ssize[4].IndexOf("."));

                    string sourceFile = Path.Combine(path, @"\", files[i]);

                    System.IO.FileInfo fi = new System.IO.FileInfo(sourceFile);
                    Console.WriteLine(sourceFile);
                    if (fi.Exists)
                    {
                        string finalpath = Path.Combine(path, @"\", temp.series_name, " - ", "S0", temp.series_no.ToString(), "E", temp.episode_no.ToString(), " - ", temp.episode_name, ".srt");

                        fi.MoveTo(finalpath);
                    }
                    else
                    {
                        Console.WriteLine("foff3");
                    }

                    string sourceFile2 = Path.Combine(path, @"\", temp.series_name, " ", "S0", temp.series_no.ToString(), "E", temp.episode_no.ToString(), ".mp4");

                    System.IO.FileInfo fi2 = new System.IO.FileInfo(sourceFile2);
                    Console.WriteLine(sourceFile2);
                    if (fi2.Exists)
                    {
                        string finalpath2 = Path.Combine(path, @"\", temp.series_name, " - ", "S0", temp.series_no.ToString(), "E", temp.episode_no.ToString(), " - ", temp.episode_name, ".mp4");

                        fi2.MoveTo(finalpath2);
                    }
                    else
                    {
                        Console.WriteLine("foff4");
                    }
                }
            }
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        CtlLib.SetUser(Session["APP_DBUSER"].ToString());

        string p_dept_pk, p_work_mon, p_from_dt, p_to_dt, p_nation, p_group_pk, p_meal_emp_type;

        p_dept_pk       = Request["l_tco_dept_pk"].ToString();
        p_group_pk      = Request["l_thr_group_pk"].ToString();
        p_work_mon      = Request["l_work_mon"].ToString();
        p_to_dt         = Request["l_to_dt"].ToString();
        p_from_dt       = Request["l_from_dt"].ToString();
        p_meal_emp_type = Request["l_meal_emp_type"].ToString();

        string TemplateFile = "rpt_chrm00020_2.xls";
        string TempFile     = "../../../../system/temp/rpt_chrm00020_2_" + Session["User_ID"].ToString() + ".xls";

        TemplateFile = Server.MapPath(TemplateFile);
        TempFile     = Server.MapPath(TempFile);

        //Create a new workbook
        IWorkbook exBook = NativeExcel.Factory.OpenWorkbook(TemplateFile);

        //Add worksheet
        IWorksheet exSheet = exBook.Worksheets[1];

        string SQL_CODE
            = "SELECT MAX(CASE WHEN NUM_1 = 1 THEN NVL(NUM_2,0) ELSE 0 END) " +
              "          ,MAX(CASE WHEN NUM_1 = 2 THEN NVL(NUM_2,0) ELSE 0 END) " +
              "    FROM vhr_hr_code c " +
              "   WHERE id = 'HR0191' ";

        DataTable dt_hr_code = CtlLib.TableReadOpen(SQL_CODE);

        double meal_main_amt  = double.Parse(dt_hr_code.Rows[0][0].ToString());
        double snack_time_amt = double.Parse(dt_hr_code.Rows[0][1].ToString());

        int ncal = int.Parse(p_to_dt.Substring(6, 2).ToString()) - int.Parse(p_from_dt.Substring(6, 2).ToString()) + 1;
        int i;

        //======================================================================================================================
        string SQL_1
            = "  SELECT 1 seq,'',MAX((    SELECT g.ORG_NM  " +
              "              FROM TCO_ORG g  " +
              "             WHERE g.del_if = 0 AND G.ORG_TYPE = '06'  " +
              "        START WITH g.pk = b.pk  " +
              "        CONNECT BY PRIOR g.p_pk = g.pk)) div_nm " +
              "         ,B.ORG_NM org_nm " +
              "         ,C.WORKGROUP_NM group_nm " +
              "         ,D.EMP_ID EMP_ID " +
              "         ,D.FULL_NAME " +
              "         ,TO_CHAR (TO_DATE (D.JOIN_DT, 'yyyymmdd'), 'dd/mm/yyyy') join_dt " +
              "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
              "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";

        for (i = 1; i < ncal; i++)
        {
            SQL_1 = SQL_1 + "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                    "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                    "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                    "         ,SUM (CASE WHEN F.WORK_DT_OF_SHIFT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        }

        SQL_1 = SQL_1 + "    FROM THR_MEAL_CHECKING F, TCO_ORG B, THR_WORK_GROUP C, THR_EMPLOYEE D " +
                "   WHERE  F.DEL_IF = 0 AND B.DEL_IF = 0 AND C.DEL_IF =0 AND D.DEL_IF =0  " +
                "         AND F.THR_EMP_PK = d.pk " +
                "         AND F.TCO_ORG_PK = b.pk " +
                "         and D.THR_WG_PK = c.pk  " +
                "         AND F.WORK_DT_OF_SHIFT BETWEEN '" + p_from_dt + "' AND '" + p_to_dt + "' " +
                "         AND F.MEAL_TIMES IS NOT NULL " +
                "         AND F.MEAL_EMP_TYPE = 'IN' " +
                "         AND DECODE ('" + p_group_pk + "', 'ALL', 'ALL', D.THR_WG_PK) = '" + p_group_pk + "'  " +
                "         AND D.TCO_ORG_PK IN  " +
                "              (    SELECT g.pk  " +
                "                     FROM TCO_ORG g  " +
                "                    WHERE g.del_if = 0  " +
                "               START WITH g.pk =  " +
                "                             CASE  " +
                "                                WHEN '" + p_dept_pk + "' = 'ALL' THEN g.pk  " +
                "                                ELSE TO_NUMBER ('" + p_dept_pk + "')  " +
                "                             END  " +
                "               CONNECT BY PRIOR g.pk = g.p_pk)  " +
                "     GROUP BY D.EMP_ID,B.ORG_NM,C.WORKGROUP_NM,D.FULL_NAME,D.JOIN_DT " +
                " ORDER BY seq,div_nm,org_nm,EMP_ID     ";

        //======================================================================================================================
        string SQL_2
            = "  SELECT 2 seq,'','' div_nm " +
              "         ,'' org_nm " +
              "         ,'' group_nm " +
              "         ,F.EMP_ID EMP_ID " +
              "         ,F.FULL_NAME " +
              "         ,'' join_dt " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";

        for (i = 1; i < ncal; i++)
        {
            SQL_2 = SQL_2 + "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                    "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                    "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                    "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        }
        SQL_2 = SQL_2 + "    FROM THR_MEAL_CHECKING F " +
                "   WHERE  F.DEL_IF = 0   " +
                "         AND F.WORK_DT BETWEEN '" + p_from_dt + "' AND '" + p_to_dt + "' " +
                "         AND F.MEAL_TIMES IS NOT NULL " +
                "         AND F.MEAL_EMP_TYPE = 'OUT' " +
                "     GROUP BY F.EMP_ID,F.FULL_NAME " +
                " ORDER BY seq,div_nm,org_nm,EMP_ID     ";

        //======================================================================================================================
        string SQL_3
            = "  SELECT 3 seq,'','' div_nm " +
              "         ,'' org_nm " +
              "         ,'' group_nm " +
              "         ,'' EMP_ID " +
              "         ,F.VISITOR_NM " +
              "         ,'' join_dt " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";

        for (i = 1; i < ncal; i++)
        {
            SQL_3 = SQL_3 + "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                    "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                    "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                    "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        }
        SQL_3 = SQL_3 + "    FROM THR_MEAL_VISITOR F " +
                "   WHERE  F.DEL_IF = 0   " +
                "         AND F.WORK_DT BETWEEN '" + p_from_dt + "' AND '" + p_to_dt + "' " +
                "         AND F.MEAL_TIMES IS NOT NULL " +
                "    GROUP BY F.VISITOR_NM " +
                " ORDER BY seq,div_nm,org_nm,EMP_ID     ";

        //======================================================================================================================
        string SQL_ALL
            = "  SELECT 1 seq,'',MAX((    SELECT g.ORG_NM  " +
              "              FROM TCO_ORG g  " +
              "             WHERE g.del_if = 0 AND G.ORG_TYPE = '06'  " +
              "        START WITH g.pk = b.pk  " +
              "        CONNECT BY PRIOR g.p_pk = g.pk)) div_nm " +
              "         ,B.ORG_NM org_nm " +
              "         ,C.WORKGROUP_NM group_nm " +
              "         ,D.EMP_ID EMP_ID " +
              "         ,D.FULL_NAME " +
              "         ,TO_CHAR (TO_DATE (D.JOIN_DT, 'yyyymmdd'), 'dd/mm/yyyy') join_dt " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
              "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";

        for (i = 1; i < ncal; i++)
        {
            SQL_ALL = SQL_ALL + "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        }

        SQL_ALL = SQL_ALL + "    FROM THR_MEAL_CHECKING F, TCO_ORG B, THR_WORK_GROUP C, THR_EMPLOYEE D " +
                  "   WHERE  F.DEL_IF = 0 AND B.DEL_IF = 0 AND C.DEL_IF =0 AND D.DEL_IF =0  " +
                  "         AND F.THR_EMP_PK = d.pk " +
                  "         AND F.TCO_ORG_PK = b.pk " +
                  "         and D.THR_WG_PK = c.pk  " +
                  "         AND F.WORK_DT BETWEEN '" + p_from_dt + "' AND '" + p_to_dt + "' " +
                  "         AND F.MEAL_TIMES IS NOT NULL " +
                  "         AND F.MEAL_EMP_TYPE = 'IN' " +
                  "         AND DECODE ('" + p_group_pk + "', 'ALL', 'ALL', D.THR_WG_PK) = '" + p_group_pk + "'  " +
                  "         AND D.TCO_ORG_PK IN  " +
                  "              (    SELECT g.pk  " +
                  "                     FROM TCO_ORG g  " +
                  "                    WHERE g.del_if = 0  " +
                  "               START WITH g.pk =  " +
                  "                             CASE  " +
                  "                                WHEN '" + p_dept_pk + "' = 'ALL' THEN g.pk  " +
                  "                                ELSE TO_NUMBER ('" + p_dept_pk + "')  " +
                  "                             END  " +
                  "               CONNECT BY PRIOR g.pk = g.p_pk)  " +
                  "     GROUP BY D.EMP_ID,B.ORG_NM,C.WORKGROUP_NM,D.FULL_NAME,D.JOIN_DT " +
                  "    UNION ALL " +
                  "    SELECT 2 seq,'','' div_nm " +
                  "         ,'' org_nm " +
                  "         ,'' group_nm " +
                  "         ,F.EMP_ID EMP_ID " +
                  "         ,F.FULL_NAME " +
                  "         ,'' join_dt " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        for (i = 1; i < ncal; i++)
        {
            SQL_ALL = SQL_ALL + "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN 1 ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN 1 ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        }
        SQL_ALL = SQL_ALL + "    FROM THR_MEAL_CHECKING F " +
                  "   WHERE  F.DEL_IF = 0   " +
                  "         AND F.WORK_DT BETWEEN '" + p_from_dt + "' AND '" + p_to_dt + "' " +
                  "         AND F.MEAL_TIMES IS NOT NULL " +
                  "         AND F.MEAL_EMP_TYPE = 'OUT' " +
                  "     GROUP BY F.EMP_ID,F.FULL_NAME " +
                  "    UNION ALL " +
                  "    SELECT 3 seq,'','' div_nm " +
                  "         ,'' org_nm " +
                  "         ,'' group_nm " +
                  "         ,'' EMP_ID " +
                  "         ,F.VISITOR_NM " +
                  "         ,'' join_dt " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                  "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + 0,'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        for (i = 1; i < ncal; i++)
        {
            SQL_ALL = SQL_ALL + "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END) MEAL_MAIN_QTY " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 1 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + meal_main_amt + " ELSE 0 END) MEAL_MAIN_AMT " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END ELSE 0 END)  SNACK_TIME_QTY " +
                      "         ,SUM (CASE WHEN F.WORK_DT = TO_CHAR(TO_DATE('" + p_from_dt + "','yyyymmdd') + " + i + ",'yyyymmdd') THEN CASE WHEN F.MEAL_TYPE = 2 THEN NVL(F.MEAL_QTY,0) ELSE 0 END * " + snack_time_amt + " ELSE 0 END) SNACK_TIME_AMT ";
        }
        SQL_ALL = SQL_ALL + "    FROM THR_MEAL_VISITOR F " +
                  "   WHERE  F.DEL_IF = 0   " +
                  "         AND F.WORK_DT BETWEEN '" + p_from_dt + "' AND '" + p_to_dt + "' " +
                  "         AND F.MEAL_TIMES IS NOT NULL " +
                  "    GROUP BY F.VISITOR_NM " +
                  " ORDER BY seq,div_nm,org_nm,EMP_ID     ";

        string SQL;

        if (p_meal_emp_type == "IN")
        {
            SQL = SQL_1;
        }
        else if (p_meal_emp_type == "OUT")
        {
            SQL = SQL_2;
        }
        else if (p_meal_emp_type == "VIS")
        {
            SQL = SQL_3;
        }
        else
        {
            SQL = SQL_ALL;
        }

        //Response.Write(SQL);
        //Response.End();
        DataTable dt_emp = CtlLib.TableReadOpen(SQL);

        int irow = dt_emp.Rows.Count;
        int icol = dt_emp.Columns.Count;

        if (irow == 0)
        {
            Response.Write("There is no data.");
            Response.End();
        }


        //Khai bao bien
        int j, k, pos = 6;
        int ntotal = icol - 8, nseq = 0;        //8 cot khong sum

        double[] s_total = new double[ntotal];
        double[] g_total = new double[ntotal];
        int      ncount  = 0;

        for (j = 0; j < ntotal; j++)
        {
            s_total[j] = 0;
            g_total[j] = 0;
        }

        //Dem so luong thay doi meal type
        for (i = 0; i < irow - 1; i++)
        {
            if (dt_emp.Rows[i]["seq"].ToString() != dt_emp.Rows[i + 1]["seq"].ToString())
            {
                nseq++;
            }
        }
        //Insert new row

        for (i = 0; i < irow - 1 + nseq; i++)
        {
            exSheet.Range[pos + 1, 1].Rows.EntireRow.Insert();
        }

        //Title value
        exSheet.Cells["BL2"].Value = "Month: " + p_work_mon.Substring(4, 2).ToString() + "/" + p_work_mon.Substring(0, 4).ToString();

        //Show data
        for (i = 0; i < irow; i++)
        {
            for (k = 0; k < ntotal; k++)
            {
                s_total[k] = s_total[k] + double.Parse(dt_emp.Rows[i][k + 8].ToString());
                g_total[k] = g_total[k] + double.Parse(dt_emp.Rows[i][k + 8].ToString());
            }
            ncount++;
            exSheet.Cells[pos + i, 1].Value = ncount;
            for (j = 2; j < icol; j++)
            {
                if (j <= 7)
                {
                    exSheet.Cells[pos + i, j].Value = dt_emp.Rows[i][j].ToString();
                }
                else
                {
                    exSheet.Cells[pos + i, j].Value = double.Parse(dt_emp.Rows[i][j].ToString());
                }
            }

            //Dong sub total
            if (i == irow - 1)
            {
                exSheet.Cells[pos + i + 1, 1].Value = "Total " + ncount + " employees";
                for (k = 0; k < ntotal; k++)
                {
                    exSheet.Cells[pos + i + 1, k + 8].Value = s_total[k];
                    exSheet.Cells[pos + i + 2, k + 8].Value = g_total[k];
                }
            }
            else if (dt_emp.Rows[i]["seq"].ToString() != dt_emp.Rows[i + 1]["seq"].ToString())
            {
                exSheet.Cells[pos + i + 1, 1, pos + i + 1, 7].Merge();
                exSheet.Cells[pos + i + 1, 1, pos + i + 1, icol].Font.Bold = true;
                exSheet.Cells[pos + i + 1, 1].HorizontalAlignment          = XlHAlign.xlHAlignCenter;
                exSheet.Cells[pos + i + 1, 1].Value = "Total " + ncount + " employees";

                for (k = 0; k < ntotal; k++)
                {
                    exSheet.Cells[pos + i + 1, k + 8].Value = s_total[k];
                    s_total[k] = 0;
                }

                ncount = 0;
                pos++;
            }
        }

        //Xóa cột dư ở những tháng không đủ 31 ngày
        int ndel = 0;   //so luong ngày can xoa
        int cdel = 0;   //vi tri cot can xoa

        ndel = 31 - ncal;
        cdel = ncal * 4 + 7;

        for (i = 0; i < ndel * 4; i++)
        {
            exSheet.Range[1, cdel + 1].Columns.EntireColumn.Delete();
            exSheet.Range[1, cdel + 1].Columns.EntireColumn.Delete();
        }

        // end loop detail percent
        if (File.Exists(TempFile))
        {
            File.Delete(TempFile);
        }


        // hide row firts

        //range = exSheet.Range["A1"];
        // hide row A5
        //range.Rows.Hidden = true;

        exBook.SaveAs(TempFile);
        //CtlLib.ExcelToPdf(TempFile);
        //string pdfFilePath = TempFile.Replace(".xls", ".pdf");

        //write out to client broswer
        System.IO.FileInfo file = new System.IO.FileInfo(TempFile);
        //System.IO.FileInfo file = new System.IO.FileInfo(pdfFilePath);
        Response.Clear();
        Response.Charset         = "UTF-8";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        //Add header, give a default file name for "File Download/Store as"
        Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name));
        //Add header, set file size to enable browser display download progress
        Response.AddHeader("Content-Length", file.Length.ToString());
        //Set the return string is unavailable reading for client, and must be downloaded
        Response.ContentType = "application/ms-exSheet";
        //Response.ContentType = "application/pdf";
        //Send file string to client
        Response.WriteFile(TempFile);
        //Response.WriteFile(pdfFilePath);
        //Stop execute
        Response.End();
    }
Ejemplo n.º 54
0
        /// <summary>
        /// Adds the console, debugger, file, or host listener if requested.
        /// </summary>
        internal void AddTraceListenersToSources(Collection <PSTraceSource> matchingSources)
        {
            if (DebuggerListener)
            {
                if (_defaultListener == null)
                {
                    _defaultListener =
                        new DefaultTraceListener();

                    // Note, this is not meant to be localized.
                    _defaultListener.Name = "Debug";
                }

                AddListenerToSources(matchingSources, _defaultListener);
            }

            if (PSHostListener)
            {
                if (_hostListener == null)
                {
                    ((MshCommandRuntime)this.CommandRuntime).DebugPreference = ActionPreference.Continue;
                    _hostListener = new PSHostTraceListener(this);

                    // Note, this is not meant to be localized.
                    _hostListener.Name = "Host";
                }

                AddListenerToSources(matchingSources, _hostListener);
            }

            if (FileListener != null)
            {
                if (_fileListeners == null)
                {
                    _fileListeners = new Collection <TextWriterTraceListener>();
                    FileStreams    = new Collection <FileStream>();

                    Exception error = null;

                    try
                    {
                        Collection <string> resolvedPaths = new Collection <string>();
                        try
                        {
                            // Resolve the file path
                            ProviderInfo provider = null;
                            resolvedPaths = this.SessionState.Path.GetResolvedProviderPathFromPSPath(FileListener, out provider);

                            // We can only export aliases to the file system
                            if (!provider.NameEquals(this.Context.ProviderNames.FileSystem))
                            {
                                throw
                                    new PSNotSupportedException(
                                        StringUtil.Format(TraceCommandStrings.TraceFileOnly,
                                                          FileListener,
                                                          provider.FullName));
                            }
                        }
                        catch (ItemNotFoundException)
                        {
                            // Since the file wasn't found, just make a provider-qualified path out if it
                            // and use that.

                            PSDriveInfo  driveInfo = null;
                            ProviderInfo provider  = null;
                            string       path      =
                                this.SessionState.Path.GetUnresolvedProviderPathFromPSPath(
                                    FileListener,
                                    new CmdletProviderContext(this.Context),
                                    out provider,
                                    out driveInfo);

                            // We can only export aliases to the file system
                            if (!provider.NameEquals(this.Context.ProviderNames.FileSystem))
                            {
                                throw
                                    new PSNotSupportedException(
                                        StringUtil.Format(TraceCommandStrings.TraceFileOnly,
                                                          FileListener,
                                                          provider.FullName));
                            }

                            resolvedPaths.Add(path);
                        }

                        if (resolvedPaths.Count > 1)
                        {
                            throw
                                new PSNotSupportedException(StringUtil.Format(TraceCommandStrings.TraceSingleFileOnly, FileListener));
                        }

                        string resolvedPath = resolvedPaths[0];

                        Exception fileOpenError = null;
                        try
                        {
                            if (ForceWrite && System.IO.File.Exists(resolvedPath))
                            {
                                // remove readonly attributes on the file
                                System.IO.FileInfo fInfo = new System.IO.FileInfo(resolvedPath);
                                if (fInfo != null)
                                {
                                    // Save some disk write time by checking whether file is readonly..
                                    if ((fInfo.Attributes & FileAttributes.ReadOnly) == FileAttributes.ReadOnly)
                                    {
                                        // Make sure the file is not read only
                                        fInfo.Attributes &= ~(FileAttributes.ReadOnly);
                                    }
                                }
                            }

                            // Trace commands always append..So there is no need to set overwrite with force..
                            FileStream fileStream = new FileStream(resolvedPath, FileMode.Append, FileAccess.Write, FileShare.ReadWrite);
                            FileStreams.Add(fileStream);

                            // Open the file stream

                            TextWriterTraceListener fileListener =
                                new TextWriterTraceListener(fileStream, resolvedPath);

                            fileListener.Name = FileListener;

                            _fileListeners.Add(fileListener);
                        }
                        catch (IOException ioException)
                        {
                            fileOpenError = ioException;
                        }
                        catch (SecurityException securityException)
                        {
                            fileOpenError = securityException;
                        }
                        catch (UnauthorizedAccessException unauthorized)
                        {
                            fileOpenError = unauthorized;
                        }

                        if (fileOpenError != null)
                        {
                            ErrorRecord errorRecord =
                                new ErrorRecord(
                                    fileOpenError,
                                    "FileListenerPathResolutionFailed",
                                    ErrorCategory.OpenError,
                                    resolvedPath);

                            WriteError(errorRecord);
                        }
                    }
                    catch (ProviderNotFoundException providerNotFound)
                    {
                        error = providerNotFound;
                    }
                    catch (System.Management.Automation.DriveNotFoundException driveNotFound)
                    {
                        error = driveNotFound;
                    }
                    catch (NotSupportedException notSupported)
                    {
                        error = notSupported;
                    }

                    if (error != null)
                    {
                        ErrorRecord errorRecord =
                            new ErrorRecord(
                                error,
                                "FileListenerPathResolutionFailed",
                                ErrorCategory.InvalidArgument,
                                FileListener);

                        WriteError(errorRecord);
                    }
                }

                foreach (TraceListener listener in _fileListeners)
                {
                    AddListenerToSources(matchingSources, listener);
                }
            }
        }
Ejemplo n.º 55
0
        // function to add files and folders recursively
        private bool AddFileOrFolderRecursive(FolderTreeNode parentNode, String path)
        {
            // if path is a file
            if (File.Exists(path))
            {
                VirtFsNode virtFsFileNode;
                FileData   fileOverwrite = null;
                if (parentNode.childFiles != null)
                {
                    foreach (FileData file in parentNode.childFiles)
                    {
                        if (!file.deleted && Path.GetFileName(file.virtFsNode.FileName).Equals(Path.GetFileName(path), StringComparison.CurrentCultureIgnoreCase))
                        {
                            if (MessageBox.Show(String.Format("File \"{0}\" already exists, overwrite?", file.virtFsNode.FileName), "Overwrite?", MessageBoxButtons.YesNo) == DialogResult.No)
                            {
                                return(false);
                            }
                            else
                            {
                                if ((file.addedFrom != ""))
                                {
                                    fileOverwrite = file;
                                }
                                else
                                {
                                    file.deleted = true;
                                }
                                break;
                            }
                        }
                    }
                }


                virtFsFileNode = new VirtFsNode();
#pragma warning disable 1690
                virtFsFileNode.FileName = TreeHelper.FullPath(parentNode.virtFsNode.FileName, Path.GetFileName(path));
#pragma warning restore 1690
                virtFsFileNode.FileFlags = VIRT_FILE_FLAGS.ISFILE;      //it's a file
                if (Path.GetExtension(virtFsFileNode.FileName).Equals(".dll"))
                {
                    virtFsFileNode.FileFlags |= VIRT_FILE_FLAGS.DEPLOY_UPON_PRELOAD;
                }


                System.IO.FileInfo fi = new System.IO.FileInfo(path);
                virtFsFileNode.EndOfFile = (ulong)fi.Length;

                if (fileOverwrite != null)
                {
                    fileOverwrite.virtFsNode = virtFsFileNode;
                }
                else
                {
                    AddFileOrFolder(virtFsFileNode, path);     // Also sets dirty = true
                }
                if (parentNode == fsFolderTree.SelectedNode)
                {
                    RefreshFolderNodeRecursively(parentNode, 0);
                    TreeViewEventArgs ev = new TreeViewEventArgs(parentNode);
                    OnFolderTreeSelect(null, ev);
                }
                return(true);
            }

            if (!Directory.Exists(path))
            {
                return(false);
            }

            FolderTreeNode folderOverwrite = null;
            //foreach (String subdir in subdirs)
            {
                foreach (FolderTreeNode childNode in parentNode.Nodes)
                {
                    if (childNode.Text.Equals(Path.GetFileName(path), StringComparison.CurrentCultureIgnoreCase))
                    {
#pragma warning disable 1690
                        if (!childNode.deleted && MessageBox.Show(String.Format("Folder \"{0}\" already exists, overwrite?", childNode.virtFsNode.FileName), "Overwrite?", MessageBoxButtons.YesNo) == DialogResult.No)
#pragma warning restore 1690
                        {
                            return(false);
                        }
                        else
                        {
                            folderOverwrite   = childNode;
                            childNode.deleted = false;
                            if (childNode.childFiles != null)
                            {
                                foreach (FileData file in childNode.childFiles)
                                {
                                    file.deleted = true;// make sure files from a previously deleted folder dont come back..
                                }
                            }
                            break;
                        }
                    }
                }
            }

            String[] lsFiles = Directory.GetFiles(path);
            String[] lsDirs  = Directory.GetDirectories(path);
            FolderTreeNode subdirNode;
            if (folderOverwrite == null)
            {
                // if path is a folder
                VirtFsNode virtFsDirNode = new VirtFsNode();
#pragma warning disable 1690
                virtFsDirNode.FileName = TreeHelper.FullPath(parentNode.virtFsNode.FileName, Path.GetFileName(path));
#pragma warning restore 1690
                virtFsDirNode.FileFlags = 0;                           //it's a dir
                subdirNode = AddFileOrFolder(virtFsDirNode, path);     // Also sets dirty = true
            }
            else
            {
                subdirNode = folderOverwrite;
            }


            foreach (String file in lsFiles)
            {
                if (!AddFileOrFolderRecursive(subdirNode, file))
                {
                    return(false);
                }
            }
            foreach (String dir in lsDirs)
            {
                if (!AddFileOrFolderRecursive(subdirNode, dir))
                {
                    return(false);
                }
            }
            if (parentNode == fsFolderTree.SelectedNode)
            {
                RefreshFolderNodeRecursively(parentNode, 0);
                TreeViewEventArgs ev = new TreeViewEventArgs(parentNode);
                OnFolderTreeSelect(null, ev);
            }
            return(true);
        }
        private void GenerateContent()
        {
            try
            {
                sb = new StringBuilder();
                sb.AppendLine("--Generated Upgrade For Version " + _model.Version + "." + _model.GeneratedVersion);
                sb.AppendLine("--Generated on " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                sb.AppendLine();

                //***********************************************************
                //ATTEMPT TO GENERATE AN UPGRADE SCRIPT FROM PREVIOUS VERSION
                //***********************************************************

                #region Generate Upgrade Script

                //Find the previous model file if one exists
                var fileName     = this._model.GeneratorProject.FileName;
                var prevFileName = fileName + ".sql.lastgen";
                var fiPrev       = new System.IO.FileInfo(prevFileName);
                var fi           = new System.IO.FileInfo(fileName);

                if (fiPrev.Exists)
                {
                    var newFileName = string.Format(fileName, "sql.");

                    //Rename old style to new style
                    if (File.Exists(prevFileName) && !File.Exists(fileName))
                    {
                        File.Move(fileName, newFileName);
                    }

                    fileName = newFileName;

                    fi = new System.IO.FileInfo(fileName);
                    if (fi.Exists)
                    {
                        var newFile = fileName + ".converting";
                        if (File.Exists(newFile))
                        {
                            File.Delete(newFile);
                            System.Threading.Thread.Sleep(250);
                        }
                        File.Copy(fileName, newFile);
                        var fileText = File.ReadAllText(newFile);
                        fileText = fileText.Replace("Widgetsphere.Generator.", "nHydrate.Generator.");
                        fileText = fileText.Replace("WidgetsphereGeneratorProject", "nHydrateGeneratorProject");
                        File.WriteAllText(newFile, fileText);
                        System.Threading.Thread.Sleep(500);

                        //Load the previous model
                        var generator = nHydrate.Generator.Common.GeneratorFramework.GeneratorHelper.OpenModel(prevFileName);
                        var oldRoot   = generator.Model as ModelRoot;
                        sb.Append(SqlHelper.GetModelDifferenceSql(oldRoot, _model));

                        if (File.Exists(newFile))
                        {
                            File.Delete(newFile);
                        }

                        //Copy the current LASTGEN file to BACKUP
                        //fi.CopyTo(fileName + ".bak", true);
                    }
                }

                //Just in case it was there, but there is already a new file name, just remove it
                if (File.Exists(prevFileName))
                {
                    File.Delete(prevFileName);
                }

                //Save this version on top of the old version
                var currentFile = new System.IO.FileInfo(this._model.GeneratorProject.FileName);
                currentFile.CopyTo(prevFileName, true);

                #endregion
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Ejemplo n.º 57
0
        //[TestMethod]
        public void RunPerformanceComparison()
        {
            //string testfilesDirectory = @"C:\Users\margus\Desktop\IJCAR12\proceedings";
            string testfilesDirectory = "../../../GeneratedCodeSamples/SampleTexts";
            var    someTestFiles      = System.IO.Directory.GetFiles(testfilesDirectory);

            int decodeTimeSystem_tot    = 0;
            int decodeTimeSystemWeb_tot = 0;
            int decodeTimeA_tot         = 0;
            int decodeTimeS_tot         = 0;

            long totsize = 0;

            int someTestFileNr = 0;

            while (totsize < 100000000)
            {
                string file = someTestFiles[someTestFileNr];
                someTestFileNr = (someTestFileNr + 1) % someTestFiles.Length;

                int    LIMIT   = 1000000;
                var    fi      = new System.IO.FileInfo(file);
                var    size    = fi.Length;
                string content = "<" + System.IO.File.ReadAllText(file, Encoding.UTF8) + ">";
                string encoded = HtmlEncodeStrict.Apply(content);

                string decoded_System    = "";
                string decoded_SystemWeb = "";
                string decoded_A         = "";
                string decoded_S         = "";

                //--- decode with system
                int decodeTimeSystemNet = System.Environment.TickCount;
                for (long K = 0; K < LIMIT; K += size)
                {
                    decoded_System = System.Net.WebUtility.HtmlDecode(encoded);
                    totsize       += size;
                }
                decodeTimeSystemNet = System.Environment.TickCount - decodeTimeSystemNet;

                int decodeTimeSystemWeb = System.Environment.TickCount;
                for (long K = 0; K < LIMIT; K += size)
                {
                    decoded_SystemWeb = System.Web.HttpUtility.HtmlDecode(encoded);
                }
                decodeTimeSystemWeb = System.Environment.TickCount - decodeTimeSystemWeb;

                //--- decode with methB (using StringBuilder)
                int decodeTimeS = System.Environment.TickCount;
                for (long K = 0; K < LIMIT; K += size)
                {
                    decoded_S = HtmlDecodeS.Apply(encoded);
                }
                decodeTimeS = System.Environment.TickCount - decodeTimeS;

                //--- decode with methA (using Array)
                int decodeTimeA = System.Environment.TickCount;
                for (long K = 0; K < LIMIT; K += size)
                {
                    decoded_A = HtmlDecodeA.Apply(encoded);
                }
                decodeTimeA = System.Environment.TickCount - decodeTimeA;

                //--- summary of times
                //string summary = string.Format("{0}: System:{1}ms, methA:{2}ms, methS:{3}ms", fi.Name, decodeTimeSystem, decodeTimeA, decodeTimeS);
                //Console.WriteLine(summary);

                //--- validate outputs
                Assert.AreEqual <string>(decoded_System, decoded_SystemWeb);
                if (!decoded_System.Equals(decoded_A))
                {
                    for (int i = 0; i < decoded_System.Length; i++)
                    {
                        if (decoded_System[i] != decoded_A[i])
                        {
                            Assert.Fail();
                        }
                    }
                }
                Assert.AreEqual <string>(decoded_System, decoded_S);


                decodeTimeSystem_tot    += decodeTimeSystemNet;
                decodeTimeSystemWeb_tot += decodeTimeSystemWeb;
                decodeTimeA_tot         += decodeTimeA;
                decodeTimeS_tot         += decodeTimeS;
            }

            string summary_tot = string.Format("{0}MB: System.Net.WebUtility.HtmlDecode:{1}ms, System.Web.HttpUtility.HtmlDecode:{4}, methA:{2}ms, methS:{3}ms",
                                               totsize / 1000000, decodeTimeSystem_tot, decodeTimeA_tot, decodeTimeS_tot, decodeTimeSystemWeb_tot);

            Console.WriteLine(summary_tot);
        }
Ejemplo n.º 58
0
        public static void TraverseTree(string root)
        {
            // Data structure to hold names of subfolders to be
            // examined for files.
            Stack <string> dirs = new Stack <string>(20);

            if (!System.IO.Directory.Exists(root))
            {
                throw new ArgumentException();
            }
            dirs.Push(root);

            while (dirs.Count > 0)
            {
                string   currentDir = dirs.Pop();
                string[] subDirs;
                try
                {
                    subDirs = System.IO.Directory.GetDirectories(currentDir);
                }
                // An UnauthorizedAccessException exception will be thrown if we do not have
                // discovery permission on a folder or file. It may or may not be acceptable
                // to ignore the exception and continue enumerating the remaining files and
                // folders. It is also possible (but unlikely) that a DirectoryNotFound exception
                // will be raised. This will happen if currentDir has been deleted by
                // another application or thread after our call to Directory.Exists. The
                // choice of which exceptions to catch depends entirely on the specific task
                // you are intending to perform and also on how much you know with certainty
                // about the systems on which this code will run.
                catch (UnauthorizedAccessException e)
                {
                    Console.WriteLine(e.Message);
                    continue;
                }
                catch (System.IO.DirectoryNotFoundException e)
                {
                    Console.WriteLine(e.Message);
                    continue;
                }

                string[] files = null;
                try
                {
                    files = System.IO.Directory.GetFiles(currentDir);
                }
                catch (UnauthorizedAccessException e)
                {
                    Console.WriteLine(e.Message);
                    continue;
                }
                catch (System.IO.DirectoryNotFoundException e)
                {
                    Console.WriteLine(e.Message);
                    continue;
                }
                // Perform the required action on each file here.
                // Modify this block to perform your required task.
                int counter = 0;
                foreach (string file in files)
                {
                    counter++;
                    try
                    {
                        // Perform whatever action is required in your scenario.
                        System.IO.FileInfo fi       = new System.IO.FileInfo(file);
                        string             contents = File.ReadAllText(file);

                        contents = StripComments(contents);

                        string pattern   = @"namespace (.*);";
                        var    NameSpace = PCRE.PcreRegex.Match(contents, pattern).ToArray();
                        //System.Data.DataTable results = DBStorage.SQLite.Query("namespaces", "SELECT id from namespaces where name='" + NameSpace[1] + "'");
                        //if (results != null && results.Rows.Count == 0)
                        //{
                        //    //DBStorage.SQLite.Query("namespaces", @"INSERT INTO namespaces VALUES(" + counter + ",'" + NameSpace[1] + "','" + fi.Name + "')");
                        //}

                        pattern = @"use (.*);";
                        PcreMatch[] Dependencies = PCRE.PcreRegex.Matches(contents, pattern).ToArray();
                        var         depList      = String.Join(", ", Dependencies.AsEnumerable());

                        pattern = @"\s+(?<functionView>\w+)\s*function\s+(?<functionName>\w+)\s?(?<functionArguments>\(.*(?R)*\))\s*(?<functionBody>{(?:[^{}]+|(?-1))*+})?";
                        var    PageFunctions = PCRE.PcreRegex.Matches(contents, pattern).ToArray();
                        string queries       = "";
                        foreach (var function in PageFunctions)
                        {
                            string privacy           = function[1];
                            string functionName      = function[2];
                            string functionArguments = function[3];
                            string FunctionBody      = function[4];
                            pattern = @"\s+(?<functionNameSpace>(?=[^\s\(\>])(\$this-\>)?([\w\d]*[\:|\\]{0,2}){0,4})(?=\s*\()";
                            var           InternalFunctions      = PCRE.PcreRegex.Matches(FunctionBody, pattern).ToArray();
                            int           InternalFunctionsCount = 0;
                            List <string> InternalFunctionsList  = new List <string>();
                            if (InternalFunctions.Length > 0)
                            {
                                foreach (var func in InternalFunctions)
                                {
                                    bool builtin = false;
                                    foreach (var builtInPHP in PHPFNames.php_functions)
                                    {
                                        if (builtInPHP == func[1])
                                        {
                                            builtin = true;
                                            break;
                                        }
                                    }

                                    if (builtin == false)
                                    {
                                        InternalFunctionsList.Add(func[1]);
                                    }
                                }

                                InternalFunctionsList  = InternalFunctionsList.Distinct().ToList();
                                InternalFunctionsCount = InternalFunctionsList.Count;
                            }
                            var InternalFunctionsListString = String.Join(", ", InternalFunctionsList.AsEnumerable());
                            //(?<functionName>(?=[^\(])([\w\d]*[:|\\]*)*[\w\d]*)\s?\((?<Arguments>.*)?\)
                            queries += @"INSERT INTO code_objects (namespace,scope,name,args,body,total_using,using_list,internal_function_list,internal_function_count,filename) VALUES('" + NameSpace[1] + "','" + privacy.Replace("'", "''") + "','" + functionName.Replace("'", "''") + "','" + functionArguments.Replace("'", "''") + "','" + FunctionBody.Replace("'", "''") + "','" + Dependencies.Length + "','" + depList.Replace("'", "''") + "','" + InternalFunctionsListString + "','" + InternalFunctionsCount + "','" + file + "');";
                        }
                        DBStorage.SQLite.Query("namespaces", queries);
                        //System.Data.DataTable results2 = DBStorage.SQLite.Query("namespaces", "SELECT id,body from code_objects");
                        //if (results2 != null && results2.Rows.Count == 0)
                        //{
                        //    DBStorage.SQLite.Query("namespaces", @"INSERT INTO namespaces VALUES(" + counter + ",'" + NameSpace[1] + "','" + fi.Name + "')");
                        //}
                    }
                    catch (System.IO.FileNotFoundException e)
                    {
                        // If file was deleted by a separate application
                        //  or thread since the call to TraverseTree()
                        // then just continue.
                        Console.WriteLine(e.Message);
                        continue;
                    }
                }

                // Push the subdirectories onto the stack for traversal.
                // This could also be done before handing the files.
                foreach (string str in subDirs)
                {
                    dirs.Push(str);
                }
            }
        }
Ejemplo n.º 59
0
        /// <summary>
        /// Handle trace requests - typically during development, but may be turned on to track code flow in production.
        /// </summary>
        /// <param name="level"></param>
        /// <param name="message"></param>
        /// <param name="showingDatetime">If true, precede message with current date-time, otherwise just the message> The latter is useful for data dumps</param>
        public static void DoTrace(int level, string message, bool showingDatetime = true, string logPrefix = "")
        {
            //TODO: Future provide finer control at the control level
            string msg           = "";
            int    appTraceLevel = UtilityManager.GetAppKeyValue("appTraceLevel", 6);
            //bool useBriefFormat = true;
            const int NumberOfRetries = 4;
            const int DelayOnRetry    = 1000;

            if (showingDatetime)
            {
                msg = "\n " + System.DateTime.Now.ToString() + " - " + message;
            }
            else
            {
                msg = "\n " + message;
            }
            string datePrefix1 = System.DateTime.Today.ToString("u").Substring(0, 10);
            string datePrefix  = System.DateTime.Today.ToString("yyyy-dd");
            string logFile     = UtilityManager.GetAppKeyValue("path.trace.log", "");

            if (!string.IsNullOrWhiteSpace(logPrefix))
            {
                datePrefix += "_" + logPrefix;
            }
            //Allow if the requested level is <= the application thresh hold
            if (string.IsNullOrWhiteSpace(logFile) || level > appTraceLevel)
            {
                return;
            }
            string outputFile = "";

            if (message.IndexOf("UPPER CASE URI") > -1 || message.IndexOf("GRAPH URI") > -1)
            {
                logFile = logFile.Replace("[date]", "[date]_URI_ISSUES");
            }
            //added retries where log file is in use
            for (int i = 1; i <= NumberOfRetries; ++i)
            {
                try
                {
                    outputFile = logFile.Replace("[date]", datePrefix + (i < 3 ? "" : "_" + i.ToString()));

                    if (File.Exists(outputFile))
                    {
                        if (File.GetLastWriteTime(outputFile).Month != DateTime.Now.Month)
                        {
                            File.Delete(outputFile);
                        }
                    }
                    else
                    {
                        System.IO.FileInfo f = new System.IO.FileInfo(outputFile);
                        f.Directory.Create();                         // If the directory already exists, this method does nothing.
                    }

                    StreamWriter file = File.AppendText(outputFile);

                    file.WriteLine(msg);
                    file.Close();
                    if (level > 0)
                    {
                        Console.WriteLine(msg);
                    }
                    break;
                }
                catch (IOException e) when(i <= NumberOfRetries)
                {
                    // You may check error code to filter some exceptions, not every error
                    // can be recovered.
                    Thread.Sleep(DelayOnRetry);
                }
                catch (Exception ex)
                {
                    //ignore errors
                }
            }
        }
Ejemplo n.º 60
0
        /// <summary>
        /// Get file write time
        /// </summary>
        /// <param name="filename">file name</param>
        /// <returns></returns>
        public static System.DateTime GetWriteTime(string filename)
        {
            System.IO.FileInfo fi = new System.IO.FileInfo(filename);

            return(fi.LastWriteTime);
        }