public ActionResult List(JqGridFilterModel opts) { var devices = new AccountService().GetLstClients(); if (devices.LstClients == null) { devices.LstClients = new List <ConnectionFullModel>(); } var result = new { page = 1, records = devices.LstClients.Count, total = 1, rows = devices.LstClients.Select(e => new { id = e.DeviceId, cell = new { id = e.DeviceId, Name = e.DeviceName, e.StartDateTx, e.EndDateTx, e.Code } }) }; return(Json(result)); }
public ActionResult List(JqGridFilterModel opts) { using (var repository = new GenericRepository <Drs.Repository.Entities.Franchise>()) { var result = repository.JqGridFindBy(opts, FranchiseInfoJson.Key, FranchiseInfoJson.Columns, (e => e.IsObsolete == false) , FranchiseInfoJson.DynamicToDto); return(Json(result)); } }
public static string OrderBy(JqGridFilterModel opt) { if (opt.sord.Trim().ToLower() == JQGRID_DESC) { return(string.Format("{0} {1}", opt.sidx, SQL_DESC)); } return(string.Format("{0} {1}", opt.sidx, SQL_ASC)); }
public ActionResult List(JqGridFilterModel opts) { using (var repository = new GenericRepository <ViewStoreCoverage>()) { var result = repository.JqGridFindBy(opts, ViewStoreCoverageJson.Key, ViewStoreCoverageJson.Columns, (e => e.IsObsolete == false) , ViewStoreCoverageJson.DynamicToDto); return(Json(result)); } }
public ActionResult List(JqGridFilterModel opts) { using (var repository = new GenericRepository <Drs.Repository.Entities.ViewOrderInfo>()) { var result = repository.JqGridFindBy(opts, OrderInfoJson.Key, OrderInfoJson.Columns, (e => !SettingsData.Constants.TrackConst.OrderStatusEnd.Contains(e.LastStatus)), OrderInfoJson.DynamicToDto); return(Json(result)); } }
public ActionResult OffLineList(JqGridFilterModel opts, int id) { var userId = User.Identity.GetUserId(); var extraFilter = User.IsInRole(RoleConstants.STORE_MANAGER) ? ExtraFilterOffline(id, userId) : ExtraFilterOffline(id); StoreOfflineInfoDto.UtcTime = DateTime.UtcNow; using (var repository = new GenericRepository <FranchiseStoreOffLine>()) { var result = repository.JqGridFindBy(opts, StoreOfflineInfoJson.Key, StoreOfflineInfoJson.Columns, extraFilter , StoreOfflineInfoJson.DynamicToDto); return(Json(result)); } }
public ActionResult List(JqGridFilterModel opts) { Expression <Func <ViewStoreInfo, bool> > extraFilter; var userId = User.Identity.GetUserId(); if (User.IsInRole(RoleConstants.STORE_MANAGER)) { extraFilter = (e => e.IsObsolete == false && e.ManagerUserId == userId); } else { extraFilter = (e => e.IsObsolete == false); } using (var repository = new GenericRepository <ViewStoreInfo>()) { var result = repository.JqGridFindBy(opts, StoreInfoJson.Key, StoreInfoJson.Columns, extraFilter , StoreInfoJson.DynamicToDto); return(Json(result)); } }
public JqGridResultModel JqGridFindBy <TEntityDto>(JqGridFilterModel opts, string sKey, string sColumns, Expression <Func <TEntity, bool> > extraFilter = null, Func <dynamic, TEntityDto> dtoFunc = null) { try { var result = new JqGridResultModel(); var query = _dbSet as IQueryable <TEntity>; if (query == null) { return(null); } if (opts._search) { var filterDyn = new JavaScriptSerializer().Deserialize <JqGridMultipleFilterModel>(opts.filters); JqGridQueryWhere whereOpts = JqGridClause.ExpresionToExec(filterDyn); query = query.Where(whereOpts.Query, whereOpts.ArrParams); } if (extraFilter != null) { query = query.Where(extraFilter); } if (string.IsNullOrWhiteSpace(opts.sidx) == false && string.IsNullOrWhiteSpace(opts.sord) == false) { query = query.OrderBy(JqGridClause.OrderBy(opts)); } result.total = 0; result.page = 1; result.records = query.Count(); if (opts.page.HasValue && opts.rows.HasValue) { query = query.Skip((opts.page.Value - 1) * opts.rows.Value).Take(opts.rows.Value); result.page = opts.page.Value; result.total = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.records) / opts.rows.Value)); } IEnumerable qSel = query.Select(string.Format("New({0})", sColumns)); if (qSel == null) { return(null); } var lstObj = qSel.Cast <dynamic>().ToList(); if (lstObj.Count == 0) { result.rows = new List <JqGridRowsModel>(); } else { var prop = lstObj[0].GetType().GetProperty(sKey); result.rows = lstObj.Select(e => new JqGridRowsModel { id = prop.GetValue(e), cell = dtoFunc == null ? e : dtoFunc(e) }).ToList(); } return(result); } catch (Exception ex) { SharedLogger.LogError(ex, opts, sKey, sColumns); return(null); } }