public void InitPveMap(int nPveID, int nCompleteTime, RemoteTable pveValue)
{
KPve pveInfo = KConfigFileManager.GetInstance().pveList.getData(nPveID.ToString());
showText = pveInfo.Text;
enterTime = (int)PlayerManager.GetInstance().MajorPlayer.onlineTime;
MapName.text = pveInfo.Name;
ProcessTime.text = GiftItem.FormatTime(nCompleteTime);
completeTime = nCompleteTime;
exsistTime = pveInfo.tExistTime;
pveID = nPveID;
UpdateTime();
for (int i = 0; i < 9; i++)
{
int nValue = pveValue[i];
mapValue[i] = nValue;
}
UpdateValue();
ShowProcess();
}
public void LinqODataWithSelectConversions()
{
// Arrange
var client = GetMockClient();
var table = new RemoteTable <ClientMovie>("movies", client);
var query = new TableQuery <ClientMovie>(table);
DateTimeOffset dto1 = new(1994, 10, 14, 0, 0, 0, TimeSpan.Zero);
const string dts1 = "1994-10-14T00:00:00.000Z";
// Need to make sure the $select statement is added in the right spot.
var expected = NormalizeQueryString($"__includedeleted=true&$count=true&$filter=(updatedAt gt cast({dts1},Edm.DateTimeOffset))&$orderby=updatedAt&$skip=25&$select=id,title");
// Act
TableQuery <SelectResult> tableQuery = query
.Where(x => x.UpdatedAt > dto1)
.IncludeDeletedItems()
.OrderBy(x => x.UpdatedAt)
.IncludeTotalCount()
.Skip(25)
.Select(m => new SelectResult {
Id = m.Id, Title = m.Title
}) as TableQuery <SelectResult>;
var actual = NormalizeQueryString(Uri.UnescapeDataString(tableQuery.ToODataString()));
// Assert
Assert.Equal(expected, actual);
}
public object ShowPveView(int nPveID, float fCompleteTime, RemoteTable award)
{
KPve pveInfo = KConfigFileManager.GetInstance().pveList.getData(nPveID.ToString());
Open(null);
SuccSprite1.gameObject.SetActive(false);
SuccSprite2.gameObject.SetActive(false);
SuccSprite3.gameObject.SetActive(false);
if (fCompleteTime > pveInfo.tNormalTime)
{
SuccSprite1.gameObject.SetActive(true);
nShowStar = 1;
}
else if (fCompleteTime > pveInfo.tGoodTime)
{
SuccSprite2.gameObject.SetActive(true);
Star3.gameObject.SetActive(false);
nShowStar = 2;
}
else
{
SuccSprite3.gameObject.SetActive(true);
nShowStar = 3;
}
CompleteTimeLabel.text = GiftItem.FormatTime((int)fCompleteTime);
ShowAward(award);
showTime = (int)PlayerManager.GetInstance().MajorPlayer.onlineTime;
return(null);
}
// Example of scenario such as storing a query in a database and retreiving it
// later into the same object model.
public static void DLinqQuerySerializationSamples()
{
Console.WriteLine("DLINQ BASIC SAMPLE - Single Object Model used on both sides of serialization:");
// Write the query against RemoteTable<Customer>, a dummy implementation
// of IQueryable
RemoteTable <Customer> customers = new RemoteTable <Customer>();
var query = from c in customers
where c.City == "London"
select new { c.CompanyName, c };
XElement queryXml = query.SerializeQuery();
// On the other side - create a new DataContext, and deserialize
// the query xml into a query against this datacontext
NorthwindDataContext dbOther = new NorthwindDataContext();
IQueryable queryAfter = dbOther.DeserializeQuery(queryXml);
// Print out the IQueryable: "(x, y) => x + y"
Console.WriteLine("Deserialized IQueryable:");
Console.WriteLine(" " + queryAfter.ToString());
Console.WriteLine("\n Results: ");
queryAfter.Cast <object>().ToList().ForEach(n => Console.WriteLine(" " + n.ToString()));
Console.WriteLine();
}
// Example of scenario such as storing a query in a database and retreiving it
// later into the same object model.
public static void DLinqQuerySerializationSamples()
{
Console.WriteLine("DLINQ BASIC SAMPLE - Single Object Model used on both sides of serialization:");
// Write the query against RemoteTable<Customer>, a dummy implementation
// of IQueryable
RemoteTable<Customer> customers = new RemoteTable<Customer>();
var query = from c in customers
where c.City == "London"
select new {c.CompanyName,c};
XElement queryXml = query.SerializeQuery();
// On the other side - create a new DataContext, and deserialize
// the query xml into a query against this datacontext
NorthwindDataContext dbOther = new NorthwindDataContext();
IQueryable queryAfter = dbOther.DeserializeQuery(queryXml);
// Print out the IQueryable: "(x, y) => x + y"
Console.WriteLine("Deserialized IQueryable:");
Console.WriteLine(" " + queryAfter.ToString());
Console.WriteLine("\n Results: ");
queryAfter.Cast<object>().ToList().ForEach(n => Console.WriteLine(" " + n.ToString()));
Console.WriteLine();
}
public void Ctor_SetsInternals()
{
var client = GetMockClient();
var sut = new RemoteTable("movies", client);
Assert.Equal("movies", sut.TableName);
Assert.Same(client, sut.ServiceClient);
}
public void IncludeTotalCount_Disabled_RemovesKey()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).IncludeTotalCount(false) as TableQuery <IdEntity>;
Assert.False(query.RequestTotalCount);
}
public void WithParameter_Illegal_Throws(string key, string value)
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Assert.Throws <ArgumentException>(() => query.WithParameter(key, value));
}
public void Take_ThrowsOutOfRange([CombinatorialValues(-10, -1, 0)] int take)
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Assert.Throws <ArgumentOutOfRangeException>(() => query.Take(take));
}
public void ToODataString_ThenBy_ThrowsNotSupported()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).ThenBy(m => m.Id.ToLower()) as TableQuery <IdEntity>;
Assert.Throws <NotSupportedException>(() => query.ToODataString());
}
public void ToODataString_Where_ThrowsNotSupported()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).ThenByDescending(m => m.Id.Normalize() == "foo") as TableQuery <IdEntity>;
Assert.Throws <NotSupportedException>(() => query.ToODataString());
}
public void WithParameters_Null_Throws()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Assert.Throws <ArgumentNullException>(() => query.WithParameters(null));
}
public void IncludeTotalCount_Enabled_AddsKey()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).IncludeTotalCount(true) as TableQuery <IdEntity>;
Assert.True(query.RequestTotalCount);
}
public void ToODataString_Where_IsWellFormed()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).Where(m => m.Id == "foo") as TableQuery <IdEntity>;
var odata = query.ToODataString();
Assert.Equal("$filter=(id eq 'foo')", odata);
}
public void RemoteTableExpressionTest()
{
var rt = new RemoteTable <RTItem>();
var query = rt.Where(x => x.name == "dd");
Expression <Func <int, bool> > expression = x => (-x > 5) ? true : false;
var el = rt.SerializeQuery();
}
public void ToODataString_ThenByDescending_IsWellFormed()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).ThenByDescending(m => m.Id) as TableQuery <IdEntity>;
var odata = query.ToODataString();
Assert.Equal("$orderby=id desc", odata);
}
public void ThenByDescending_Null_Throws()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Expression <Func <IdEntity, string> > keySelector = null;
Assert.Throws <ArgumentNullException>(() => query.ThenByDescending(keySelector));
}
public void ToODataString_Take_IsWellFormed()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).Take(5) as TableQuery <IdEntity>;
var odata = query.ToODataString();
Assert.Equal("$top=5", odata);
}
public void WithParameter_Overwrites()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).WithParameter("testkey", "testvalue");
var actual = query.WithParameter("testkey", "replacement") as TableQuery <IdEntity>;
AssertEx.Contains("testkey", "replacement", actual.Parameters);
}
public void Select_Null_Throws()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Expression <Func <IdEntity, IdOnly> > selector = null;
Assert.Throws <ArgumentNullException>(() => query.Select(selector));
}
/// <summary>
/// Returns the result of the query as an <see cref="IAsyncEnumerable{T}"/>.
/// </summary>
/// <returns>The list of items as an <see cref="IAsyncEnumerable{T}"/></returns>
public IAsyncEnumerable<T> ToAsyncEnumerable()
{
if (IsOfflineEnabled)
{
var offlineTable = new OfflineTable<T>(RemoteTable.TableName, RemoteTable.ServiceClient);
return offlineTable.GetAsyncItems(this);
}
return RemoteTable.GetAsyncItems(this);
}
public void Linq_InvalidOrderBy_Lambda()
{
// Arrange
var client = GetMockClient();
var table = new RemoteTable <ClientMovie>("movies", client);
var query = new TableQuery <ClientMovie>(table).OrderBy(m => m.Id == "foo" ? "yes" : "no") as TableQuery <ClientMovie>;
Assert.Throws <NotSupportedException>(() => query.ToODataString());
}
public void Where_Null_Throws()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Expression <Func <IdEntity, bool> > predicate = null;
Assert.Throws <ArgumentNullException>(() => query.Where(predicate));
}
public void ToODataString_IncludeDeletedItems_IsWellFormed()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).IncludeDeletedItems() as TableQuery <IdEntity>;
var odata = query.ToODataString();
Assert.Equal("__includedeleted=true", odata);
}
public void Linq_InvalidOrderBy_ToString()
{
// Arrange
var client = GetMockClient();
var table = new RemoteTable <ClientMovie>("movies", client);
var query = new TableQuery <ClientMovie>(table).OrderBy(m => m.ReleaseDate.ToString("o")) as TableQuery <ClientMovie>;
Assert.Throws <NotSupportedException>(() => query.ToODataString());
}
public void Linq_NegateNotSupported()
{
// Arrange
var client = GetMockClient();
var table = new RemoteTable <ClientMovie>("movies", client);
var query = new TableQuery <ClientMovie>(table).Where(m => (-m.Year) <= -2000) as TableQuery <ClientMovie>;
Assert.Throws <NotSupportedException>(() => query.ToODataString());
}
public void IncludeDeletedItems_Disabled_WorksWithEmptyParameters()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
var actual = query.IncludeDeletedItems(false) as TableQuery <IdEntity>;
Assert.False(actual.Parameters.ContainsKey("__includedeleted"));
}
public void Ctor_BlankSetup()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
Assert.Same(table, query.RemoteTable);
Assert.IsAssignableFrom <IQueryable <IdEntity> >(query.Query);
Assert.Empty(query.Parameters);
}
public void ToODataString_WithParameter_EncodesValue()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table).WithParameter("testkey", "test value") as TableQuery <IdEntity>;
var odata = query.ToODataString();
Assert.Equal("testkey=test%20value", odata);
}
public void ToODataString_DefaultIncludeParameters()
{
// Arrange
var client = GetMockClient();
var table = new RemoteTable <ClientMovie>("movies", client);
var query = new TableQuery <ClientMovie>(table).OrderBy(m => m.ReleaseDate).WithParameter("foo", "bar") as TableQuery <ClientMovie>;
var actual = query.ToODataString();
Assert.Equal("$orderby=releaseDate&foo=bar", actual);
}
public void IncludeDeletedItems_Enabled_ChangesKey()
{
var client = GetMockClient();
RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>;
var query = new TableQuery <IdEntity>(table);
query.Parameters.Add("__includedeleted", "test");
var actual = query.IncludeDeletedItems() as TableQuery <IdEntity>;
AssertEx.Contains("__includedeleted", "true", actual.Parameters);
}
// Example of querying using LINQ against a LINQ to SQL implementation hidden behind a WCF service
// Note that no database is being directly referenced - all types and calls are proxies generated by
// the service reference.
public static void AcrossTheWireSerializationSamples()
{
Console.WriteLine("DLINQ ACROSS THE WIRE SAMPLE - Query against an IQueryable wrapper over a web service:");
// Query is against a RemoteTable which is a proxy for the the WCF service which executes the DLinq query
// on the server. Note that the elements are the service-reference generated types that align with the
// DLinq mapping types via the DataContracts.
var queryService = new RemoteTable<RemoteQueryService.ServiceReference.Customer>();
var query = from c in queryService
where c.City == "London"
orderby c.CustomerID
select (from o in c.Orders
orderby o.OrderDate
select o.OrderDate).First();
Console.WriteLine("\n Query Results: ");
foreach (var c in query)
Console.WriteLine(" " + c.Value.ToShortDateString());
}
