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 int GetUserMonitorCountInPeriod(string UserName, string UserIP) { UserMonitorDAC usermonitorComponent = new UserMonitorDAC(); return usermonitorComponent.GetUserMonitorCountInPeriod(UserName, UserIP); //return usermonitorComponent.GetUserMonitorCountInPeriod("*****@*****.**", "41.68.50.64-"); }
public void Delete(int Original_UserMonitorId) { UserMonitorDAC usermonitorComponent = new UserMonitorDAC(); usermonitorComponent.DeleteUserMonitor(Original_UserMonitorId); }
public int UpdateDataset(System.Data.DataSet dataset) { UserMonitorDAC usermonitorcomponent = new UserMonitorDAC(); return usermonitorcomponent.UpdateDataset(dataset); }
public bool Update( int PersonId, bool IsSuccess, string UserIP, string UserName, DateTime DateCreated, int Original_UserMonitorId) { UserMonitorDAC usermonitorComponent = new UserMonitorDAC(); return usermonitorComponent.UpdateUserMonitor( PersonId, IsSuccess, UserIP, UserName, DateCreated, Original_UserMonitorId); }
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); }
public bool Insert( int PersonId, bool IsSuccess, string UserIP, string UserName, DateTime DateCreated) { UserMonitorDAC usermonitorComponent = new UserMonitorDAC(); int UserMonitorId = 0; return usermonitorComponent.InsertNewUserMonitor( ref UserMonitorId, PersonId, IsSuccess, UserIP, UserName, DateCreated); }