private void charactersToolStripMenuItem_Click(object sender, EventArgs e) { List <Character> toons = new List <Character>(); FrmNewCharacters frmX = new FrmNewCharacters(toons, GetStatusType(), GetMains()); }
private void buttonImportRaidDump_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; List <Character> List1 = GetRaidDumpFile(out DateTime dumptime); List <Character> List2 = GetCharsFromDB(); IEnumerable <Character> query = from a in List1 join b in List2 on a.Name equals b.Name into c from x in c.DefaultIfEmpty() where x == null select a; List <Character> newChar = query.ToList <Character>(); newChar = newChar.OrderBy(o => o.Name).ToList(); if (newChar.Count > 0) { FrmNewCharacters frmX = new FrmNewCharacters(newChar, GetStatusType(), GetMains()); Cursor.Current = Cursors.Default; if (frmX.ShowDialog() == DialogResult.OK) { AddNewPlayers(frmX.GetList()); } frmX.Dispose(); List2.Clear(); List2 = GetCharsFromDB(); } IEnumerable <Character> query2 = from a in List2 join b in List1 on a.Name equals b.Name select a; List <Character> players = query2.ToList <Character>(); int sched = 0; if (checkBoxAttendence.Checked == true) { sched = CreateScheduleEntry(dumptime); if (sched == 0) { MessageBox.Show("An error occurred while trying to create a Schedule entry.\nPlease Try Again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (sched < 0) { DialogResult = MessageBox.Show("You are using a dump file that has already been used for attendance.\nA Dump file for attendance can only be used once.\nPlease Try Again.", "Error - Duplicate File", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } foreach (Character c in players) { if (c.StatusName == "Guest") { continue; } SqlCommand cmd = new SqlCommand("usp_AddNewAttendance", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", c.Name); cmd.Parameters.AddWithValue("@SchedID", sched); cmd.ExecuteNonQuery(); cmd.Dispose(); } } LoadDKP(players, (Int16)DKPAward.Value, sched, checkBoxAttendence.Checked); // upload raid dump file for storage Cursor.Current = Cursors.Default; }