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;
}
}
}
}
}