public bool Insert(SiteCategory sitecategory) { int autonumber = 0; SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); bool endedSuccessfuly = sitecategoryComponent.InsertNewSiteCategory( ref autonumber, sitecategory.Name, sitecategory.RowGuid, sitecategory.ModifiedDate); if(endedSuccessfuly) { sitecategory.SiteCategoryId = autonumber; } return endedSuccessfuly; }
public SiteCategory GetByID(int _siteCategoryId) { SiteCategoryDAC _siteCategoryComponent = new SiteCategoryDAC(); IDataReader reader = _siteCategoryComponent.GetByIDSiteCategory(_siteCategoryId); SiteCategory _siteCategory = null; while(reader.Read()) { _siteCategory = new SiteCategory(); if(reader["SiteCategoryId"] != DBNull.Value) _siteCategory.SiteCategoryId = Convert.ToInt32(reader["SiteCategoryId"]); if(reader["Name"] != DBNull.Value) _siteCategory.Name = Convert.ToString(reader["Name"]); if(reader["RowGuid"] != DBNull.Value) _siteCategory.RowGuid = new Guid(reader["RowGuid"].ToString()); if(reader["ModifiedDate"] != DBNull.Value) _siteCategory.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); _siteCategory.NewRecord = false; } reader.Close(); return _siteCategory; }
public List<SiteCategory> GetAll() { SiteCategoryDAC _siteCategoryComponent = new SiteCategoryDAC(); IDataReader reader = _siteCategoryComponent.GetAllSiteCategory().CreateDataReader(); List<SiteCategory> _siteCategoryList = new List<SiteCategory>(); while(reader.Read()) { if(_siteCategoryList == null) _siteCategoryList = new List<SiteCategory>(); SiteCategory _siteCategory = new SiteCategory(); if(reader["SiteCategoryId"] != DBNull.Value) _siteCategory.SiteCategoryId = Convert.ToInt32(reader["SiteCategoryId"]); if(reader["Name"] != DBNull.Value) _siteCategory.Name = Convert.ToString(reader["Name"]); if(reader["RowGuid"] != DBNull.Value) _siteCategory.RowGuid = new Guid(reader["RowGuid"].ToString()); if(reader["ModifiedDate"] != DBNull.Value) _siteCategory.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); _siteCategory.NewRecord = false; _siteCategoryList.Add(_siteCategory); } reader.Close(); return _siteCategoryList; }
public bool Update(SiteCategory sitecategory ,int old_siteCategoryId) { SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); return sitecategoryComponent.UpdateSiteCategory( sitecategory.Name, sitecategory.RowGuid, sitecategory.ModifiedDate, old_siteCategoryId); }