public List<UserMonitor> GetAll() { UserMonitorDAC _userMonitorComponent = new UserMonitorDAC(); IDataReader reader = _userMonitorComponent.GetAllUserMonitor().CreateDataReader(); List<UserMonitor> _userMonitorList = new List<UserMonitor>(); while(reader.Read()) { if(_userMonitorList == null) _userMonitorList = new List<UserMonitor>(); UserMonitor _userMonitor = new UserMonitor(); if(reader["UserMonitorId"] != DBNull.Value) _userMonitor.UserMonitorId = Convert.ToInt32(reader["UserMonitorId"]); if(reader["PersonId"] != DBNull.Value) _userMonitor.PersonId = Convert.ToInt32(reader["PersonId"]); if(reader["IsSuccess"] != DBNull.Value) _userMonitor.IsSuccess = Convert.ToBoolean(reader["IsSuccess"]); if(reader["UserIP"] != DBNull.Value) _userMonitor.UserIP = Convert.ToString(reader["UserIP"]); if(reader["UserName"] != DBNull.Value) _userMonitor.UserName = Convert.ToString(reader["UserName"]); if(reader["DateCreated"] != DBNull.Value) _userMonitor.DateCreated = Convert.ToDateTime(reader["DateCreated"]); _userMonitor.NewRecord = false; _userMonitorList.Add(_userMonitor); } reader.Close(); return _userMonitorList; }
public UserMonitor GetByID(int _userMonitorId) { UserMonitorDAC _userMonitorComponent = new UserMonitorDAC(); IDataReader reader = _userMonitorComponent.GetByIDUserMonitor(_userMonitorId); UserMonitor _userMonitor = null; while(reader.Read()) { _userMonitor = new UserMonitor(); if(reader["UserMonitorId"] != DBNull.Value) _userMonitor.UserMonitorId = Convert.ToInt32(reader["UserMonitorId"]); if(reader["PersonId"] != DBNull.Value) _userMonitor.PersonId = Convert.ToInt32(reader["PersonId"]); if(reader["IsSuccess"] != DBNull.Value) _userMonitor.IsSuccess = Convert.ToBoolean(reader["IsSuccess"]); if(reader["UserIP"] != DBNull.Value) _userMonitor.UserIP = Convert.ToString(reader["UserIP"]); if(reader["UserName"] != DBNull.Value) _userMonitor.UserName = Convert.ToString(reader["UserName"]); if(reader["DateCreated"] != DBNull.Value) _userMonitor.DateCreated = Convert.ToDateTime(reader["DateCreated"]); _userMonitor.NewRecord = false; } reader.Close(); return _userMonitor; }
public bool Insert(UserMonitor usermonitor) { int autonumber = 0; UserMonitorDAC usermonitorComponent = new UserMonitorDAC(); bool endedSuccessfuly = usermonitorComponent.InsertNewUserMonitor( ref autonumber, usermonitor.PersonId, usermonitor.IsSuccess, usermonitor.UserIP, usermonitor.UserName, usermonitor.DateCreated); if(endedSuccessfuly) { usermonitor.UserMonitorId = autonumber; } return endedSuccessfuly; }
public bool Update(UserMonitor usermonitor ,int old_userMonitorId) { UserMonitorDAC usermonitorComponent = new UserMonitorDAC(); return usermonitorComponent.UpdateUserMonitor( usermonitor.PersonId, usermonitor.IsSuccess, usermonitor.UserIP, usermonitor.UserName, usermonitor.DateCreated, old_userMonitorId); }