public virtual DT_ViewList <TResult> GetTableRows(DataTableParameters dtParams, List <Sorter <TEntity> > sorters, Expression <Func <TEntity, bool> > filter, Expression <Func <TEntity, TResult> > selector) { var list = PrepareSet().Where(filter); int recordsTotal = list.Count(); #region Order By var i = 0; foreach (var sorter in sorters) { i++; list = sorter.Sort(list, i > 1); } #endregion #region ModelViewReturn var listToShow = list.Skip(dtParams.Start).Take(dtParams.Length).Select(selector).ToList(); DT_ViewList <TResult> ModelViewReturn = new DT_ViewList <TResult>(); ModelViewReturn.draw = dtParams.Draw + 1; ModelViewReturn.recordsFiltered = listToShow.Count(); ModelViewReturn.recordsTotal = recordsTotal; ModelViewReturn.data = listToShow; #endregion return(ModelViewReturn); }
public JsonResult GetTableList(int AreaId, DataTableParameters dataTableParameters) { var urlTopic = Url.RouteUrl("AnswerList", new { id = 0 }); urlTopic = urlTopic.Remove(urlTopic.Length - 1); Expression <Func <Database.ForumTopic, bool> > filter = null; if (AreaId > 0) { filter = x => x.Active && x.CategoryId == AreaId; } else { var searchText = Session["SearchText"].ToString(); filter = x => x.Active && (x.Name.Contains(searchText) || x.ForumAnswers.Any(y => y.Active && y.Answer.Contains(searchText))); } var list = _crudRepository.GetTableRows(dataTableParameters, _crudRepository.GetSorters(dataTableParameters), filter, x => new TableRowModel() { Replies = x.Replies, Views = x.Views, Voicer = x.User.Nickname, TopicDate = x.StartDate, TopicName = x.Name, TopicURL = urlTopic + x.Id }); return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult GetIcons(DataTableParameters dataTableParameters) { using (var db = new ZapContext()) { var icons = db.Icons.OrderByDescending(i => i.Id).Skip(dataTableParameters.Start).Take(dataTableParameters.Length) .ToList(); var values = icons.Select(i => new DataItem() { Icon = i.Icon, Graphic = i.Icon, Id = i.Id, }).ToList(); int numrec = db.Icons.Count(); var ret = new { draw = dataTableParameters.Draw, recordsTotal = numrec, recordsFiltered = numrec, data = values }; return(Json(ret)); } }
public JsonResult GetCourseById(DataTableParameters dataTableParameters, int ID) { COURSE course = new COURSE(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = course.GetCourseByID(ID, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = course.GetCount(ID); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<img src='" + i.PICTURE + "' class='img-rounded' height='100' width='100' alt='X' />"); columns.Add(i.EMP_ID == null ? "" : i.EMP_ID.Trim()); columns.Add(i.EMP_NAME == null ? "" : i.EMP_NAME.Trim()); columns.Add(i.DEPARTMENT == null ? "" : i.DEPARTMENT.Trim()); columns.Add(i.COURSE.Trim()); columns.Add(i.TEACHER == null ? "" : i.TEACHER.Trim()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <Company>(_db); var items = repo.GetItemsByExpression(w => w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal) .Select(s => new { s.CompanyId, s.Logo, s.Name, s.Cnpj }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsCompany(); foreach (var item in items) { dtResult.data.Add(new object[] { item.Name, item.Cnpj, buttons.ToPagination(item.CompanyId, Account.Current.Roles) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public override List <Sorter <Whisper> > GetSorters(DataTableParameters dtParams) { List <Sorter <Whisper> > list = new List <Sorter <Whisper> >(); if (dtParams.Order != null) { foreach (var orderItem in dtParams.Order) { Sorter <Whisper> sorter = Sorter <Whisper> .Get(x => x.DateSent, false); bool asc = (orderItem.Dir == "asc"); if (orderItem.Column == 0) { list.Add(Sorter <Whisper> .Get(x => x.Id, asc)); } else if (orderItem.Column == 1) { list.Add(Sorter <Whisper> .Get(x => x.DateSent, asc)); } } } if (list.Count == 0) { list.Add(Sorter <Whisper> .Get(x => x.DateSent, false)); } return(list); }
public JsonResult GetIdea(DataTableParameters dataTableParameters, string div, string dep) { IdeaManager idea = IdeaManager.GetInstance(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = idea.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, div, dep); resultSet.recordsTotal = resultSet.recordsFiltered = idea.GetCount(div, dep); foreach (var i in lst) { var columns = new List <string>(); columns.Add(i.ROWNUM.ToString()); columns.Add((i.DIVISION == null) ? "" : i.DIVISION.Trim()); columns.Add((i.DEPARTMENT == null) ? "" : i.DEPARTMENT.Trim()); columns.Add((i.EMP_NAME == null) ? "" : i.EMP_NAME.Trim()); columns.Add("<a class='title' href='#' id='" + i.ID + "' data-emp='" + i.EMP_ID.Trim() + "'>" + i.IDEA_TITLE.Trim() + "</a>"); columns.Add((i.DATE == null) ? "" : i.DATE.ToShortDateString()); columns.Add("<a href='#' class='rep' title='Reply' data-id='" + i.ID + "' data-trigger='focus'><span class='badge badge-pill badge-primary'>" + i.REP.ToString() + "</span></a>"); columns.Add("<a href='#' class='like' title='Like' data-id='" + i.ID + "' data-table='1' data-trigger='focus'><span class='badge badge-pill badge-primary'>" + i.L.ToString() + "</span></a>"); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetEmployee(DataTableParameters dataTableParameters) { EMPLOYEE cus = new EMPLOYEE(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = cus.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = cus.GetCount(dataTableParameters.Search.Value); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.EMP_ID.Trim() + "' />"); columns.Add(i.EMP_NAME.Trim()); columns.Add(i.EMP_ID.Trim()); columns.Add(i.C_ID == null ? "" : i.C_ID.Trim()); columns.Add(i.CUST_NAME == null ? "" : i.CUST_NAME.Trim()); columns.Add(i.EMP_MOBILE == null ? "" : i.EMP_MOBILE.Trim()); columns.Add(i.EMP_EMAIL == null ? "" : i.EMP_EMAIL.Trim()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public async Task <IActionResult> DataHandler(DataTableParameters model) { var start = Convert.ToInt32(HttpContext.Request.Form["start"].FirstOrDefault()); var length = Convert.ToInt32(HttpContext.Request.Form["length"].FirstOrDefault()); List <Message> messages; long total; total = await _messages.Find(Message => true).CountDocumentsAsync(); messages = await _messages.Find(Message => true).Sort(new MongoDB.Bson.BsonDocument("MessageDate", -1)).Skip(start).Limit(length).ToListAsync(); var newData = messages.Select(m => new[] { "<div class=\"row align-items-center justify-content-center mt-3\">" + "<span style=\"color:Orange;\">" + HttpUtility.HtmlEncode(m.SenderName) + "</span>" + " " + "<span style=\"color:DarkBlue;\">" + HttpUtility.HtmlEncode(m.Email) + "</span>" + " " + "<span style=\"color:BurlyWood;\">" + HttpUtility.HtmlEncode(m.MessageDate) + "</span>" + "</div>" + "<div class=\"row align-items-center justify-content-center mt-3\">" + "<div>" + DisplaySmiles(HttpUtility.HtmlEncode(m.MessageText)) + "</div>" + "</div>" }).ToList(); var result = new { aaData = newData, iTotalDisplayRecords = total, iTotalRecords = total }; return(Json(result)); }
//Search based on param.Search only. //TODO: can add each search for individual columns public virtual IQueryable <OperationSummaryProvider> GetSearchResult(DataTableParameters param, List <OperationSummaryProvider> list) { string search = param.Search.Value; return(list.AsQueryable().Where(p => (search == null || p.Provider != null && p.Provider.ToLower().Contains(search.ToLower())))); }
public JsonResult GetVisit(DataTableParameters dataTableParameters, string from, string to, string cus_id, string emp_id) { VIST_CONTACTOR vit = new VIST_CONTACTOR(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = vit.GetVisit(from, to, cus_id, emp_id, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = vit.GetCountVisit(from, to, cus_id, emp_id); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' data-emp='" + i.EMP_ID + "' />"); columns.Add(i.CONTACT_DATE.ToShortDateString()); columns.Add(i.CUSTOMER_ID.ToString()); columns.Add(i.CUS_NAME.ToString()); columns.Add(i.CUST_VIST_TYPE == null ? "" : i.CUST_VIST_TYPE); columns.Add(i.CUST_VIST_PURPOSE == null ? "" : i.CUST_VIST_PURPOSE); columns.Add(i.VIST_REMARK == null ? "" : i.VIST_REMARK); columns.Add(i.EMP_NAME == null? "":i.EMP_NAME); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetTableList(string Type, DataTableParameters dtParams) { Expression <Func <Whisper, bool> > filter = x => true; Expression <Func <Whisper, WhisperRowModel> > selector = null; if (Type == "INBOX") { filter = x => x.UserReceiverId == this._userID && !x.DeleteReceiver; selector = x => new WhisperRowModel() { Id = x.Id, Date = x.DateSent, Message = x.Title, VoicerId = x.UserSenderId, VoicerName = x.User1.Nickname }; } else if (Type == "SENT") { filter = x => x.UserSenderId == this._userID && !x.DeleteSender; selector = x => new WhisperRowModel() { Id = x.Id, Date = x.DateSent, Message = x.Title, VoicerId = x.UserReceiverId, VoicerName = x.User1.Nickname }; } var list = _crudRepository.GetTableRows(dtParams, _crudRepository.GetSorters(dtParams), filter, selector); return(Json(list, JsonRequestBehavior.AllowGet)); }
public JsonResult GetVisit(DataTableParameters dataTableParameters, string from) { VIST_CONTACTOR vit = new VIST_CONTACTOR(); EMPLOYEE em = new EMPLOYEE(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = vit.SelectPaging(from, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = em.GetCount(); foreach (var i in lst) { var columns = new List <string>(); var tar = i.tar == null ? 0 : i.tar; var Ratio = tar == 0 ? 0 : Math.Round(Convert.ToDouble(i.result) / i.tar * 100, 2, MidpointRounding.ToEven).ToString(); columns.Add("<a href='#' class='emp' data-emid='" + i.EMP_ID + "'>" + i.EMP_ID + "</a>"); columns.Add(i.EMP_NAME.Trim()); columns.Add(tar.ToString()); columns.Add(i.result.ToString()); columns.Add(i.dir.ToString()); columns.Add(i.ca.ToString()); columns.Add(i.email.ToString()); columns.Add(Ratio.ToString()); columns.Add(i.EMP_DEPT == null ? "" : i.EMP_DEPT.Trim()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <Event>(_db); var items = repo.GetItemsByExpression(w => w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal, i => i.Address.City) .Select(s => new { s.EventId, s.Name, s.StartDate, s.EndDate, s.Address.City }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsEvent(); foreach (var item in items) { dtResult.data.Add(new object[] { item.Name, $"{(item.StartDate == item.EndDate ? item.StartDate.ToString("dd/MM/yyyy HH:mm") : $"{item.StartDate:dd/MM/yyyy HH:mm} - {item.EndDate:dd/MM/yyyy HH:mm}")}", item.City.Name, buttons.ToPagination(item.EventId, Account.Current.Roles) });
public JsonResult GetCustomer(DataTableParameters dataTableParameters) { CUSTOMER cus = new CUSTOMER(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = cus.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = cus.GetCount(dataTableParameters.Search.Value); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' />"); columns.Add(i.ID); columns.Add(i.NAME); columns.Add(i.LOCATION == null ? "" : i.LOCATION.Trim()); columns.Add(i.EMP_NAME == null ? "" : i.EMP_NAME); columns.Add(i.TYPE == null ? "": i.TYPE); columns.Add("<a href='#' class='end' title='End User' id='" + i.ID + "'><span class='badge badge-pill badge-primary'>" + i.NUM_END + "</span></a>"); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult Returndata(DataTableParameters request) { var filteredData = String.IsNullOrWhiteSpace(request.Search?.Value) ? _repository.GetDishes(request.Start, request.Length) : _repository.GetDishes(request.Search.Value, request.Start, request.Length); switch (request.Order[0]?.Column) { case 1: filteredData = request.Order[0]?.Dir == "asc" ? filteredData.OrderBy(x => x.Name) : filteredData.OrderByDescending(x => x.Name); break; case 2: filteredData = request.Order[0]?.Dir == "asc" ? filteredData.OrderBy(x => x.Tuppers) : filteredData.OrderByDescending(x => x.Tuppers); break; case 3: filteredData = request.Order[0]?.Dir == "asc" ? filteredData.OrderBy(x => x.Type) : filteredData.OrderByDescending(x => x.Type); break; case 4: filteredData = request.Order[0]?.Dir == "asc" ? filteredData.OrderBy(x => x.Consistency) : filteredData.OrderByDescending(x => x.Consistency); break; default: filteredData = filteredData.OrderByDescending(x => x.Name); break; } return(Json(new DataTablesResponse(request.Draw, filteredData, _repository.GetDishesCount(), filteredData.Count()))); }
public override List <Sorter <ForumAnswer> > GetSorters(DataTableParameters dataTableParameters) { List <Sorter <ForumAnswer> > list = new List <Sorter <ForumAnswer> >(); if (dataTableParameters.Order != null) { foreach (var orderItem in dataTableParameters.Order) { Sorter <ForumAnswer> sorter = Sorter <ForumAnswer> .Get(x => x.Id, true); bool asc = (orderItem.Dir == "asc"); if (orderItem.Column == 0) { list.Add(Sorter <ForumAnswer> .Get(x => x.Id, asc)); } else if (orderItem.Column == 1) { list.Add(Sorter <ForumAnswer> .Get(x => x.TopicId, asc)); } } } if (list.Count == 0) { list.Add(Sorter <ForumAnswer> .Get(x => x.Id, true)); } return(list); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <User>(_db); var items = repo.GetItemsByExpression(w => string.Concat(w.FirstName, " ", w.LastName).Contains(search), x => x.FirstName, parameters.Start, parameters.Length, out var recordsTotal) .Select(s => new { s.UserId, s.FullName, s.Cpf, s.IsActive }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttonsUser = new ButtonsUser(); foreach (var item in items) { dtResult.data.Add(new[] { item.UserId.ToString(), item.FullName, item.Cpf, $"{(item.IsActive ? "Ativado" : "Desativado")}", buttonsUser.ToPagination(item.UserId, item.IsActive) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> GetAlertsTable([System.Web.Http.FromBody] DataTableParameters dataTableParameters) { var userId = User.Identity.GetUserId(); if (userId == null) { return(RedirectToAction("Index", "Home")); } using (var db = new ZapContext()) { var sorts = dataTableParameters.Order; var pageUserAlertsQS = db.Users .Where(u => u.AppId == userId) .SelectMany(u => u.Alerts) .Include(m => m.PostLink) .Include(m => m.CommentLink) .Where(m => !m.IsDeleted); // Build our query and ensure default sort order IOrderedQueryable <UserAlert> pageUserAlertsQ = pageUserAlertsQS.OrderByDescending(m => m.TimeStamp); foreach (var s in sorts) { if (s.Dir == "asc") { if (dataTableParameters.Columns[s.Column].Name == "Date") { pageUserAlertsQ = pageUserAlertsQS.OrderBy(q => q.TimeStamp ?? DateTime.UtcNow); } } else { if (dataTableParameters.Columns[s.Column].Name == "Date") { pageUserAlertsQ = pageUserAlertsQS.OrderByDescending(q => q.TimeStamp ?? DateTime.UtcNow); } } } var pageUserAlerts = await pageUserAlertsQ .Skip(dataTableParameters.Start) .Take(dataTableParameters.Length) .ToListAsync(); List <AlertDataItem> values = GetAlertDataItems(pageUserAlerts); int numrec = await pageUserAlertsQ.CountAsync(); return(Json(new { draw = dataTableParameters.Draw, recordsTotal = numrec, recordsFiltered = numrec, data = values })); } }
public LessonFilterModel(DataTableParameters dataTableParameters) : base(dataTableParameters) { if (dataTableParameters.Search?.Value?.Length > 0) { Term = dataTableParameters.Search.Value; } }
public QuestionAnswerFilterModel(DataTableParameters dataTableParameters) : base(dataTableParameters) { if (dataTableParameters.Search?.Value?.Length > 0) { Term = dataTableParameters.Search.Value; } }
//Search based on param.Search only. //TODO: can add each search for individual columns public override IQueryable <TopPlayerInfoST> GetSearchResult(DataTableParameters param, List <TopPlayerInfoST> list) { string search = param.Search.Value; return(list.AsQueryable().Where(p => (search == null || p.PlayerName != null && p.PlayerName.ToLower().Contains(search.ToLower()) || p.Telofono != null && p.Telofono.ToLower().Contains(search.ToLower()) || p.Email != null && p.Email.ToLower().Contains(search.ToLower()) || p.Celular != null && p.Celular.ToLower().Contains(search.ToLower())))); }
public DataViewModel(int RTdevID, string RTdevType, TemperatureCondition RTtemperatureCondition, int TMdevID, string TMdevType, TemperatureCondition TMtemperatureCondition) : base() { SqlConnection Connection = CreateConnection(); this.RT = new DataTableParameters(); this.RT.Load(Connection, RTdevID, RTdevType, RTtemperatureCondition); this.TM = new DataTableParameters(); this.TM.Load(Connection, TMdevID, TMdevType, TMtemperatureCondition); }
/*Get List for jQueryDataTable*/ public virtual List <OperationSummaryProvider> GetDataTableResultByPage(DataTableParameters param, List <OperationSummaryProvider> list) { if (param.Length == -1) { return(GetSearchResult(param, list).SortBy(param.SortOrder).ToList()); } else { return(GetSearchResult(param, list).SortBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList()); } }
/*Get List for jQueryDataTable*/ public override List <SlotOccupationST> GetDataTableResultByPage(DataTableParameters param, List <SlotOccupationST> list) { if (param.Length == -1) { return(GetSearchResult(param, list).SortBy(param.SortOrder).ToList()); } else { return(GetSearchResult(param, list).SortBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList()); } }
public void Data(object parameters, string css, int tipo) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); EstadisticosAfiliados Datos = new EstadisticosAfiliados(); Datos.Start = req.Start; Datos.Length = req.Length; Datos.SearchValue = req.SearchValue; Datos.OrderBy = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { Datos.OrderBy = req.Order[aux].Column; Datos.OrderDirection = req.Order[aux].Direction; } } Datos.Conexion = Comun.Conexion; Datos.TipoLista = tipo; EstadisticosAfiliados_Negocio neg = new EstadisticosAfiliados_Negocio(); neg.ObtenerEvaluacionAJAX(Datos); resultSet.draw = req.Draw; resultSet.recordsTotal = Datos.RecordTotal; resultSet.recordsFiltered = Datos.RecordFilter; foreach (EstadisticosRepresentantesSeccion Item in Datos.Lista) { var columns = new List <string>(); string ColImagen = string.Empty, ColAvance = string.Empty; if (!string.IsNullOrEmpty(Item.Imagen)) { ColImagen = @"<a href='#' class='thumb-sm m-r'><img class='r r-2x' src='data:image/jpg;base64," + Item.Imagen + @"' /></a>"; } else { ColImagen = @"<a href='#' class='thumb-sm m-r'><img class='r r-2x' src='img/anonymous.jpg'/></a>"; } ColAvance = @"<div class='progress'> <div class='progress-bar " + css + @"' role='progressbar' aria-valuenow='" + Item.Avance + @"' aria-valuemin='0' aria-valuemax='100' style='width: " + Item.Avance + @"%'> <span class=''>" + Item.Avance + @"%</span> </div> </div>"; columns.Add(ColImagen); columns.Add(Item.Seccion.ToString()); columns.Add(Item.Nombre); columns.Add(ColAvance); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public Task <Result <object> > List(DataTableParameters dtParameters) => Result <object> .TryAsync(async() => { var searchBy = dtParameters.Search?.Value; var orderCriteria = string.Empty; var orderAscendingDirection = true; if (dtParameters.Order != null) { orderCriteria = dtParameters.Columns[dtParameters.Order[0].Column].Data; orderAscendingDirection = dtParameters.Order[0].Dir.ToString().ToLower() == "asc"; } else { orderCriteria = "Id"; orderAscendingDirection = true; } var pagingModel = new PagingModel() { PageNumber = dtParameters.Start == 0 ? 0 : dtParameters.Start / dtParameters.Length, PageSize = dtParameters.Length, Sort = orderCriteria, SortDirection = orderAscendingDirection ? SortDirection.ASC : SortDirection.DESC }; var resultList = await _repository.SortedPageListAsNoTrackingAsync <Supplier>(s => searchBy == null || (s.CompanyName != null && s.CompanyName.Contains(searchBy)) || (s.ContactName != null && s.ContactName.Contains(searchBy)) || (s.EmergencyMobile != null && s.EmergencyMobile.Contains(searchBy)) || (s.Phone != null && s.Phone.Contains(searchBy)) || (s.Address != null && s.Address.Contains(searchBy)) || (s.City != null && s.City.Contains(searchBy)) || (s.PostalCode != null && s.PostalCode.Contains(searchBy)), pagingModel); if (!resultList.Success) { return(Result <object> .Failed(Error.WithCode(ErrorCodes.SuppliersNotFound), "Some thing went wrong!")); } var totalFilteredCount = resultList.TotalCount; var totalCount = (await _repository.CountAllAsync <Supplier>()).Data; var supplierModels = _mapper.Map <IEnumerable <SupplierModel> >(resultList.Items); return(Result <object> .Successful(new { draw = dtParameters.Draw, recordsTotal = totalCount, recordsFiltered = totalFilteredCount, data = supplierModels })); });
public AnswerFilterModel(DataTableParameters dataTableParameters) : base(dataTableParameters) { if (dataTableParameters.Search?.Value?.Length > 0) { Term = dataTableParameters.Search.Value; } if (dataTableParameters.Search?.Value?.Length > 0) { RepositoryTerm = dataTableParameters.Search.Value; } }
public void Data(object parameters) { //Read paramater from datatable along with additional parms var req = DataTableParameters.Get(parameters); QuerySP query = new QuerySP(); DataTable table = query.QueryData(); DataView dv = table.DefaultView; //dv.Sort = "ID DESC"; foreach (var col in req.Columns) { if (req.Order.ContainsKey(col.Key)) { dv.Sort = table.Columns[req.Order[col.Key].Column].ToString() + " " + req.Order[col.Key].Direction; } } table = dv.ToTable(); var resultSet = new DataTableResultSet(); resultSet.draw = req.Draw; resultSet.recordsTotal = table.Rows.Count; resultSet.recordsFiltered = table.Rows.Count; foreach (DataRow recordFromDb in table.Select().Skip(req.Start).Take(req.Length)) { //var columns = new List<string>(); // Working var columns = new List <string>(); foreach (DataColumn col in table.Columns) { //columns.Add(recordFromDb[col.ColumnName].ToString()); - Working //columns.Add(recordFromDb[col.ColumnName] as LiteralControl); //columns.Add(((LiteralControl)recordFromDb[col.ColumnName]).Text); columns.Add(recordFromDb[col.ColumnName].ToString()); } //columns.Add("<a href='https://google.com'>Link</a>"); //columns.Add(recordFromDb[0].ToString()); //columns.Add(recordFromDb[1].ToString()); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public ActionResult GetSpendingEvents(DataTableParameters dataTableParameters) { var userId = User.Identity.GetUserId(); using (var db = new ZapContext()) { User u; u = db.Users .Include(usr => usr.LNTransactions) .Include(usr => usr.SpendingEvents) .Include(usr => usr.SpendingEvents.Select(s => s.Post)) .Include(usr => usr.SpendingEvents.Select(s => s.Group)) .Include(usr => usr.SpendingEvents.Select(s => s.Comment)) .Include(usr => usr.SpendingEvents.Select(s => s.Comment).Select(c => c.Post)) //.Where(usr => usr.Name == "renepickhardt").First(); //Debug issue observed by this user .Where(us => us.AppId == userId).First(); var pageSpendings = u.SpendingEvents .OrderByDescending(e => e.TimeStamp) .Skip(dataTableParameters.Start) .Take(dataTableParameters.Length) .ToList(); var values = pageSpendings.Select(t => new DataItem() { Time = t.TimeStamp.Value.ToString("yyyy-MM-dd HH:mm:ss"), Type = t.Post != null ? "Post " + t.Post.PostId.ToString() : ( t.Comment != null ? "Comment " + t.Comment.CommentId.ToString() : ( t.Group != null ? "Group " + t.Group.GroupId.ToString() : "Other")), Amount = Convert.ToString(t.Amount), URL = t.Post != null ? Url.Action("Detail", "Post") + "/" + Convert.ToString(t.Post.PostId) : ( t.Comment != null ? Url.Action("Detail", "Post") + "/" + t.Comment.Post.PostId.ToString() : ( t.Group != null ? Url.Action("Index", "Group") : "")), }).ToList(); int numrec = u.SpendingEvents.Count(); var ret = new { draw = dataTableParameters.Draw, recordsTotal = numrec, recordsFiltered = numrec, data = values }; return(Json(ret)); } }
public JsonResult GetProducts(DataTableParameters param) { baioEntities db = new baioEntities(); //string CategoryType = param.pageType; //IEnumerable<sp_ProductGetAllbyPaging_Result> data = db.sp_ProductGetAllbyPaging(1, param.iDisplayLength, 0,false).ToList(); IEnumerable<sp_ProductGetAllbyPaging_Result> data = db.sp_ProductGetAllbyPaging((param.iDisplayStart / param.iDisplayLength) + 1, param.iDisplayLength, 0, false,1).ToList(); string sKey; if (!string.IsNullOrEmpty(param.sSearch)) { sKey = param.sSearch.ToLower(); data = data.Where(x => !string.IsNullOrEmpty(x.Name) ? x.Name.ToLower().Contains(sKey) : true); } var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]); Func<sp_ProductGetAllbyPaging_Result, string> orderingFunction = (p => sortColumnIndex == 1 ? p.Name : sortColumnIndex == 2 ? p.Stock.ToString() : p.Price.ToString()); var pagedData = data.OrderBy(x => x.Rank); var sortDirection = Request["sSortDir_0"]; if (sortDirection == "asc") pagedData = pagedData.OrderBy(orderingFunction); else pagedData = pagedData.OrderByDescending(orderingFunction); //string CacheKey = CategoryType + param.iDisplayLength + param.iDisplayStart + param.sSearch + param.iDisplayLength + sortColumnIndex + sortDirection; //var _Context = System.Web.HttpContext.Current; //var PageCache = _Context.Cache.Get(CacheKey) as List<sp_GetPagesLite_Result>; var lastData = new List<sp_ProductGetAllbyPaging_Result>(); //if (PageCache == null) //if (true) //{ lastData = pagedData // .Skip(param.iDisplayStart / param.iDisplayLength * param.iDisplayLength) //.Take(param.iDisplayLength) .Select(x => new sp_ProductGetAllbyPaging_Result { ImageSrc = x.ImageSrc, Total = x.Total, ID = x.ID, Name = x.Name, IsActive = x.IsActive, Stock = x.Stock, OrderCount = x.OrderCount, Variant = x.Variant, Price = x.Price }).ToList(); //_Context.Cache.Add(CacheKey, lastData, null, System.Web.Caching.Cache.NoAbsoluteExpiration, new TimeSpan(6, 0, 0), System.Web.Caching.CacheItemPriority.Default, null); //} //else //{ // lastData = PageCache; //} return Json(new { sEcho = param.sEcho, iTotalRecords = data.Count(), iTotalDisplayRecords = data.FirstOrDefault() != null ? data.FirstOrDefault().Total : 0, aaData = lastData }, JsonRequestBehavior.AllowGet); }