public bool Insert(SitePageLanguage sitepagelanguage) { int autonumber = 0; SitePageLanguageDAC sitepagelanguageComponent = new SitePageLanguageDAC(); bool endedSuccessfuly = sitepagelanguageComponent.InsertNewSitePageLanguage(ref autonumber, sitepagelanguage.SitePageId, sitepagelanguage.LanguageId, sitepagelanguage.PageName, sitepagelanguage.PageContent, sitepagelanguage.AuthorAlias, sitepagelanguage.PageAlias, sitepagelanguage.ModifiedDate); if (endedSuccessfuly) { sitepagelanguage.SitePageLanguageId = autonumber; } return(endedSuccessfuly); }
public List <SitePageLanguage> GetAllBySitePageId(int PageId) { SitePageLanguageDAC _sitePageLanguageComponent = new SitePageLanguageDAC(); IDataReader reader = _sitePageLanguageComponent.GetAllSitePageLanguage(" SitePageId = " + PageId).CreateDataReader(); List <SitePageLanguage> _sitePageLanguageList = new List <SitePageLanguage>(); while (reader.Read()) { if (_sitePageLanguageList == null) { _sitePageLanguageList = new List <SitePageLanguage>(); } SitePageLanguage _sitePageLanguage = new SitePageLanguage(); if (reader["SitePageLanguageId"] != DBNull.Value) { _sitePageLanguage.SitePageLanguageId = Convert.ToInt32(reader["SitePageLanguageId"]); } if (reader["SitePageId"] != DBNull.Value) { _sitePageLanguage.SitePageId = Convert.ToInt32(reader["SitePageId"]); } if (reader["LanguageId"] != DBNull.Value) { _sitePageLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]); } if (reader["PageName"] != DBNull.Value) { _sitePageLanguage.PageName = Convert.ToString(reader["PageName"]); } if (reader["PageContent"] != DBNull.Value) { _sitePageLanguage.PageContent = Convert.ToString(reader["PageContent"]); } if (reader["AuthorAlias"] != DBNull.Value) { _sitePageLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]); } if (reader["PageAlias"] != DBNull.Value) { _sitePageLanguage.PageAlias = Convert.ToString(reader["PageAlias"]); } if (reader["ModifiedDate"] != DBNull.Value) { _sitePageLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } _sitePageLanguage.NewRecord = false; _sitePageLanguageList.Add(_sitePageLanguage); } reader.Close(); return(_sitePageLanguageList); }
public SitePageLanguage GetBySitePageIDLanguageId(int SitePageId, int LanguageId) { SitePageLanguageDAC _sitePageLanguageComponent = new SitePageLanguageDAC(); IDataReader reader = _sitePageLanguageComponent.GetByPageIDLanguageIdSitePageLanguage(SitePageId, LanguageId); SitePageLanguage _sitePageLanguage = null; while (reader.Read()) { _sitePageLanguage = new SitePageLanguage(); if (reader["SitePageLanguageId"] != DBNull.Value) { _sitePageLanguage.SitePageLanguageId = Convert.ToInt32(reader["SitePageLanguageId"]); } if (reader["SitePageId"] != DBNull.Value) { _sitePageLanguage.SitePageId = Convert.ToInt32(reader["SitePageId"]); } if (reader["LanguageId"] != DBNull.Value) { _sitePageLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]); } if (reader["PageName"] != DBNull.Value) { _sitePageLanguage.PageName = Convert.ToString(reader["PageName"]); } if (reader["PageContent"] != DBNull.Value) { _sitePageLanguage.PageContent = Convert.ToString(reader["PageContent"]); } if (reader["AuthorAlias"] != DBNull.Value) { _sitePageLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]); } if (reader["PageAlias"] != DBNull.Value) { _sitePageLanguage.PageAlias = Convert.ToString(reader["PageAlias"]); } if (reader["ModifiedDate"] != DBNull.Value) { _sitePageLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } _sitePageLanguage.NewRecord = false; } reader.Close(); return(_sitePageLanguage); }
public bool Update(SitePageLanguage sitepagelanguage, int old_sitePageLanguageId) { SitePageLanguageDAC sitepagelanguageComponent = new SitePageLanguageDAC(); return(sitepagelanguageComponent.UpdateSitePageLanguage(sitepagelanguage.SitePageId, sitepagelanguage.LanguageId, sitepagelanguage.PageName, sitepagelanguage.PageContent, sitepagelanguage.AuthorAlias, sitepagelanguage.PageAlias, sitepagelanguage.ModifiedDate, old_sitePageLanguageId)); }