/**
* Get R_RequestType_ID
* @return Request Type
*/
private int GetR_RequestType_ID()
{
MClientInfo ci = MClientInfo.Get(GetCtx(), GetAD_Client_ID());
int R_RequestType_ID = ci.GetR_RequestType_ID();
if (R_RequestType_ID != 0)
{
return(R_RequestType_ID);
}
log.Warning("Set Request Type in Window Client Info");
// Default
MRequestType rt = MRequestType.GetDefault(GetCtx());
if (rt != null)
{
R_RequestType_ID = rt.GetR_RequestType_ID();
ci.SetR_RequestType_ID(R_RequestType_ID);
ci.Save();
return(R_RequestType_ID);
}
//
return(0);
}
} // testEMail
public bool SetupClientInfo(String language)
{
// Create Trees
String sql = null;
if (Env.IsBaseLanguage(language, "AD_Ref_List")) // Get TreeTypes & Name
{
sql = "SELECT Value, Name FROM AD_Ref_List WHERE AD_Reference_ID=120 AND IsActive='Y'";
}
else
{
sql = "SELECT l.Value, t.Name FROM AD_Ref_List l, AD_Ref_List_Trl t "
+ "WHERE l.AD_Reference_ID=120 AND l.AD_Ref_List_ID=t.AD_Ref_List_ID AND l.IsActive='Y'";
}
// Tree IDs
int AD_Tree_Org_ID = 0, AD_Tree_BPartner_ID = 0, AD_Tree_Project_ID = 0,
AD_Tree_SalesRegion_ID = 0, AD_Tree_Product_ID = 0,
AD_Tree_Campaign_ID = 0, AD_Tree_Activity_ID = 0;
bool success = false;
try
{
//IDataReader dr = DataBase.DB.ExecuteReader(sql, null, Get_TrxName());
DataSet dr = DataBase.DB.ExecuteDataset(sql, null, Get_TrxName());
MTree tree = null;
for (int i = 0; i <= dr.Tables[0].Rows.Count - 1; i++)
{
try
{
String treeType = dr.Tables[0].Rows[i]["Value"].ToString();
if (treeType.Equals(X_AD_Tree.TREETYPE_Other) ||
treeType.StartsWith("U"))
{
continue;
}
String name = GetName() + " " + dr.Tables[0].Rows[i]["Name"].ToString();
//
if (treeType.Equals(X_AD_Tree.TREETYPE_Organization))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_Org_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_BPartner))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_BPartner_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_Project))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_Project_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_SalesRegion))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_SalesRegion_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_Product))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_Product_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_ElementValue))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
m_AD_Tree_Account_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_Campaign))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_Campaign_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_Activity))
{
tree = new MTree(this, name, treeType);
success = tree.Save();
AD_Tree_Activity_ID = tree.GetAD_Tree_ID();
}
else if (treeType.Equals(X_AD_Tree.TREETYPE_Menu)) // No Menu
{
success = true;
}
else // PC (Product Category), BB (BOM)
{
tree = new MTree(this, name, treeType);
success = tree.Save();
}
if (!success)
{
log.Log(VAdvantage.Logging.Level.SEVERE, "Tree NOT created: " + name);
break;
}
}
catch { }
}
dr.Dispose();
}
catch (Exception e1)
{
log.Log(VAdvantage.Logging.Level.SEVERE, "Trees", e1);
success = false;
}
if (!success)
{
return(false);
}
// Create ClientInfo
MClientInfo clientInfo = new MClientInfo(this,
AD_Tree_Org_ID, AD_Tree_BPartner_ID, AD_Tree_Project_ID,
AD_Tree_SalesRegion_ID, AD_Tree_Product_ID,
AD_Tree_Campaign_ID, AD_Tree_Activity_ID, Get_TrxName());
success = clientInfo.Save();
return(success);
} // createTrees
