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 Insert(string Name, Guid RowGuid, DateTime ModifiedDate) { SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); int SiteCategoryId = 0; return(sitecategoryComponent.InsertNewSiteCategory(ref SiteCategoryId, Name, Guid.NewGuid(), DateTime.Now)); }
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 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 bool Update(string Name, Guid RowGuid, DateTime ModifiedDate, int Original_SiteCategoryId) { SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); return(sitecategoryComponent.UpdateSiteCategory(Name, RowGuid, DateTime.Now, Original_SiteCategoryId)); }
public bool Update(SiteCategory sitecategory, int old_siteCategoryId) { SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); return(sitecategoryComponent.UpdateSiteCategory(sitecategory.Name, sitecategory.RowGuid, sitecategory.ModifiedDate, old_siteCategoryId)); }
public bool Insert(ref int SiteCategoryId, string Name, Guid RowGuid, DateTime ModifiedDate) { SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); return(sitecategoryComponent.InsertNewSiteCategory(ref SiteCategoryId, Name, RowGuid, ModifiedDate)); }
public int UpdateDataset(System.Data.DataSet dataset) { SiteCategoryDAC sitecategorycomponent = new SiteCategoryDAC(); return(sitecategorycomponent.UpdateDataset(dataset)); }
public void Delete(int Original_SiteCategoryId) { SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC(); sitecategoryComponent.DeleteSiteCategory(Original_SiteCategoryId); }