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