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 GetSitePageLanguageByLanguageId(int id)
{
SitePageLanguage lang = new SitePageLanguage();
var availableSitePageLanguages = from x in CurrentSitePageLanguages where x.LanguageId == id select x;
foreach (SitePageLanguage l in availableSitePageLanguages)
{
lang = l;
}
return(lang);
}
public SitePageLanguage GetSitePageLanguageByLanguageId(int id)
{
SitePageLanguage lang = new SitePageLanguage();
var availableSitePageLanguages = from x in CurrentSitePageLanguages where x.LanguageId == id select x;
foreach(SitePageLanguage l in availableSitePageLanguages)
{
lang = l;
}
return lang;
}
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);
}
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 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;
}