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