public List <EventPlayerInfo> GetAllEventPlayerInfoByID(int eventID)
{
using (conn = new MySqlConnection(DB.GetConnString()))
{
string selectQuery = string.Format("SELECT * FROM event_player_info WHERE eventID={0}", eventID);
MySqlCommand selectCmd = new MySqlCommand(selectQuery, conn);
conn.Open();
List <EventPlayerInfo> eventPlayerInfos = new List <EventPlayerInfo>();
using (MySqlDataReader reader = selectCmd.ExecuteReader())
{
while (reader.Read())
{
EventPlayerInfo eventPlayer = new EventPlayerInfo();
eventPlayer.EventID = reader.GetInt32("eventID");
eventPlayer.HashedUserID = reader.GetString("hashedUserID");
eventPlayer.RoleID = reader.GetInt32("roleID");
eventPlayer.StatusCode = reader.GetInt32("status_code");
eventPlayer.Claim = reader.GetString("claim");
eventPlayerInfos.Add(eventPlayer);
}
reader.Close();
}
return(eventPlayerInfos);
}
}
public EventInfo CreateEvent(EventInfo eventObj)
{
try
{
EventPlayerInfo eventPlayer = new EventPlayerInfo();
//TODO: change to systemID to hash id
//eventPlayer.hashedUserID = databaseQuery.GetHashedUserID(Int32.Parse(eventObj.Host));
_eventDataAccess.InsertEvent(eventObj);
eventObj.EventID = _eventDataAccess.GetLatestID();
eventPlayer.EventID = eventObj.EventID;
eventPlayer.HashedUserID = eventObj.Host;
eventPlayer.RoleID = 0;
eventPlayer.Claim = "";
_eventDataAccess.InsertEventPlayer(eventPlayer);
_loggingManager.Log("Event Creation", "");
return(eventObj);
} catch (Exception e)
{
_loggingManager.Log("Event Creation", "Data Store Error");
throw e;
}
}
public object AddGamerToEvent(int eventID, string hashedUserID)
{
EventPlayerInfo eventPlayer = new EventPlayerInfo();
eventPlayer.EventID = eventID;
eventPlayer.HashedUserID = hashedUserID;
eventPlayer.RoleID = 1;
eventPlayer.Claim = "";
return(_eventDataAccess.AddGamerToEvent(eventPlayer));
}
public void InsertEventPlayer(EventPlayerInfo eventPlayer)
{
var DB = new Database();
using (MySqlConnection conn = new MySqlConnection(DB.GetConnString()))
{
using (MySqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "INSERT INTO event_player_info(eventID, hasheduserID, roleID, claim) VALUES(@eventID, @hasheduserID, @roleID, @claim)";
comm.Parameters.AddWithValue("@eventID", eventPlayer.EventID);
comm.Parameters.AddWithValue("@hashedUserID", eventPlayer.HashedUserID);
comm.Parameters.AddWithValue("@roleID", eventPlayer.RoleID);
comm.Parameters.AddWithValue("@claim", eventPlayer.Claim);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
}
}
public EventPlayerInfo GetEventPlayerInfo(int eventID, int userID)
{
using (conn = new MySqlConnection(DB.GetConnString()))
{
string selectQuery = string.Format("SELECT * FROM event_player_info WHERE eventID={0} and hashedUserID={1}", eventID, userID);
MySqlCommand selectCmd = new MySqlCommand(selectQuery, conn);
conn.Open();
EventPlayerInfo eventObj = new EventPlayerInfo();
using (MySqlDataReader reader = selectCmd.ExecuteReader())
{
reader.Read();
eventObj.EventID = reader.GetInt32("eventID");
eventObj.HashedUserID = reader.GetString("hashedUserID");
eventObj.RoleID = reader.GetInt32("roleID");
eventObj.Claim = reader.GetString("claim");
eventObj.StatusCode = reader.GetInt32("status_code");
eventObj.reason = reader.GetString("reason");
reader.Close();
}
return(eventObj);
}
}
public object AddGamerToEvent(EventPlayerInfo eventPlayer)
{
databaseQuery.InsertEventPlayer(eventPlayer);
return(eventPlayer);
}
public EventPlayerInfo InsertEventPlayer(EventPlayerInfo eventPlayer)
{
databaseQuery.InsertEventPlayer(eventPlayer);
return(eventPlayer);
}
