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