/// <summary> /// Search Data in UserState table /// </summary> /// <param name="iDto"> /// Dto of UserState form /// </param> /// <param name="dtResult"> /// Out a Datatable that contains search result(all columns) in UserState table /// </param> /// <returns> /// 0: Update successful /// 1: Access denied, login to database fail(invalid username, invalid password) /// 2: Invalid host, cannot find server(host) that set in app config file /// 3: Invalid database, cannot find database that set in DbConfig file /// 4: Lost connection, cannot connect to database because lost connection /// 5: Duplicate key: insert Primary Key or Unique Key that already exist in database /// 6: Forgeign key not exist: insert a foreign key that not exist in primary key /// 7: Foreign Key Violation: Foreign Key Violation (delete primary key that is foreign key in other table) /// 8: Data not found: Delete or Update data that not exist in database /// 9: Exception occured: other exception /// </returns> public int SearchData(IDto searchDto, out DataTable dtResult) { SYS_UserStateDao dao = new SYS_UserStateDao(); SYS_UserStateDto dto = (SYS_UserStateDto)searchDto; return(dao.SelectData(dto, out dtResult)); }
/// <summary> /// Disconnect UserState data from Database /// </summary> /// <param name="ListDto"> /// list object that contains data to delete /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int DisconnectData(List <IDto> listDto) { SYS_UserStateDao dao = new SYS_UserStateDao(); List <int> listDisconnectData = new List <int>(); foreach (SYS_UserStateDto dto in listDto) { listDisconnectData.Add(dto.ID); } return(dao.DisconnectData(listDisconnectData)); }
public int SearchOnlineUsersData(string exeptUserCode, out DataTable dtResult) { SYS_UserStateDao dao = new SYS_UserStateDao(); return(dao.SelectOnlineUsersData(exeptUserCode, out dtResult)); }
public int SendMessage(string exeptUserCode, string message) { SYS_UserStateDao dao = new SYS_UserStateDao(); return(dao.SendMessage(exeptUserCode, message)); }