public ObservableCollection <AccessStatusModel> GetAccessStatusList() { var connectionString = ConfigurationManager.ConnectionStrings["cs_login"].ConnectionString; var connection = new MySqlConnection(connectionString); var commandString = "SELECT * FROM access_status ORDER BY access_status_id; "; var sqlCommand = new MySqlCommand(commandString, connection); var result = new ObservableCollection <AccessStatusModel>(); var usersTable = new DataTable(); connection.Open(); var dbReader = sqlCommand.ExecuteReader(); usersTable.Load(dbReader); connection.Close(); sqlCommand?.Dispose(); foreach (DataRow row in usersTable.Rows) { var accessStatusId = (int)row[0]; var accessStatusName = (string)row[1]; var accessStatusModel = new AccessStatusModel(accessStatusId, accessStatusName); result.Add(accessStatusModel); } return(result); }
public List <AccessStatusModel> GetAccessStatusList(string connectionString) { var connection = new MySqlConnection(connectionString); var commandString = "SELECT * FROM access_status ORDER BY access_status_id; "; var sqlCommand = new MySqlCommand(commandString, connection); try { var result = new List <AccessStatusModel>(); var usersTable = new DataTable(); connection.Open(); var dbReader = sqlCommand.ExecuteReader(); usersTable.Load(dbReader); foreach (DataRow row in usersTable.Rows) { var accessStatusId = (int)row[0]; if (accessStatusId >= this.AccessID) { continue; } var accessStatusName = (string)row[1]; var accessStatusModel = new AccessStatusModel(accessStatusId, accessStatusName); result.Add(accessStatusModel); } return(result); } finally { connection.Close(); sqlCommand?.Dispose(); } }