} // get /// <summary> /// Get Client Info /// </summary> /// <param name="ctx">context</param> /// <param name="AD_Client_ID">id</param> /// <param name="trxName">optional trx</param> /// <returns>Client Info</returns> public static MClientInfo Get(Ctx ctx, int AD_Client_ID, Trx trxName) { int key = AD_Client_ID; MClientInfo info = (MClientInfo)s_cache[key]; if (info != null) { return(info); } // String sql = "SELECT * FROM AD_ClientInfo WHERE AD_Client_ID=" + AD_Client_ID; DataSet ds = null; try { VConnection vcon = VConnection.Get(); ds = DataBase.DB.ExecuteDataset(sql, null, trxName); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; info = new MClientInfo(ctx, dr, null); if (trxName == null) { s_cache.Add(key, info); } } } catch (Exception ex) { _log.Log(Level.SEVERE, sql, ex); } ds = null; return(info); }
} // isMultiLingualDocument /// <summary> ///Get Header info (connection, org, user) /// </summary> /// <param name="ctx"></param> /// <param name="WindowNo"></param> /// <returns></returns> public static String GetHeader(Ctx ctx, int windowNo) { StringBuilder sb = new StringBuilder(); if (windowNo > 0) { sb.Append(ctx.GetContext(windowNo, "WindowName", false)).Append(" "); } sb.Append(ctx.GetContext("##AD_User_Name")).Append("@") .Append(ctx.GetContext("#AD_Org_Name")).Append(".") .Append(ctx.GetContext("#AD_Client_Name")) .Append(" [").Append(VConnection.Get().ToString()).Append("]"); // CConnection.get().toString()).append("]"); return(sb.ToString()); }
public string CreateJDBCDataSourceXml(Ctx ctx, string DBResourceName, int RecordID) { List <Document> obj = new List <Document>(); string orgName = "Org Name"; if (RecordID > 0) { MVA009Batch batch = new MVA009Batch(ctx, RecordID, null); MVA009BatchLineDetails batchDetails = null; MVA009PaymentMethod paymthd = null; string sql = @"SELECT bd.VA009_BatchLineDetails_ID FROM VA009_BatchLineDetails bd INNER JOIN va009_batchlines bl ON bl.va009_batchlines_id= bd.va009_batchlines_id WHERE VA009_Batch_ID =" + RecordID; DataSet dsb = DB.ExecuteDataset(sql); if (dsb != null && dsb.Tables[0].Rows.Count > 0) { DataSet dsbnk = null; for (int x = 0; x < dsb.Tables[0].Rows.Count; x++) { batchDetails = new MVA009BatchLineDetails(ctx, Util.GetValueOfInt(dsb.Tables[0].Rows[x]["VA009_BatchLineDetails_ID"]), null); paymthd = new MVA009PaymentMethod(ctx, batchDetails.GetVA009_PaymentMethod_ID(), null); Document dataobj = new Document(); dataobj.PaymentID = Util.GetValueOfInt(batchDetails.GetVA009_BatchLineDetails_ID()); dataobj.PaymentMethod = paymthd.GetVA009_Name(); dataobj.DueAmt = batchDetails.GetDueAmt(); dataobj.currency = Util.GetValueOfString(DB.ExecuteScalar("SELECT iso_code FROM c_currency WHERE c_currency_id = " + batchDetails.GetC_Currency_ID())); dataobj.Org = Util.GetValueOfString(DB.ExecuteScalar("SELECT name FROM ad_org WHERE ad_org_id = " + batchDetails.GetAD_Org_ID())); dsbnk = DB.ExecuteDataset("SELECT b.RoutingNo, ac.IBAN FROM C_Bank b INNER JOIN C_bankaccount ac ON b.c_bank_id= ac.c_bank_id where ac.c_bankaccount_id =" + batch.GetC_BankAccount_ID()); if (dsbnk != null && dsbnk.Tables[0].Rows.Count > 0) { dataobj.IBAN = Util.GetValueOfString(dsbnk.Tables[0].Rows[0]["IBAN"]); dataobj.BIC = Util.GetValueOfString(dsbnk.Tables[0].Rows[0]["RoutingNo"]); } orgName = dataobj.Org; obj.Add(dataobj); } } } //Get DataBase Details of Vienna Advantage Framework string filePath = ""; VConnection conn = new VConnection(); conn.SetAttributes(DBConn.CreateConnectionString()); DataSet ds = new DataSet(); if (conn.Db_Type == "Oracle") { #region commented //Document obj = new Document(); //obj.AccountName = "Manjot"; //obj.AccountNo = "1001"; //objJDBC.exportedWithPermissions = "false"; //objJDBC.folder = "/organizations"; //objJDBC.name = DBResourceName; //objJDBC.version = "0"; //objJDBC.label = DBResourceName; //objJDBC.creationDate = DateTime.Now.ToString("O"); //objJDBC.updateDate = DateTime.Now.ToString("O"); //objJDBC.driver = "tibcosoftware.jdbc.oracle.OracleDriver"; //objJDBC.connectionUrl = "jdbc:tibcosoftware:oracle://" + conn.Db_host + ";SID=" + conn.Db_name; //objJDBC.connectionUser = conn.Db_uid; //objJDBC.connectionPassword = conn.Db_pwd; //objJDBC.timezone = ""; #endregion filePath = XmlCreater(obj, true, DBResourceName, orgName); return(filePath); } return(filePath); }
} // setStage /// <summary> /// Update Elements in Container from Stage /// </summary> /// <param name="project">project</param> /// <param name="stage">stage</param> /// <param name="trxName">trx</param> protected void UpdateElements(MWebProject project, MCStage stage, Trx trxName) { vcon = new VConnection(); VAdvantage.CM.CacheHandler thisHandler = new VAdvantage.CM.CacheHandler( VAdvantage.CM.CacheHandler.ConvertJNPURLToCacheURL(vcon.Apps_host), log, GetCtx(), Get_Trx()); // First update the new ones... int[] tableKeys = X_CM_CStage_Element.GetAllIDs("CM_CStage_Element", "CM_CStage_ID=" + stage.Get_ID(), trxName); if (tableKeys != null && tableKeys.Length > 0) { for (int i = 0; i < tableKeys.Length; i++) { X_CM_CStage_Element thisStageElement = new X_CM_CStage_Element( project.GetCtx(), tableKeys[i], trxName); int[] thisContainerElementKeys = X_CM_Container_Element .GetAllIDs("CM_Container_Element", "CM_Container_ID=" + stage.Get_ID() + " AND Name LIKE '" + thisStageElement.GetName() + "'", trxName); X_CM_Container_Element thisContainerElement; if (thisContainerElementKeys != null && thisContainerElementKeys.Length > 0) { thisContainerElement = new X_CM_Container_Element(project .GetCtx(), thisContainerElementKeys[0], trxName); } else { thisContainerElement = new X_CM_Container_Element(project .GetCtx(), 0, trxName); } thisContainerElement.SetCM_Container_ID(stage.Get_ID()); X_CM_CStage_Element stageElement = new X_CM_CStage_Element( project.GetCtx(), tableKeys[i], trxName); thisContainerElement.SetName(stageElement.GetName()); thisContainerElement.SetDescription(stageElement.GetDescription()); thisContainerElement.SetHelp(stageElement.GetHelp()); thisContainerElement.SetIsActive(stageElement.IsActive()); thisContainerElement.SetIsValid(stageElement.IsValid()); String contentHTML = thisStageElement.GetContentHTML(); thisContainerElement.SetContentHTML(contentHTML); // PO.copyValues(new // X_CM_CStage_Element(project.getCtx(),tableKeys[i],trxName), // thisContainerElement); thisContainerElement.Save(trxName); // Remove Container from cache thisHandler.CleanContainerElement(thisContainerElement .Get_ID()); } } // Now we are checking the existing ones to delete the unneeded ones... tableKeys = X_CM_Container_Element.GetAllIDs("CM_Container_Element", "CM_Container_ID=" + stage.Get_ID(), trxName); if (tableKeys != null && tableKeys.Length > 0) { for (int i = 0; i < tableKeys.Length; i++) { X_CM_Container_Element thisContainerElement = new X_CM_Container_Element( project.GetCtx(), tableKeys[i], trxName); int[] thisCStageElementKeys = X_CM_CStage_Element .GetAllIDs("CM_CStage_Element", "CM_CStage_ID=" + stage.Get_ID() + " AND Name LIKE '" + thisContainerElement.GetName() + "'", trxName); // If we cannot find a representative in the Stage we will delete from production if (thisCStageElementKeys == null || thisCStageElementKeys.Length < 1) { // First delete it from cache, then delete the record itself thisHandler.CleanContainerElement(thisContainerElement .Get_ID()); thisContainerElement.Delete(true); } } } }
/// <summary> /// Retrieves Database Metadata information about Columns /// of the specific database exposed to this user /// </summary> public DataSet GetIndexInfo(string catalog, string schema, string indexName) { DataSet ds = null; try { ds = new DataSet(); //DataTable tables1 = this.connection_1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, schema, "VIENNA_2", null }); DataTable tables = null; if (DatabaseType.IsPostgre) { tables = this.connection_.GetSchema("IndexColumns", new string[] { schema, VConnection.Get().Db_searchPath, indexName.ToLower(), null }); } else { tables = this.connection_.GetSchema("IndexColumns", new string[] { null, indexName.ToUpper(), schema }); } ds.Tables.Add(tables); } catch { } return(ds); }
} // prepare /// <summary> /// Process /// </summary> /// <returns>info</returns> protected override String DoIt() { _apps_host = new VConnection(); CacheHandler thisHandler = new CacheHandler //(CacheHandler.ConvertJNPURLToCacheURL(GetCtx().GetContext("java.naming.provider.url")), log, GetCtx(), Get_Trx()); (CacheHandler.ConvertJNPURLToCacheURL((String)_apps_host.Apps_host), log, GetCtx(), Get_Trx()); log.Info("CM_WebProject_ID=" + _CM_WebProject_ID); _project = new MWebProject(GetCtx(), _CM_WebProject_ID, Get_Trx()); if (_project.Get_ID() != _CM_WebProject_ID) { throw new Exception("@NotFound@ @CM_WebProject_ID@ " + _CM_WebProject_ID); } log.Log(Level.INFO, "Starting media deployment"); // Deploy Media MMediaServer[] mserver = MMediaServer.GetMediaServer(_project); for (int i = 0; i < mserver.Length; i++) { log.Log(Level.INFO, "Media Server deployment started on: " + mserver.ToString()); if (_isRedeploy) { mserver[i].ReDeployAll(); } mserver[i].Deploy(); log.Log(Level.INFO, "Media Server deployment finished on: " + mserver.ToString()); } // Stage MCStage[] stages = MCStage.GetStages(_project); for (int i = 0; i < stages.Length; i++) { _map.Add(Utility.Util.GetValueOfInt(stages[i].GetCM_CStage_ID()), stages[i]); } // Copy Stage Tree MTree treeS = new MTree(GetCtx(), _project.GetAD_TreeCMS_ID(), false, false, Get_Trx()); VTreeNode root = treeS.GetRootNode(); CopyStage(root, "/", _isRedeploy); // Delete Inactive Containers MContainer[] containers = MContainer.GetContainers(_project); for (int i = 0; i < containers.Length; i++) { MContainer container = containers[i]; if (!_idList.Contains(Utility.Util.GetValueOfInt(container.GetCM_Container_ID()))) { String name = container.GetName(); if (container.Delete(true)) { log.Fine("Deleted: " + name); } else // e.g. was referenced { log.Warning("Failed Delete: " + name); AddLog(0, null, null, "@Error@ @Delete@: " + name); } } // Remove Container from cache thisHandler.CleanContainer(container.Get_ID()); } // Delete Inactive // Sync Stage & Container Tree MTreeNodeCMS[] nodesCMS = MTreeNodeCMS.GetTree(GetCtx(), _project.GetAD_TreeCMS_ID(), Get_Trx()); MTreeNodeCMC[] nodesCMC = MTreeNodeCMC.GetTree(GetCtx(), _project.GetAD_TreeCMC_ID(), Get_Trx()); for (int s = 0; s < nodesCMS.Length; s++) { MTreeNodeCMS nodeCMS = nodesCMS[s]; int Node_ID = nodeCMS.GetNode_ID(); for (int c = 0; c < nodesCMC.Length; c++) { MTreeNodeCMC nodeCMC = nodesCMC[c]; if (nodeCMC.GetNode_ID() == Node_ID) { //if (nodeCMS.getParent_ID()!=0) nodeCMC.setParent_ID(nodeCMS.GetParent_ID()); nodeCMC.SetSeqNo(nodeCMS.GetSeqNo()); nodeCMC.Save(); break; } } } // for all stage nodes // Clean ContainerTree Cache thisHandler.CleanContainerTree(_CM_WebProject_ID); return("@Copied@ @CM_Container_ID@ #" + _idList.Count); } // doIt