public virtual (IEnumerable <LanguageResourceModel> languageResourceModels, int totalCount) PrepareLanguageResourceModel(LanguageResourceFilterModel model, string languageId, int pageIndex, int pageSize) { var language = _languageService.GetLanguageById(languageId); var resources = _localizationService .GetAllResources(languageId) .OrderBy(x => x.ResourceName) .Select(x => new LanguageResourceModel { LanguageId = languageId, Id = x.Id, Name = x.ResourceName, Value = x.ResourceValue, }); if (model != null) { if (!string.IsNullOrEmpty(model.ResourceName)) { resources = resources.Where(x => x.Name.ToLowerInvariant().Contains(model.ResourceName.ToLowerInvariant())); } if (!string.IsNullOrEmpty(model.ResourceValue)) { resources = resources.Where(x => x.Value.ToLowerInvariant().Contains(model.ResourceValue.ToLowerInvariant())); } } resources = resources.AsQueryable(); return(resources.Skip((pageIndex - 1) * pageSize).Take(pageSize), resources.Count()); }
public JsonResult configGetTranslations() { if (Response.StatusCode == 304) { return(Json(new{ }, JsonRequestBehavior.AllowGet)); } int langId = EngineContext.Current.Resolve <IWorkContext>().WorkingLanguage.Id; IList <LocaleStringResource> localStrings = _localizationService.GetAllResources(langId); Dictionary <string, string> lcStrings = localStrings.Where(i => i.ResourceName.StartsWith("qa.", true, ci)).Select(l => new { name = l.ResourceName, value = l.ResourceValue }).ToDictionary(g => g.name, g => g.value); //tst o see if cache works //var cs = new DataSettingsManager().LoadSettings().DataConnectionString; //using (SqlConnection conn = new SqlConnection(cs)) //{ // using (SqlCommand cmd = new SqlCommand("dbo.P_QAGet", conn)) // { // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add("@LanguageId", SqlDbType.Int).Value = 10; // SqlDataReader rdr; // conn.Open(); // rdr = cmd.ExecuteReader(); // rdr.Close(); // } //} return(Json(new { time = DateTime.Now.ToString("MM/dd/yyyy h:mm:ss tt"), lcStrings = lcStrings }, JsonRequestBehavior.AllowGet)); }
private void DeleteLocaleResources() { foreach (var lang in _languageService.GetAllLanguages(true)) { var localeStringResources = _localizationService.GetAllResources(lang.Id) .Where(x => x.ResourceName.StartsWith("Plugins.Misc.Watermark.")); foreach (LocaleStringResource lsr in localeStringResources) { _localizationService.DeleteLocaleStringResource(lsr); } } }
protected NoteListModel PrepareModel() { var model = new NoteListModel(); var notes = new List <NoteModel>(); foreach (var lang in _languageService.GetAllLanguages()) { var resources = _localizationService.GetAllResources(lang.Id) .Where(x => x.ResourceName.StartsWith("Content.Notes.")); foreach (var resource in resources) { var note = notes.Where(x => x.Name == resource.ResourceName).FirstOrDefault(); if (note == null) { notes.Add(new NoteModel() { Name = resource.ResourceName, Text = resource.ResourceValue, Locales = new List <NoteLocalizedModel>() { new NoteLocalizedModel() { TextValue = resource.ResourceValue, LanguageId = resource.LanguageId } } }); } else { note.Locales.Add(new NoteLocalizedModel() { TextValue = resource.ResourceValue, LanguageId = resource.LanguageId }); } } } model.Notes = new GridModel <NoteModel>(notes); return(model); }
public IActionResult Resources(string languageId, DataSourceRequest command, LanguageResourceFilterModel model) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageLanguages)) { return(AccessDeniedView()); } var language = _languageService.GetLanguageById(languageId); var resources = _localizationService .GetAllResources(languageId) .OrderBy(x => x.ResourceName) .Select(x => new LanguageResourceModel { LanguageId = languageId, Id = x.Id, Name = x.ResourceName, Value = x.ResourceValue, }); if (model != null) { if (!string.IsNullOrEmpty(model.ResourceName)) { resources = resources.Where(x => x.Name.ToLowerInvariant().Contains(model.ResourceName.ToLowerInvariant())); } if (!string.IsNullOrEmpty(model.ResourceValue)) { resources = resources.Where(x => x.Value.ToLowerInvariant().Contains(model.ResourceValue.ToLowerInvariant())); } } resources = resources.AsQueryable(); var gridModel = new DataSourceResult { Data = resources.PagedForCommand(command), Total = resources.Count() }; return(Json(gridModel)); }
/// <summary> /// Gets all locale string resources by language identifier /// </summary> /// <param name="languageId">Language identifier</param> /// <returns>Locale string resources</returns> public IList <LocaleStringResource> GetAllResources(int languageId) { return(_localizationService.GetAllResources(languageId)); }