private void btnGenerateList_Click(object sender, EventArgs e)
{
if (cbSelectedList.Text == string.Empty)
{
return;
}
try {
using (SqlConnection sqlCon = GenerateSqlConnection()) {
sqlCon.Open();
SqlCommand cmd = new SqlCommand(GetSqlQuery(cbSelectedList.Text), sqlCon);
SqlDataReader dr = cmd.ExecuteReader();
List <SFM.ListInterface> pNewList = new List <SFM.ListInterface>();
while (dr.Read())
{
string[] val = { dr["id"].ToString(), dr["value"].ToString() };
SFM.ListInterface pInterface = new SFM.ListInterface(val);
pNewList.Add(pInterface);
}
sqlCon.Close();
switch (cbSelectedList.Text)
{
case "Itemlist":
wndGlobalUI.pListItems = pNewList;
SFM.SafeFile(pNewList, "items.txt");
SFM.UpdateDataGridView(wndGlobalUI.dgvItems, pNewList);
break;
case "BuffList":
wndGlobalUI.pListBuffs = pNewList;
SFM.SafeFile(pNewList, "buffs.txt");
SFM.UpdateDataGridView(wndGlobalUI.dgvBuffs, pNewList);
break;
case "Monsterlist":
wndGlobalUI.pListMonster = pNewList;
SFM.SafeFile(pNewList, "monster.txt");
SFM.UpdateDataGridView(wndGlobalUI.dgvMonster, pNewList);
break;
case "Petlist":
wndGlobalUI.pListPets = pNewList;
SFM.SafeFile(pNewList, "pets.txt");
SFM.UpdateDataGridView(wndGlobalUI.dgvPets, pNewList);
break;
case "Skilllist":
wndGlobalUI.pListSkills = pNewList;
SFM.SafeFile(pNewList, "skills.txt");
SFM.UpdateDataGridView(wndGlobalUI.dgvSkills, pNewList);
break;
default:
break;
}
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Properties.Settings.Default.dbAddress = tbDbAddress.Text;
Properties.Settings.Default.dbDatabase = tbDbDatabase.Text;
Properties.Settings.Default.dbUsername = tbDbUsername.Text;
if (cbSavePassword.Checked)
{
Properties.Settings.Default.dbPassword = tbDbPassword.Text;
}
Properties.Settings.Default.Save();
this.Close();
}
