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