public List<SiteSection> GetAll()
{
SiteSectionDAC _siteSectionComponent = new SiteSectionDAC();
IDataReader reader = _siteSectionComponent.GetAllSiteSection().CreateDataReader();
List<SiteSection> _siteSectionList = new List<SiteSection>();
while(reader.Read())
{
if(_siteSectionList == null)
_siteSectionList = new List<SiteSection>();
SiteSection _siteSection = new SiteSection();
if(reader["SiteSectionId"] != DBNull.Value)
_siteSection.SiteSectionId = Convert.ToInt32(reader["SiteSectionId"]);
if(reader["Name"] != DBNull.Value)
_siteSection.Name = Convert.ToString(reader["Name"]);
if(reader["SiteSectionParentId"] != DBNull.Value)
_siteSection.SiteSectionParentId = Convert.ToInt32(reader["SiteSectionParentId"]);
if(reader["SectionStatusId"] != DBNull.Value)
_siteSection.SectionStatusId = Convert.ToInt32(reader["SectionStatusId"]);
if(reader["SiteId"] != DBNull.Value)
_siteSection.SiteId = Convert.ToInt32(reader["SiteId"]);
if(reader["PersonId"] != DBNull.Value)
_siteSection.PersonId = Convert.ToInt32(reader["PersonId"]);
if(reader["SecurityAccessTypeId"] != DBNull.Value)
_siteSection.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]);
if(reader["RowGuid"] != DBNull.Value)
_siteSection.RowGuid = new Guid(reader["RowGuid"].ToString());
if(reader["ModifiedDate"] != DBNull.Value)
_siteSection.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["Alias"] != DBNull.Value)
_siteSection.Alias = Convert.ToString(reader["Alias"]);
_siteSection.NewRecord = false;
_siteSectionList.Add(_siteSection);
} reader.Close();
return _siteSectionList;
}
public int UpdateDataset(System.Data.DataSet dataset)
{
SiteSectionDAC sitesectioncomponent = new SiteSectionDAC();
return sitesectioncomponent.UpdateDataset(dataset);
}
public void Delete(int Original_SiteSectionId)
{
SiteSectionDAC sitesectionComponent = new SiteSectionDAC();
sitesectionComponent.DeleteSiteSection(Original_SiteSectionId);
BusinessLogicLayer.Common.ContentEntityLogic.Delete(Original_SiteSectionId);
}
public bool Update( int SiteSectionId, string Name, int SiteSectionParentId, int SectionStatusId, int SiteId, int PersonId, int SecurityAccessTypeId, Guid RowGuid, DateTime ModifiedDate,string Alias, int Original_SiteSectionId)
{
SiteSectionDAC sitesectionComponent = new SiteSectionDAC();
return sitesectionComponent.UpdateSiteSection( SiteSectionId, Name, SiteSectionParentId, SectionStatusId, SiteId, PersonId, SecurityAccessTypeId, RowGuid, DateTime.Now, Alias, Original_SiteSectionId);
}
public bool Update(SiteSection sitesection ,int old_siteSectionId)
{
SiteSectionDAC sitesectionComponent = new SiteSectionDAC();
return sitesectionComponent.UpdateSiteSection( sitesection.SiteSectionId, sitesection.Name, sitesection.SiteSectionParentId, sitesection.SectionStatusId, sitesection.SiteId, sitesection.PersonId, sitesection.SecurityAccessTypeId, sitesection.RowGuid, sitesection.ModifiedDate, sitesection.Alias, old_siteSectionId);
}
public bool Insert( int SiteSectionId, string Name, int SiteSectionParentId, int SectionStatusId, int SiteId, int PersonId, int SecurityAccessTypeId, Guid RowGuid, DateTime ModifiedDate,string Alias)
{
SiteSectionDAC sitesectionComponent = new SiteSectionDAC();
int id = 0;
BusinessLogicLayer.Common.ContentEntityLogic.Insert(ref id, "SS", Guid.NewGuid(), DateTime.Now);
return sitesectionComponent.InsertNewSiteSection( id, Name, SiteSectionParentId, SectionStatusId, SiteId, PersonId, SecurityAccessTypeId, Guid.NewGuid(), DateTime.Now, Alias);
}
public bool Insert(SiteSection sitesection)
{
SiteSectionDAC sitesectionComponent = new SiteSectionDAC();
return sitesectionComponent.InsertNewSiteSection( sitesection.SiteSectionId, sitesection.Name, sitesection.SiteSectionParentId, sitesection.SectionStatusId, sitesection.SiteId, sitesection.PersonId, sitesection.SecurityAccessTypeId, sitesection.RowGuid, sitesection.ModifiedDate,sitesection.Alias);
}
public SiteSection GetByID(int _siteSectionId)
{
SiteSectionDAC _siteSectionComponent = new SiteSectionDAC();
IDataReader reader = _siteSectionComponent.GetByIDSiteSection(_siteSectionId);
SiteSection _siteSection = null;
while(reader.Read())
{
_siteSection = new SiteSection();
if(reader["SiteSectionId"] != DBNull.Value)
_siteSection.SiteSectionId = Convert.ToInt32(reader["SiteSectionId"]);
if(reader["Name"] != DBNull.Value)
_siteSection.Name = Convert.ToString(reader["Name"]);
if(reader["SiteSectionParentId"] != DBNull.Value)
_siteSection.SiteSectionParentId = Convert.ToInt32(reader["SiteSectionParentId"]);
if(reader["SectionStatusId"] != DBNull.Value)
_siteSection.SectionStatusId = Convert.ToInt32(reader["SectionStatusId"]);
if(reader["SiteId"] != DBNull.Value)
_siteSection.SiteId = Convert.ToInt32(reader["SiteId"]);
if(reader["PersonId"] != DBNull.Value)
_siteSection.PersonId = Convert.ToInt32(reader["PersonId"]);
if(reader["SecurityAccessTypeId"] != DBNull.Value)
_siteSection.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]);
if(reader["RowGuid"] != DBNull.Value)
_siteSection.RowGuid = new Guid(reader["RowGuid"].ToString());
if(reader["ModifiedDate"] != DBNull.Value)
_siteSection.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["Alias"] != DBNull.Value)
_siteSection.Alias = Convert.ToString(reader["Alias"]);
_siteSection.NewRecord = false; } reader.Close();
return _siteSection;
}
