public SitePageCategory GetByID(int _sitePageCategoryId) { SitePageCategoryDAC _sitePageCategoryComponent = new SitePageCategoryDAC(); IDataReader reader = _sitePageCategoryComponent.GetByIDSitePageCategory(_sitePageCategoryId); SitePageCategory _sitePageCategory = null; while (reader.Read()) { _sitePageCategory = new SitePageCategory(); if (reader["SitePageCategoryId"] != DBNull.Value) { _sitePageCategory.SitePageCategoryId = Convert.ToInt32(reader["SitePageCategoryId"]); } if (reader["SiteCategoryId"] != DBNull.Value) { _sitePageCategory.SiteCategoryId = Convert.ToInt32(reader["SiteCategoryId"]); } if (reader["SitePageId"] != DBNull.Value) { _sitePageCategory.SitePageId = Convert.ToInt32(reader["SitePageId"]); } if (reader["ModifiedDate"] != DBNull.Value) { _sitePageCategory.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } _sitePageCategory.NewRecord = false; } reader.Close(); return(_sitePageCategory); }
public List <SitePageCategory> GetAllBySitePageId(int SitePageId) { SitePageCategoryDAC _sitePageCategoryComponent = new SitePageCategoryDAC(); IDataReader reader = _sitePageCategoryComponent.GetAllSitePageCategory(" SitePageId = " + SitePageId).CreateDataReader(); List <SitePageCategory> _sitePageCategoryList = new List <SitePageCategory>(); while (reader.Read()) { if (_sitePageCategoryList == null) { _sitePageCategoryList = new List <SitePageCategory>(); } SitePageCategory _sitePageCategory = new SitePageCategory(); if (reader["SitePageCategoryId"] != DBNull.Value) { _sitePageCategory.SitePageCategoryId = Convert.ToInt32(reader["SitePageCategoryId"]); } if (reader["SiteCategoryId"] != DBNull.Value) { _sitePageCategory.SiteCategoryId = Convert.ToInt32(reader["SiteCategoryId"]); } if (reader["SitePageId"] != DBNull.Value) { _sitePageCategory.SitePageId = Convert.ToInt32(reader["SitePageId"]); } if (reader["ModifiedDate"] != DBNull.Value) { _sitePageCategory.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } _sitePageCategory.NewRecord = false; _sitePageCategoryList.Add(_sitePageCategory); } reader.Close(); return(_sitePageCategoryList); }
public bool Insert(int SiteCategoryId, int SitePageId, DateTime ModifiedDate) { SitePageCategoryDAC sitepagecategoryComponent = new SitePageCategoryDAC(); int SitePageCategoryId = 0; return(sitepagecategoryComponent.InsertNewSitePageCategory(ref SitePageCategoryId, SiteCategoryId, SitePageId, ModifiedDate)); }
public bool Insert(SitePageCategory sitepagecategory) { int autonumber = 0; SitePageCategoryDAC sitepagecategoryComponent = new SitePageCategoryDAC(); bool endedSuccessfuly = sitepagecategoryComponent.InsertNewSitePageCategory(ref autonumber, sitepagecategory.SiteCategoryId, sitepagecategory.SitePageId, sitepagecategory.ModifiedDate); if (endedSuccessfuly) { sitepagecategory.SitePageCategoryId = autonumber; } return(endedSuccessfuly); }
public int UpdateDataset(System.Data.DataSet dataset) { SitePageCategoryDAC sitepagecategorycomponent = new SitePageCategoryDAC(); return(sitepagecategorycomponent.UpdateDataset(dataset)); }
public void DeleteBySitePageId(int Original_SitePageId) { SitePageCategoryDAC sitepagecategoryComponent = new SitePageCategoryDAC(); sitepagecategoryComponent.DeleteSitePageCategoryBySitePageId(Original_SitePageId); }
public bool Update(int SiteCategoryId, int SitePageId, DateTime ModifiedDate, int Original_SitePageCategoryId) { SitePageCategoryDAC sitepagecategoryComponent = new SitePageCategoryDAC(); return(sitepagecategoryComponent.UpdateSitePageCategory(SiteCategoryId, SitePageId, ModifiedDate, Original_SitePageCategoryId)); }
public bool Update(SitePageCategory sitepagecategory, int old_sitePageCategoryId) { SitePageCategoryDAC sitepagecategoryComponent = new SitePageCategoryDAC(); return(sitepagecategoryComponent.UpdateSitePageCategory(sitepagecategory.SiteCategoryId, sitepagecategory.SitePageId, sitepagecategory.ModifiedDate, old_sitePageCategoryId)); }