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