public bool GetRaidMembers(UniqueRaidID _UniqueRaidID, out List <string> _ResultRaidMembers)
{
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT uniqueraidid, playername FROM raidmemberstable WHERE uniqueraidid=:UniqueRaidID", conn))
{
{
var URIDParam = new NpgsqlParameter("UniqueRaidID", NpgsqlDbType.Integer);
URIDParam.Value = (int)_UniqueRaidID.ID;
cmd.Parameters.Add(URIDParam);
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true)
{
_ResultRaidMembers = new List <string>();
do
{
_ResultRaidMembers.Add(reader.GetString(1));
} while (reader.Read() == true);
return(true);
}
}
}
}
finally
{
CloseConnection();
}
_ResultRaidMembers = null;
return(false);
}
public bool GetFightEntries(UniqueRaidID _UniqueRaidID, out List <FightEntry> _ResultFightEntries)
{
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT id, uniqueraidid, fightname, fightstartdate, fightenddate, attempttype FROM fightentrytable WHERE uniqueraidid=:UniqueRaidID", conn))
{
{
var URIDParam = new NpgsqlParameter("UniqueRaidID", NpgsqlDbType.Integer);
URIDParam.Value = (int)_UniqueRaidID.ID;
cmd.Parameters.Add(URIDParam);
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true)
{
_ResultFightEntries = new List <FightEntry>();
do
{
FightEntry fightEntry = new FightEntry();
fightEntry.m_UniqueFightID = new UniqueFightID(reader.GetInt32(0));
fightEntry.m_UniqueRaidID = new UniqueRaidID(reader.GetInt32(1));
fightEntry.m_FightName = reader.GetString(2);
fightEntry.m_FightStartDate = reader.GetTimeStamp(3).DateTime;
fightEntry.m_FightEndDate = reader.GetTimeStamp(4).DateTime;
fightEntry.m_AttemptType = (SQLAttemptType)reader.GetInt16(5);
_ResultFightEntries.Add(fightEntry);
} while (reader.Read() == true);
return(true);
}
}
}
}
finally
{
CloseConnection();
}
_ResultFightEntries = null;
return(false);
}
public bool GetRaidEntry(UniqueRaidID _UniqueRaidID, out RaidEntry _ResultRaid)
{
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT uniqueraidid, ingameraidid, raidresetdate, raidinstance, raidstartdate, raidenddate, raidownername, realm FROM raidentrytable WHERE uniqueraidid=:UniqueRaidID", conn))
{
{
var URIDParam = new NpgsqlParameter("UniqueRaidID", NpgsqlDbType.Integer);
URIDParam.Value = (int)_UniqueRaidID.ID;
cmd.Parameters.Add(URIDParam);
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true)
{
_ResultRaid = new RaidEntry();
_ResultRaid.m_UniqueRaidID = new UniqueRaidID(reader.GetInt32(0));
_ResultRaid.m_IngameRaidID = reader.GetInt32(1);
_ResultRaid.m_RaidResetDate = reader.GetTimeStamp(2).DateTime;
_ResultRaid.m_RaidInstance = reader.GetString(3);
_ResultRaid.m_RaidStartDate = reader.GetTimeStamp(4).DateTime;
_ResultRaid.m_RaidEndDate = reader.GetTimeStamp(5).DateTime;
_ResultRaid.m_RaidOwnerName = reader.GetString(6);
_ResultRaid.m_Realm = (WowRealm)reader.GetInt32(7);
return(true);
}
}
}
}
finally
{
CloseConnection();
}
_ResultRaid = null;
return(false);
}
