public ActionResult GetListJson(FormGroupGridArgumentModel model) { var dal = GetDAL <StepCinemaDataLayer.DataAccess.FormGroupLayer>(); var data = dal.GetList(model); return(CamelJson(data)); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public FormGroupGridModel GetList(FormGroupGridArgumentModel model) { string formGroupId = model.Filter.FormGroupId ?? ""; string formGroupName = model.Filter.FormGroupName ?? ""; string sort = "Order ASC"; if ((!string.IsNullOrWhiteSpace(model.Sort.Field)) && (!string.IsNullOrWhiteSpace(model.Sort.Direction))) { sort = model.Sort.Field + ' ' + model.Sort.Direction; } else { model.Sort.Field = ""; model.Sort.Direction = ""; } var query = this.Entities.FormGroups.OrderBy(sort); if (!string.IsNullOrEmpty(formGroupName)) { query = query.Where(x => (x.FormGroupName ?? "").Contains(formGroupName)); } //if (!string.IsNullOrWhiteSpace(model.Filter.Active)) //{ // var active = (model.Filter.Active == "Y"); // query = query.Where(x => x.Active == active); //} var count = query.Count(); model.Pagination.Count = count; model.Pagination.MaxPages = (((count - 1) / model.Pagination.PageSize) + 1); if (model.Pagination.CurrentPage > model.Pagination.MaxPages) { model.Pagination.CurrentPage = model.Pagination.MaxPages; } var result = query .Select(x => new FormGroupGridValueModel() { FormGroupId = x.FormGroupId, FormGroupName = x.FormGroupName, //Active = ((x.Active) ? "Active" : "Inactive") }).Skip((model.Pagination.CurrentPage - 1) * model.Pagination.PageSize).Take(model.Pagination.PageSize).ToList(); //model.Filter.Active = model.Filter.Active ?? ""; var data = new FormGroupGridModel(); data.Arguments = model; data.Columns = FormGroupGridColumnModel.GetColumns(); data.Values = result; return(data); }