public List<SitePageLayout> GetAllBySiteId(int SiteID)
{
SitePageLayoutDAC _sitePageLayoutComponent = new SitePageLayoutDAC();
IDataReader reader = _sitePageLayoutComponent.GetAllSitePageLayout("SiteID = " + SiteID).CreateDataReader();
List<SitePageLayout> _sitePageLayoutList = new List<SitePageLayout>();
while (reader.Read())
{
if (_sitePageLayoutList == null)
_sitePageLayoutList = new List<SitePageLayout>();
SitePageLayout _sitePageLayout = new SitePageLayout();
if (reader["SitePageLayoutID"] != DBNull.Value)
_sitePageLayout.SitePageLayoutID = Convert.ToInt32(reader["SitePageLayoutID"]);
if (reader["SiteID"] != DBNull.Value)
_sitePageLayout.SiteID = Convert.ToInt32(reader["SiteID"]);
if (reader["Name"] != DBNull.Value)
_sitePageLayout.Name = Convert.ToString(reader["Name"]);
if (reader["DesignCode"] != DBNull.Value)
_sitePageLayout.DesignCode = Convert.ToString(reader["DesignCode"]);
if (reader["PreviewCode"] != DBNull.Value)
_sitePageLayout.PreviewCode = Convert.ToString(reader["PreviewCode"]);
if (reader["PreviewClass"] != DBNull.Value)
_sitePageLayout.PreviewClass = Convert.ToString(reader["PreviewClass"]);
_sitePageLayout.NewRecord = false;
_sitePageLayoutList.Add(_sitePageLayout);
} reader.Close();
return _sitePageLayoutList;
}
public SitePageLayout GetByID(int _sitePageLayoutID)
{
SitePageLayoutDAC _sitePageLayoutComponent = new SitePageLayoutDAC();
IDataReader reader = _sitePageLayoutComponent.GetByIDSitePageLayout(_sitePageLayoutID);
SitePageLayout _sitePageLayout = null;
while(reader.Read())
{
_sitePageLayout = new SitePageLayout();
if(reader["SitePageLayoutID"] != DBNull.Value)
_sitePageLayout.SitePageLayoutID = Convert.ToInt32(reader["SitePageLayoutID"]);
if(reader["SiteID"] != DBNull.Value)
_sitePageLayout.SiteID = Convert.ToInt32(reader["SiteID"]);
if(reader["Name"] != DBNull.Value)
_sitePageLayout.Name = Convert.ToString(reader["Name"]);
if(reader["DesignCode"] != DBNull.Value)
_sitePageLayout.DesignCode = Convert.ToString(reader["DesignCode"]);
if(reader["PreviewCode"] != DBNull.Value)
_sitePageLayout.PreviewCode = Convert.ToString(reader["PreviewCode"]);
if(reader["PreviewClass"] != DBNull.Value)
_sitePageLayout.PreviewClass = Convert.ToString(reader["PreviewClass"]);
_sitePageLayout.NewRecord = false; } reader.Close();
return _sitePageLayout;
}
public bool Update(SitePageLayout sitepagelayout ,int old_sitePageLayoutID)
{
SitePageLayoutDAC sitepagelayoutComponent = new SitePageLayoutDAC();
return sitepagelayoutComponent.UpdateSitePageLayout( sitepagelayout.SiteID, sitepagelayout.Name, sitepagelayout.DesignCode, sitepagelayout.PreviewCode, sitepagelayout.PreviewClass, old_sitePageLayoutID);
}
public bool Insert(SitePageLayout sitepagelayout)
{
int autonumber = 0;
SitePageLayoutDAC sitepagelayoutComponent = new SitePageLayoutDAC();
bool endedSuccessfuly = sitepagelayoutComponent.InsertNewSitePageLayout( ref autonumber, sitepagelayout.SiteID, sitepagelayout.Name, sitepagelayout.DesignCode, sitepagelayout.PreviewCode, sitepagelayout.PreviewClass);
if(endedSuccessfuly)
{
sitepagelayout.SitePageLayoutID = autonumber;
}
return endedSuccessfuly;
}