public List<SystemPage> GetAll(bool IsActive)
{
SystemPageDAC _systemPageComponent = new SystemPageDAC();
IDataReader reader = _systemPageComponent.GetAllSystemPage("IsActive="+(IsActive?"1":"0")).CreateDataReader();
List<SystemPage> _systemPageList = new List<SystemPage>();
while (reader.Read())
{
if (_systemPageList == null)
_systemPageList = new List<SystemPage>();
SystemPage _systemPage = new SystemPage();
if (reader["SystemPageId"] != DBNull.Value)
_systemPage.SystemPageId = Convert.ToInt32(reader["SystemPageId"]);
if (reader["Name"] != DBNull.Value)
_systemPage.Name = Convert.ToString(reader["Name"]);
if (reader["Path"] != DBNull.Value)
_systemPage.Path = Convert.ToString(reader["Path"]);
if (reader["SecurityAccessTypeId"] != DBNull.Value)
_systemPage.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]);
if (reader["IsActive"] != DBNull.Value)
_systemPage.IsActive = Convert.ToBoolean(reader["IsActive"]);
if (reader["RowGuid"] != DBNull.Value)
_systemPage.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["ModifiedDate"] != DBNull.Value)
_systemPage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["SystemFolderId"] != DBNull.Value)
_systemPage.SystemFolderId = Convert.ToInt32(reader["SystemFolderId"]);
_systemPage.NewRecord = false;
_systemPageList.Add(_systemPage);
} reader.Close();
return _systemPageList;
}
public bool Update(SystemPage systempage ,int old_systemPageId)
{
SystemPageDAC systempageComponent = new SystemPageDAC();
return systempageComponent.UpdateSystemPage( systempage.SystemPageId, systempage.Name, systempage.Path, systempage.SecurityAccessTypeId, systempage.IsActive, systempage.RowGuid, DateTime.Now, systempage.SystemFolderId, old_systemPageId);
}
public SystemPage GetByPagePath(string PagePath)
{
SystemPageDAC _systemPageComponent = new SystemPageDAC();
IDataReader reader = _systemPageComponent.GetAllSystemPage("Path='" + PagePath+"'").CreateDataReader();
//List<SystemPage> _systemPageList = new List<SystemPage>();
SystemPage _systemPage = new SystemPage();
if (reader.Read())
{
if (reader["SystemPageId"] != DBNull.Value)
_systemPage.SystemPageId = Convert.ToInt32(reader["SystemPageId"]);
if (reader["Name"] != DBNull.Value)
_systemPage.Name = Convert.ToString(reader["Name"]);
if (reader["Path"] != DBNull.Value)
_systemPage.Path = Convert.ToString(reader["Path"]);
if (reader["SecurityAccessTypeId"] != DBNull.Value)
_systemPage.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]);
if (reader["IsActive"] != DBNull.Value)
_systemPage.IsActive = Convert.ToBoolean(reader["IsActive"]);
if (reader["RowGuid"] != DBNull.Value)
_systemPage.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["ModifiedDate"] != DBNull.Value)
_systemPage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["SystemFolderId"] != DBNull.Value)
_systemPage.SystemFolderId = Convert.ToInt32(reader["SystemFolderId"]);
_systemPage.NewRecord = false;
} reader.Close();
return _systemPage; ;
}
public bool Insert(SystemPage systempage)
{
SystemPageDAC systempageComponent = new SystemPageDAC();
return systempageComponent.InsertNewSystemPage( systempage.SystemPageId, systempage.Name, systempage.Path, systempage.SecurityAccessTypeId, systempage.IsActive, systempage.RowGuid, systempage.ModifiedDate, systempage.SystemFolderId);
}
public SystemPage GetByID(int _systemPageId)
{
SystemPageDAC _systemPageComponent = new SystemPageDAC();
IDataReader reader = _systemPageComponent.GetByIDSystemPage(_systemPageId);
SystemPage _systemPage = null;
while(reader.Read())
{
_systemPage = new SystemPage();
if(reader["SystemPageId"] != DBNull.Value)
_systemPage.SystemPageId = Convert.ToInt32(reader["SystemPageId"]);
if(reader["Name"] != DBNull.Value)
_systemPage.Name = Convert.ToString(reader["Name"]);
if(reader["Path"] != DBNull.Value)
_systemPage.Path = Convert.ToString(reader["Path"]);
if(reader["SecurityAccessTypeId"] != DBNull.Value)
_systemPage.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]);
if(reader["IsActive"] != DBNull.Value)
_systemPage.IsActive = Convert.ToBoolean(reader["IsActive"]);
if(reader["RowGuid"] != DBNull.Value)
_systemPage.RowGuid = new Guid(reader["RowGuid"].ToString());
if(reader["ModifiedDate"] != DBNull.Value)
_systemPage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if(reader["SystemFolderId"] != DBNull.Value)
_systemPage.SystemFolderId = Convert.ToInt32(reader["SystemFolderId"]);
_systemPage.NewRecord = false; } reader.Close();
return _systemPage;
}