This is a migrated thread and some comments may be shown as answers.

Bit field not displaying "Yes" or "No"

7 Answers 205 Views

Grid

This is a migrated thread and some comments may be shown as answers.

7 Answers, 1 is accepted

answered on 18 Jul 2014, 02:41 PM

Here is the view. The p in "(p.IsActive ?" has a red squiggly line underneath it. The error is: "C#: Unknown entity 'p'".

Thanks, - Bruce

@model IEnumerable<DataModel.tbl_spm_phonebook>

@{
ViewBag.Title = "GMAM Phonebook";

}

<hgroup class="title">
<h1>@ViewBag.Title</h1>
</hgroup>

@(Html.Kendo().Grid(Model)
.Name("Phonebook")
.Columns(columns =>
{
columns.Bound(p => p.FullName).Title("Full Name").Width(150);
columns.Bound(p => p.GMAMID).Title("NAM ID").Width(100);
//columns.Bound(p => p.IsActive).ClientTemplate("#= IsActive ? 'Yes': 'No' #").Title("Is Active").Width(100);
columns.Bound(p => p.IsActive).Template(@<text>@(p.IsActive? "Yes" : "No")</text>);
// columns.Template(d => @Html.ActionLink("Edit", "Edit", new { id = d.PhonebookID, }));
columns.Command(command => { command.Edit(); }).Width(150);
columns.Template(d => @Html.ActionLink("Details", "Details", new { id = d.PhonebookID, }));
})

.DataSource(dataSource => dataSource
.Server()
.Sort(sort => sort.Add("FullName").Ascending())
.Model(model => model.Id(p => p.PhonebookID))
.Create(update => update.Action("EditingPopup_Create", "Grid"))
.Read(read => read.Action("EditingPopup_Read", "Grid"))
.Update(update => update.Action("editingPopup_Update", "Grid"))
)
.Pageable()
.Sortable()
.Scrollable(scr => scr.Height(400))
.Filterable()
.Editable(editable => editable.Mode(GridEditMode.PopUp))
.ToolBar(toolbar => toolbar.Create())
)

@Html.ActionLink("Create New", "Create")

-----------------------------------------------------------------------
Here is the controller (top part):

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using DataModel;

namespace SpreadMaster.Controllers
{
public class PhonebookController : Controller
{
private SpreadMasterEntities db = new SpreadMasterEntities();

//
// GET: /Phonebook/

public ActionResult Index()
{
SpreadMasterEntities contextDM = new SpreadMasterEntities();
var phonebook = contextDM.tbl_spm_phonebook;

return View(phonebook.ToList());
}