private static VLogger _log = VLogger.GetVLogger(typeof(MCStageElement).FullName); //.class);
/// <summary>
/// get By ElementName
/// </summary>
/// <param name="ctx">context</param>
/// <param name="CM_CStage_ID">id</param>
/// <param name="elementName">elementname</param>
/// <param name="trxName">trx</param>
/// <returns>element by name</returns>
public static MCStageElement GetByName(Ctx ctx, int CM_CStage_ID, String elementName, Trx trxName)
{
String sql = "SELECT * FROM CM_CStage_Element WHERE CM_CStage_ID=@param1 AND Name LIKE @param2";
MCStageElement thisElement = null;
SqlParameter[] param = new SqlParameter[2];
IDataReader idr = null;
try
{
//pstmt = DataBase.prepareStatement (sql, trxName);
//pstmt.setInt (1, CM_CStage_ID);
param[0] = new SqlParameter("@param1", CM_CStage_ID);
//pstmt.setString (2, elementName);
param[1] = new SqlParameter("@param2", Utility.Util.GetValueOfString(elementName));
idr = DataBase.DB.ExecuteReader(sql, param, trxName);
if (idr.Read())
{
thisElement = new MCStageElement(ctx, idr, trxName);
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, "getByName", e);
}
return(thisElement);
} // getByName
/// <summary>
/// Check single Element, if not existing create it...
/// </summary>
/// <param name="elementName">element name</param>
public void CheckElement(String elementName)
{
MCStageElement thisElement = GetElementByName(elementName);
if (thisElement == null)
{
thisElement = new MCStageElement(GetCtx(), 0, Get_TrxName());
thisElement.SetAD_Client_ID(GetAD_Client_ID());
thisElement.SetAD_Org_ID(GetAD_Org_ID());
thisElement.SetCM_CStage_ID(this.Get_ID());
thisElement.SetContentHTML(" ");
thisElement.SetName(elementName);
thisElement.Save(Get_TrxName());
}
}
public MCStageElement GetElementByName(String elementName)
{
return(MCStageElement.GetByName(GetCtx(), Get_ID(), elementName, Get_TrxName()));
}