private void InsertTestLanguages() { var testEntity1 = new LanguageEntity() { Name = "Name1", Description = "Name1" }; var testEntity2 = new LanguageEntity() { Name = "Name2", Description = "Name2" }; var testEntity3 = new LanguageEntity() { Name = "Name3", Description = "Name3" }; var entities = new List <LanguageEntity>() { testEntity1, testEntity2, testEntity3 }; context.Collection <LanguageEntity>().InsertMany(entities); }
public static ResourceEntity ToResource(this IDictionary <string, string> labels) { var resource = new ResourceEntity { Id = 1 }; labels.ForEach((kvp, i) => { var language = new LanguageEntity { Id = i, LanguageTag = kvp.Key }; var label = new LabelEntity { ResourceId = resource.Id, LanguageId = language.Id, Language = language, Text = kvp.Value }; resource.Labels.Add(label); }); return(resource); }
public Language(LanguageEntity LanguageEntity) : base(LanguageEntity) { if (LanguageEntity.CategoryNameEntities != null) { this.CategoryNames = new HashSet <CategoryName>(); foreach (CategoryNameEntity CategoryNameEntity in LanguageEntity.CategoryNameEntities) { CategoryNameEntity.LanguageId = LanguageEntity.Id; this.CategoryNames.Add(new CategoryName(CategoryNameEntity)); } } if (LanguageEntity.ProductAttributeNameEntities != null) { this.ProductAttributeNames = new HashSet <ProductAttributeName>(); foreach (ProductAttributeNameEntity ProductAttributeNameEntity in LanguageEntity.ProductAttributeNameEntities) { ProductAttributeNameEntity.LanguageId = LanguageEntity.Id; this.ProductAttributeNames.Add(new ProductAttributeName(ProductAttributeNameEntity)); } } if (LanguageEntity.ProductValueEntities != null) { this.ProductValues = new HashSet <ProductValue>(); foreach (ProductValueEntity ProductValueEntity in LanguageEntity.ProductValueEntities) { ProductValueEntity.LanguageId = LanguageEntity.Id; this.ProductValues.Add(new ProductValue(ProductValueEntity)); } } }
private string GetLocalize(string key) { var languageService = ServiceLocator.GetService <ILanguageService>(); var cultureOption = ServiceLocator.GetService <IOptions <CultureOption> >(); string culture = CultureInfo.CurrentUICulture.Name; if (cultureOption != null && cultureOption.Value.Code.IsNotNullAndWhiteSpace()) { culture = cultureOption.Value.Code; } var language = languageService.Get(key, culture); if (language == null) { string lanValue = key; string lanType = "UnKnown"; string module = "Unknown"; if (key.Contains("@")) { lanValue = key.Split('@')[1]; var translated = languageService.Get(n => n.LanKey.EndsWith("@" + lanValue) && n.CultureName == culture).FirstOrDefault(); if (translated != null) { lanValue = translated.LanValue; } else { StringBuilder lanValueBuilder = new StringBuilder(); if (lanValue.EndsWith("ID") || lanValue.EndsWith("Id")) { lanValue = lanValue.Substring(0, lanValue.Length - 2); } for (int i = 0; i < lanValue.Length; i++) { char charLan = lanValue[i]; if (i > 0 && char.IsUpper(charLan)) { lanValueBuilder.Append(' '); } lanValueBuilder.Append(charLan); } lanValue = lanValueBuilder.ToString(); } lanType = "EntityProperty"; module = key.Split('@')[0]; language = new LanguageEntity { CultureName = culture, LanValue = lanValue, LanKey = key, LanType = lanType, Module = module }; languageService.Add(language); return(language.LanValue); } return(key); } return(language.LanValue); }
public void Update(LanguageEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_UpdateLanguage", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); cmd.Parameters.AddWithValue("@Title", t.Title); cmd.Parameters.AddWithValue("@Description", t.Description); cmd.Parameters.AddWithValue("@Status", Convert.ToInt32(t.Status)); cmd.Parameters.AddWithValue("@ApplicationId", Convert.ToInt32(t.ApplicationId)); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void Delete(LanguageEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_DeleteLanguage", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public static async Task <int> Count(ApplicationDbContext context, LanguageEntity entity) { if (!entity.iscache || Configs.GeneralSettings.cache_duration == 0 || entity.pagenumber > Configs.GeneralSettings.max_cache_pages) { return(await CountRecords(context, entity)); } else { string key = GenerateKey("cnt_language", entity); int records = 0; if (!SiteConfig.Cache.TryGetValue(key, out records)) { records = await CountRecords(context, entity); var cacheEntryOptions = new MemoryCacheEntryOptions() // Keep in cache for this time, reset time if accessed. .SetSlidingExpiration(TimeSpan.FromSeconds(3600)); // Save data in cache. SiteConfig.Cache.Set(key, records, cacheEntryOptions); } else { records = (int)SiteConfig.Cache.Get(key); } return(records); } }
public static string Get(string lanKey) { var lanCache = new StaticCache(); LanguageEntity lan = lanCache.Get(lanKey, m => { m.When(LanguageService.SignalLanguageUpdate); if (LanService == null) return new LanguageEntity { LanKey = lanKey, LanValue = lanKey }; var language = LanService.Get(lanKey, GetCurrentLanID()); if (language == null) { string lanValue = lanKey; string lanType = "UnKnown"; string module = "Unknown"; if (lanKey.Contains("@")) { lanValue = lanKey.Split('@')[1]; lanType = "EntityProperty"; module = lanKey.Split('@')[0]; } language = new LanguageEntity { LanID = GetCurrentLanID(), LanValue = lanValue, LanKey = lanKey, LanType = lanType, Module = module }; LanService.Add(language); } return language; }); return lan.LanValue; }
public LanguageEntity Update(EmployeeEntity EmployeeEntity, Guid LanguageId, LanguageEntity LanguageEntity) { LanguageEntity.Id = LanguageId; Language Language = new Language(LanguageEntity); UnitOfWork.LanguageRepository.AddOrUpdate(Language); UnitOfWork.Complete(); return(Get(EmployeeEntity, Language.Id)); }
public IActionResult Create(LanguageEntity language) { if (ModelState.IsValid) { _languageService.Add(language); return(RedirectToAction("Index")); } return(View(language)); }
private void InsertTestLanguage() { var testEntity = new LanguageEntity() { Name = "NameBeforeTest", Description = "Description" }; context.Collection <LanguageEntity>().InsertOne(testEntity); }
public IActionResult Edit(LanguageEntity language) { if (ModelState.IsValid) { Localization.RemoveCache(language.LanKey); _languageService.Update(language); return(RedirectToAction("Index")); } return(View(language)); }
public int InsertOrUpdateLanguage(int StoreId, int LoggedInUserId, LanguageEntity objEntity) { var ParameterStoreId = new SqlParameter { ParameterName = "StoreId", DbType = DbType.Int32, Value = StoreId }; var ParameterLoggedInUserId = new SqlParameter { ParameterName = "LoggedInUserId", DbType = DbType.Int32, Value = LoggedInUserId }; var paramlanguageId = new SqlParameter { ParameterName = "languageId", DbType = DbType.Int32, Value = Convert.ToInt32(objEntity.language_id) }; var paramlanguageCd = new SqlParameter { ParameterName = "languageCd", DbType = DbType.String, Value = objEntity.code.Trim() }; var paramsort_order = new SqlParameter { ParameterName = "sort_order", DbType = DbType.Int32, Value = objEntity.sort_order }; var paramlanguageName = new SqlParameter { ParameterName = "languageName", DbType = DbType.String, Value = objEntity.name }; var paramimage = new SqlParameter { ParameterName = "image", DbType = DbType.String, Value = objEntity.image }; var paramstatus = new SqlParameter { ParameterName = "status", DbType = DbType.Int32, Value = objEntity.status }; var result = objGenericRepository.ExecuteSQL <int>("InsertOrUpdateLanguage", paramlanguageId, paramlanguageCd, paramsort_order, paramlanguageName, paramimage, paramstatus, ParameterStoreId, ParameterLoggedInUserId).FirstOrDefault(); return(result); }
public static List <LanguageDictionary> BuildDictionaries(string text) { var lines = ParseText(text); var lineCount = lines.Count; if (lineCount == Int.ZERO) { return(new List <LanguageDictionary>()); } var entityCount = lineCount - Int.ONE; //Build empty dictionaries: var headerRow = lines[Int.ZERO]; var headerChunks = ParseLine(headerRow); var languageCount = headerChunks.Count - Int.ONE; var dictionaries = new List <LanguageDictionary>(); for (var i = Int.ZERO; i < languageCount; i++) { var languageText = headerChunks[i + Int.ONE]; var dictionary = new LanguageDictionary { language = languageText, entities = new List <LanguageEntity>() }; dictionaries.Add(dictionary); } //Fill dictionaries: for (var i = Int.ZERO; i < entityCount; i++) { var line = lines[i + Int.ONE]; var chunks = ParseLine(line); var key = chunks[Int.ZERO]; if (!key.StartsWith("TXT")) { continue; } for (var j = Int.ZERO; j < languageCount; j++) { var dictionary = dictionaries[j]; var entity = new LanguageEntity { key = key, translation = chunks[j + Int.ONE] }; dictionary.entities.Add(entity); } } return(dictionaries); }
private void InsertTestLanguage() { var testEntity = new LanguageEntity() { Name = "TestName", Description = "TestDescription" }; context.Collection <LanguageEntity>().InsertOne(testEntity); request.Id = testEntity.Id; }
internal static Language ToServiceModel(this LanguageEntity dataObject) { Language serviceModel = new Language(); serviceModel.Id = dataObject.Id; serviceModel.Code = dataObject.Code?.ToServiceModel(); serviceModel.GameIds = dataObject.GameIds.ToServiceModels(); serviceModel.FallbackLanguages = dataObject.FallbackLanguages.ToList(); return(serviceModel); }
internal static LanguageEntity ToDataObject(this Language serviceModel) { LanguageEntity dataObject = new LanguageEntity(); dataObject.Id = serviceModel.Id; dataObject.Code = serviceModel.Code?.ToDataObject(); dataObject.GameIds = serviceModel.GameIds.ToDataObjects().ToList(); dataObject.FallbackLanguages = serviceModel.FallbackLanguages.ToList(); return(dataObject); }
protected void ProceedButton_Click(object sender, EventArgs e) { LanguageEntity entity = new LanguageEntity(); entity.Title = TitleTextBox.Text; entity.Description = OtherInfoTextBox.Text; entity.ApplicationId = Convert.ToInt32(ConfigurationManager.AppSettings["ApplicationId"]); new LanguageMapper().Insert(entity); Response.Redirect("List.aspx"); }
public IDataPage <Language> Get() { var languagesList = new LanguageEntity[] { new LanguageEntity { Code = "en", Description = "english" }, new LanguageEntity { Code = "it", Description = "italian" } }; var languagePagedList = new PagedList <LanguageEntity>(languagesList.AsQueryable(), 1, 10); return(mapper.Map <IPagedList <LanguageEntity>, IDataPage <Language> >(languagePagedList)); }
public LanguageEntity Create(EmployeeEntity EmployeeEntity, LanguageEntity LanguageEntity) { if (LanguageEntity == null) { throw new NotFoundException(); } Language Language = new Language(LanguageEntity); UnitOfWork.LanguageRepository.AddOrUpdate(Language); UnitOfWork.Complete(); return(Get(EmployeeEntity, Language.Id)); }
protected void ProceedButton_Click(object sender, EventArgs e) { LanguageEntity entity = new LanguageEntity(); entity.Id = Convert.ToInt32(Request.QueryString["LanguageId"]); entity.Title = TitleTextBox.Text; entity.Description = OtherInfoTextBox.Text; entity.Status = StatusEnum.Active; entity.ApplicationId = Convert.ToInt32(ConfigurationManager.AppSettings["ApplicationId"]); new LanguageMapper().Update(entity); Response.Redirect("List.aspx"); }
public LanguageEntity SearchLanguage(int langId) { var ObjContext = new CinestarEntitiesDAL(); Language ObjLang = ObjContext.Languages.Find(langId); LanguageEntity feedback = new LanguageEntity(); if (ObjLang != null) { feedback.LanguageId = ObjLang.LanguageId; feedback.LanguageName = ObjLang.LanguageName; } return(feedback); }
public static string Get(string lanKey) { return(LanguageCache.GetOrAdd(lanKey, key => { using (var languageService = ServiceLocator.GetService <ILanguageService>()) { string culture = CultureInfo.CurrentUICulture.Name; var cultureOption = ServiceLocator.GetService <IOptions <CultureOption> >(); if (cultureOption != null && cultureOption.Value.Code.IsNotNullAndWhiteSpace()) { culture = cultureOption.Value.Code; } var language = languageService.Get(n => n.LanKey == key && n.CultureName == culture).FirstOrDefault(); if (language == null) { string lanValue = key; string lanType = "UnKnown"; string module = "Unknown"; if (key.Contains("@")) { lanValue = key.Split('@')[1]; var translated = languageService.Get(n => n.LanKey.EndsWith("@" + lanValue) && n.CultureName == culture).FirstOrDefault(); if (translated != null) { lanValue = translated.LanValue; } lanType = "EntityProperty"; module = key.Split('@')[0]; } language = new LanguageEntity { CultureName = culture, LanValue = lanValue, LanKey = key, LanType = lanType, Module = module }; languageService.Add(language); } return language; } }).LanValue); }
public List <LanguageEntity> ViewAllLanguageDAL() { List <LanguageEntity> objGenreList = new List <LanguageEntity>(); var objcontext = new CinestarEntitiesDAL(); var query = from s in objcontext.Languages select s; LanguageEntity objGenre = null; foreach (var newGenre in query) { objGenre = new LanguageEntity(); objGenre.LanguageId = newGenre.LanguageId; objGenre.LanguageName = newGenre.LanguageName; objGenreList.Add(objGenre); } return(objGenreList); }
public static string Get(string lanKey) { var lanCache = new StaticCache(); LanguageEntity lan = lanCache.Get(lanKey, m => { m.When(LanguageService.SignalLanguageUpdate); if (LanService == null) { return new LanguageEntity { LanKey = lanKey, LanValue = lanKey } } ; var language = LanService.Get(lanKey, GetCurrentLanID()); if (language == null) { string lanValue = lanKey; string lanType = "UnKnown"; string module = "Unknown"; if (lanKey.Contains("@")) { lanValue = lanKey.Split('@')[1]; lanType = "EntityProperty"; module = lanKey.Split('@')[0]; } language = new LanguageEntity { LanID = GetCurrentLanID(), LanValue = lanValue, LanKey = lanKey, LanType = lanType, Module = module }; LanService.Add(language); } return(language); }); return(lan.LanValue); }
public List <LanguageEntity> ListForAmandmentTemplate(int AmandmentTemplateId) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListLanguagesForAmandmentTemplate", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AmandmentTemplateId", AmandmentTemplateId); SqlDataReader rdr = cmd.ExecuteReader(); List <LanguageEntity> list = new List <LanguageEntity>(); while (rdr.Read()) { LanguageEntity entity = new LanguageEntity(); entity.Id = Convert.ToInt32(rdr["Id"]); entity.Status = (StatusEnum)rdr["Status"]; entity.Title = Convert.ToString(rdr["Title"]); entity.Description = Convert.ToString(rdr["Description"]); entity.ApplicationId = Convert.ToInt32(rdr["ApplicationId"]); list.Add(entity); } return(list); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void SetLanguage(LanguageEntity language) { if (language == null) { throw new ArgumentNullException(nameof(language)); } var validationMessages = new List <string>(); var messages = _languageEntityValidator.Validate(language); validationMessages.AddRange(messages); if (validationMessages.Any()) { // TODO: Handle validation failures gracefully. throw new ArgumentException(); } _languageRepository.SetById(language); }
public LanguageEntity Get(int Id) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetLanguageById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", Id); SqlDataReader rdr = cmd.ExecuteReader(); LanguageEntity entity = new LanguageEntity(); while (rdr.Read()) { entity.Id = Convert.ToInt32(rdr["Id"]); entity.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); entity.Title = Convert.ToString(rdr["Title"]); entity.Description = Convert.ToString(rdr["Description"]); entity.ApplicationId = Convert.ToInt32(rdr["ApplicationId"]); } return(entity); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public static string Get(string lanKey) { var lanCache = new StaticCache(); LanguageEntity lan = lanCache.Get(lanKey, m => { using (var languageService = ServiceLocator.GetService <ILanguageService>()) { var language = languageService.Get(n => n.LanKey == lanKey && n.CultureName == CultureInfo.CurrentUICulture.Name).FirstOrDefault(); if (language == null) { string lanValue = lanKey; string lanType = "UnKnown"; string module = "Unknown"; if (lanKey.Contains("@")) { lanValue = lanKey.Split('@')[1]; lanType = "EntityProperty"; module = lanKey.Split('@')[0]; } language = new LanguageEntity { CultureName = CultureInfo.CurrentUICulture.Name, LanValue = lanValue, LanKey = lanKey, LanType = lanType, Module = module }; languageService.Add(language); } return(language); } }); return(lan.LanValue); }
public HttpResponseMessage InsertOrUpdateLanguage(int StoreId, int LoggedInUserId, LanguageEntity objEntity) { try { //HttpContext.Current.Server.MapPath("~/Content/NewsImages) int result = _LanguageServices.InsertOrUpdateLanguage(StoreId, LoggedInUserId, objEntity); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception) { throw; } }
private static System.Linq.Expressions.Expression <Func <JGN_Languages, bool> > returnWhereClause(LanguageEntity entity) { var where_clause = PredicateBuilder.New <JGN_Languages>(true); if (entity.id > 0) { where_clause = where_clause.And(p => p.id == entity.id); } if (entity.isselected != 2) { where_clause = where_clause.And(p => p.isselected == entity.isselected); } if (entity.isdefault != 2) { where_clause = where_clause.And(p => p.isdefault == entity.isdefault); } if (entity.term != "") { where_clause = where_clause.And(p => p.culturename.Contains(entity.term) || p.language.Contains(entity.term) || p.region.Contains(entity.term)); } return(where_clause); }