Exemple #1
0
        // 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));
        }
Exemple #2
0
        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();
        }