private void PopulateData()
{
using (SqlConnection connection = new SqlConnection(this._connString))
{
SqlDataReader dataReader = null;
string selectSql = @"SELECT * FROM dbo.posVwUserRight ORDER BY IdUserRight;";
SqlCommand command = new SqlCommand(selectSql, connection);
connection.Open();
this._urgStore.Clear();
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
this._urgStore.Add(new UserRight()
{
Id = (string)dataReader["IdUserRight"],
Name = (string)dataReader["Name"],
Rights = RightsHelper.ToRights((string)dataReader["Rights"]),
Status = (bool)dataReader["Status"]
});
}
}
}
