public ActionResult GetApostadores(JqGridRequest request) { //int equipoId = ViewBag.ApuestaId; int totalRecords = 0; List<Apostador> apuestas = repository.dal_apostador.GetApostadores(); ; totalRecords = apuestas.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; foreach (Apostador apuesta in apuestas) { response.Records.Add(new JqGridRecord(Convert.ToString(apuesta.ApostadorId), new List<object>() { apuesta.ApostadorId, apuesta.Nombre, apuesta.Correo, apuesta.Puntaje })); } //Return data as json return new JqGridJsonResult() { Data = response }; }
public JqGridJsonResult GetUsersGridModel(JqGridRequest request) { var enumerable = this.Manager.FindAll(new UserAll(true)); var users = new List<UserEntity>(enumerable); var totalRecordsCount = users.Count(); var list = (from u in users select new JqGridRecord<UserGridModel>( u.Id.ToString(CultureInfo.InvariantCulture), new UserGridModel { Id = u.Id, Name = u.Name, Email = u.Email, Login = u.UserPasswordCredential != null ? u.UserPasswordCredential.Login : string.Empty, })).ToList(); var response = new JqGridResponse { TotalPagesCount = (int)Math.Ceiling(totalRecordsCount / (float)request.RecordsCount), PageIndex = request.PageIndex, TotalRecordsCount = totalRecordsCount, }; response.Records.AddRange(list); return new JqGridJsonResult { Data = response }; }
public ActionResult NameSpaces(JqGridRequest request) { using (var db = new ContentRepository()) { var nameSpaceQry = from n in db.NameSpaces orderby n.Id select n; var totalRecs = db.NameSpaces.Count(); var response = new JqGridResponse() { TotalPagesCount = (int) Math.Ceiling((float) totalRecs/(float) request.RecordsCount), PageIndex = request.PageIndex, TotalRecordsCount = totalRecs }; var nameSpaces = nameSpaceQry .Skip(request.PageIndex*request.RecordsCount) .Take((request.PagesCount.HasValue ? request.PagesCount.Value : 1)*request.RecordsCount).ToList(); var jqGridRecords = from n in nameSpaces select new JqGridRecord<NameSpaceGridModel>( n.Id.ToString(), new NameSpaceGridModel(n)); response.Records.AddRange(jqGridRecords); return new JqGridJsonResult() { Data = response }; } }
public ActionResult Search(JqGridRequest request, String marketSearchBoxString) { int totalRecordsCount = CoinManager.GetCount(new MarketSearchBoxModel(marketSearchBoxString)); JqGridResponse response = new JqGridResponse() { TotalPagesCount = (int)Math.Ceiling((float)totalRecordsCount / (float)request.RecordsCount), PageIndex = request.PageIndex, TotalRecordsCount = totalRecordsCount }; IList<CoinViewModel> coins = new List<CoinViewModel>(); foreach (var coin in CoinManager.GetCoinsByMarketSearch( new MarketSearchBoxModel(marketSearchBoxString), String.Format("{0} {1}", request.SortingName, request.SortingOrder), request.PageIndex)) { response.Records.Add(new JqGridRecord<CoinViewModel>( Convert.ToString(coin.Id), new CoinViewModel(coin) )); } ViewBag.MarketSearchBoxString = marketSearchBoxString; return new JqGridJsonResult() { Data = response }; }
public ActionResult Employees(JqGridRequest request) { using (var proxy = new TimeCardServiceClient()) { var employees = proxy.SearchEmployees(null, null, null, false); var response = new JqGridResponse(); response.Records.AddRange(employees.Select(e => new JqGridRecord<EmployeeModel>(Convert.ToString(e.Id), e.ToModel()))); return new JqGridJsonResult { Data = response }; } }
public ActionResult Partidos(JqGridRequest request) { _logger.Info("START Partidos"); JqGridResponse response; try { int totalRecords = 0; List<PartidosView> partidos = repository.dal_partido.GetPartidosView(0); totalRecords = partidos.Count(); //Prepare JqGridData instance response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; foreach (PartidosView partido in partidos) { response.Records.Add(new JqGridRecord(Convert.ToString(partido.PartidoId), new List<object>() { partido.PartidoId, partido.EquipoIdLocal, partido.EquipoDescLocal, partido.GolesLocal, partido.Resultado, partido.EquipoIdVisita, partido.GolesVisita, partido.EquipoDescVisita })); } } catch (Exception ex) { _logger.Error("Error : ", ex); throw; } finally { } //Return data as json return new JqGridJsonResult() { Data = response }; }
public ActionResult GetPartidosUpdate(JqGridRequest request) { //int equipoId = ViewBag.ApuestaId; int totalRecords = 0; List<PartidoLog> partidos = repository.dal_partido_log.GetPartidos(); totalRecords = partidos.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; foreach (PartidoLog partido in partidos) { response.Records.Add(new JqGridRecord(Convert.ToString(partido.Id), new List<object>() { partido.Id, partido.PartidoId, partido.UserId, partido.UpdateDate.ToString("yy/MM/dd hh:mm:ss"), partido.Partido.EquipoIdLocal, partido.Partido.EquipoDescLocal, partido.Partido.GolesLocal, partido.Partido.Resultado, partido.Partido.EquipoIdVisita, partido.Partido.EquipoDescVisita, partido.Partido.GolesVisita })); } //Return data as json return new JqGridJsonResult() { Data = response }; }
public ActionResult GetEquipos(JqGridRequest request) { //int equipoId = ViewBag.ApuestaId; int totalRecords = 0; List<Equipo> equipos = repository.dal_equipo.GetEquipos(); ; totalRecords = equipos.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; foreach (Equipo equipo in equipos) { response.Records.Add(new JqGridRecord(Convert.ToString(equipo.Equipo_ID), new List<object>() { equipo.Equipo_ID, equipo.Grupo, equipo.Equipo_desc, equipo.Ptos, equipo.PJ, equipo.PG, equipo.PE, equipo.PP, equipo.GF, equipo.GC, equipo.DG, })); } //Return data as json return new JqGridJsonResult() { Data = response }; }
public ActionResult GridData(JqGridRequest request, int id, int GrandChampionId) { IQueryable<Competitor> competitors = db.Competitors.Where(m => m.TournamentId == id && m.GrandChampionId == GrandChampionId).OrderByDescending(m => m.CompetitorDivisions.Sum(cd => cd.Result)); int totalRecords = competitors.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; //Table with rows data foreach (Competitor competitor in competitors.Skip(request.PageIndex * request.RecordsCount).Take(request.PagesCount.HasValue ? request.PagesCount.Value : 1 * request.RecordsCount)) { string GoldCount = competitor.CompetitorDivisions.Count(m => m.Result == 5).ToString(); string SilverCount = competitor.CompetitorDivisions.Count(m => m.Result == 3).ToString(); string BronzeCount = competitor.CompetitorDivisions.Count(m => m.Result == 2).ToString(); string CopperCount = competitor.CompetitorDivisions.Count(m => m.Result == 1).ToString(); string TotalPoints = competitor.CompetitorDivisions.Sum(m => m.Result).ToString(); response.Records.Add(new JqGridRecord(Convert.ToString(competitor.CompetitorId), new List<object>() { competitor.CompetitorId, competitor.Student.FirstName, competitor.Student.LastName, competitor.Student.School.SchoolName, GoldCount, SilverCount, BronzeCount, CopperCount, TotalPoints })); } //Return data as json return new JqGridJsonResult() { Data = response }; }
public ActionResult GridData(JqGridRequest request, int id) { IQueryable<TournamentDivision> tournamentDivisions = db.TournamentDivisions.Where(m => m.TournamentId == id); if (request.Searching) { foreach (JqGridRequestSearchingFilter searchingFilter in request.SearchingFilters.Filters) { int searchValue; if (Int32.TryParse(searchingFilter.SearchingValue, out searchValue)) { if (searchingFilter.SearchingName.Contains(WKSADBConstants.RankId)) { tournamentDivisions = tournamentDivisions.Where(m => m.Division.RankId == searchValue); } if (searchingFilter.SearchingName.Contains(WKSADBConstants.DivisionTypeId)) { tournamentDivisions = tournamentDivisions.Where(m => m.Division.DivisionTypeId == searchValue); } if (searchingFilter.SearchingName.Contains(WKSADBConstants.AgeGroupId)) { tournamentDivisions = tournamentDivisions.Where(m => m.Division.AgeGroupId == searchValue); } } } } int totalRecords = tournamentDivisions.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; //Table with rows data foreach (TournamentDivision tournamentDivision in tournamentDivisions.OrderBy(request.SortingName + " " + request.SortingOrder.ToString()).Skip(request.PageIndex * request.RecordsCount).Take(request.PagesCount.HasValue ? request.PagesCount.Value : 1 * request.RecordsCount)) { response.Records.Add(new JqGridRecord(Convert.ToString(tournamentDivision.DivisionId), new List<object>() { tournamentDivision.DivisionId, tournamentDivision.Division.DivisionName, tournamentDivision.Division.Rank.Description, tournamentDivision.Division.DivisionType.Description, tournamentDivision.Division.AgeGroup.Description })); } //Return data as json return new JqGridJsonResult() { Data = response }; }
public ActionResult Products(JqGridRequest request, TaskObjects viewModel) { //Service1Client obj = new Service1Client(); JqGridResponse response = new JqGridResponse(); List<TaskObjects> listobj = new List<TaskObjects>(); Task dal = new Task(); var m = dal.LsitTask(); //var m = obj.display(); listobj = m.ToList(); foreach (TaskObjects product in listobj) { response.Records.Add(new JqGridRecord(Convert.ToString(product.TaskId), new List<object>() { product.TaskId, product.ProjectName, product.ModuleName, product.ScreenName, product.TaskName, product.EstimateHours, product.Priority, product.Creator, product.Reviewer, product.Assigned, product.StartDate, product.EndDate, product.StartTime, product.EndTime, product.Status, product.Comments, })); } return new JqGridJsonResult() { Data = response }; }
public ActionResult HomePageGridData(JqGridRequest request) { IQueryable<School> schools = db.Schools.OrderBy(m => m.SchoolName); if (request.Searching) { foreach (JqGridRequestSearchingFilter searchingFilter in request.SearchingFilters.Filters) { // No idea why I have to assign this to a string var first. Doesn't work otherwise!?! string searchText = searchingFilter.SearchingValue; if (searchingFilter.SearchingName.Contains(WKSADBConstants.SchoolCode)) { schools = schools.Where(m => m.SchoolCode.Contains(searchText)); } else if (searchingFilter.SearchingName.Contains(WKSADBConstants.SchoolName)) { schools = schools.Where(m => m.SchoolName.Contains(searchText)); } else if (searchingFilter.SearchingName.Contains(WKSADBConstants.InstructorName)) { schools = schools.Where(m => m.InstructorName.Contains(searchText)); } else { int searchValue; if (Int32.TryParse(searchingFilter.SearchingValue, out searchValue)) { if (searchingFilter.SearchingName.Contains(WKSADBConstants.CountryName)) { schools = schools.Where(m => m.CountryId == searchValue); } } } } } int totalRecords = schools.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; //Table with rows data foreach (School school in schools.OrderBy(request.SortingName + " " + request.SortingOrder.ToString()).Skip(request.PageIndex * request.RecordsCount).Take(request.PagesCount.HasValue ? request.PagesCount.Value : 1 * request.RecordsCount)) { response.Records.Add(new JqGridRecord(Convert.ToString(school.SchoolId), new List<object>() { school.SchoolId, school.SchoolCode, school.SchoolName, school.Country.CountryName, school.InstructorName })); } //Return data as json return new JqGridJsonResult() { Data = response }; }
public ActionResult GridData(JqGridRequest request, int id) { IOrderedEnumerable<IGrouping<int, Competitor>> schools = null; switch(request.SortingName) { case "CompetitorCount": if (request.SortingOrder.Equals(JqGridSortingOrders.Desc)) { schools = db.Competitors.Where(m => m.TournamentId == id).ToLookup(m => m.Student.SchoolId).OrderBy(m => m.Count()); } else { schools = db.Competitors.Where(m => m.TournamentId == id).ToLookup(m => m.Student.SchoolId).OrderByDescending(m => m.Count()); } break; case "Average": if (request.SortingOrder.Equals(JqGridSortingOrders.Desc)) { schools = db.Competitors.Where(m => m.TournamentId == id).ToLookup(m => m.Student.SchoolId).OrderBy(m => m.Sum(c => c.CompetitorDivisions.Sum(cd => cd.Result)) / m.Count()); } else { schools = db.Competitors.Where(m => m.TournamentId == id).ToLookup(m => m.Student.SchoolId).OrderByDescending(m => m.Sum(c => c.CompetitorDivisions.Sum(cd => cd.Result)) / m.Count()); } break; case "TotalPoints": if (request.SortingOrder.Equals(JqGridSortingOrders.Desc)) { schools = db.Competitors.Where(m => m.TournamentId == id).ToLookup(m => m.Student.SchoolId).OrderByDescending(m => m.Sum(c => c.CompetitorDivisions.Sum(cd => cd.Result))); } else { schools = db.Competitors.Where(m => m.TournamentId == id).ToLookup(m => m.Student.SchoolId).OrderBy(m => m.Sum(c => c.CompetitorDivisions.Sum(cd => cd.Result))); } break; } int totalRecords = schools.Count(); //Prepare JqGridData instance JqGridResponse response = new JqGridResponse() { //Total pages count TotalPagesCount = (int)Math.Ceiling((float)totalRecords / (float)request.RecordsCount), //Page number PageIndex = request.PageIndex, //Total records count TotalRecordsCount = totalRecords }; //Table with rows data foreach (IGrouping<int, Competitor> schoolCompetitors in schools.Skip(request.PageIndex * request.RecordsCount).Take(request.PagesCount.HasValue ? request.PagesCount.Value : 1 * request.RecordsCount)) { School school = schoolCompetitors.First().Student.School; int CompetitorCount = schoolCompetitors.Count(); int? TotalPoints = schoolCompetitors.Sum(s => s.CompetitorDivisions.Sum(cd => cd.Result)); decimal Average = TotalPoints.HasValue ? TotalPoints.Value / CompetitorCount : 0; response.Records.Add(new JqGridRecord(Convert.ToString(school.SchoolId), new List<object>() { school.SchoolId, school.SchoolCode, school.SchoolName, school.InstructorName, CompetitorCount.ToString(), Average.ToString("0.#"), TotalPoints.ToString() })); } //Return data as json return new JqGridJsonResult() { Data = response }; }