public async Task DateKinds() { IMobileServiceTable <DateExample> table = GetClient().GetTable <DateExample>(); DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); DateExample instance = new DateExample { Date = original }; Log("Start Kind: {0}", instance.Date.Kind); await table.InsertAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); Assert.AreEqual(original, instance.Date); Log("Change to UTC"); instance.Date = new DateTime(2010, 5, 21, 0, 0, 0, 0, DateTimeKind.Utc); await table.UpdateAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); Log("Change to Local"); instance.Date = new DateTime(2010, 5, 21, 0, 0, 0, 0, DateTimeKind.Local); await table.UpdateAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); }
public async Task ChangeCulture() { IMobileServiceTable <DateExample> table = GetClient().GetTable <DateExample>(); CultureInfo threadCulture = CultureInfo.DefaultThreadCurrentCulture; CultureInfo threadUICulture = CultureInfo.DefaultThreadCurrentUICulture; DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); DateExample instance = new DateExample { Date = original }; await table.InsertAsync(instance); Log("Change culture to ar-EG"); CultureInfo arabic = new CultureInfo("ar-EG"); CultureInfo.DefaultThreadCurrentCulture = arabic; CultureInfo.DefaultThreadCurrentUICulture = arabic; DateExample arInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, arInstance.Date); Log("Change culture to zh-CHS"); CultureInfo chinese = new CultureInfo("zh-CHS"); CultureInfo.DefaultThreadCurrentCulture = chinese; CultureInfo.DefaultThreadCurrentUICulture = chinese; DateExample zhInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, zhInstance.Date); Log("Change culture to ru-RU"); CultureInfo russian = new CultureInfo("ru-RU"); CultureInfo.DefaultThreadCurrentCulture = russian; CultureInfo.DefaultThreadCurrentUICulture = russian; DateExample ruInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, ruInstance.Date); CultureInfo.DefaultThreadCurrentCulture = threadCulture; CultureInfo.DefaultThreadCurrentUICulture = threadUICulture; }
public async Task InsertAndQuery() { IMobileServiceTable<DateExample> table = GetClient().GetTable<DateExample>(); DateTime date = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Log("Start: {0}", date); Log("Inserting instance"); DateExample instance = new DateExample { Date = date }; await table.InsertAsync(instance); Assert.AreEqual(date, instance.Date); Log("Querying for instance"); List<DateExample> items = await table.Where(i => i.Date == date).Where(i => i.Id >= instance.Id).ToListAsync(); Assert.AreEqual(1, items.Count); Assert.AreEqual(date, items[0].Date); Log("Finish: {0}", items[0].Date); }
public async Task InsertAndQuery() { IMobileServiceTable <DateExample> table = GetClient().GetTable <DateExample>(); DateTime date = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Log("Start: {0}", date); Log("Inserting instance"); DateExample instance = new DateExample { Date = date }; await table.InsertAsync(instance); Assert.AreEqual(date, instance.Date); Log("Querying for instance"); List <DateExample> items = await table.Where(i => i.Date == date).Where(i => i.Id >= instance.Id).ToListAsync(); Assert.AreEqual(1, items.Count); Assert.AreEqual(date, items[0].Date); Log("Finish: {0}", items[0].Date); }
public async Task ChangeCulture() { IMobileServiceTable<DateExample> table = GetClient().GetTable<DateExample>(); CultureInfo threadCulture = CultureInfo.DefaultThreadCurrentCulture; CultureInfo threadUICulture = CultureInfo.DefaultThreadCurrentUICulture; DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); DateExample instance = new DateExample { Date = original }; await table.InsertAsync(instance); Log("Change culture to ar-EG"); CultureInfo arabic = new CultureInfo("ar-EG"); CultureInfo.DefaultThreadCurrentCulture = arabic; CultureInfo.DefaultThreadCurrentUICulture = arabic; DateExample arInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, arInstance.Date); Log("Change culture to zh-CHS"); CultureInfo chinese = new CultureInfo("zh-CHS"); CultureInfo.DefaultThreadCurrentCulture = chinese; CultureInfo.DefaultThreadCurrentUICulture = chinese; DateExample zhInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, zhInstance.Date); Log("Change culture to ru-RU"); CultureInfo russian = new CultureInfo("ru-RU"); CultureInfo.DefaultThreadCurrentCulture = russian; CultureInfo.DefaultThreadCurrentUICulture = russian; DateExample ruInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, ruInstance.Date); CultureInfo.DefaultThreadCurrentCulture = threadCulture; CultureInfo.DefaultThreadCurrentUICulture = threadUICulture; }
public async Task DateKinds() { IMobileServiceTable<DateExample> table = GetClient().GetTable<DateExample>(); DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); DateExample instance = new DateExample { Date = original }; Log("Start Kind: {0}", instance.Date.Kind); await table.InsertAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); Assert.AreEqual(original, instance.Date); Log("Change to UTC"); instance.Date = new DateTime(2010, 5, 21, 0, 0, 0, 0, DateTimeKind.Utc); await table.UpdateAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); Log("Change to Local"); instance.Date = new DateTime(2010, 5, 21, 0, 0, 0, 0, DateTimeKind.Local); await table.UpdateAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); }