// GET: Program public ActionResult GetList() { HSBCPSEntities _entities = new HSBCPSEntities(); IList <tbl_Program> tblProgramList = _entities.tbl_Program.OrderBy(x => x.Name).ToList(); string jsonResult = JsonConvert.SerializeObject(tblProgramList); DataTableResponse aa = new DataTableResponse { recordsTotal = tblProgramList.Count(), recordsFiltered = 10, data = tblProgramList.Take(10).ToArray() }; return(Json(aa, JsonRequestBehavior.AllowGet)); }
public void UpdateList(string updateID) { Guid _updatedID = Guid.Parse(updateID); HSBCPSEntities _entities = new HSBCPSEntities(); tbl_Program tblProgram = _entities.tbl_Program.Where(x => x.ID == _updatedID).Single(); if (tblProgram.Active == true) { tblProgram.Active = false; } else { tblProgram.Active = true; } _entities.Entry(tblProgram).State = EntityState.Modified; _entities.SaveChanges(); Clients.All.UpdateList(); }