public ActionResult NameSpaces(JqGridRequest request) { using (var db = new ContentRepository()) { var nameSpaceQry = from n in db.NameSpaces orderby n.Id select n; var totalRecs = db.NameSpaces.Count(); var response = new JqGridResponse() { TotalPagesCount = (int) Math.Ceiling((float) totalRecs/(float) request.RecordsCount), PageIndex = request.PageIndex, TotalRecordsCount = totalRecs }; var nameSpaces = nameSpaceQry .Skip(request.PageIndex*request.RecordsCount) .Take((request.PagesCount.HasValue ? request.PagesCount.Value : 1)*request.RecordsCount).ToList(); var jqGridRecords = from n in nameSpaces select new JqGridRecord<NameSpaceGridModel>( n.Id.ToString(), new NameSpaceGridModel(n)); response.Records.AddRange(jqGridRecords); return new JqGridJsonResult() { Data = response }; } }
public ActionResult Index(int id) { using (var repository = new ContentRepository() ) { var asset = (from content in repository.Contents.OfType<MediaContent>() where content.Id == id select content.DigitalAsset).FirstOrDefault(); return base.File(asset.Data, asset.ContentType); } }
public ActionResult EditNameSpace(int id) { PartialViewResult partial = null; if (id == 0) { partial = PartialView("EditNameSpace", new NameSpaceGridModel()); } else { using (var db = new ContentRepository()) { var nameSpaceQry = from n in db.NameSpaces where n.Id == id select new NameSpaceGridModel() {Description = n.Description, Id = n.Id, NameSpaceName = n.NameSpaceName}; partial = PartialView("EditNameSpace", nameSpaceQry.FirstOrDefault()); } } return partial; }
public ActionResult SaveNameSpace([FromURLEncodedJson]NameSpaceGridModel nameSpace) { if (nameSpace.Id == 0) { var ns = new NameSpace(); ns.Description = nameSpace.Description; ns.NameSpaceName = nameSpace.NameSpaceName; using (var db = new ContentRepository()) { db.NameSpaces.Add(ns); db.SaveChanges(); db.Commit(); } } else { using (var db = new ContentRepository()) { var nameSpaceQry = from n in db.NameSpaces where n.Id == nameSpace.Id select n; if (nameSpaceQry.Any()) { var ns = nameSpaceQry.First(); ns.Description = nameSpace.Description; ns.NameSpaceName = nameSpace.NameSpaceName; db.SaveChanges(); db.Commit(); } } } return View("Index"); }