I think I have a solution.
In every controller method that returns date time objects, instead of returning a JsonResult, do:
JavaScriptSerializer js = new JavaScriptSerializer();
js.RegisterConverters(new List<JavaScriptConverter> { new DateTimeJavaScriptConverter(_dateTimeHelper) });
string output = js.Serialize(gridModel);
//Add backslashes and single quotes to date in serialized output (it cant be done in the converter because the uri gets url encoded)
var modifiedOutput = System.Text.RegularExpressions.Regex.Replace(output, "/Date\\((.*?)\\)/", "\\/Date('$1')\\/");
return Content(modifiedOutput, "application/json");
The DateTimeJavaScriptConverter is (slighty modified from
this post):
public class DateTimeJavaScriptConverter : JavaScriptConverter
{
private readonly IDateTimeHelper _dateTimeHelper;
public DateTimeJavaScriptConverter(IDateTimeHelper dateTimeHelper)
{
_dateTimeHelper = dateTimeHelper;
}
public override object Deserialize(IDictionary<string, object> dictionary, Type type, JavaScriptSerializer serializer)
{
return new JavaScriptSerializer().ConvertToType(dictionary, type);
}
public override IDictionary<string, object> Serialize(object obj, JavaScriptSerializer serializer)
{
if (!(obj is DateTime)) return null;
var date = (DateTime)obj;
var dateOffset = new DateTimeOffset(date, _dateTimeHelper.CurrentTimeZone.GetUtcOffset(date));
return new CustomString("/Date(" + dateOffset.ToString("yyyy-MM-ddTHH:mm:sszzz") + ")/");
}
public override IEnumerable<Type> SupportedTypes
{
get { return new[] { typeof(DateTime) }; }
}
private class CustomString : Uri, IDictionary<string, object>
{
public CustomString(string str)
: base(str, UriKind.Relative)
{
}
void IDictionary<string, object>.Add(string key, object value)
{
throw new NotImplementedException();
}
bool IDictionary<string, object>.ContainsKey(string key)
{
throw new NotImplementedException();
}
ICollection<string> IDictionary<string, object>.Keys
{
get { throw new NotImplementedException(); }
}
bool IDictionary<string, object>.Remove(string key)
{
throw new NotImplementedException();
}
bool IDictionary<string, object>.TryGetValue(string key, out object value)
{
throw new NotImplementedException();
}
ICollection<object> IDictionary<string, object>.Values
{
get { throw new NotImplementedException(); }
}
object IDictionary<string, object>.this[string key]
{
get
{
throw new NotImplementedException();
}
set
{
throw new NotImplementedException();
}
}
void ICollection<KeyValuePair<string, object>>.Add(KeyValuePair<string, object> item)
{
throw new NotImplementedException();
}
void ICollection<KeyValuePair<string, object>>.Clear()
{
throw new NotImplementedException();
}
bool ICollection<KeyValuePair<string, object>>.Contains(KeyValuePair<string, object> item)
{
throw new NotImplementedException();
}
void ICollection<KeyValuePair<string, object>>.CopyTo(KeyValuePair<string, object>[] array, int arrayIndex)
{
throw new NotImplementedException();
}
int ICollection<KeyValuePair<string, object>>.Count
{
get { throw new NotImplementedException(); }
}
bool ICollection<KeyValuePair<string, object>>.IsReadOnly
{
get { throw new NotImplementedException(); }
}
bool ICollection<KeyValuePair<string, object>>.Remove(KeyValuePair<string, object> item)
{
throw new NotImplementedException();
}
IEnumerator<KeyValuePair<string, object>> IEnumerable<KeyValuePair<string, object>>.GetEnumerator()
{
throw new NotImplementedException();
}
IEnumerator IEnumerable.GetEnumerator()
{
throw new NotImplementedException();
}
}
}
Let me know what you think of this solution. The conversion is now done on the server for each date.