public static cg_cms_Pages_Info getCmsPageByName(string pageName, string IetfLanguageTag)
{
caval_goEntities db = new caval_goEntities();
if (IetfLanguageTag == null) IetfLanguageTag = System.Threading.Thread.CurrentThread.CurrentCulture.IetfLanguageTag;
var pageInfo = (from ppg in db.cg_cms_Pages
where ppg.Name.ToLower() == pageName.ToLower()
from l in db.cg_Languages
where l.SystemLocale.ToLower() == IetfLanguageTag.ToLower()
from pi in ppg.cg_cms_Pages_Info
where pi.LanguageId == l.LanguageId
select pi).FirstOrDefault();
if (pageInfo == null)
{
var defaultCulture = ConfigurationManager.AppSettings["defaultLocale"];
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo(defaultCulture);
pageInfo = (from ppg in db.cg_cms_Pages
where ppg.Name.ToLower() == pageName.ToLower()
from l in db.cg_Languages
where l.SystemLocale.ToLower() == cultureInfo.IetfLanguageTag.ToLower()
from pi in ppg.cg_cms_Pages_Info
where pi.LanguageId == l.LanguageId
select pi).FirstOrDefault();
}
if (pageInfo == null) pageInfo = new cg_cms_Pages_Info();
return pageInfo;
}
/// <summary>
/// Deprecated Method for adding a new object to the cg_cms_Pages_Info EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTocg_cms_Pages_Info(cg_cms_Pages_Info cg_cms_Pages_Info)
{
base.AddObject("cg_cms_Pages_Info", cg_cms_Pages_Info);
}
/// <summary>
/// Create a new cg_cms_Pages_Info object.
/// </summary>
/// <param name="cmsPageInfoId">Initial value of the CmsPageInfoId property.</param>
/// <param name="cmsPageId">Initial value of the CmsPageId property.</param>
/// <param name="languageId">Initial value of the LanguageId property.</param>
public static cg_cms_Pages_Info Createcg_cms_Pages_Info(global::System.Int64 cmsPageInfoId, global::System.Int64 cmsPageId, global::System.Int64 languageId)
{
cg_cms_Pages_Info cg_cms_Pages_Info = new cg_cms_Pages_Info();
cg_cms_Pages_Info.CmsPageInfoId = cmsPageInfoId;
cg_cms_Pages_Info.CmsPageId = cmsPageId;
cg_cms_Pages_Info.LanguageId = languageId;
return cg_cms_Pages_Info;
}
public ActionResult cms_page_info_add(FormCollection collection)
{
long pageId = Convert.ToInt64(collection["PageId"]);
cg_cms_Pages item = db.cg_cms_Pages.Where(p => p.PageId == pageId).FirstOrDefault();
cg_cms_Pages_Info itemInfo = new cg_cms_Pages_Info();
// add values
itemInfo.Name = collection["pageName"];
itemInfo.Code = collection["Code"];
itemInfo.Tag_Description = collection["Tag_Description"];
itemInfo.Tag_Keywords = collection["Tag_Keywords"];
itemInfo.Tag_Title = collection["Tag_Title"];
itemInfo.LanguageId = Convert.ToInt64(collection["LanguageId"]);
// add to DB & save
item.cg_cms_Pages_Info.Add(itemInfo);
db.SaveChanges();
return RedirectToAction("cms_page_infos", new { id = pageId });
}