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 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 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 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()"); }