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