public void ShowLoot()
{
debugLogger.WriteDebug_3("Begin Method: Raid.ShowLoot()");
DataRow[] loot = dbRaid.Select("(PTS<0)");
DataTable newTable = rowsToTable(dbRaid,loot);
TableViewer table = new TableViewer(owner,newTable,new TableViewer.UpdateDel(UpdateLoot));
table.Show();
debugLogger.WriteDebug_3("End Method: Raid.ShowLoot()");
}
public void ShowAttendees()
{
debugLogger.WriteDebug_3("Begin Method: Raid.ShowAttendees()");
DataRow[] attendees = dbRaid.Select("(PTS>=0)");
DataTable newTable = rowsToTable(dbRaid,attendees);
TableViewer table = new TableViewer(owner,newTable,new TableViewer.UpdateDel(UpdateAttendees));
table.Show();
debugLogger.WriteDebug_3("End Method: Raid.ShowAttendees()");
}
private void mnuUnretire_Click(object sender, System.EventArgs e)
{
debugLogger.WriteDebug_3("Begin Method: frmMain.mnuUnretire_Click(object,EventArgs) (" + sender.ToString() + "," + e.ToString() + ")");
InputBoxDialog input = new InputBoxDialog();
input.FormPrompt = "Who do you want to unretire? ";
input.FormCaption = "Unretire Query";
input.ShowDialog();
string person = input.InputResponse;
input.Close();
TableViewer table = new TableViewer(this,TableViewer.DKPUPDATE,"UPDATE DKS SET DKS.Name = \"" + person + "\",DKS.Comment = \" \" WHERE (((DKS.Name)=\"zzzDKP Retired\" AND (DKS.Comment=\"" + person + "\")))",false);
StatusMessage = "Performing UPDATE query...";
debugLogger.WriteDebug_3("End Method: frmMain.mnuUnretire_Click()");
}
private void mnuNamesTiers_Click(object sender, System.EventArgs e)
{
debugLogger.WriteDebug_3("Begin Method: frmMain.mnuNamesTiers_Click(object,EventArgs) (" + sender.ToString() + "," + e.ToString() + ")");
TableViewer table = new TableViewer(this,TableViewer.DKPSELECT,"SELECT * FROM NamesTiers ORDER BY Name ASC",false);
table.Show();
StatusMessage = "Performing SELECT query...";
debugLogger.WriteDebug_3("End Method: frmMain.mnuNamesTiers_Click()");
}
private void mnuEnterSQL_Click(object sender, System.EventArgs e)
{
debugLogger.WriteDebug_3("Begin Method: frmMain.mnuEnterSQL_Click(object,EventArgs) (" + sender.ToString() + "," + e.ToString() + ")");
InputBoxDialog input = new InputBoxDialog();
input.FormPrompt = "Enter Query: ";
input.FormCaption = "SQL Query";
input.ShowDialog();
string query = input.InputResponse;
input.Close();
debugLogger.WriteDebug_3("InputBox.InputResponse returns " + query);
if (query.StartsWith("SELECT"))
{
debugLogger.WriteDebug_2("SELECT query entered");
TableViewer table = new TableViewer(this,TableViewer.DKPSELECT,query,true);
table.Show();
StatusMessage = "Performing SELECT query...";
}
else if (query.StartsWith("UPDATE")||query.StartsWith("DELETE")||query.StartsWith("INSERT"))
{
debugLogger.WriteDebug_2("UPDATE, DELETE, or INSERT query entered");
TableViewer table = new TableViewer(this,TableViewer.DKPUPDATE,query,false);
StatusMessage = "Performing UPDATE query...";
}
else
{
debugLogger.WriteDebug_2("Invalid query entered");
MessageBox.Show("Invalid SQL Query","Error");
}
debugLogger.WriteDebug_3("End Method: frmMain.mnuEnterSQLQuery_Click()");
}
private void mnuBalanceQuery_Click(object sender, System.EventArgs e)
{
debugLogger.WriteDebug_3("Begin Method: frmMain.mnuBalanceQuery_Click(object,EventArgs) (" + sender.ToString() + "," + e.ToString() + ")");
TableViewer table = new TableViewer(this,TableViewer.DKPSELECT,"SELECT Sum(DKS.PTS) AS DKPBalance, ActiveRaiders, (DKPBalance/ActiveRaiders) AS AVGBalance FROM DKS, qActiveRaiders WHERE (((DKS.Name)<>\"zzzDKP Retired\")) GROUP BY ActiveRaiders",true);
table.Show();
StatusMessage = "Performing SELECT query...";
debugLogger.WriteDebug_3("End Method: frmMain.mnuBalanceQuery_Click()");
}
