public List <GameProfileStatisticItem> GetList(List <Dictionary <string, object> > dictList) { data.Clear(); foreach (Dictionary <string, object> dict in dictList) { foreach (KeyValuePair <string, object> obj in dict) { GameProfileStatisticItem objectValue = (GameProfileStatisticItem)obj.Value; objectValue.FillFromDictionary(dict); data.Add(objectValue); } } return(data); }
public virtual bool SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(DEFAULT_SET_TYPE, obj); }
public virtual bool SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(SetType set_type, GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(ConvertSetTypeToString(set_type), obj); }
//------------------------------------------------------------------------------ public virtual bool SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(string set_type, GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(set_type, obj); }
public virtual bool SetGameProfileStatisticItemByUuid(GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByUuid(DEFAULT_SET_TYPE, obj); }
//------------------------------------------------------------------------------ public virtual bool SetGameProfileStatisticItemByUuid(string set_type, GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByUuid(set_type, obj); }
public virtual bool SetGameProfileStatisticItemByProfileIdByCode(SetType set_type, GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByProfileIdByCode(ConvertSetTypeToString(set_type), obj); }
//------------------------------------------------------------------------------ public virtual bool SetGameProfileStatisticItemByCodeByProfileIdByGameId(string set_type, GameProfileStatisticItem obj) { return act.SetGameProfileStatisticItemByCodeByProfileIdByGameId(set_type, obj); }
//------------------------------------------------------------------------------ public virtual bool SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(string set_type, GameProfileStatisticItem obj) { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@set_type", set_type)); parameters.Add(new SqlParameter("@status", obj.status)); parameters.Add(new SqlParameter("@username", obj.username)); parameters.Add(new SqlParameter("@code", obj.code)); parameters.Add(new SqlParameter("@stat_value_formatted", obj.stat_value_formatted)); parameters.Add(new SqlParameter("@profile_id", obj.profile_id)); parameters.Add(new SqlParameter("@active", obj.active)); parameters.Add(new SqlParameter("@game_id", obj.game_id)); parameters.Add(new SqlParameter("@data", obj.data)); parameters.Add(new SqlParameter("@stat_value", obj.stat_value)); parameters.Add(new SqlParameter("@uuid", obj.uuid)); parameters.Add(new SqlParameter("@date_modified", obj.date_modified)); parameters.Add(new SqlParameter("@level", obj.level)); parameters.Add(new SqlParameter("@points", obj.points)); parameters.Add(new SqlParameter("@timestamp", obj.timestamp)); parameters.Add(new SqlParameter("@date_created", obj.date_created)); parameters.Add(new SqlParameter("@type", obj.type)); try { return (bool)data.ExecuteScalar( BaseGamingData.connectionString , CommandType.StoredProcedure , "usp_game_profile_statistic_item_set_by_uuid_by_profile_id_by_game_id_by_timestamp" , parameters ); } catch (Exception e){ log.Error(e); return false; } }
//------------------------------------------------------------------------------ public virtual bool SetGameProfileStatisticItemByUuid(string set_type, GameProfileStatisticItem obj) { List<NpgsqlParameter> parameters = new List<NpgsqlParameter>(); parameters.Add(new NpgsqlParameter("in_set_type", set_type)); parameters.Add(new NpgsqlParameter("in_status", obj.status)); parameters.Add(new NpgsqlParameter("in_username", obj.username)); parameters.Add(new NpgsqlParameter("in_code", obj.code)); parameters.Add(new NpgsqlParameter("in_stat_value_formatted", obj.stat_value_formatted)); parameters.Add(new NpgsqlParameter("in_profile_id", obj.profile_id)); parameters.Add(new NpgsqlParameter("in_active", obj.active)); parameters.Add(new NpgsqlParameter("in_game_id", obj.game_id)); parameters.Add(new NpgsqlParameter("in_data", obj.data)); parameters.Add(new NpgsqlParameter("in_stat_value", obj.stat_value)); parameters.Add(new NpgsqlParameter("in_uuid", obj.uuid)); parameters.Add(new NpgsqlParameter("in_date_modified", obj.date_modified)); parameters.Add(new NpgsqlParameter("in_level", obj.level)); parameters.Add(new NpgsqlParameter("in_points", obj.points)); parameters.Add(new NpgsqlParameter("in_timestamp", obj.timestamp)); parameters.Add(new NpgsqlParameter("in_date_created", obj.date_created)); parameters.Add(new NpgsqlParameter("in_type", obj.type)); try { return Convert.ToBoolean(data.ExecuteScalar( BaseGamingData.connectionString , CommandType.StoredProcedure , "usp_game_profile_statistic_item_set_uuid" , parameters )); } catch (Exception e){ log.Error(e); return false; } }
public virtual GameProfileStatisticItem FillGameProfileStatisticItem(DataRow dr) { GameProfileStatisticItem obj = new GameProfileStatisticItem(); if (dr["status"] != null) obj.status = dataType.FillDataString(dr, "status"); if (dr["username"] != null) obj.username = dataType.FillDataString(dr, "username"); if (dr["code"] != null) obj.code = dataType.FillDataString(dr, "code"); if (dr["stat_value_formatted"] != null) obj.stat_value_formatted = dataType.FillDataString(dr, "stat_value_formatted"); if (dr["profile_id"] != null) obj.profile_id = dataType.FillDataString(dr, "profile_id"); if (dr["active"] != null) obj.active = dataType.FillDataBool(dr, "active"); if (dr["game_id"] != null) obj.game_id = dataType.FillDataString(dr, "game_id"); if (dr["data"] != null) obj.data = dataType.FillDataString(dr, "data"); if (dr["stat_value"] != null) obj.stat_value = dataType.FillDataFloat(dr, "stat_value"); if (dr["uuid"] != null) obj.uuid = dataType.FillDataString(dr, "uuid"); if (dr["date_modified"] != null) obj.date_modified = dataType.FillDataDateTime(dr, "date_modified"); if (dr["level"] != null) obj.level = dataType.FillDataString(dr, "level"); if (dr["points"] != null) obj.points = dataType.FillDataFloat(dr, "points"); if (dr["timestamp"] != null) obj.timestamp = dataType.FillDataFloat(dr, "timestamp"); if (dr["date_created"] != null) obj.date_created = dataType.FillDataDateTime(dr, "date_created"); if (dr["type"] != null) obj.type = dataType.FillDataString(dr, "type"); return obj; }
public virtual bool SetGameProfileStatisticItemByProfileIdByCodeByTimestamp(string set_type, GameProfileStatisticItem obj) { return data.SetGameProfileStatisticItemByProfileIdByCodeByTimestamp(set_type, obj); }
//------------------------------------------------------------------------------ public virtual void SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp() { ResponseGameProfileStatisticItemBool wrapper = new ResponseGameProfileStatisticItemBool(); wrapper.message = "Success"; wrapper.code = 0; wrapper.action = "game-profile-statistic-item/set/by-uuid/by-profile-id/by-game-id/by-timestamp"; GameProfileStatisticItem obj = new GameProfileStatisticItem(); string _status = util.GetParamValue(_context, "status"); if(!String.IsNullOrEmpty(_status)) obj.status = (string)_status; string _username = util.GetParamValue(_context, "username"); if(!String.IsNullOrEmpty(_username)) obj.username = (string)_username; string _code = util.GetParamValue(_context, "code"); if(!String.IsNullOrEmpty(_code)) obj.code = (string)_code; string _stat_value_formatted = util.GetParamValue(_context, "stat_value_formatted"); if(!String.IsNullOrEmpty(_stat_value_formatted)) obj.stat_value_formatted = (string)_stat_value_formatted; string _profile_id = util.GetParamValue(_context, "profile_id"); if(!String.IsNullOrEmpty(_profile_id)) obj.profile_id = (string)_profile_id; string _active = util.GetParamValue(_context, "active"); if(!String.IsNullOrEmpty(_active)) obj.active = Convert.ToBoolean(_active); string _game_id = util.GetParamValue(_context, "game_id"); if(!String.IsNullOrEmpty(_game_id)) obj.game_id = (string)_game_id; string _data = util.GetParamValue(_context, "data"); if(!String.IsNullOrEmpty(_data)) obj.data = (string)_data; string _stat_value = util.GetParamValue(_context, "stat_value"); if(!String.IsNullOrEmpty(_stat_value)) obj.stat_value = float.Parse(_stat_value); string _uuid = util.GetParamValue(_context, "uuid"); if(!String.IsNullOrEmpty(_uuid)) obj.uuid = (string)_uuid; string _date_modified = util.GetParamValue(_context, "date_modified"); if(!String.IsNullOrEmpty(_date_modified)) obj.date_modified = Convert.ToDateTime(_date_modified); else obj.date_modified = DateTime.Now; string _level = util.GetParamValue(_context, "level"); if(!String.IsNullOrEmpty(_level)) obj.level = (string)_level; string _points = util.GetParamValue(_context, "points"); if(!String.IsNullOrEmpty(_points)) obj.points = float.Parse(_points); string _timestamp = util.GetParamValue(_context, "timestamp"); if(!String.IsNullOrEmpty(_timestamp)) obj.timestamp = float.Parse(_timestamp); string _date_created = util.GetParamValue(_context, "date_created"); if(!String.IsNullOrEmpty(_date_created)) obj.date_created = Convert.ToDateTime(_date_created); else obj.date_created = DateTime.Now; string _type = util.GetParamValue(_context, "type"); if(!String.IsNullOrEmpty(_type)) obj.type = (string)_type; // get data wrapper.data = api.SetGameProfileStatisticItemByUuidByProfileIdByGameIdByTimestamp(obj); util.SerializeTypeJSONToResponse(_context, wrapper); }