Sep 21, 2010, 4:57 PM
[CLOSED] JSON.Deserialize Lastes SVN
Hello,
We have started to come accross some problems with the latest SVN code. We understand some of the fixes you have done and we have accomodated the changes to our app so it works properly.
One of the starngest things is a JSON.Deserialize object when it is a date field, and the field is either invalid or null, the item will not be included in the dictionary. We had to start changing our code to check for something like the following code snipet;
We did not have to check for this before.
I have include a running sample with a bogus date, if you select the row and click on the button at the bottom of the grid, you will get the error "The given key was not present in the dictionary".
We have started to come accross some problems with the latest SVN code. We understand some of the fixes you have done and we have accomodated the changes to our app so it works properly.
One of the starngest things is a JSON.Deserialize object when it is a date field, and the field is either invalid or null, the item will not be included in the dictionary. We had to start changing our code to check for something like the following code snipet;
if(!record.ContainsKey("object_name"))
{
}We did not have to check for this before.
I have include a running sample with a bogus date, if you select the row and click on the button at the bottom of the grid, you will get the error "The given key was not present in the dictionary".
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Globalization" %>
<%@ Import Namespace="System.Collections.Generic" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
CultureInfo ci = new CultureInfo("en-US");
Store store = GridPanel1.Store.Primary;
store.DataSource = new List<Project>
{
new Project(100, "Ext Forms: Field Anchoring", 112, "Integrate 2.0 Forms with 2.0 Layouts", 6, 150, 0, DateTime.Parse("01/01/0001",ci)),
new Project(100, "Ext Forms: Field Anchoring", 113, "Implement AnchorLayout", 4, 150, 0, DateTime.Parse("06/25/2007",ci)),
new Project(100, "Ext Forms: Field Anchoring", 114, "Add support for multiple types of anchors", 4, 150, 0, DateTime.Parse("06/27/2007",ci)),
new Project(100, "Ext Forms: Field Anchoring", 115, "Testing and debugging", 8, 0, 0, DateTime.Parse("06/29/2007",ci)),
new Project(101, "Ext Grid: Single-level Grouping", 101, "Add required rendering \"hooks\" to GridView", 6, 100, 0, DateTime.Parse("07/01/2007",ci)),
new Project(101, "Ext Grid: Single-level Grouping", 102, "Extend GridView and override rendering functions", 6, 100, 0, DateTime.Parse("07/03/2007",ci)),
new Project(101, "Ext Grid: Single-level Grouping", 103, "Extend Store with grouping functionality", 4, 100, 0, DateTime.Parse("07/04/2007",ci)),
new Project(101, "Ext Grid: Single-level Grouping", 121, "Default CSS Styling", 2, 100, 0, DateTime.Parse("07/05/2007",ci)),
new Project(101, "Ext Grid: Single-level Grouping", 104, "Testing and debugging", 6, 100, 0, DateTime.Parse("07/06/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 105, "Ext Grid plugin integration", 4, 125, 0, DateTime.Parse("07/01/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 106, "Summary creation during rendering phase", 4, 125, 0, DateTime.Parse("07/02/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 107, "Dynamic summary updates in editor grids", 6, 125, 0, DateTime.Parse("07/05/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 108, "Remote summary integration", 4, 125, 0, DateTime.Parse("07/05/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 109, "Summary renderers and calculators", 4, 125, 0, DateTime.Parse("07/06/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 110, "Integrate summaries with GroupingView", 10, 125, 0, DateTime.Parse("07/11/2007",ci)),
new Project(102, "Ext Grid: Summary Rows", 111, "Testing and debugging", 8, 125, 0, DateTime.Parse("07/15/2007",ci))
};
store.DataBind();
}
}
protected void test1(object sender, DirectEventArgs e)
{
var records = JSON.Deserialize<Dictionary<string, string>[]>(e.ExtraParams["gridData1"]);
foreach (Dictionary<string, string> record in records)
{
string DateCompleted = record["Due"];
}
}
protected void CalculateGroup(object sender, DirectEventArgs e)
{
var records = JSON.Deserialize<Dictionary<string, string>[]>(e.ExtraParams["groupRecords"]);
int total = 0;
int estimate = 0;
double rate = 0;
foreach (Dictionary<string, string> record in records)
{
string test = record["Due"];
total += int.Parse(record["Estimate"]) * int.Parse(record["Rate"]);
estimate += int.Parse(record["Estimate"]);
rate += int.Parse(record["Rate"]);
}
RemoteSummary1.UpdateSummaryData(e.ExtraParams["groupValue"], new
{
Description = records.Length,
Estimate = estimate,
Rate = rate / records.Length,
Due = new JRawValue(Ext.Net.Utilities.DateTimeUtils.DateNetToJs(DateTime.Today)),
Cost = total
});
}
public class Project
{
public Project(int projectId, string name, int taskId, string description, int estimate, double rate, double cost, DateTime due)
{
this.ProjectID = projectId;
this.Name = name;
this.TaskID = taskId;
this.Description = description;
this.Estimate = estimate;
this.Rate = rate;
this.Due = due;
}
public int ProjectID { get; set; }
public string Name { get; set; }
public int TaskID { get; set; }
public string Description { get; set; }
public int Estimate { get; set; }
public double Rate { get; set; }
public double Cost { get; set; }
public DateTime Due { get; set; }
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Grouping with Remote Summary - Ext.NET Examples</title>
<link href="../../../../resources/css/examples.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.x-grid3-cell-inner
{
font-family: "segoe ui" ,tahoma, arial, sans-serif;
}
.x-grid-group-hd div
{
font-family: "segoe ui" ,tahoma, arial, sans-serif;
}
.x-grid3-hd-inner
{
font-family: "segoe ui" ,tahoma, arial, sans-serif;
font-size: 12px;
}
.x-grid3-body .x-grid3-td-Cost
{
background-color: #f1f2f4;
}
.x-grid3-summary-row .x-grid3-td-Cost
{
background-color: #e1e2e4;
}
</style>
</head>
<body>
<form id="Form1" runat="server">
<h1>
Grouping with Remote Summary</h1>
<p>
Advanced grouping grid that allows cell editing and includes remotely loaded dynamic
summary calculations.</p>
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:GridPanel ID="GridPanel1" runat="server" Frame="true" StripeRows="true" Title="Sponsored Projects"
AutoExpandColumn="Description" Collapsible="true" AnimCollapse="false" Icon="ApplicationViewColumns"
TrackMouseOver="false" Width="800" Height="450" ClicksToEdit="1">
<Store>
<ext:Store ID="Store1" runat="server" GroupField="Name">
<SortInfo Direction="ASC" Field="Due" />
<Reader>
<ext:JsonReader IDProperty="TaskID">
<Fields>
<ext:RecordField Name="ProjectID" />
<ext:RecordField Name="Name" />
<ext:RecordField Name="TaskID" />
<ext:RecordField Name="Description" />
<ext:RecordField Name="Estimate" Type="Int" />
<ext:RecordField Name="Rate" Type="Float" />
<ext:RecordField Name="Due" Type="Date" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
</Store>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:GroupingSummaryColumn ColumnID="Description" Header="Task" Sortable="true" DataIndex="Description"
Hideable="false" SummaryType="Count">
<SummaryRenderer Handler="return ((value === 0 || value > 1) ? '(' + value +' Tasks)' : '(1 Task)');" />
<Editor>
<ext:TextField ID="TextField1" runat="server" AllowBlank="false" />
</Editor>
</ext:GroupingSummaryColumn>
<ext:Column ColumnID="Name" Header="Project" DataIndex="Name" Width="20" />
<ext:GroupingSummaryColumn ColumnID="Due" Width="25" Header="Due Date" Sortable="true"
DataIndex="Due" SummaryType="Max">
<Renderer Format="Date" FormatArgs="'m/d/Y'" />
<Editor>
<ext:DateField ID="DateField1" runat="server" Format="MM/dd/yyyy" />
</Editor>
</ext:GroupingSummaryColumn>
<ext:GroupingSummaryColumn Width="20" ColumnID="Estimate" Header="Estimate" Sortable="true"
DataIndex="Estimate" SummaryType="Sum">
<Renderer Handler="return value +' hours';" />
<Editor>
<ext:NumberField ID="NumberField1" runat="server" AllowBlank="false" AllowNegative="false"
StyleSpec="text-align:left" />
</Editor>
</ext:GroupingSummaryColumn>
<ext:GroupingSummaryColumn Width="20" ColumnID="Rate" Header="Rate" Sortable="true"
DataIndex="Rate" SummaryType="Average">
<Renderer Format="UsMoney" />
<Editor>
<ext:NumberField ID="NumberField2" runat="server" AllowBlank="false" AllowNegative="false"
StyleSpec="text-align:left" />
</Editor>
</ext:GroupingSummaryColumn>
<ext:GroupingSummaryColumn Width="20" ColumnID="Cost" Header="Cost" Sortable="false"
Groupable="false" DataIndex="Cost" CustomSummaryType="totalCost">
<Renderer Handler="return Ext.util.Format.usMoney(record.data.Estimate * record.data.Rate);" />
<SummaryRenderer Format="UsMoney" />
</ext:GroupingSummaryColumn>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="roselMdl" runat="server"></ext:RowSelectionModel>
</SelectionModel>
<View>
<ext:GroupingView ID="GroupingView1" runat="server" ForceFit="true" MarkDirty="false"
ShowGroupName="false" EnableNoGroups="true" HideGroupedColumn="true" />
</View>
<TopBar>
<ext:Toolbar ID="Toolbar1" runat="server">
<Items>
<ext:Button ID="Button1" runat="server" Text="Toggle" ToolTip="Toggle the visibility of summary row">
<Listeners>
<Click Handler="#{GridPanel1}.getGroupingSummary().toggleSummaries();" />
</Listeners>
</ext:Button>
</Items>
</ext:Toolbar>
</TopBar>
<Plugins>
<ext:HybridSummary ID="RemoteSummary1" runat="server">
<Calculations>
<ext:JFunction Name="totalCost" Handler="return v + (record.data.Estimate * record.data.Rate);" />
</Calculations>
</ext:HybridSummary>
</Plugins>
<DirectEvents>
<AfterEdit OnEvent="CalculateGroup" Before="el.getGroupingSummary().showSummaryMsg(e.record.get(el.store.groupField), 'Updating Summary...');">
<ExtraParams>
<ext:Parameter Name="groupRecords" Value="this.store.getRecordsValues({records: this.view.getGroupRecords(e.record.get(this.store.groupField))})"
Mode="Raw" Encode="true" />
<ext:Parameter Name="groupValue" Value="e.record.get(this.store.groupField)" Mode="Raw" />
</ExtraParams>
</AfterEdit>
</DirectEvents>
<BottomBar>
<ext:Toolbar ID="tlbr1" runat="server">
<Items>
<ext:Button ID="btn1" runat="server" Text="Test">
<DirectEvents>
<Click OnEvent="test1">
<ExtraParams>
<ext:Parameter Name="gridData1" Value="Ext.encode(#{GridPanel1}.getRowsValues({selectedOnly : true, currentPageOnly : true}))"
Mode="Raw" />
</ExtraParams>
</Click>
</DirectEvents>
</ext:Button>
</Items>
</ext:Toolbar>
</BottomBar>
</ext:GridPanel>
</form>
</body>
</html>
