public JQueryDataTableResponse GetAll(string search, int?sortColumn, string sortOrder, int skip, int take, string sEcho) { int total, filtered; List <Tag> tags = _tagDAL.GetAll(search, sortColumn, sortOrder, skip, take, DeleteFlag.Active, out total, out filtered); IEnumerable <string[]> data = new List <string[]>(); if (tags != null) { int i = skip + 1; data = from t in tags let index = i++ select new[] { index.ToString(), t.Content, t.GrammarTags.Count.ToString(), t.Id.ToString(), t.Id.ToString(), t.Id.ToString() }; } JQueryDataTableResponse response = new JQueryDataTableResponse() { sEcho = sEcho, iTotalRecords = total, iTotalDisplayRecords = filtered, aaData = data }; return(response); }
public ActionResult LoadPlayersToAssociate(JQueryDataTableRequest jqueryTableRequest, string teamId, int count, int workerTypeId) { if (jqueryTableRequest != null) { TeamEngineDTO team = TeamEngineService.Instance.GetById(teamId); List <string> externalIds = GetWorkersOnTeamCache(); externalIds.Add(team.MasterPlayerId); List <WorkerDTO> workers = WorkerRepository.Instance.GetUserProfileByWorkerTypeIdExceptWhenOnListOfExternalIds(externalIds, workerTypeId, jqueryTableRequest.Page); JQueryDataTableResponse response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = count, RecordsFiltered = count, Data = workers.Select(r => new string[] { r.ExternalId, r.Name, r.Email }).ToArray() }; return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
// // GET: /Tag/IndexAjax public ActionResult IndexAjax(JQueryDataTableRequest request) { JQueryDataTableResponse response = _tagBLL.GetAll(request.sSearch, request.iSortCol_0, request.sSortDir_0 , request.iDisplayStart, request.iDisplayLength, request.sEcho); return(Json(response, JsonRequestBehavior.AllowGet)); }
public JQueryDataTableResponse GetAll(string search, int?sortColumn, string sortOrder, int skip, int take, string sEcho) { int total, filtered; List <Grammar> grammars = _grammarDAL.GetAll(search, sortColumn, sortOrder, skip, take, DeleteFlag.Active, out total, out filtered); IEnumerable <string[]> data = new List <string[]>(); if (grammars != null) { int i = skip + 1; data = from g in grammars let index = i++ select new[] { index.ToString(), g.Content, string.Join(", ", g.GrammarTags.Select(gm => gm.Tag.Content).ToArray()), g.Id.ToString(), g.Id.ToString(), g.Id.ToString() }; } JQueryDataTableResponse response = new JQueryDataTableResponse() { sEcho = sEcho, iTotalRecords = total, iTotalDisplayRecords = filtered, aaData = data }; return(response); }
public ActionResult SearchMetricResults(JQueryDataTableRequest jqueryTableRequest, string metricId, string episodeId, string teamId, string playerId) { if (jqueryTableRequest != null) { GetAllDTO all = new GetAllDTO(); if (playerId != "" && playerId != "empty") { RunEngineDTO run = RunEngineService.Instance.GetRunByPlayerAndTeamId(playerId, teamId); all = RunMetricEngineService.Instance.findByRunIdAndMetricId(run.Id, metricId, jqueryTableRequest.Page); } else if (teamId != "" && teamId != "empty" && teamId != "null") { all = TeamEngineService.Instance.resultsByTeamIdAndMetricId(teamId, metricId, jqueryTableRequest.Page); } else { all = EpisodeEngineService.Instance.resultsByEpisodeIdAndMetricId(episodeId, metricId, jqueryTableRequest.Page); } List <WorkerDTO> workers = all.List == null ? new List <WorkerDTO>() : WorkerRepository.Instance.GetWorkerDTOByListExternalId(all.List.runMetric.Select(i => i.PlayerId).ToList()); GetAllDTO itens = ItemEngineService.Instance.GetByGameId(CurrentFirm.ExternalId, 0, 1000); if (all.List != null) { foreach (RunMetricEngineDTO rm in all.List.runMetric) { DateTime dat = new DateTime(rm.Date); string ds = dat.ToString("dd/MM/yyyy"); } } else { all.List = new GetAllDTO.Embedded(); all.List.runMetric = new List <RunMetricEngineDTO>(); } JQueryDataTableResponse response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = (from runMetric in all.List.runMetric join worker in workers on runMetric.PlayerId equals worker.ExternalId into runMetricWorker from rmw in runMetricWorker.DefaultIfEmpty() select new { Date = new DateTime(runMetric.Date), WorkerName = rmw != null ? rmw.Name : "Jogador excluído", Email = rmw != null ? rmw.Email : "", Result = runMetric.Points, RunMetricId = runMetric.Id, ItemName = itens.List == null ? "" : (itens.List.item.Where(q => q.Id == runMetric.ItemId).Select(x => x.Name)).FirstOrDefault() }). Select(r => new string[] { r.Date.ToString("dd/MM/yyyy"), r.WorkerName, r.Email, r.ItemName, r.Result.ToString(), r.RunMetricId }).ToArray() }; return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchPlayers(JQueryDataTableRequest jqueryTableRequest, string episodeId, string metricId) { GetAllDTO all; if (jqueryTableRequest != null) { all = RunEngineService.Instance.ScoreByEpisodeIdAndMetricId(episodeId, metricId == "empty" ? "" : metricId, jqueryTableRequest.Page); foreach (RunEngineDTO run in all.List.run) { try { run.LogoId = PlayerEngineService.Instance.GetById(run.PlayerId).LogoId; } catch (Exception e) { run.LogoId = 0; } } int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.run.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.PlayerName + ";" + t.LogoId + ";" + t.PlayerId + ";" + t.TeamId, t.TeamName, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.run.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.PlayerName + ";" + t.LogoId + ";" + t.PlayerId + ";" + t.TeamId, t.TeamName, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search() { LinqTable optHelper = new LinqTable(); var result = optHelper.BlogHelper(); result = result.Where(x => x.Categore == "成品展覽"); int totalLen = Convert.ToInt16(result.Count()); JQueryDataTableResponse <ArticleViewModel> jqDataTableRs = JQueryDataTableHelper <ArticleViewModel> .GetResponse(1, totalLen, totalLen, result.ToList()); return(Json(jqDataTableRs)); }
public ActionResult Search() { var Emp = EmployeePageService.GetAll(); var result = (from emp in Emp select new Employee { Name = emp.Name, Account = emp.Account }).ToList(); int totalLen = Convert.ToInt16(result.Count()); JQueryDataTableResponse <Employee> jqDataTableRs = JQueryDataTableHelper <Employee> .GetResponse(1, totalLen, totalLen, result.ToList()); return(Json(jqDataTableRs)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId) { if (jqueryTableRequest != null) { List <string> externalIds = new List <string>(); GetAllDTO all = TeamEngineService.Instance.FindByEpisodeIdAndGameId(episodeId, CurrentFirm.ExternalId, jqueryTableRequest.Page); externalIds.AddRange((from team in all.List.team where team.MasterPlayerId != null select team.MasterPlayerId).ToList()); List <WorkerDTO> sponsors = WorkerRepository.Instance.GetWorkerDTOByListExternalId(externalIds); int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.team.Select(t => new string[] { t.Nick + ";" + t.LogoId, (t.MasterPlayerId == null ? "Não há responsável por essa equipe." : sponsors.Find(w => w.ExternalId == t.MasterPlayerId) != null ? sponsors.Find(w => w.ExternalId == t.MasterPlayerId).Name : ""), t.Id }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.team.Select(t => new string[] { t.Nick + ";" + t.LogoId, (t.MasterPlayerId == null ? "Não há responsável por essa equipe." : sponsors.Find(w => w.ExternalId == t.MasterPlayerId) != null ? sponsors.Find(w => w.ExternalId == t.MasterPlayerId).Name : ""), t.Id }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchWorkeTypesToAssociate(JQueryDataTableRequest jqueryTableRequest, string metricId, int NumberOfFunctionsToAssociate) { if (jqueryTableRequest != null) { string filter = ""; string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None); filter = searchTerms[0]; List <WorkerTypeEntity> searchResult = null; searchResult = WorkerTypeMetricRepository.Instance.GetAllToAssociate(metricId, CurrentFirm.ExternalId, jqueryTableRequest.Page, 10); int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = NumberOfFunctionsToAssociate, RecordsFiltered = NumberOfFunctionsToAssociate, Data = searchResult.Select(r => new string[] { r.Id.ToString(), r.TypeName }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = NumberOfFunctionsToAssociate, RecordsFiltered = NumberOfFunctionsToAssociate, Data = searchResult.Select(r => new string[] { r.Id.ToString(), r.TypeName }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string teamId) { if (jqueryTableRequest != null) { TeamEngineDTO team = TeamEngineService.Instance.GetById(teamId); GetAllDTO all = RunEngineService.Instance.GetRunsByTeamId(teamId); List <string> externalIds = all.List.run.Select(x => x.PlayerId).Where(q => q != team.MasterPlayerId).Skip(10 * jqueryTableRequest.Page).Take(10).ToList(); List <WorkerDTO> workers = WorkerRepository.Instance.GetDTOFromListExternalId(externalIds); int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.List.run.Count() - 1, RecordsFiltered = all.List.run.Count() - 1, Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId, r.Email, r.WorkerTypeName, r.ExternalId }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.List.run.Count() - 1, RecordsFiltered = all.List.run.Count() - 1, Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId, r.Email, r.WorkerTypeName, r.ExternalId }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(string Lang) { var blog = BloggerService.GetAll(); var articles = ArticleService.GetAll(); LinqTable optHelper = new LinqTable(); var result = optHelper.ArtHelper(); result = result.Where(x => x.Categore == "服務頁"); if (!String.IsNullOrEmpty(Lang)) { result = result.Where(i => i.Id == int.Parse(Lang)).ToList(); } int totalLen = Convert.ToInt16(result.Count()); JQueryDataTableResponse <ArticleViewModel> jqDataTableRs = JQueryDataTableHelper <ArticleViewModel> .GetResponse(1, totalLen, totalLen, result.ToList()); return(Json(jqDataTableRs)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest) { int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } if (jqueryTableRequest != null) { string gameId = CurrentFirm.ExternalId; List <ParamEntity> paramList = ParamRepository.Instance.GetAll(gameId, jqueryTableRequest.Page); int count = ParamRepository.Instance.GetCountFromGame(gameId); JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = count, RecordsFiltered = count, Data = paramList.Select(r => new string[] { r.Name, r.Value, r.Description, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = count, RecordsFiltered = count, Data = paramList.Select(r => new string[] { r.Name, r.Value, r.Description, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchPlayersFromTeam(JQueryDataTableRequest jqueryTableRequest, string teamId) { if (jqueryTableRequest != null) { List <string> allExternalWorkerIds = GetWorkersOnTeamCache(); List <string> externalIds = (from externalId in allExternalWorkerIds select externalId).Skip(jqueryTableRequest.Page * 10).Take(10).ToList(); List <WorkerDTO> workers = WorkerRepository.Instance.GetUserProfileByListOfExternalIds(externalIds); int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = allExternalWorkerIds.Count(), RecordsFiltered = allExternalWorkerIds.Count(), Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.ExternalId }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = allExternalWorkerIds.Count(), RecordsFiltered = allExternalWorkerIds.Count(), Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.ExternalId }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult searchWithID(JQueryDataTableRequest jqueryTableRequest) { int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } if (jqueryTableRequest != null) { GetAllDTO all = EpisodeEngineService.Instance.GetByGameId(CurrentFirm.ExternalId, jqueryTableRequest.Page); JQueryDataTableResponse response = null; DateTime dateInit; DateTime dateFinish; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.episode.Select(r => new string[] { r.Id, r.Name, (dateInit = new DateTime(r.initDate)).ToString("dd/MM/yyyy"), (dateFinish = new DateTime(r.finishDate)).ToString("dd/MM/yyyy"), r.XpReward.ToString(), r.Active == true ? "Sim" : "Não", r.sendEmail == true ? "Sim" : "Não", r.Id }).ToArray().ToArray() //.OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.episode.Select(r => new string[] { r.Id, r.Name, (dateInit = new DateTime(r.initDate)).ToString("dd/MM/yyyy"), (dateFinish = new DateTime(r.finishDate)).ToString("dd/MM/yyyy"), r.XpReward.ToString(), r.Active == true ? "Sim" : "Não", r.sendEmail == true ? "Sim" : "Não", r.Id }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest) { int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } if (jqueryTableRequest != null) { GetAllDTO all = MetricEngineService.Instance.GetAllDTOByGame(CurrentFirm.ExternalId, jqueryTableRequest.Page); JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.metric.Select(r => new string[] { r.Icon + ";" + r.Name, r.Multiplier.ToString(), r.Id }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.metric.Select(r => new string[] { r.Icon + ";" + r.Name, r.Multiplier.ToString(), r.Id }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest) { int index = jqueryTableRequest.Page; if (jqueryTableRequest != null) { var all = QuestionService.Instance.GetAllFromFirm(CurrentFirm.Id, jqueryTableRequest.Search, index, jqueryTableRequest.Length); var total = QuestionService.Instance.GetCountFromFirm(CurrentFirm.Id, jqueryTableRequest.Search); JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = total, RecordsFiltered = all.Count(), Data = all.Select(r => new string[] { r.Id.ToString(), r.Question, r.status.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = total, RecordsFiltered = all.Count(), Data = all.Select(r => new string[] { r.Id.ToString(), r.Question, r.status.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string metricId, int numberOfFunctions) { if (jqueryTableRequest != null) { List <WorkerTypeMetricDTO> searchResult = null; searchResult = WorkerTypeMetricRepository.Instance.GetAllDTOFromMetric(metricId, jqueryTableRequest.Page, 10); int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = numberOfFunctions, RecordsFiltered = numberOfFunctions, Data = searchResult.Select(r => new string[] { r.WorkerTypeName, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = numberOfFunctions, RecordsFiltered = numberOfFunctions, Data = searchResult.Select(r => new string[] { r.WorkerTypeName, r.Id.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search() { var a = DateTime.Now.ToString("yyyy-MM-dd"); var contact = ContactService.GetAll(); var result = (from b in contact select new Contact { Id = b.Id, Name = b.Name, Phone = b.Phone, Email = b.Email, Service = b.Service, Time = DBNull.Value.Equals(b.CreateTime) ? "" :ToYMD(b.CreateTime), Memo = b.Memo }).ToList(); int totalLen = Convert.ToInt16(result.Count()); JQueryDataTableResponse <Contact> jqDataTableRs = JQueryDataTableHelper <Contact> .GetResponse(1, totalLen, totalLen, result.ToList()); return(Json(jqDataTableRs)); }
public ActionResult SearchAssociate(JQueryDataTableRequest jqueryTableRequest, int id) { int index = jqueryTableRequest.Page; if (jqueryTableRequest != null) { var association = QuestionAnswerService.Instance.GetByQuestion(id); var all = new List <AnswersEntity>(); foreach (var item in association) { var entity = AnswerService.Instance.GetById(item.IdAnswer); entity.IdAssociate = item.Id; all.Add(entity); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsFiltered = all.Count(), Data = all.Select(r => new string[] { r.Id.ToString(), r.Name, r.Answer, r.status.ToString(), r.IdAssociate.ToString() }).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchAssociate(JQueryDataTableRequest jqueryTableRequest, int id) { int index = jqueryTableRequest.Page; var listAssociated = QuizCampaignService.Instance.getByAssociated(id); var episodeList = new List <EpisodeEngineDTO>(); foreach (var item in listAssociated) { var episode = EpisodeEngineService.Instance.GetById(item.IdCampaign); episode.Id = item.Id.ToString(); episodeList.Add(episode); } DateTime dateInit; DateTime dateFinish; if (jqueryTableRequest != null) { JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsFiltered = episodeList.Count(), Data = episodeList.Select(r => new string[] { r.Id, r.Name, (dateInit = new DateTime(r.initDate)).ToString("dd/MM/yyyy"), (dateFinish = new DateTime(r.finishDate)).ToString("dd/MM/yyyy"), r.XpReward.ToString(), r.Active == true ? "Sim" : "Não", r.sendEmail == true ? "Sim" : "Não", r.Id }).ToArray().ToArray() //.OrderBy(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchCheckIn(JQueryDataTableRequest jqueryTableRequest, string episodeId, string metricId, string teamId, string playerId) { if (jqueryTableRequest != null) { GetAllDTO all = new GetAllDTO(); List <RunEngineDTO> runners = new List <RunEngineDTO>(); if (playerId != "empty") { RunEngineDTO runner = RunEngineService.Instance.GetByEpisodeIdAndPlayerId(episodeId, playerId); runners.Add(runner); } else if (teamId != "empty") { runners = GetRunsByTeamIdRecursive(teamId); } else { all = TeamEngineService.Instance.FindByEpisodeId(episodeId); all.List.team = all.List.team.OrderBy(x => x.Nick).ToList(); List <string> subTeamsNull = all.List.team.Where(x => x.SubOfTeamId == null).Select(x => x.Id).ToList(); List <TeamEngineDTO> teams = new List <TeamEngineDTO>(); foreach (string subTeamNull in subTeamsNull) { teams.AddRange(OrganizeHierarchy(all.List.team, subTeamNull)); } foreach (TeamEngineDTO team in teams) { runners.AddRange(GetRunsByTeamIdRecursive(team.Id)); } } MetricEngineDTO metric = MetricEngineService.Instance.GetById(metricId); List <LocationDTO> locations = MetricEngineService.Instance.MapPointsByRunsAndMetric(runners, metric); List <CheckInDTO> checkIns = new List <CheckInDTO>(); foreach (LocationDTO location in locations) { CheckInDTO ci = new CheckInDTO(); DateTime date = new DateTime(((location.Date - 10800000) * 10000) + 621355968000000000l); ci.Date = date.ToString("dd'/'MM'/'yyyy HH':'mm':'ss"); PlayerEngineDTO player = PlayerEngineService.Instance.GetById(location.PlayerId); ci.PlayerName = player.Nick; ci.Description = location.Description ?? "Check-in"; ci.Place = location.Place; checkIns.Add(ci); } JQueryDataTableResponse response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = locations.Count, RecordsFiltered = locations.Count, Data = checkIns.OrderByDescending(r => DateTime.Parse(r.Date)).Select(r => new string[] { r.Date, r.PlayerName, r.Description, r.Place }).ToArray() }; return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, int numberOfWorkers) { numberOfWorkers = WorkerRepository.Instance.GetCountFromFirm(CurrentFirm.Id); if (jqueryTableRequest != null) { string filter = ""; string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None); filter = searchTerms[0]; List <WorkerDTO> searchResult = null; searchResult = WorkerRepository.Instance.GetAllFromFirm(CurrentFirm.Id, jqueryTableRequest.Page, 10); var searchedQueryList = new List <WorkerDTO>(); searchedQueryList = searchResult; if (!string.IsNullOrWhiteSpace(filter)) { filter = filter.ToLowerInvariant().Trim(); var searchedQuery = from n in searchResult where (n.Cpf != null && n.Cpf.ToLowerInvariant().Trim().Contains(filter)) || n.Name.ToLowerInvariant().Trim().Contains(filter) || n.Email.ToLowerInvariant().Trim().Contains(filter) select n; searchedQueryList = searchedQuery.ToList(); } int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = numberOfWorkers, RecordsFiltered = numberOfWorkers, Data = searchedQueryList.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.WorkerTypeName, r.IdWorker.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = numberOfWorkers, RecordsFiltered = numberOfWorkers, Data = searchedQueryList.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.WorkerTypeName, r.IdWorker.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest) { if (jqueryTableRequest != null) { string filter = ""; string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None); filter = searchTerms[0]; List <VideoEntity> searchResult = null; searchResult = VideoRepository.Instance.GetAllFromFirm(CurrentFirm.Id); var searchedQueryList = new List <VideoEntity>(); searchedQueryList = searchResult; if (!string.IsNullOrWhiteSpace(filter)) { filter = filter.ToLowerInvariant().Trim(); var searchedQuery = from n in searchResult where (n.VideoTitle.ToLowerInvariant().Trim().Contains(filter)) select n; searchedQueryList = searchedQuery.ToList(); } int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count), RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1, Data = searchedQueryList.Select(r => new string[] { r.VideoTitle, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count), RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1, Data = searchedQueryList.Select(r => new string[] { r.VideoTitle, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId, string teamId) { GetAllDTO all; if (jqueryTableRequest != null) { if (teamId != "empty") { all = RunEngineService.Instance.GetRunsByTeamId(teamId); List <PlayerEngineDTO> players = (from run in all.List.run select PlayerEngineService.Instance.GetById(run.PlayerId)).ToList(); all.List.result = (from run in all.List.run from player in players where run.PlayerId == player.Id && player.Active == true select new ResultEngineDTO { Id = player.Id, Nick = player.Nick, Score = run.Score, LogoId = player.LogoId }).ToList(); } else { all = TeamEngineService.Instance.FindByEpisodeIdAndGameId(episodeId, CurrentFirm.ExternalId, jqueryTableRequest.Page, 1000); all.List.result = (from team in all.List.team select new ResultEngineDTO { Id = team.Id, Nick = team.Nick, Score = team.Score, LogoId = team.LogoId }).ToList(); } int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = 1, //all.PageInfo.totalElements, RecordsFiltered = 1, //all.PageInfo.totalElements, Data = all.List.result.OrderBy(t => t.Nick).Select(t => new string[] { t.Id, t.Nick }).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = 1, //all.PageInfo.totalElements, RecordsFiltered = 1, //all.PageInfo.totalElements, Data = all.List.result.OrderByDescending(t => t.Nick).Select(t => new string[] { t.Id, t.Nick }).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, int numberOfQuiz) { string episodeId = Request["episodeId"]; numberOfQuiz = EpisodeQuizEngineService.Instance.GetByEpisodeId(episodeId).List.quizSheet.Count; if (jqueryTableRequest != null) { string filter = ""; string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None); filter = searchTerms[0]; List <EpisodeQuizEngineDTO> searchResult = null; searchResult = EpisodeQuizEngineService.Instance.GetByEpisodeId(episodeId).List.quizSheet; var searchedQueryList = new List <EpisodeQuizEngineDTO>(); searchedQueryList = searchResult; if (!string.IsNullOrWhiteSpace(filter)) { filter = filter.ToLowerInvariant().Trim(); var searchedQuery = from n in searchResult where (n.Title != null && n.Title.ToLowerInvariant().Trim().Contains(filter)) select n; searchedQueryList = searchedQuery.ToList(); } int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = numberOfQuiz, RecordsFiltered = numberOfQuiz, Data = searchedQueryList.Select(r => new string[] { r.Title, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = numberOfQuiz, RecordsFiltered = numberOfQuiz, Data = searchedQueryList.Select(r => new string[] { r.Title, r.Id.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId, string teamId, int workerTypeId = 0) { if (jqueryTableRequest != null) { if (Request["episodeId"] != null && !string.IsNullOrWhiteSpace(Request["episodeId"]) && !Request["episodeId"].Equals("undefined")) { episodeId = Request["episodeId"]; } if (Request["teamId"] != null && !string.IsNullOrWhiteSpace(Request["teamId"]) && !Request["teamId"].Equals("undefined")) { teamId = Request["teamId"]; } if (Request["workerTypeId"] != null && !string.IsNullOrWhiteSpace(Request["workerTypeId"]) && !Request["workerTypeId"].Equals("undefined")) { workerTypeId = int.Parse(Request["workerTypeId"]); } string filter = ""; string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None); filter = searchTerms[0]; List <RankingDTO> searchResult = null; if (episodeId != null && !episodeId.Equals("")) { if (teamId != null && !teamId.Equals("")) { TeamEntity team = TeamRepository.Instance.GetByIdExterno(teamId); WorkerTypeEntity workerType = WorkerTypeRepository.Instance.GetById(team.WorkerTypeId); if (workerType.ProfileName.Equals(Profiles.LIDER)) { List <RankingDTO> rankingDTOList = new List <RankingDTO>(); //List<PlayerRunEntity> playerRunList = PlayerRunRepository.Instance.GetByEpisodeAndTeam(episodeId.ToString(), teamId); GetAllDTO runnersDTO = RunEngineService.Instance.GetRunsByTeamId(teamId); // buscar lista de run ao inves da tabela foreach (RunEngineDTO item in runnersDTO.List.run) { RankingDTO dto = new RankingDTO(); WorkerDTO worker = WorkerRepository.Instance.GetDTOById(item.PlayerId); //run .get player ID dto = EngineBIZ.GetGlobalScoreInEpisodeByEpisodeAndPlayer(episodeId.ToString(), worker.ExternalId); dto.LogoId = worker.LogoId; dto.PlayerId = worker.ExternalId; dto.PlayerName = worker.Name; dto.LogoId = worker.LogoId; rankingDTOList.Add(dto); } searchResult = rankingDTOList; } else { List <RankingDTO> rankingDTOList = new List <RankingDTO>(); GetAllDTO runnersDTO = RunEngineService.Instance.GetRunsByTeamId(teamId); foreach (RunEngineDTO item in runnersDTO.List.run) { RankingDTO dto = new RankingDTO(); WorkerDTO worker = WorkerRepository.Instance.GetDTOById(item.PlayerId); dto = EngineBIZ.GetScoreByRun(item.Id); dto.PlayerName = worker.Name; dto.LogoId = worker.LogoId; rankingDTOList.Add(dto); } searchResult = rankingDTOList; } } else { List <EngineTeamDTO> teamsFromEngine = new List <EngineTeamDTO>(); List <TeamEntity> teams = new List <TeamEntity>(); teamsFromEngine.AddRange(EngineBIZ.GetTeamsByEpisode(episodeId.ToString())); if (workerTypeId > 0) { foreach (EngineTeamDTO item in teamsFromEngine) { TeamEntity team = new TeamEntity(); team = TeamRepository.Instance.GetByIdExterno(item.IdExterno); teams.Add(team); } var teamsVar = from n in teams where n.WorkerTypeId == workerTypeId select n; teams = teamsVar.ToList(); } else { foreach (EngineTeamDTO item in teamsFromEngine) { TeamEntity team = new TeamEntity(); team = TeamRepository.Instance.GetByIdExterno(item.IdExterno); teams.Add(team); } } List <RankingDTO> rankingDTOList = new List <RankingDTO>(); foreach (TeamEntity team in teams) { if (team != null) { WorkerTypeEntity workerType = WorkerTypeRepository.Instance.GetById(team.WorkerTypeId); RankingDTO rankingDTO = new RankingDTO(); if (workerType.ProfileName.Equals(Profiles.LIDER)) { WorkerEntity sponsor = WorkerRepository.Instance.GetById(team.SponsorId); rankingDTO = EngineBIZ.GetGlobalScoreInEpisodeByEpisodeAndPlayer(episodeId.ToString(), sponsor.ExternalId); rankingDTO.LogoId = team.LogoId; rankingDTO.PlayerId = team.ExternalId; rankingDTO.PlayerName = team.TeamName; } else { rankingDTO = EngineBIZ.GetTeamScoreByTeamId(team.ExternalId); rankingDTO.LogoId = team.LogoId; } rankingDTOList.Add(rankingDTO); } } searchResult = rankingDTOList; } } else { searchResult = new List <RankingDTO>(); } var searchedQueryList = new List <RankingDTO>(); searchedQueryList = searchResult; if (!string.IsNullOrWhiteSpace(filter)) { filter = filter.ToLowerInvariant().Trim(); var searchedQuery = from n in searchResult where (n.PlayerName != null && n.PlayerName.ToLowerInvariant().Trim().Contains(filter)) orderby n.Score descending select n; searchedQueryList = searchedQuery.ToList(); } else { var searchedQuery = from n in searchResult orderby n.Score descending select n; searchedQueryList = searchedQuery.ToList(); } int index = Int32.Parse(jqueryTableRequest.Order); JQueryDataTableResponse response = null; if (jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count), RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1, Data = searchedQueryList.Select(r => new string[] { r.PlayerId != null ? r.PlayerId.ToString() : "", r.PlayerName + ";" + r.LogoId.ToString(), r.Score != null ? r.Score.Value.ToString() : 0.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count), RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1, Data = searchedQueryList.Select(r => new string[] { r.PlayerId != null ? r.PlayerId.ToString() : "", r.PlayerName + ";" + r.LogoId.ToString(), r.Score != null ? r.Score.Value.ToString() : 0.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId, string teamId, string metricId) { GetAllDTO all; if (metricId == "empty") { metricId = ""; } if (jqueryTableRequest != null) { if (teamId != "empty") { all = RunEngineService.Instance.GetAllRunScore(teamId, metricId, jqueryTableRequest.Page); List <PlayerEngineDTO> players = (from run in all.List.run select PlayerEngineService.Instance.GetById(run.PlayerId)).ToList(); all.List.result = (from run in all.List.run from player in players where run.PlayerId == player.Id select new ResultEngineDTO { Id = player.Id, Nick = player.Nick, Score = run.Score, LogoId = player.LogoId }).ToList(); } else if (episodeId != "null") { all = TeamEngineService.Instance.GetAllTeamScoreByEpisodeId(episodeId, metricId, jqueryTableRequest.Page); all.List.result = (from team in all.List.team select new ResultEngineDTO { Id = team.Id, Nick = team.Nick, Score = team.Score, LogoId = team.LogoId }).ToList(); } else { all = new GetAllDTO(); all.List = new GetAllDTO.Embedded(); all.PageInfo = new GetAllDTO.Page(); all.List.result = new List <ResultEngineDTO>(); } int index = 0; if (jqueryTableRequest.Order != null) { index = Int32.Parse(jqueryTableRequest.Order); } JQueryDataTableResponse response = null; if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc")) { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.result.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.Nick + ";" + t.LogoId + ";" + t.Id, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } else { response = new JQueryDataTableResponse() { Draw = jqueryTableRequest.Draw, RecordsTotal = all.PageInfo.totalElements, RecordsFiltered = all.PageInfo.totalElements, Data = all.List.result.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.Nick + ";" + t.LogoId + ";" + t.Id, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray() }; } return(new DataContractResult() { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(Json(null, JsonRequestBehavior.AllowGet)); }