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);
}
