public void NPCsAdd_Load(object sender, EventArgs e)
{
conn.Open();
string query = "Select PLACE_ID, NAME FROM PLACES order by NAME";
try
{
using (SqlCommand command = new SqlCommand(query, conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
PLACE place = new PLACE();
place.PLACE_ID = reader.GetInt32(0);
place.NAME = reader.GetString(1);
comboBoxHomeCity.Items.Add(place);
}
}
}
}
catch
{
MessageBox.Show("An error occurred in NPCsAdd_Load.");
}
query = "Select TYPE_ID, DESCR FROM TYPE_V WHERE CATEGORY = 'OCCUPATION' order by DESCR";
try
{
using (SqlCommand command = new SqlCommand(query, conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TYPE_V occupation = new TYPE_V();
occupation.TYPE_ID = reader.GetInt32(0);
occupation.DESCR = reader.GetString(1);
comboBoxOccupation.Items.Add(occupation);
}
}
}
}
catch
{
MessageBox.Show("An error occurred in NPCsAdd_Load.");
}
conn.Close();
}
private void doRefresh()
{
AllItems.Clear();
ListV.Clear();
listViewTypeV.Items.Clear();
conn.Open();
string query = "SELECT * FROM TYPE_V";
try
{
using (SqlCommand command = new SqlCommand(query, conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TYPE_V type_v = new TYPE_V();
type_v.TYPE_ID = reader.GetInt32(0);
type_v.CATEGORY = reader.GetString(1);
type_v.DESCR = reader.GetString(2);
ListV.Add(type_v);
}
}
}
foreach (var item in ListV)
{
ListViewItem row = new ListViewItem(item.DESCR);
row.SubItems.Add(new ListViewItem.ListViewSubItem(row, item.CATEGORY));
row.SubItems.Add(new ListViewItem.ListViewSubItem(row, item.TYPE_ID.ToString()));
listViewTypeV.Items.Add(row);
}
AllItems = ListV;
}
catch
{
MessageBox.Show("An error occurred in doRefresh().");
}
conn.Close();
}
private void comboBoxCategory_SelectedIndexChanged(object sender, EventArgs e)
{
AllItems.Clear();
ListV.Clear();
listViewTypeV.Items.Clear();
conn.Open();
string query = "SELECT * FROM TYPE_V WHERE CATEGORY = " + "'" + comboBoxCategory.SelectedItem + "'";
try
{
using (SqlCommand command = new SqlCommand(query, conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TYPE_V type_v = new TYPE_V();
type_v.TYPE_ID = reader.GetInt32(0);
type_v.CATEGORY = reader.GetString(1);
type_v.DESCR = reader.GetString(2);
ListV.Add(type_v);
}
}
}
foreach (var item in ListV)
{
ListViewItem row = new ListViewItem(item.DESCR);
row.SubItems.Add(new ListViewItem.ListViewSubItem(row, item.CATEGORY));
row.SubItems.Add(new ListViewItem.ListViewSubItem(row, item.TYPE_ID.ToString()));
listViewTypeV.Items.Add(row);
}
AllItems = ListV;
}
catch
{
MessageBox.Show("An error occurred in comboBoxCategory_SelectedIndexChanged.");
}
conn.Close();
}
