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