public bool SaveContentLanguage(long contentId, string cultureCode, string title, string description, string link, string imageUrl, long userId) { bool newRec = false; awContentCulture cl = _context.awContentCultures. FirstOrDefault(st => st.contentId.Equals(contentId) && st.cultureCode.Equals(cultureCode)); if (cl == null) { newRec = true; cl = new awContentCulture(); cl.contentCultureId = AWAPI_Common.library.MiscLibrary.CreateUniqueId(); cl.contentId = contentId; cl.cultureCode = cultureCode; } cl.title = title; cl.description = description; cl.link = link; cl.imageurl = imageUrl; cl.userId = userId; if (newRec) { _context.awContentCultures.InsertOnSubmit(cl); } _context.SubmitChanges(); return(true); }
/// <summary> /// /// </summary> /// <param name="blogId"></param> /// <returns></returns> public awContent Get(long contentId, string cultureCode, bool returnDefaultForLanguage) { if (contentId <= 0) { return(null); } var contList = from c in _context.awContents where c.contentId.Equals(contentId) select c; if (contList == null || contList.Count() == 0) { return(null); } awContent cont = contList.ToList()[0]; if (String.IsNullOrEmpty(cultureCode) || cont.awSite_.cultureCode == cultureCode) { return(cont); } var contLangList = from cl in _context.awContentCultures where cl.contentId.Equals(cont.contentId) && cl.cultureCode.ToLower().Equals(cultureCode.ToLower()) select cl; if (contLangList == null || contLangList.Count() == 0) { if (!returnDefaultForLanguage) { cont.title = null; cont.description = null; cont.link = null; cont.imageurl = null; } return(cont); } awContentCulture contLang = contLangList.FirstOrDefault <awContentCulture>(); cont.title = (returnDefaultForLanguage) ? ((contLang.title == null) ? cont.title : contLang.title) : contLang.title; cont.description = (returnDefaultForLanguage) ? ((contLang.description == null) ? cont.description : contLang.description) : contLang.description; cont.link = (returnDefaultForLanguage) ? ((contLang.link == null) ? cont.link : contLang.link) : contLang.link; cont.imageurl = (returnDefaultForLanguage) ? ((contLang.imageurl == null) ? cont.imageurl : contLang.imageurl) : contLang.imageurl; return(cont); }