Hi , i have he following code in myview of businessunit grid.
while displaying it the businessunit grid and edit businessunit pages it reflects wrong date format be default- 01/01/0001 instead of the actual date though there is an actual and corect date in database.
i am using sql server 2014 .
businessunit view
@{
Layout = null;
}
@Scripts.Render("~/bundles/kendo")
<div>
@(Html.Kendo().Button()
.Name("textButton")
.HtmlAttributes(new { type = "Add BusinessUnit", @class = "btn-primary mar-b-10" })
.Content("Add BusinessUnit"))
</div>
<div id="businessunit" >
@(Html.Kendo().Grid<BHEBS.Areas.Admin.Models.ModalfBusinessUnit>()
.Name("BusinessUnitGrid")
.Events(events => events.Change("Grid_OnRowSelect"))
.Columns(columns =>
{
columns.Bound(b => b.BusinessUnit).Width(40); ;
columns.Bound(b => b.Fund).Width(30);
columns.Bound(b => b.FundPurpose).Width(40);
columns.Bound(b => b.ServiceType).Width(40);
columns.Bound(b => b.GrantNumber).Width(40);
columns.Bound(b => b.StartDate).Format("{0:MM/dd/yyyy}").Width(30);
columns.Bound(b => b.EndDate).Format("{0:MM/dd/yyyy}").Width(30);
columns.Bound(b => b.id).Visible(false);
columns.Bound("").ClientTemplate("<button class='btnGrid btn btn-primary btn-sm' data-id='#:id#' onclick='gridBtnClick(this)'><span class='edit_icon glyphicon glyphicon-pencil' aria-hidden='true'></span>Edit</button> <button class='btnGrid btn btn-primary btn-sm' data-id='#:id#' value='View' onclick='gridBtnClick(this)'><span class='edit_icon glyphicon glyphicon-eye-open' aria-hidden='true'></span>View</button>").Width(40);
})
.HtmlAttributes(new { style = "height: 410px;" })
.ToolBar(tools => tools.Excel())
.Scrollable()
.Sortable()
.Excel(excel => excel
.FileName("BusinessUnit.xlsx")
.Filterable(true)
.ProxyURL(Url.Action("Excel_Export_Save", "Grid"))
)
.ColumnMenu()
.Filterable()
.Pageable(pageable => pageable
.Refresh(true)
.PageSizes(true)
.ButtonCount(5))
.Resizable(resize => resize.Columns(true))
.Selectable(selectable => selectable
.Mode(GridSelectionMode.Multiple))
.DataSource(dataSource => dataSource
.Ajax()
.Read(read => read.Action("GetBusinessUnitData", "BusinessUnit"))
)
)
</div>
<br />
@(Html.Kendo().Button()
.Name("textButtonAA")
.HtmlAttributes(new { type = "Add BusinessUnit", @class = "btn-primary mar-b-10" })
.Content("Add BusinessUnit AA"))
<div id="businessunitaa" >
@(Html.Kendo().Grid<BHEBS.Areas.Admin.Models.ModalfBusinessUnitAA>()
.Name("BusinessUnitGridAA")
.Columns(columns =>
{
columns.Bound(b => b.SpendPriority).Width(40); ;
columns.Bound(b => b.Description).Width(80);
columns.Bound(b => b.StartDate).Format("{0:MM/dd/yyyy}").Width(30);
columns.Bound(b => b.EndDate).Format("{0:MM/dd/yyyy}").Width(30);
columns.Bound(b => b.InitTotalAuth).Width(35);
columns.Bound(b => b.InitAvailable).Width(35);
columns.Bound(b => b.Id).Visible(false).Width(10);
// columns.Bound("").ClientTemplate("<button class='btnGrid btn btn-primary btn-sm' data-id='#:Id#' onclick='gridAAClick(this)'><span class='edit_icon glyphicon glyphicon-pencil' aria-hidden='true'></span>Edit</button><button class='btnGrid btn btn-primary btn-sm' data-id='#:Id#' onclick='gridAAClick(this)'><span class='edit_icon glyphicon glyphicon-eye-open' aria-hidden='true'></span>View</button>").Width(50);
columns.Bound("").ClientTemplate("<button class='btnGrid btn btn-primary btn-sm' data-id='#:Id#' onclick='gridAAClick(this)'><span class='edit_icon glyphicon glyphicon-pencil' aria-hidden='true'></span>Edit</button> <button class='btnGrid btn btn-primary btn-sm' data-id='#:Id#' value='View' onclick='gridAAClick(this)'><span class='edit_icon glyphicon glyphicon-eye-open' aria-hidden='true'></span>View</button>").Width(40);
})
.HtmlAttributes(new { style = "height: 410px;", })
.ToolBar(tools => tools.Excel() )
.Scrollable()
.Sortable()
.Excel(excel => excel
.FileName("BusinessUnitAA.xlsx")
.Filterable(true)
.ProxyURL(Url.Action("Excel_Export_Save", "Grid"))
)
.ColumnMenu()
.Filterable()
.Pageable(pageable => pageable
.Refresh(true)
.PageSizes(true)
.ButtonCount(5))
.Resizable(resize => resize.Columns(true))
.Selectable(selectable => selectable
.Mode(GridSelectionMode.Multiple))
.Navigatable()
.Navigatable()
.DataSource(dataSource => dataSource
.Ajax()
.Read(read => read.Action("GetBusinessUnitAA", "BusinessUnit").Data("additionalInfo"))
)
)
</div>
<script>
var id = 0;
Grid_OnRowSelect = function (e) {
var data = this.dataItem(this.select());
id = data.id;
$('#BusinessUnitGridAA').data('kendoGrid').dataSource.read();
$('#BusinessUnitGridAA').data('kendoGrid').refresh();
// alert("1 st grid :" + data.id);//IMP
}
function additionalInfo() {
//alert(id);
return { AdditionalParam: id };
}
function doOnRowSelect(e) {
var selectedItem = this.dataItem(this.select());
alert(selectedItem.ShipName);
}
function formatDate(date) {
debugger;
switch (flag) {
case 1:
return kendo.toString(date, "g");
case 2:
return kendo.toString(date, "d");
case 3:
return kendo.toString(date, "Y");
default:
return kendo.toString(date, "F");
}
}
$('#textButton').on('click', function () {
$.ajax({
url: '@Url.Action("AddBusinessUnit", "BusinessUnit")',
type: 'GET',
success: function (data) {
$('#AddBusinessUnitDiv').html(data);
},
error: function () {
console.log("add business unit error rendering page");
}
});
});
$('#textButtonAA').on('click', function () {
if (id == 0) {
alert("Select one row on the BusinessUnit grid");
}
else {
$.ajax({
url: '@Url.Action("AddBusinessUnitAA", "BusinessUnit")' + '?BU_Id=' + id,
type: 'GET',
success: function (data) {
$('#AddBusinessUnitDiv').html(data);
},
error: function () {
console.log("add business unit aa error rendering page");
}
});
}
});
</script>
<style>
.row div:nth-child(even) {
background-color: #F9F9F9;
}
.row div:nth-child(odd) {
background-color: #aaaaaa;
}
</style>
please suggest.
1 Answer, 1 is accepted
The default value of the DateTime object is "01/01/0001". This leads me to the assumption that the values of StartDate and EndDate fields are actually DateTime.MinValue.
Could you examine the server response and specifically the returned JSON? This will show us whether the dates are returned correctly or not.
Regards,
Georgi Krustev
Telerik