/// <summary>
/// Update Elements in Container from Stage
/// </summary>
/// <param name="project">proejct</param>
/// <param name="stage">stage</param>
/// <param name="trxName">trx</param>
protected void UpdateTTables(MWebProject project, MCStage stage,
Trx trxName)
{
int[] tableKeys = X_CM_CStageTTable.GetAllIDs("CM_CStageTTable",
"CM_CStage_ID=" + stage.Get_ID(), trxName);
if (tableKeys != null && tableKeys.Length > 0)
{
for (int i = 0; i < tableKeys.Length; i++)
{
X_CM_CStageTTable thisStageTTable = new X_CM_CStageTTable(
project.GetCtx(), tableKeys[i], trxName);
int[] thisContainerTTableKeys = X_CM_ContainerTTable.GetAllIDs(
"CM_ContainerTTable", "CM_Container_ID=" + stage.Get_ID()
+ " AND CM_TemplateTable_ID="
+ thisStageTTable.GetCM_TemplateTable_ID(), trxName);
X_CM_ContainerTTable thisContainerTTable;
if (thisContainerTTableKeys != null &&
thisContainerTTableKeys.Length > 0)
{
thisContainerTTable = new X_CM_ContainerTTable(project
.GetCtx(), thisContainerTTableKeys[0], trxName);
}
else
{
thisContainerTTable = new X_CM_ContainerTTable(project
.GetCtx(), 0, trxName);
}
thisContainerTTable.SetCM_Container_ID(stage.Get_ID());
PO.CopyValues(new X_CM_CStageTTable(project.GetCtx(),
tableKeys[i], trxName), thisContainerTTable);
thisContainerTTable.Save(trxName);
}
}
}
/// <summary>
/// Get Stages
/// </summary>
/// <param name="project">project</param>
/// <returns>stages</returns>
public static MCStage[] GetStages(MWebProject project)
{
List <MCStage> list = new List <MCStage>();
SqlParameter[] param = new SqlParameter[1];
IDataReader idr = null;
String sql = "SELECT * FROM CM_CStage WHERE CM_WebProject_ID=@param ORDER BY CM_CStage_ID";
try
{
//pstmt = DataBase.prepareStatement (sql, project.get_TrxName());
//pstmt.setInt (1, project.getCM_WebProject_ID());
param[0] = new SqlParameter("@param", project.GetCM_WebProject_ID());
idr = DataBase.DB.ExecuteReader(sql, param, project.Get_TrxName());
while (idr.Read())
{
list.Add(new MCStage(project.GetCtx(), idr, project.Get_TrxName()));
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, e);
}
MCStage[] retValue = new MCStage[list.Count];
retValue = list.ToArray();
return(retValue);
} // getStages
} // getStages
/// <summary>
/// Get Stage by Name
/// </summary>
/// <param name="project">project</param>
/// <param name="RelativeURL">relurl</param>
/// <param name="parent_ID">id</param>
/// <returns>stages</returns>
public static MCStage GetByName(MWebProject project, String RelativeURL, int parent_ID)
{
MCStage retValue = null;
IDataReader idr = null;
SqlParameter[] param = new SqlParameter[4];
String sql = "SELECT * FROM CM_CStage WHERE CM_WebProject_ID=@param1 AND RelativeURL LIKE @param2 " + //1,2
"AND CM_CStage_ID IN (SELECT Node_ID FROM AD_TreeNodeCMS WHERE " +
" AD_Tree_ID=@param3 AND Parent_ID=@param4)" + // 3, 4
"ORDER BY CM_CStage_ID";
try
{
//pstmt = DataBase.prepareStatement (sql, project.get_TrxName());
//pstmt.setInt (1, project.getCM_WebProject_ID());
param[0] = new SqlParameter("@param1", project.GetCM_WebProject_ID());
//pstmt.setString (2, RelativeURL);
param[1] = new SqlParameter("@param2", RelativeURL);
//pstmt.setInt (3, project.getAD_TreeCMS_ID ());
param[2] = new SqlParameter("@param3", project.GetAD_TreeCMS_ID());
//pstmt.setInt (4, parent_ID);
param[3] = new SqlParameter("@param4", parent_ID);
idr = DataBase.DB.ExecuteReader(sql, param, project.Get_TrxName());
if (idr.Read())
{
retValue = new MCStage(project.GetCtx(), idr, project.Get_TrxName());
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, e);
}
return(retValue);
} // getStages
} // 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);
}
}
}
}
