/// <summary>
/// Read Available Apps using SQL Query
/// </summary>
public void ReadAppList(string filter = null)
{
InitializeData();
string query = string.Empty;
if (string.IsNullOrEmpty(filter))
{
query = "SELECT id, company_id, app_name, app_secret FROM oauth_application";
}
else
{
query = string.Format("SELECT id, company_id, app_name, app_secret FROM oauth_application WHERE app_name = '{0}'", filter);
}
try
{
List <Dictionary <string, object> > rows = mySqlHandler.ExecuteReaderQuery(query);
foreach (Dictionary <string, object> row in rows)
{
int new_id = row["id"] != System.DBNull.Value ? (int)row["id"] : -1;
int new_company_id = row["company_id"] != System.DBNull.Value ? (int)row["company_id"] : -1;
string new_app_name = row["app_name"] != System.DBNull.Value ? (string)row["app_name"] : string.Empty;
string new_app_secret = row["app_secret"] != System.DBNull.Value ? (string)row["app_secret"] : string.Empty;
HrbcApp newApp = new HrbcApp()
{
id = new_id,
company_id = new_company_id > 0 ? new_company_id.ToString() : "NULL",
app_name = new_app_name,
app_secret = new_app_secret
};
AvailableHrbcApps.Add(newApp);
}
}
catch (MySql.Data.MySqlClient.MySqlException e)
{
Console.WriteLine("SQL Connection is not established properly yet.");
Console.WriteLine(e.ToString());
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
if (this.AppListGrid.SelectedItems != null && this.AppListGrid.SelectedItems.Count > 1)
{
//List<HrbcApp> selectedItems = (List<HrbcApp>)this.AppListGrid.SelectedItems;
foreach (HrbcApp item in this.AppListGrid.SelectedItems)
{
int selectedId = item.id;
if (!WhitelistedApps.Contains(selectedId))
{
WhitelistedApps.Add(selectedId);
}
else
{
Console.WriteLine("Selected id {0} exists", selectedId);
}
}
}
else if (this.AppListGrid.SelectedItem != null)
{
HrbcApp selectedItem = (HrbcApp)this.AppListGrid.SelectedItem;
int selectedId = selectedItem.id;
if (!WhitelistedApps.Contains(selectedId))
{
WhitelistedApps.Add(selectedId);
}
else
{
Console.WriteLine("Selected id {0} exists", selectedId);
}
}
this.WhiteListBox.ItemsSource = WhitelistedApps;
this.WhiteListBox.Items.Refresh();
}