protected void Show_All_Click(object sender, EventArgs e)
{
int selectedIndex = SearchDropDown.SelectedIndex;
String tableName = "health_profile";
if (selectedIndex == 1)
{
tableName = "diet";
}
else if (selectedIndex == 2)
{
tableName = "enum_health_condition";
}
else if (selectedIndex == 3)
{
tableName = "health_profile";
}
else if (selectedIndex == 4)
{
tableName = "enum_medication";
}
else if (selectedIndex == 5)
{
tableName = "prescription";
}
else if (selectedIndex == 6)
{
tableName = "animal";
}
using (MySqlConnection conn = new MySqlConnection(CONNECTION_STR))
{
try
{
// Connect to Azure MySQL server
System.Diagnostics.Debug.WriteLine("Connecting to server...");
conn.Open();
string query = "SELECT * FROM " + tableName;
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = cmd;
DataTable table = new DataTable();
adapter.Fill(table);
SearchOutput.DataSource = table;
SearchOutput.DataBind();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
}
}
protected void SearchBtn_Click(object sender, EventArgs e)
{
// Get user input
int keyID = Convert.ToInt32(SearchInput.Text.Trim());
int selectedIndex = SearchDropDown.SelectedIndex;
String tableName = "health_profile";
String primaryKey = "profile_id";
if (selectedIndex == 1)
{
tableName = "diet";
primaryKey = "diet_id";
}
else if (selectedIndex == 2)
{
tableName = "enum_health_condition";
primaryKey = "condition_id";
}
else if (selectedIndex == 3)
{
tableName = "health_profile";
primaryKey = "profile_id";
}
else if (selectedIndex == 4)
{
tableName = "enum_medication";
primaryKey = "med_id";
}
else if (selectedIndex == 5)
{
tableName = "prescription";
primaryKey = "prescription_id";
}
else if (selectedIndex == 6)
{
tableName = "animal";
primaryKey = "animal_id";
}
using (MySqlConnection conn = new MySqlConnection(CONNECTION_STR))
{
try
{
// Connect to Azure MySQL server
System.Diagnostics.Debug.WriteLine("Connecting to server...");
conn.Open();
string query = "SELECT * FROM " + tableName + " WHERE " + primaryKey + " = @key_id;";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("@key_id", keyID);
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = cmd;
DataTable table = new DataTable();
adapter.Fill(table);
SearchOutput.DataSource = table;
SearchOutput.DataBind();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
}
}