public static int GetAD_Language_ID() { string sLang = GetLoginLanguage(Env.GetCtx()).GetAD_Language(); MLanguage language = MLanguage.Get(Env.GetCtx(), sLang, null); return(language.GetAD_Language_ID()); }
} // getScopeSQL /// <summary> /// Validate Language. //Check if AD_Language record exists // Check Trl table records /// </summary> /// <param name="AD_Language">language</param> /// <returns> "" if validated - or error message</returns> public String ValidateLanguage(String AD_Language) { String sql = "SELECT * " + "FROM AD_Language " + "WHERE AD_Language=@param"; MLanguage language = null; IDataReader idr = null; SqlParameter[] param = new SqlParameter[1]; try { param[0] = new SqlParameter("@param", AD_Language); idr = DataBase.DB.ExecuteReader(sql, param, null); if (idr.Read()) { language = new MLanguage(_ctx, idr, null); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } log.Log(Level.SEVERE, sql, e); return(e.ToString()); } // No AD_Language Record if (language == null) { log.Log(Level.SEVERE, "Language does not exist: " + AD_Language); return("Language does not exist: " + AD_Language); } // Language exists SetAD_Language(AD_Language); if (language.IsActive()) { if (language.IsBaseLanguage()) { return(""); } } else { log.Log(Level.SEVERE, "Language not active or not system language: " + AD_Language); return("Language not active or not system language: " + AD_Language); } // Validate Translation log.Info("Start Validating ... " + language); language.Maintain(true); return(""); } // validateLanguage
} // prepare /// <summary> ///Perform Process. /// </summary> /// <returns>Message (clear text)</returns> /// <exception cref="Exception">if not successful</exception> override protected String DoIt() { //IDbTransaction trx = ExecuteQuery.GerServerTransaction(); //_language = MLanguage.Get(GetCtx(), _AD_Language_ID, trx.ToString()); _language = MLanguage.Get(GetCtx(), _AD_Language_ID, Get_TrxName()); log.Info("Mode=" + _MaintenanceMode + ", ID=" + _AD_Language_ID + " - " + _language); if (_language.IsBaseLanguage()) { throw new Exception("Base Language has no Translations"); } int deleteNo = 0; int insertNo = 0; // Delete the recods of the _trl table if (MAINTENANCEMODE_Delete.Equals(_MaintenanceMode) || MAINTENANCEMODE_ReCreate.Equals(_MaintenanceMode)) { deleteNo = _language.Maintain(false); } // Add the records from the _trl if (MAINTENANCEMODE_Add.Equals(_MaintenanceMode) || MAINTENANCEMODE_ReCreate.Equals(_MaintenanceMode)) { if (_language.IsActive() && _language.IsSystemLanguage()) { insertNo = _language.Maintain(true); } else { //MessageBox.Show("Set System Language"); throw new Exception("Language not active System Language"); } } // Delete complete the records from _trl table if (MAINTENANCEMODE_Delete.Equals(_MaintenanceMode)) { if (_language.IsSystemLanguage()) { _language.SetIsSystemLanguage(false); _language.Save(); } } //MessageBox.Show("Inserted Records:" + insertNo + "\n Deleted Records:" + deleteNo); return("@Deleted@=" + deleteNo + " - @Inserted@=" + insertNo); }
public static void FillLanguage() { if (_languages.Count > 0) { return; } lock (_lock) { if (_languages.Count > 0) { return; } langList.Clear(); DataTable dt = MLanguage.GetSystemLanguage(); _languages.Add(0, new Language("English", AD_Language_en_US, new System.Globalization.CultureInfo("en-US"), null, "", MediaSize.NA.LETTER)); langList.Add(new ValueNamePair("en_US", "English")); _loginLanguage = _languages[0]; if (dt != null) { foreach (DataRow row in dt.Rows) { try { var cul = new System.Globalization.CultureInfo(row["AD_Language"].ToString().Replace("_", "-")); _languages.Add(_languages.Count, new Language (row["Name"].ToString(), row["AD_Language"].ToString(), cul, cul.NumberFormat.NumberDecimalSeparator == ".", cul.DateTimeFormat.ShortDatePattern, MediaSize.ISO.A4)); langList.Add(new ValueNamePair(row["AD_Language"].ToString(), row["DisplayName"].ToString())); } catch { continue; } } } } }