void SetValue(QueryValues which, object obj) { switch (which) { // key case QueryValues.CorpID: m_DataObject.CorpID = DBConvert.ToLong(obj); return; case QueryValues.MedalID: m_DataObject.MedalID = DBConvert.ToLong(obj); return; // data case QueryValues.title: m_DataObject.title = DBConvert.ToString(obj); return; case QueryValues.description: m_DataObject.description = DBConvert.ToString(obj); return; case QueryValues.creatorID: m_DataObject.creatorID = DBConvert.ToLong(obj); return; case QueryValues.created: m_DataObject.created = DBConvert.ToDateTime(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
public AuthenticationResult GetAuthenticationResult(Uri responseUri, OAuthRequestCode request) { QueryValues queryValues; AuthenticationResult result; if (request is OAuthRequestAuthorizationCode auth) { queryValues = QueryValues.Parse(StringUtils.RemovePrefix(responseUri.Query, "?")); this.EnsureStateEquals(queryValues, request); var accessTokenRequest = new OAuthTokenRequest(); accessTokenRequest.ClientSecret = auth.ClientSecret; accessTokenRequest.Code = queryValues.Single("code"); accessTokenRequest.GrantType = "authorization_code"; accessTokenRequest.RedirectUri = auth.RedirectUri; result = this.GetAuthenticationResult(accessTokenRequest); } else if (request is OAuthRequestTokenCode) { queryValues = QueryValues.Parse(HttpUtility.UrlDecode(StringUtils.RemovePrefix(responseUri.Fragment, "#"))); this.EnsureStateEquals(queryValues, request); result = new AuthenticationResult(queryValues); } else { throw new ArgumentException("Invalid OAuthRequest Type", nameof(request)); } return(result); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.Id: m_DataObject.ID = DBConvert.ToLong(obj); return; case QueryValues.UserID: m_DataObject.UserID = DBConvert.ToString(obj); return; case QueryValues.url: m_DataObject.url = DBConvert.ToString(obj); return; case QueryValues.ValidUntil: m_DataObject.ValidUntil = DBConvert.ToDateTime(obj); return; case QueryValues.Response: m_DataObject.Response = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { // key case QueryValues.Key_ID: m_DataObject.Key_ID = DBConvert.ToLong(obj); return; // data case QueryValues.KillID: m_DataObject.KillID = DBConvert.ToLong(obj); return; case QueryValues.flag: m_DataObject.flag = DBConvert.ToLong(obj); return; case QueryValues.qtyDropped: m_DataObject.qtyDropped = DBConvert.ToLong(obj); return; case QueryValues.qtyDestroyed: m_DataObject.qtyDestroyed = DBConvert.ToLong(obj); return; case QueryValues.typeID: m_DataObject.typeID = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
public void OnAttemptToRegister() { if (validateUsername(usernameText) && validatePassword(passwordText) && validateEmail(emailText)) { string username = usernameText; QueryValues qv = Database.Instance.GenerateQueryValues("RegisterUser", new Dictionary <string, string> { { "username", usernameText }, { "password", passwordText }, { "email", emailText } }); Database.Instance.QueryDatabase(qv, delegate(string Value) { //Debug.Log(Value); GeneralReturn generalReturn = JsonUtility.FromJson <GeneralReturn>(Value); if (generalReturn.Result) { PlayerInformation.Instance.PlayerName = generalReturn.Details; onCheckAdminStatus(); } else { //If Fail present fail message given by server errorText.DOKill(); errorText.color = errorText.color.SetAlpha(1); errorText.text = "Error: " + generalReturn.Details; errorText.DOFade(0, 0.5f).SetDelay(5).SetEase(Ease.InOutSine).OnComplete(() => { errorText.text = ""; }); } }); } }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.Key_ID: m_DataObject.Key_ID = DBConvert.ToLong(obj); return; case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.typeID: m_DataObject.typeID = DBConvert.ToLong(obj); return; case QueryValues.skillpoints: m_DataObject.skillpoints = DBConvert.ToLong(obj); return; case QueryValues.level: m_DataObject.level = DBConvert.ToLong(obj); return; case QueryValues.unpublished: m_DataObject.unpublished = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch ((QueryValues)which) { case QueryValues.Key_ID: m_DataObject.Key_ID = DBConvert.ToLong(obj); return; case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.standingType: m_DataObject.standingType = DBConvert.ToLong(obj); return; case QueryValues.ID: m_DataObject.ID = DBConvert.ToLong(obj); return; case QueryValues.Name: m_DataObject.Name = DBConvert.ToString(obj); return; case QueryValues.standing: m_DataObject.standing = DBConvert.ToDecimal(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.Key_ID: m_DataObject.Key_ID = DBConvert.ToLong(obj); return; case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.RoleType: m_DataObject.RoleType = DBConvert.ToLong(obj); return; case QueryValues.RoleID: m_DataObject.RoleID = DBConvert.ToLong(obj); return; case QueryValues.RoleName: m_DataObject.RoleName = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
public AuthenticationResult(QueryValues values) { this.AccessToken = values.Single("access_token"); this.RefreshToken = values.Single("refresh_token"); this.ExpiresIn = NumberUtils.ToInt(values.Single("expires_in")); this.Scopes = values.Single("scope").Split(OAuthRequest.ScopeSeparater, StringSplitOptions.RemoveEmptyEntries); this.TokenType = values.Single("token_type"); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.date: m_DataObject.date = DBConvert.ToDateTime(obj); return; case QueryValues.refID: m_DataObject.refID = DBConvert.ToLong(obj); return; case QueryValues.refTypeID: m_DataObject.refTypeID = DBConvert.ToLong(obj); return; case QueryValues.ownerName1: m_DataObject.ownerName1 = DBConvert.ToString(obj); return; case QueryValues.ownerID1: m_DataObject.ownerID1 = DBConvert.ToLong(obj); return; case QueryValues.ownerName2: m_DataObject.ownerName2 = DBConvert.ToString(obj); return; case QueryValues.ownerID2: m_DataObject.ownerID2 = DBConvert.ToLong(obj); return; case QueryValues.argName1: m_DataObject.argName1 = DBConvert.ToString(obj); return; case QueryValues.argID: m_DataObject.argID = DBConvert.ToLong(obj); return; case QueryValues.amount: m_DataObject.amount = DBConvert.ToDecimal(obj); return; case QueryValues.balance: m_DataObject.balance = DBConvert.ToDecimal(obj); return; case QueryValues.reason: m_DataObject.reason = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.date: m_DataObject.date = DBConvert.ToDateTime(obj); return; case QueryValues.transID: m_DataObject.transID = DBConvert.ToLong(obj); return; case QueryValues.quantity: m_DataObject.quantity = DBConvert.ToLong(obj); return; case QueryValues.typeName: m_DataObject.typeName = DBConvert.ToString(obj); return; case QueryValues.typeID: m_DataObject.typeID = DBConvert.ToLong(obj); return; case QueryValues.price: m_DataObject.price = DBConvert.ToDecimal(obj); return; case QueryValues.clientID: m_DataObject.clientID = DBConvert.ToLong(obj); return; case QueryValues.clientName: m_DataObject.clientName = DBConvert.ToString(obj); return; case QueryValues.stationID: m_DataObject.stationID = DBConvert.ToLong(obj); return; case QueryValues.stationName: m_DataObject.stationName = DBConvert.ToString(obj); return; case QueryValues.transactionType: m_DataObject.transactionType = DBConvert.ToString(obj); return; case QueryValues.transactionFor: m_DataObject.transactionFor = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
public PostgreQueryCompiler(DocumentOption option, DocumentQuery query) { ValueBy = new QueryValues(); Option = option; Query = query; TypeOf = query.TypeOf; Take = query.Take; Skip = query.Skip; }
/** * @Kyle van Raaij * This method will run the given query with the given parameter values. * The values will be put in a grid class and given back to the caller. * * @_values query and parameters * @_parameterValues the values that are put in the given parameters * @return grid with the data of the returnvalue of the given databasequery **/ public Grid GetGridByQuery(QueryValues _values, List <ParameterValue> _parameterValues) { Grid grid = new Grid(); FbConnection connection = dbconn.GetFbConnection(); try { FbCommand command = new FbCommand(_values.Query, connection); command.CommandType = CommandType.Text; foreach (string parameter in _values.Parameteres) { if (_values.Query.Contains("@" + parameter)) { foreach (ParameterValue pValue in _parameterValues) { if (pValue.ParameterName == parameter) { command.Parameters.Add("@" + parameter, pValue.Value); } } } } connection.Open(); FbDataReader reader = command.ExecuteReader(); int fieldCount = reader.FieldCount; if (reader.HasRows) { while (reader.Read()) { Row row = new Row(); for (int i = 0; i < fieldCount; i++) { row.Values.Add(reader.GetString(i)); } grid.Rows.Add(row); } } grid.RowCount = fieldCount; connection.Close(); return(grid); } catch (FbException ex) { Console.WriteLine(ex); connection.Close(); return(null); } }
public IActionResult Index(long page, string order, bool desc, string id, string companyName, string region) { var values = new QueryValues { { nameof(id), id }, { nameof(companyName), companyName }, { nameof(region), region }, }; var result = _customerService.Find(new Pager(page), values, order, desc); var data = result.Data; var mappedResult = _mapper.Map <IEnumerable <CustomerPartialViewModel> >(data); var viewModel = new IndexViewModel <CustomerPartialViewModel>( mappedResult, new Pager(page, result.TotalItems), values, order, desc); return(View(viewModel)); }
public void Query2_Stringify() { var runner = RunnerFactory.Create(); var parameters = new QueryValues { Value1 = 5, Value2 = 3.14f, Value3 = "TEST" }; var query = new Query(parameters); var result = runner.ObjectStringifier.Stringify(query); result.Should().NotBeNullOrEmpty(); }
public void ParameterObject_Test() { var runner = RunnerFactory.Create(); var parameters = new QueryValues { Value1 = 5, Value2 = 3.14f, Value3 = "TEST" }; var result = runner.Query(new Query(parameters)); result.Value1.Should().Be(5); result.Value2.Should().Be(3.14f); result.Value3.Should().Be("TEST"); }
void SetValue(QueryValues which, object obj) { switch (which) { // key case QueryValues.TableName: m_DataObject.TableName = DBConvert.ToString(obj); return; // data case QueryValues.VersionNumber: m_DataObject.VersionNumber = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
public void EnsureStateEquals(QueryValues queryValues, OAuthRequestCode request) { var requested = request.State; if (requested == null) { return; } var responsed = queryValues.Single("state"); if (requested.Equals(responsed) == false) { throw new TwitchException($"OAuth state mismatched - Request:{requested} vs Response:{responsed})"); } }
/** * @Kyle van Raaij * Gets a query out of the database table with as name _gridName. * All the parameters connected to the database table _gridName will be acquired as well. * * @_gridName the name of the grid that is stored in the database * @return the query used to get all gridvalues **/ public QueryValues GetGridQuery(string _gridName) { FbConnection conn = dbconn.GetFbConnection(); try { FbCommand cmd = new FbCommand("CCDA_GRIDQUERY", conn); //FbCommand cmd2 = new FbCommand("SELECT P.CCDA_P_NAME, p.CCDA_P_ID FROM CCDA_GRID G LEFT JOIN CCDA_PARAMETER P ON G.CCDA_G_NAME = P.CCDA_P_PARENTNAME", conn); FbCommand cmd2 = new FbCommand("SELECT CCDA_P_NAME, CCDA_P_ID FROM CCDA_PARAMETER WHERE CCDA_P_PARENTNAME = @GRID_NAME", conn); cmd2.CommandType = CommandType.Text; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@GRID_NAME", _gridName); cmd2.Parameters.Add("@GRID_NAME", _gridName); conn.Open(); string query = (string)cmd.ExecuteScalar(); FbDataReader reader = cmd2.ExecuteReader(); QueryValues qValues = new QueryValues(); qValues.Query = query; List <string> values = new List <string>(); if (reader.HasRows) { while (reader.Read()) { values.Add(reader.GetString(0)); } } conn.Close(); qValues.Parameteres = values; return(qValues); } catch (FbException ex) { Console.WriteLine(ex); conn.Close(); return(null); } catch (NullReferenceException ex) { Console.WriteLine(ex); conn.Close(); return(null); } }
public WebRequestParameter CreateWebRequest(TwitchAPIRequest apiRequest) { var baseUri = this.GetBaseUri(apiRequest.BaseUrl, apiRequest.Version, apiRequest.Path); var queryValues = new QueryValues(); queryValues.AddRange(QueryValues.Parse(baseUri.Query)); queryValues.AddRange(apiRequest.QueryValues); var request = new WebRequestParameter(); request.RetryCount = 0; request.Uri = $"{baseUri.Scheme}{Uri.SchemeDelimiter}{baseUri.Host}{baseUri.LocalPath}{queryValues.ToString(false)}"; request.Method = apiRequest.Method; request.WriteParameter = apiRequest.PostData; request.ContentType = apiRequest.ContentType ?? request.ContentType; this.SetupRequest(request, apiRequest.Version); return(request); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.Key_ID: m_DataObject.Key_ID = DBConvert.ToLong(obj); return; case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.queuePosition: m_DataObject.queuePosition = DBConvert.ToLong(obj); return; case QueryValues.typeID: m_DataObject.typeID = DBConvert.ToLong(obj); return; case QueryValues.startSP: m_DataObject.startSP = DBConvert.ToLong(obj); return; case QueryValues.endSP: m_DataObject.endSP = DBConvert.ToLong(obj); return; case QueryValues.startTime: m_DataObject.startTime = DBConvert.ToDateTime(obj); return; case QueryValues.endTime: m_DataObject.endTime = DBConvert.ToDateTime(obj); return; case QueryValues.level: m_DataObject.level = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch ((QueryValues)which) { case QueryValues.Key_ID: m_DataObject.Key_ID = DBConvert.ToLong(obj); return; case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.ItemID: m_DataObject.ItemID = DBConvert.ToLong(obj); return; case QueryValues.ItemParentID: m_DataObject.ItemParentID = DBConvert.ToLong(obj); return; case QueryValues.locationID: m_DataObject.locationID = DBConvert.ToLong(obj); return; case QueryValues.typeID: m_DataObject.typeID = DBConvert.ToLong(obj); return; case QueryValues.quantity: m_DataObject.quantity = DBConvert.ToLong(obj); return; case QueryValues.flag: m_DataObject.flag = DBConvert.ToLong(obj); return; case QueryValues.singleton: m_DataObject.singleton = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch ((QueryValues)which) { case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.MedalID: m_DataObject.MedalID = DBConvert.ToLong(obj); return; case QueryValues.issuerID: m_DataObject.issuerID = DBConvert.ToLong(obj); return; case QueryValues.corporationID: m_DataObject.corporationID = DBConvert.ToLong(obj); return; case QueryValues.issued: m_DataObject.issued = DBConvert.ToDateTime(obj); return; case QueryValues.reason: m_DataObject.reason = DBConvert.ToString(obj); return; case QueryValues.status: m_DataObject.status = DBConvert.ToString(obj); return; case QueryValues.title: m_DataObject.title = DBConvert.ToString(obj); return; case QueryValues.description: m_DataObject.description = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { // key case QueryValues.CorpID: m_DataObject.CorpID = DBConvert.ToLong(obj); return; case QueryValues.AccountKey: m_DataObject.AccountKey = DBConvert.ToLong(obj); return; // data case QueryValues.description: m_DataObject.description = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
private void onCheckAdminStatus() { QueryValues qv = Database.Instance.GenerateQueryValues("CheckAdminStatus", new Dictionary <string, string> { { "username", usernameText }, { "password", passwordText } }); Database.Instance.QueryDatabase(qv, delegate(string Value) { //Debug.Log(Value); GeneralReturn generalReturn = JsonUtility.FromJson <GeneralReturn>(Value); if (generalReturn.Result) { PlayerInformation.Instance.IsAdmin = true; } //Load after our login/register and admin check LoaderManager.Instance.LoadLevel(SceneList.MAIN_MENU_SCREEN, delegate(string E) { LoaderManager.Instance.UnLoadLevel(SceneList.LOGIN); //Unload after new level is in }); }); }
/** * @Kyle van Raaij * information will be acquired out of the database based of what _gridName is given. * the userid parameter will always be made with the name "MID". three other parameter * can be added if needed. parameter values need to be given with the value and parametername. * for example: parameter1 = "2017,YEAR". * * * @_gridName the name of the grid that needs to be looked up. * @_userId the id the user uses to log in. * @_parameter1 optional string parameter for query's with different parameters needed than _userID * @_parameter2 optional string parameter for query's with different parameters needed than _userID * @_parameter3 optional string parameter for query's with different parameters needed than _userID * @return grid with values **/ public Grid GetGrid(string _gridName, int _userId, string _parameter1 = null, string _parameter2 = null, string _parameter3 = null) { List <ParameterValue> list = new List <ParameterValue>(); QueryValues qValues = db.GetGridQuery(_gridName); ParameterValue value = new ParameterValue(); value.ParameterName = "MID"; value.Value = _userId.ToString(); list.Add(value); if (_parameter1 != null) { string[] splitted = Splitter(_parameter1); value = new ParameterValue(); value.ParameterName = splitted[1]; value.Value = splitted[0]; list.Add(value); } if (_parameter2 != null) { string[] splitted = Splitter(_parameter2); value = new ParameterValue(); value.ParameterName = splitted[1]; value.Value = splitted[0]; list.Add(value); } //TODO: Parameter 1,2,3 splitten //Als ze bestaan toeveogen aan de list. //Database klasse gebruiken om de grid op te halen. Grid grid = db.GetGridByQuery(qValues, list); return(grid); }
void SetValue(QueryValues which, object obj) { switch (which) { // key case QueryValues.CorpID: m_DataObject.CorpID = DBConvert.ToLong(obj); return; // data case QueryValues.Name0: m_DataObject.Name0 = DBConvert.ToString(obj); return; case QueryValues.Name1: m_DataObject.Name1 = DBConvert.ToString(obj); return; case QueryValues.Name2: m_DataObject.Name2 = DBConvert.ToString(obj); return; case QueryValues.Name3: m_DataObject.Name3 = DBConvert.ToString(obj); return; case QueryValues.Name4: m_DataObject.Name4 = DBConvert.ToString(obj); return; case QueryValues.Name5: m_DataObject.Name5 = DBConvert.ToString(obj); return; case QueryValues.Name6: m_DataObject.Name6 = DBConvert.ToString(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { // key case QueryValues.CorpID: m_DataObject.CorpID = DBConvert.ToLong(obj); return; // data case QueryValues.MemberOk: m_DataObject.MemberOk = DBConvert.ToLong(obj); return; case QueryValues.MemberCaution: m_DataObject.MemberCaution = DBConvert.ToLong(obj); return; case QueryValues.MemberWarning: m_DataObject.MemberWarning = DBConvert.ToLong(obj); return; case QueryValues.RecruitDefinition: m_DataObject.RecruitDefinition = DBConvert.ToLong(obj); return; case QueryValues.RecruitOk: m_DataObject.RecruitOk = DBConvert.ToLong(obj); return; case QueryValues.RecruitCaution: m_DataObject.RecruitCaution = DBConvert.ToLong(obj); return; case QueryValues.RecruitWarning: m_DataObject.RecruitWarning = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.AccountID: m_DataObject.AccountID = DBConvert.ToLong(obj); return; case QueryValues.AccountKey: m_DataObject.AccountKey = DBConvert.ToLong(obj); return; case QueryValues.balance: m_DataObject.balance = DBConvert.ToDecimal(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }
void SetValue(QueryValues which, object obj) { switch (which) { case QueryValues.CharID: m_DataObject.CharID = DBConvert.ToLong(obj); return; case QueryValues.StartTime: m_DataObject.StartTime = DBConvert.ToDateTime(obj); return; case QueryValues.EndTime: m_DataObject.EndTime = DBConvert.ToDateTime(obj); return; case QueryValues.TypeID: m_DataObject.TypeID = DBConvert.ToLong(obj); return; case QueryValues.StartSP: m_DataObject.StartSP = DBConvert.ToLong(obj); return; case QueryValues.EndSP: m_DataObject.EndSP = DBConvert.ToLong(obj); return; case QueryValues.ToLevel: m_DataObject.ToLevel = DBConvert.ToLong(obj); return; case QueryValues.SkillInTraining: m_DataObject.SkillInTraining = DBConvert.ToLong(obj); return; } throw new ArgumentOutOfRangeException("which", which, ""); }