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>(); //win7 is different setting default thread current culture //CultureInfo threadCulture = CultureInfo.DefaultThreadCurrentCulture; //CultureInfo threadUICulture = CultureInfo.DefaultThreadCurrentUICulture; CultureInfo threadCulture = System.Threading.Thread.CurrentThread.CurrentCulture; CultureInfo threadUICulture = System.Threading.Thread.CurrentThread.CurrentUICulture; 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; System.Threading.Thread.CurrentThread.CurrentCulture = arabic; System.Threading.Thread.CurrentThread.CurrentUICulture = 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; System.Threading.Thread.CurrentThread.CurrentCulture = chinese; System.Threading.Thread.CurrentThread.CurrentUICulture = 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; System.Threading.Thread.CurrentThread.CurrentCulture = russian; System.Threading.Thread.CurrentThread.CurrentUICulture = russian; DateExample ruInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, ruInstance.Date); //CultureInfo.DefaultThreadCurrentCulture = threadCulture; //CultureInfo.DefaultThreadCurrentUICulture = threadUICulture; System.Threading.Thread.CurrentThread.CurrentCulture = threadCulture; System.Threading.Thread.CurrentThread.CurrentUICulture = threadCulture; }
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>(); //win7 is different setting default thread current culture //CultureInfo threadCulture = CultureInfo.DefaultThreadCurrentCulture; //CultureInfo threadUICulture = CultureInfo.DefaultThreadCurrentUICulture; CultureInfo threadCulture = System.Threading.Thread.CurrentThread.CurrentCulture; CultureInfo threadUICulture = System.Threading.Thread.CurrentThread.CurrentUICulture; 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; System.Threading.Thread.CurrentThread.CurrentCulture = arabic; System.Threading.Thread.CurrentThread.CurrentUICulture = 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; System.Threading.Thread.CurrentThread.CurrentCulture = chinese; System.Threading.Thread.CurrentThread.CurrentUICulture = 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; System.Threading.Thread.CurrentThread.CurrentCulture = russian; System.Threading.Thread.CurrentThread.CurrentUICulture = russian; DateExample ruInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, ruInstance.Date); //CultureInfo.DefaultThreadCurrentCulture = threadCulture; //CultureInfo.DefaultThreadCurrentUICulture = threadUICulture; System.Threading.Thread.CurrentThread.CurrentCulture = threadCulture; System.Threading.Thread.CurrentThread.CurrentUICulture = threadCulture; }
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); }