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