public static cg_cms_StaticBlocks_Info getCmsBlockByName(string blockName, string IetfLanguageTag) { caval_goEntities db = new caval_goEntities(); if (IetfLanguageTag == null) IetfLanguageTag = System.Threading.Thread.CurrentThread.CurrentCulture.IetfLanguageTag; var blockInfo = (from pb in db.cg_cms_StaticBlocks where pb.Name.ToLower() == blockName.ToLower() from l in db.cg_Languages where l.SystemLocale.ToLower() == IetfLanguageTag.ToLower() from pi in pb.cg_cms_StaticBlocks_Info where pi.LanguageId == l.LanguageId select pi).FirstOrDefault(); if (blockInfo == null) { var defaultCulture = ConfigurationManager.AppSettings["defaultLocale"]; System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo(defaultCulture); blockInfo = (from pb in db.cg_cms_StaticBlocks where pb.Name.ToLower() == blockName.ToLower() from l in db.cg_Languages where l.SystemLocale.ToLower() == cultureInfo.IetfLanguageTag.ToLower() from pi in pb.cg_cms_StaticBlocks_Info where pi.LanguageId == l.LanguageId select pi).FirstOrDefault(); } if (blockInfo == null) blockInfo = new cg_cms_StaticBlocks_Info(); return blockInfo; }
/// <summary> /// Deprecated Method for adding a new object to the cg_cms_StaticBlocks_Info EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTocg_cms_StaticBlocks_Info(cg_cms_StaticBlocks_Info cg_cms_StaticBlocks_Info) { base.AddObject("cg_cms_StaticBlocks_Info", cg_cms_StaticBlocks_Info); }
/// <summary> /// Create a new cg_cms_StaticBlocks_Info object. /// </summary> /// <param name="staticBlockInfoId">Initial value of the StaticBlockInfoId property.</param> /// <param name="staticBlockId">Initial value of the StaticBlockId property.</param> /// <param name="languageId">Initial value of the LanguageId property.</param> public static cg_cms_StaticBlocks_Info Createcg_cms_StaticBlocks_Info(global::System.Int64 staticBlockInfoId, global::System.Int64 staticBlockId, global::System.Int64 languageId) { cg_cms_StaticBlocks_Info cg_cms_StaticBlocks_Info = new cg_cms_StaticBlocks_Info(); cg_cms_StaticBlocks_Info.StaticBlockInfoId = staticBlockInfoId; cg_cms_StaticBlocks_Info.StaticBlockId = staticBlockId; cg_cms_StaticBlocks_Info.LanguageId = languageId; return cg_cms_StaticBlocks_Info; }
public ActionResult cms_staticblock_info_add(FormCollection collection) { long blockId = Convert.ToInt64(collection["BlockId"]); var item = db.cg_cms_StaticBlocks.Where(sb => sb.StaticBlockId == blockId).FirstOrDefault(); var itemInfo = new cg_cms_StaticBlocks_Info(); // add values itemInfo.Code = collection["Code"]; itemInfo.LanguageId = Convert.ToInt64(collection["LanguageId"]); // add to DB & save item.cg_cms_StaticBlocks_Info.Add(itemInfo); db.SaveChanges(); return RedirectToAction("cms_staticblock_infos", new { id = blockId }); }