public void DoMergePAMDocument(long id, string mergeByFQN, string mergeBy) { MergeDocument svcMerge = new MergeDocument(); string conStringIIF = this.AppConfig.IIFConnectionString; svcMerge.MergePAMDocument(id, conStringIIF, this.AppConfig.PAMMergeDocumentTemplateLocation, this.AppConfig.PAMMergeDocumentTemporaryLocation, mergeByFQN, mergeBy); PAM_Services svcPAM = new PAM_Services(); svcPAM.AppConfig = this.AppConfig; svcPAM.DownloadPAMToSharedFolder(id); }
static void Main(string[] args) { try { log4net.Config.XmlConfigurator.Configure(); MergeDocument svcMerge = new MergeDocument(); //string conStringIIF = "data source=k2projectiif;initial catalog=IIF;user id=sa;password=P@ssw0rd;"; //string conStringIIF = "data source=.;initial catalog=IIF;user id=sa;password=P@ssw0rd;"; //string templateFolder = @"\\k2projectiif\c$\IIF\PAMTemplate\Newest"; //string mergeResultFolder = @"\\k2projectiif\c$\IIF\MergeResult"; //svcMerge.MergePAMDocument(32, conStringIIF, @"D:\Srf\Project\PIS\IIF\Merge\PAMTemplate", @"D:\Srf\Project\PIS\IIF\Merge\Temp", "MergeByFQN", "MergeBy"); //svcMerge.MergePAMDocument(10112, conStringIIF, templateFolder, @"C:\temp", "MergeByFQN", "MergeBy"); #region DB Old (IIF_Report) //10168 - CM Project Finance //svcMerge.MergeCMDocument(10168, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //20210 - CM Corporate Finance //svcMerge.MergeCMDocument(20210, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //53 - CM Equity //svcMerge.MergeCMDocument(53, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //20237 - CM Waiver //svcMerge.MergeCMDocument(20237, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //10131 - PAM Project Finance (gede) //svcMerge.MergePAMDocument(10131, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //10121 - PAM Project Finance (standard) //svcMerge.MergePAMDocument(10121, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //svcMerge.MergePAMDocument(10121, conStringIIF, templateFolder, @"C:\temp", "MergeByFQN", "MergeBy"); //10112 - PAM Corporate Finance //svcMerge.MergePAMDocument(10112, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //82 - PAM Corporate Finance (data aneh) //svcMerge.MergePAMDocument(82, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //10119 - PAM Equity //svcMerge.MergePAMDocument(10119, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); #endregion #region DBBARU-CLEAN (IIF) //string conStringIIF = "data source=.;initial catalog=IIF;user id=sa;password=P@ssw0rd;"; //string templateFolder = @"C:\Project\IIF\IIF\PAMTemplate"; //string mergeResultFolder = @"C:\Project\IIF\IIF\MergeResult"; //42 - PAM Equity //svcMerge.MergePAMDocument(42, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //39 - PAM Equity //svcMerge.MergePAMDocument(39, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //75 - PAM Equity //svcMerge.MergePAMDocument(75, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //40 - PAM Corporate //svcMerge.MergePAMDocument(40, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //72 - PAM Corporate //svcMerge.MergePAMDocument(72, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //77 - PAM Corporate //svcMerge.MergePAMDocument(77, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //41 - PAM Project Finance //svcMerge.MergePAMDocument(41, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //70 - PAM Project Finance //svcMerge.MergePAMDocument(70, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //76 - PAM Project Finance //svcMerge.MergePAMDocument(76, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //20 - CM Equity //svcMerge.MergeCMDocument(20, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //106 - CM Equity //svcMerge.MergeCMDocument(106, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //5 - CM Corporate Finance //svcMerge.MergeCMDocument(5, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //110 - CM Corporate Finance //svcMerge.MergeCMDocument(110, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //17 - CM Project Finance //svcMerge.MergeCMDocument(17, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //41 - CM Project Finance //svcMerge.MergeCMDocument(41, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //105 - CM Project Finance //svcMerge.MergeCMDocument(105, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //1 - CM Waiver //svcMerge.MergeCMDocument(1, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //103 - CM Waiver //svcMerge.MergeCMDocument(103, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); #endregion #region DB Dev/Prod IIF string conStringIIF = "data source=10.15.3.216\\IDJKTINSKTWO;initial catalog=IIF;user id=sa;password=@[email protected];"; string templateFolder = @"\\10.15.3.214\c$\IIF\PAMTemplate"; string mergeResultFolder = @"\\10.15.3.214\c$\IIF\MergeResult"; #region get INSTALLED fonts //InstalledFontCollection installedFontCollection = new InstalledFontCollection(); //FontFamily[] fontFamilies = installedFontCollection.Families; //int count = fontFamilies.Length; //for (int j = 0; j < count; ++j) //{ // Console.WriteLine(fontFamilies[j].Name); //} #endregion //2 - PAM Project Finance //svcMerge.MergePAMDocument(2, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //10 - PAM Project Finance //svcMerge.MergePAMDocument(10, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //17 - PAM Project Finance //svcMerge.MergePAMDocument(17, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //26 - PAM Project Finance //svcMerge.MergePAMDocument(26, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //16 - PAM Equity //svcMerge.MergePAMDocument(16, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //49 - PAM Equity svcMerge.MergePAMDocument(49, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //40 - PAM Corporate //svcMerge.MergePAMDocument(40, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //15 - CM WAIVER //svcMerge.MergeCMDocument(15, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //32 - CM WAIVER //svcMerge.MergeCMDocument(32, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //21 - CM PROJECT //svcMerge.MergeCMDocument(21, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //28 - CM PROJECT //svcMerge.MergeCMDocument(28, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //29 - CM PROJECT //svcMerge.MergeCMDocument(29, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //34 - CM PROJECT //svcMerge.MergeCMDocument(34, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //23 - CM Corporate //svcMerge.MergeCMDocument(23, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //2 - CM Equity //svcMerge.MergeCMDocument(2, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); //25 - CM Equity //svcMerge.MergeCMDocument(25, conStringIIF, templateFolder, mergeResultFolder, "MergeByFQN", "MergeBy"); #endregion Console.WriteLine("Success"); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadLine(); }