private void SearchGridView(object sender, EventArgs e)
{
List <SFM.ListInterface> pList = null;
DataGridView dgv = null;
string search = "";
if (sender.Equals(btnSearchItems))
{
pList = pListItems;
dgv = dgvItems;
search = tbItemsSearch.Text;
}
else if (sender.Equals(btnBuffsSearch))
{
pList = pListBuffs;
dgv = dgvBuffs;
search = tbBuffsSearch.Text;
}
else if (sender.Equals(btnMonsterSearch))
{
pList = pListMonster;
dgv = dgvMonster;
search = tbMonsterSearch.Text;
}
else if (sender.Equals(btnPetsSearch))
{
pList = pListPets;
dgv = dgvPets;
search = tbPetsSearch.Text;
}
else if (sender.Equals(btnSkillsSearch))
{
pList = pListSkills;
dgv = dgvSkills;
search = tbSkillsSearch.Text;
}
var pSearch = pList.FindAll(i => i.Name.ToLower().Contains(search.ToLower()));
SFM.UpdateDataGridView(dgv, pSearch);
}
private void ResetGridView(object sender, EventArgs e)
{
if (sender.Equals(btnItemsResetList))
{
SFM.UpdateDataGridView(dgvItems, pListItems);
}
else if (sender.Equals(btnBuffsResetList))
{
SFM.UpdateDataGridView(dgvBuffs, pListBuffs);
}
else if (sender.Equals(btnMonsterResetList))
{
SFM.UpdateDataGridView(dgvMonster, pListMonster);
}
else if (sender.Equals(btnPetsResetList))
{
SFM.UpdateDataGridView(dgvPets, pListPets);
}
else if (sender.Equals(btnSkillsResetList))
{
SFM.UpdateDataGridView(dgvSkills, pListSkills);
}
return;
}
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();
}
