/// <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
