// GET: Admin/Shop public ActionResult Index(int page = 1, int pagesize = 5) { try { var model = new CodeShop(); var result = model.GetAllShop(); return(View(result)); } catch (Exception ex) { ViewData["Error"] = ex.Message; return(View()); } }
public JsonResult DataTableGet([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { var context = new ShopBanHangDbContext(); var model = new CodeShop(); IQueryable <ShopModel> query = model.GetAllShop().AsQueryable(); var totalCount = query.Count(); // Apply filters if (!string.IsNullOrEmpty(requestModel.Search.Value)) { var value = requestModel.Search.Value.Trim(); query = query.Where(p => p.Name.Contains(value)); } var filteredCount = query.Count(); // Sort var sortedColumns = requestModel.Columns.GetSortedColumns(); var orderByString = String.Empty; foreach (var column in sortedColumns) { orderByString += orderByString != String.Empty ? "," : ""; orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc"); } orderByString = orderByString == String.Empty ? "ID asc" : orderByString; //squery = query.OrderBy(orderByString); // Paging query = query.Skip(requestModel.Start).Take(requestModel.Length); var data = query.Select(p => new { Id = p.ID, Name = p.Name, Description = p.Description, Address = p.Address, UserID = p.UserID, Email = p.Email, Action = "<br /><p class=\"btn-action\"><a href=\"#\" class=\"detail\"><i class=\"ui-tooltip fa fa-pencil-square-o detail\" style=\"font-size: 22px;\" data-original-title=\"Detail\"></i></a> <a href=\"#\" class=\"remove\" ><i class=\"ui-tooltip fa fa-trash-o remove\" style=\"font-size: 20px;\" data-original-title=\"Delete\" tooltip=\"Delete\"></i></a></p>", }).ToList(); return(Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount), JsonRequestBehavior.AllowGet)); }