} // prepare /// <summary> /// messages /// </summary> /// <returns>string</returns> protected override String DoIt() { log.Info("AD_Language=" + _AD_Language + ",Mode=" + _ImportExport + ",Scope=" + _ExportScope + ",AD_Table_ID=" + _AD_Table_ID + ",Level=" + _TranslationLevel + ",Directory=" + _Directory); // TranslationMgr t = new TranslationMgr(GetCtx()); String msg = t.ValidateLanguage(_AD_Language); if (msg.Length > 0) { throw new Exception("@LanguageSetupError@ - " + msg); } t.SetByExportID(_ByExportID); // Mode bool imp = Mode_Import.Equals(_ImportExport); // Client int AD_Client_ID = 0; if (ExportScope_Tenant.Equals(_ExportScope)) { AD_Client_ID = GetCtx().GetAD_Client_ID(); } t.SetExportScope(_ExportScope, AD_Client_ID); // Directory if (Utility.Util.IsEmpty(_Directory)) { _Directory = DataBase.Ini.GetFrameworkHome();// } #region [Module Parameter Check] // Added by Sukhwinder on 23 June,2017 for creating translations on the basis of Modules. MModuleInfo module = null; if (_AD_ModuleInfo_ID != 0) { module = new MModuleInfo(GetCtx(), _AD_ModuleInfo_ID, null); } #endregion int noWords = 0; // All Tables if (_AD_Table_ID == 0) { String sql = "SELECT * FROM AD_Table WHERE IsActive='Y' AND IsView='N'" + " AND TableName LIKE '%_Trl' AND TableName<>'AD_Column_Trl'"; if (ExportScope_Tenant.Equals(_ExportScope)) { sql += " AND AccessLevel<>'4'"; // System Only } else { sql += " AND AccessLevel NOT IN ('1','2','3')"; // Org/Client/Both } sql += " ORDER BY TableName"; List <MTable> tables = MTable.GetTablesByQuery(GetCtx(), sql); foreach (MTable table in tables) { String tableName = table.GetTableName(); msg = null; //msg = imp ? t.ImportTrl(_Directory, table.GetTableName()) : t.ExportTrl(_Directory, table.GetTableName(), _TranslationLevel); // Commented and added following code in IF-ELSE on the basis of Module parameter.(Sukhwinder) if (module == null) { msg = imp ? t.ImportTrl(_Directory, tableName) : t.ExportTrl(_Directory, tableName, _TranslationLevel); } else { msg = imp ? t.ImportTrl(_Directory, tableName) : t.ExportTrl(_Directory, tableName, _TranslationLevel, module.GetPrefix()); // by Sukhwinder on 23 June, 2017 } //if (!msg.Contains("Updated")) //{ // msg = "Updated=0"; //} AddLog(msg); } noWords = t.GetWordCount(); } else // single table { MTable table = MTable.Get(GetCtx(), _AD_Table_ID); msg = null; //msg = imp ? t.ImportTrl(_Directory, table.GetTableName()) : t.ExportTrl(_Directory, table.GetTableName(), _TranslationLevel); // Commented and added following code in IF-ELSE on the basis of Module parameter.(Sukhwinder) if (module == null) { msg = imp ? t.ImportTrl(_Directory, table.GetTableName()) : t.ExportTrl(_Directory, table.GetTableName(), _TranslationLevel); } else { msg = imp ? t.ImportTrl(_Directory, table.GetTableName()) : t.ExportTrl(_Directory, table.GetTableName(), _TranslationLevel, module.GetPrefix()); // by Sukhwinder on 23 June, 2017 } //if (!msg.Contains("Updated")) //{ // msg = "Updated=0"; //} AddLog(msg); noWords = t.GetWordCount(); } // //return ("Word Count = " + noWords); return(Msg.GetMsg(GetCtx(), "WordCount") + " = " + noWords); }
} // prepare /// <summary> /// messages /// </summary> /// <returns>string</returns> protected override String DoIt() { if (string.IsNullOrEmpty(_prefix) || string.IsNullOrEmpty(_Directory)) { throw new Exception("@Error@ - prefix or folder path not found"); } log.Info("AD_Language=" + _AD_Language + ",Mode=" + _ImportExport + ",Scope=" + _ExportScope + ",AD_Table_ID=" + _AD_Table_ID + ",Level=" + _TranslationLevel + ",Directory=" + _Directory); if (!System.IO.Directory.Exists(_Directory)) { try { System.IO.Directory.CreateDirectory(_Directory); } catch (Exception e) { throw e; } } TranslationMgr t = new TranslationMgr(_ctx); t.SetPrefix(_prefix); t.SetByExportID(true); String msg = t.ValidateLanguage(_AD_Language); if (msg.Length > 0) { throw new Exception("@LanguageSetupError@ - " + msg); } // Mode bool imp = Mode_Import.Equals(_ImportExport); // Client int AD_Client_ID = 0; if (ExportScope_Tenant.Equals(_ExportScope)) { AD_Client_ID = _ctx.GetAD_Client_ID(); } t.SetExportScope(_ExportScope, AD_Client_ID); // Directory if (Util.IsEmpty(_Directory)) { _Directory = VAdvantage.DataBase.Ini.GetFrameworkHome();// } int noWords = 0; // All Tables if (_AD_Table_ID == 0) { String sql = "SELECT * FROM AD_Table WHERE IsActive='Y' AND IsView='N'" + " AND TableName LIKE '%_Trl' AND TableName<>'AD_Column_Trl'"; if (ExportScope_Tenant.Equals(_ExportScope)) { sql += " AND AccessLevel<>'4'"; // System Only } else { sql += " AND AccessLevel NOT IN ('1','2','3')"; // Org/Client/Both } sql += " ORDER BY TableName"; List <MTable> tables = MTable.GetTablesByQuery(_ctx, sql); foreach (MTable table in tables) { String tableName = table.GetTableName(); msg = null; msg = imp ? t.ImportTrl(_Directory, tableName) : t.ExportTrl(_Directory, tableName, _TranslationLevel); AddLog(msg); } noWords = t.GetWordCount(); } else // single table { MTable table = MTable.Get(_ctx, _AD_Table_ID); msg = null; msg = imp ? t.ImportTrl(_Directory, table.GetTableName()) : t.ExportTrl(_Directory, table.GetTableName(), _TranslationLevel); AddLog(msg); noWords = t.GetWordCount(); } // sb.Append("Word Count = " + noWords); return(sb.ToString()); }
} // prepare /// <summary> /// messages /// </summary> /// <returns>string</returns> protected override String DoIt() { log.Info("AD_Language=" + _AD_Language + ",Mode=" + _ImportExport + ",Scope=" + _ExportScope + ",AD_Table_ID=" + _AD_Table_ID + ",Level=" + _TranslationLevel + ",Directory=" + _Directory); // TranslationMgr t = new TranslationMgr(GetCtx()); String msg = t.ValidateLanguage(_AD_Language); if (msg.Length > 0) { throw new Exception("@LanguageSetupError@ - " + msg); } t.SetByExportID(_ByExportID); // Mode bool imp = Mode_Import.Equals(_ImportExport); // Client int AD_Client_ID = 0; if (ExportScope_Tenant.Equals(_ExportScope)) { AD_Client_ID = GetCtx().GetAD_Client_ID(); } t.SetExportScope(_ExportScope, AD_Client_ID); // Directory if (Utility.Util.IsEmpty(_Directory)) { _Directory = DataBase.Ini.GetFrameworkHome();// } int noWords = 0; // All Tables if (_AD_Table_ID == 0) { String sql = "SELECT * FROM AD_Table WHERE IsActive='Y' AND IsView='N'" + " AND TableName LIKE '%_Trl' AND TableName<>'AD_Column_Trl'"; if (ExportScope_Tenant.Equals(_ExportScope)) { sql += " AND AccessLevel<>'4'"; // System Only } else { sql += " AND AccessLevel NOT IN ('1','2','3')"; // Org/Client/Both } sql += " ORDER BY TableName"; List <MTable> tables = MTable.GetTablesByQuery(GetCtx(), sql); foreach (MTable table in tables) { String tableName = table.GetTableName(); msg = null; msg = imp ? t.ImportTrl(_Directory, tableName) : t.ExportTrl(_Directory, tableName, _TranslationLevel); //if (!msg.Contains("Updated")) //{ // msg = "Updated=0"; //} AddLog(msg); } noWords = t.GetWordCount(); } else // single table { MTable table = MTable.Get(GetCtx(), _AD_Table_ID); msg = null; msg = imp ? t.ImportTrl(_Directory, table.GetTableName()) : t.ExportTrl(_Directory, table.GetTableName(), _TranslationLevel); //if (!msg.Contains("Updated")) //{ // msg = "Updated=0"; //} AddLog(msg); noWords = t.GetWordCount(); } // return("Word Count = " + noWords); }