We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

EJ Grid UK currency and Date Formats

Thread ID:

Created:

Updated:

Platform:

Replies:

118870 Apr 17,2015 05:27 AM Apr 20,2015 02:11 AM ASP.NET MVC 1
loading
Tags: Grid
peter hancock
Asked On April 17, 2015 05:27 AM

We are just evolution the product and the board meet on Tuesday, I have to do a demonstration and we have a show stopper.  Im an unable to get dates to display on the grid, and the currencies are in American format.

Dates display as: /date(123456754234353)/
Currency display as $10

MVC IEnumerable model as follows:

public class ApplicationForPaymentModel
    {
        public Guid Id { get; set; }
        [Display(Name = "Application Ref")]
        public String ApplicationReference{ get; set; }
        [Display(Name = "Application Date")]
        [DataType(DataType.Date)]
        [Required]
        public System.DateTime? ApplicationDate{ get; set; }
        [Display(Name = "Valuation Period End")]
        [DataType(DataType.Date)]
        [Required]
        public DateTime? ValuationPeriodEndDate { get; set; }
        [Display(Name = "Amount")]
        [DataType(DataType.Currency)]
        [Required]
        public Decimal Amount{ get; set; }
        [Display(Name = "Application Contract To")]
        [DataType(DataType.Date)]
        [Required]
        public DateTime? ApplicationContractToDate { get; set; }
        [Required]
        [DataType(DataType.Date)]
        [Display(Name = "Payment Due Date")]
        public DateTime? PaymentDueDate { get; set; }
        [Required]
        [DataType(DataType.Date)]
        [Display(Name = "Payment Notice Date")]
        public DateTime? PaymentNoticeDate { get; set; }
        [Required]
        [DataType(DataType.Date)]
        [Display(Name = "Pay Less Notice Date")]
        public DateTime? PayLessNoticeDate { get; set; }
        [Display(Name = "Final Date For Payment")]
        [Required]
        [DataType(DataType.Date)]
        public DateTime? FinalDateForPayment { get; set; }
        public Boolean Accepted { get; set; }
    }

Grid is as follows:

$.post("@Url.Action("ArchivedApplications", "ApplicationsForPayment")",
            null,
            function (data) {
                $("#FlatGrid").ejGrid({
                    dataSource: data, // data must be array of json
                    columns: [
                       { field: "ApplicationReference", headerText: "Reference", width: 100 },
                       { field: "ApplicationDate", headerText: "Application Date", width: 80, format: "{0:dd/MM/yyyy}" },
                       { field: "Amount", headerText: "Amount", width: 100, textAlign: ej.TextAlign.Right, format: "{0:C2}" }
                    ],
                    pageSettings: { pageSize: 3 },
                    allowSorting: true,
                    allowPaging: true,
                    allowFiltering: true,
                    filterSettings: { filterType: "excel" },
                    enableAltRow: true,
                    //enablePersistence: true,
                });
        });

The script references in desktop layout include the UK localisation as per your instructions:

<script src="@Url.Content("~/Scripts/jquery-1.10.2.min.js")"></script>
    <script src="@Url.Content("~/Scripts/jsrender.min.js")"></script>
    <script src="@Url.Content("~/Scripts/jquery.easing-1.3.min.js")"></script>
    <script src="@Url.Content("~/Scripts/jquery.globalize.min.js")"></script>
    <script src="@Url.Content("~/Scripts/globalize.culture.en-GB.min.js")"></script>
    <script src="@Url.Content("~/Scripts/ej/ej.web.all.min.js")"></script>
    <script src="@Url.Content("~/Scripts/ej/ej.unobtrusive.min.js")"></script>

at the bottom of the layout:
@Html.EJ().ScriptManager()

Ragavee U S [Syncfusion]
Replied On April 20, 2015 02:11 AM

Hi Peter,

Thanks for your interest in syncfusion products.

Query #1: the dates and currencies are not displaying in correctly

For your kind information, we have already discussed the same issue in the below Knowledge base link. So please refer the below link to resolve the issue.

Online Knowledge Base Link: http://www.syncfusion.com/kb/3017/date-fields-in-json-data-are-not-formatted-properly-in-ajax-post

Query #2: the dates and currencies are not in UK format:

For your kind information, in order to set the localization for the grid, the locale property of the grid can be used. Please refer the below Online Knowledge base link for more information on how to enable localization in Grid.

Online Knowledge base Link: http://www.syncfusion.com/kb/4008/how-to-enable-localization-in-grid

The culture script file corresponding to the localization can be found in the below location.

Culture Script Location: C:\Program Files (x86)\Syncfusion\Essential Studio\13.1.0.21\JavaScript\assets\external\cultures

For your convenience, we have created a simple sample with the above solutions and the sample can be downloaded from the below location.

Sample Link: http://www.syncfusion.com/downloads/support/forum/118871/Sample-689940584.zip
Please get back to us if you need any further assistance.

Regards
Ragavee U S


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;