public static void UpdatePoints(string userId, int addedPoints) { RankingModel ranking = GetRankingForUser(userId); ranking.Points += addedPoints; SaveChanges(); }
public async Task <ResponseModel> Insert(RankingModel model) { ResponseModel response = new ResponseModel(); try { Ranking md = new Ranking(); md.Name = model.Name; md.Precedence = model.Precedence; md.IsActive = model.IsActive; md.CreateBy = base.UserId; md.CreateDate = DateTime.Now; md.Deleted = false; await _context.RankingRepository.AddAsync(md).ConfigureAwait(true); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } return(response); }
public IHttpActionResult GetRanking() { try { using (var context = new gamequizlgpdEntities()) { var viewModel = new RankingModel(); viewModel.ListUsers = context.Usuarios .Where(p => p.Pontos != 0) .OrderByDescending(p => p.Pontos) .Select(p => new UserModel { Id = p.Id, Name = p.Nome, Points = p.Pontos, }) .Take(10).ToList(); return(Ok(viewModel)); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
private void ChangeDataChosenStudents(int studentId, bool isAdd) { if (chosenStudents.Any(x => x.Id == studentId) && isAdd) { MessageBox.Show("Đã chọn học sinh này", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); NotificationForm notificationForm = new NotificationForm("Đã chọn học sinh này", "Thông báo", MessageBoxIcon.Information); notificationForm.ShowDialog(); return; } else { if (isAdd) { // add StudentModel studentModel = managingStudentService.GetSingleStudentById(studentId); RankingModel defaultRankingStudent = managingStudentService.GetAllRanking().FirstOrDefault(); studentModel.RankingId = defaultRankingStudent.Id; studentModel.RankingName = defaultRankingStudent.RankingName; chosenStudents.Add(studentModel); } else { // remove chosenStudents.Remove(chosenStudents.Where(x => x.Id == studentId).FirstOrDefault()); } LoadChosenStudents(); } }
public async Task <ResponseModel> Delete(RankingModel model) { ResponseModel response = new ResponseModel(); try { Ranking md = await _context.RankingRepository.FirstOrDefaultAsync(m => m.Id == model.Id); if (!md.RowVersion.SequenceEqual(model.RowVersion)) { response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData; return(response); } md.Deleted = true; md.UpdateBy = base.UserId; md.UpdateDate = DateTime.Now; _context.RankingRepository.Update(md); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } return(response); }
public List <RankingModel> Get(Guid group_id) { List <RankingModel> leaderboard = new List <RankingModel>(); // Get all scores for the group var scores = DocumentDBRepository <QuizResultModel> .GetItems("Scores", i => i.group_id == group_id); // Group by user var grouped = scores.GroupBy(i => i.user); foreach (var userScores in grouped) { RankingModel ranking = new RankingModel() { user = userScores.Key, pct_score = 0, total_possible = 0, total_score = 0 }; for (var i = 0; i < userScores.Count(); i++) { ranking.total_possible += userScores.ElementAt(i).questions; ranking.total_score += userScores.ElementAt(i).correct; } ranking.pct_score = ((ranking.total_score + 0.0) / ranking.total_possible) * 100.0; leaderboard.Add(ranking); } return(leaderboard.OrderByDescending(i => i.pct_score).ToList()); }
public void AddRankingRecord(RankingModel record /*string name, int stage, int score*/) { try { CreateConnection(); dbconn.Open(); IDbCommand dbcmd = dbconn.CreateCommand(); string query = string.Format( "INSERT INTO RankingRecords " + "(Name, Stage, Score) " + "VALUES ('{0}',{1},{2})", record.NameValue, record.StageValue, record.ScoreValue); dbcmd.CommandText = query; dbcmd.ExecuteReader(); dbcmd.Dispose(); dbcmd = null; } catch (Exception e) { Debug.LogError(e.Message); } finally { dbconn.Close(); dbconn = null; } }
public void Init(ScoreModel scoreModel) { _rankingModel = new RankingModel(scoreModel); _rankingView.Init(); Bind(); }
public PlayerModel() { Ranking = new RankingModel(); Gender = GenderType.Man; ForehandRight = true; DateOfBirth = Constants.MinimalSqlDate; PlayFrom = Constants.MinimalSqlDate; }
public ActionResult Index() { var model = new RankingModel { ListaHistorico = ObterHistorico() }; return(View(model)); }
public void ActionConfirmName() { GlobalPlayerData.Instance.Name = inputField.text; var ranking = new RankingModel(inputField.text, GlobalPlayerData.Instance.Stage, GlobalPlayerData.Instance.Score); db.AddRankingRecord(ranking); SceneManager.LoadScene("Ranking"); }
internal List <RankingModel> SelectAllRanking() { SQLiteConnection conn = ConnectionToDB(); SQLiteDataReader reader = SelectExecuteSQL(string.Format("select * from ranking", RankingModel.Column), conn); List <RankingModel> rankings = RankingModel.MakeResultSet(reader); DisconnectionToDB(conn); return(rankings); }
// GET: Ranking public ActionResult Index() { var ranking = new RankingModel { Season = SetSeason(), Ranking = BuildLeagueRanking() }; return(View(ranking)); }
public void AddRankingRecord(RankingModel record) { string query = string.Format( "INSERT INTO RankingRecords " + "(Name, Wave, Score) " + "VALUES ('{0}',{1},{2})", record.NameValue, record.WaveValue, record.ScoreValue); this.PostQueryToDb(query); }
// GET: Ranking public ActionResult Index() { string RedisServer = WebConfigurationManager.AppSettings["redisServer"]; ConnectionMultiplexer redis = ConnectionMultiplexer.Connect(RedisServer); IDatabase db = redis.GetDatabase(); RankingModel model = new RankingModel(); RankingUtils ranking = new RankingUtils(); model.Ranking = ranking.get_topAccess_list(); return(View(model)); }
public void Win() // <====={ SCENE WIN } { StartCoroutine(TransitionScene(conditionScene)); RankingModel ranking = new RankingModel("Gano", WaveManager.instance.currentWave, score); database.AddRankingRecord(ranking); GetScores(); SortScores(); isDead = false; hasWon = true; }
public List <RankingModel> SortClans(List <Matches> matches, List <Clans> clans) { List <RankingModel> _ranking = new List <RankingModel>(); foreach (var clan in clans) { RankingModel temp = new RankingModel(); temp.Name = clan.Name; temp.Id = clan.Id; _ranking.Add(temp); } GetScores(matches, _ranking); _ranking.Sort((x, y) => y.TotalScore.Value.CompareTo(x.TotalScore.Value)); return(_ranking); }
public List <RankingModel> ranking(List <int> idji) { List <RankingModel> seznam = new List <RankingModel>(); foreach (int enid in idji) { RankingModel element = new RankingModel(); element.denar = trenutnoStanje(enid); element.winloss = winpercantage(enid); element.mail_uporabnik = dobiMail(enid); seznam.Add(element); } return(seznam); }
public void GameOver() // <====={ SCENE LOSE } { if (!isDead) { StartCoroutine(TransitionScene(conditionScene)); isDead = true; RankingModel ranking = new RankingModel("Perdio", WaveManager.instance.currentWave, score); database.AddRankingRecord(ranking); GetScores(); SortScores(); isDead = true; hasWon = false; } }
public RankingViewModel GetRankingVendasByMes(int?ano) { try { var vendas = new DataAccess.VendaDataAccess().GetList(); var filter = vendas.AsEnumerable().Where(x => (ano == null || x.dtVenda.Year == ano)).ToList(); var ranking = from venda in filter group venda by venda.dtVenda.Month into vendasGroup select new { mes = vendasGroup.Key, qtdeVendas = vendasGroup.Count(), vendas = vendasGroup }; ranking = ranking.OrderByDescending(x => x.qtdeVendas).ThenBy(x => x.mes); var rankingView = new RankingViewModel(); decimal vrTotalVendas = 0; foreach (var item in ranking) { var vendaGroup = item.vendas; foreach (var itemVenda in vendaGroup) { var produto = new ProdutoBusiness().Get(itemVenda.idProduto); if (produto != null) { var vrProduto = produto.vrProduto.Split('$')[1]; vrTotalVendas = vrTotalVendas + decimal.Parse(vrProduto); } } var itemRank = new RankingModel(null, item.qtdeVendas, vrTotalVendas, DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(item.mes), null); rankingView.Ranking.Add(itemRank); vrTotalVendas = 0; } return(rankingView); } catch (Exception e) { return(new RankingViewModel(e.Message)); } }
public List <RankingModel> GetAllRankingRecords() { var records = new List <RankingModel>(); try { CreateConnection(); dbconn.Open(); IDbCommand dbcmd = dbconn.CreateCommand(); string sqlQuery = "SELECT Id, Name, Stage, Score FROM RankingRecords"; dbcmd.CommandText = sqlQuery; IDataReader reader = dbcmd.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); int stage = reader.GetInt32(2); int score = reader.GetInt32(3); var record = new RankingModel(name, stage, score); record.Id = id; records.Add(record); Debug.Log(string.Format("id: {0} \t name: {1} \t stage: {2} \t score: {3}", id, name, stage, score)); } reader.Close(); reader = null; dbcmd.Dispose(); dbcmd = null; } catch (Exception e) { Debug.LogError(e.Message); } finally { dbconn.Close(); dbconn = null; } return(records); }
public async Task Rank(IGuildUser user, [Remainder] string _ = "") { if (!_scoreRepo.HasScore(user)) { throw new UserHasNoScoreException(); } RankingModel rm = new RankingModel() { CreatedRank = _scoreRepo.GiveRankUser(user, Enums.ScoreType.Qouter), QuoteRank = _scoreRepo.GiveRankUser(user, Enums.ScoreType.Qouted), VCRank = _scoreRepo.GiveRankUser(user, Enums.ScoreType.VC) }; EmbedBuilder emb = await RankEmbedBuilder.BuildRank(Context, rm, user); await Context.Message.Channel.SendMessageAsync(embed : emb.Build()); }
public async static Task <EmbedBuilder> BuildRank(ICommandContext context, RankingModel ranking, IGuildUser user) { EmbedFooterBuilder footer = await EmbedBuilderFunctions.AddFooter(context); EmbedBuilder builder = new EmbedBuilder() { Color = Color.Green, Title = $"Rank for {user.Nickname ?? user.Username}", ThumbnailUrl = user.GetAvatarUrl(), Description = $"So you want to know your standing huh? Well here it is.", Footer = footer }; builder.AddField("Qouted Ranking", $"#{ranking.QuoteRank}", true); builder.AddField("Quotes Created Ranking", $"#{ranking.CreatedRank}", true); builder.AddField("Voice Ranking", $"#{ranking.VCRank}", false); return(builder); }
public RankingModel getUserRankinsById(int id) { RankingModel rank = new RankingModel(); databaseConnection.Open(); query = "Select win,loose from rankings where userId = " + id;; MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); MySqlDataReader reader = commandDatabase.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { rank = new RankingModel(0, "", reader.GetInt32(0), reader.GetInt32(1), 0); } } databaseConnection.Close(); return(rank); }
public ActionResult Crear(RankingModel model) { Guid id = Guid.NewGuid(); try { Ranking Ranking = new Ranking() { RankingId = 106, Puntuacion = 5, }; RankingBrl.Insertar(Ranking); return(RedirectToAction("")); } catch { return(View()); } }
private void UpdateUserWonAndLostTable(List <Tuple <int, int> > top4, List <Tuple <int, int> > last4) { for (int i = 0; i < top4.Count; i++) { if (i == 0) { RankingModel rank = rDB.getUserRankinsById(top4[i].Item1); rDB.updateRankings(top4[i].Item1, rank.Win + 3, rank.Lose); } else if (i == 1 || i == 2) { RankingModel rank = rDB.getUserRankinsById(top4[i].Item1); rDB.updateRankings(top4[i].Item1, rank.Win + 2, rank.Lose + 1); } else if (i == 3) { RankingModel rank = rDB.getUserRankinsById(top4[i].Item1); rDB.updateRankings(top4[i].Item1, rank.Win + 1, rank.Lose + 2); } } for (int i = 0; i < last4.Count; i++) { if (i == 0) { RankingModel rank = rDB.getUserRankinsById(last4[i].Item1); rDB.updateRankings(last4[i].Item1, rank.Win + 2, rank.Lose + 1); } else if (i == 1 || i == 2) { RankingModel rank = rDB.getUserRankinsById(last4[i].Item1); rDB.updateRankings(last4[i].Item1, rank.Win + 1, rank.Lose + 2); } else if (i == 3) { RankingModel rank = rDB.getUserRankinsById(last4[i].Item1); rDB.updateRankings(last4[i].Item1, rank.Win, rank.Lose + 3); } } }
/// <summary> /// 폼 닫기 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Unload(object sender, FormClosingEventArgs e) { // 그리드 저장 DataGridViewRowCollection rows = dataGridView1.Rows; List <RankingModel> models = new List <RankingModel>(); for (int i = 0; i < rows.Count; i++) { DataGridViewRow row = rows[i]; RankingModel model = new RankingModel(); model.keyword = (string)row.Cells[HEADER_KEYWORD].Value; model.subKeyword = (string)row.Cells[HEADER_SUB_KEYWORD].Value; model.rank = (string)row.Cells[HEADER_RANKING].Value; model.checkedAt = (string)row.Cells[HEADER_UPDATE_DATE].Value; model.more = (string)row.Cells[HEADER_IS_MORE].Value; models.Add(model); } sqlite.DeleteAllTables(RankingModel.TableName); sqlite.InsertAllRankings(models); }
public async Task <IActionResult> OnGetAsync(int id) { var templateOfPasion = await _context.Passion.FirstOrDefaultAsync(passion => passion.Id == id); var nameMapPassion = _context.PassionType.Where(type => type.Id == templateOfPasion.PassionTypeId).Select(type => type.Name).ToList(); var correctPassions = await _context.Passion.Where(pasion => pasion.PassionTypeId == templateOfPasion.PassionTypeId).OrderByDescending(pasion => pasion.Points).ToListAsync(); var users = await _context.UserApp.ToListAsync(); int idOfList = 1; RankingModel ranking = new RankingModel(); ranking.PasstionName = nameMapPassion[0]; ranking.Users = new List <UserRankingData>(); foreach (var passion in correctPassions) { foreach (var user in users) { if (passion.UserId == user.Id) { var levelName = _context.Level.Where(level => level.Id == passion.LevelId).Select(level => level.Name).FirstOrDefault(); ranking.Users.Add(new UserRankingData { Number = idOfList, FullName = user.FirstName + " " + user.LastName, Points = passion.Points, Level = levelName }); } } idOfList++; } RankingData = ranking; return(Page()); }
public List <RankingModel> GetAll() { List <RankingModel> rankingModels = new List <RankingModel>(); using (conn = JBCertConnection.Instance) { string queryString = "Select * From [dbo].[tblXeploai] Where IsDeleted = 0"; conn.Open(); SqlCommand sqlCommand = new SqlCommand(queryString, conn); sqlCommand.CommandType = CommandType.Text; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); try { while (sqlDataReader.Read()) { RankingModel rankingModel = new RankingModel(); rankingModel.Id = int.Parse(sqlDataReader["Id"].ToString()); rankingModel.RankingName = sqlDataReader["Tenxeploai"].ToString(); rankingModel.Note = sqlDataReader["Ghichu"].ToString(); rankingModel.IsDeleted = false; rankingModels.Add(rankingModel); } } catch (Exception ex) { throw ex; } finally { sqlDataReader.Close(); conn.Close(); } } return(rankingModels); }
public RankingViewModel GetRankingProdutosByPeriodo(DateTime dtInicial, DateTime dtFinal) { try { var vendas = new DataAccess.VendaDataAccess().GetList(); var filter = vendas.AsEnumerable().Where(x => x.dtVenda >= dtInicial && x.dtVenda <= dtFinal).ToList(); var ranking = from venda in filter group venda by venda.idProduto into vendasGroup select new { idProduto = vendasGroup.Key, qtdeVendas = vendasGroup.Count(), }; ranking = ranking.OrderByDescending(x => x.qtdeVendas); var rankingView = new RankingViewModel(); foreach (var item in ranking) { var produto = new ProdutoBusiness().Get(item.idProduto); if (produto != null) { var vrProduto = produto.vrProduto.Split('$')[1]; var itemRank = new RankingModel(produto.nmProduto, item.qtdeVendas, decimal.Parse(vrProduto) * item.qtdeVendas, null, null); rankingView.Ranking.Add(itemRank); } } return(rankingView); } catch (Exception e) { return(new RankingViewModel(e.Message)); } }
public void InsertAllRankings(List <RankingModel> rankingModels) { SQLiteConnection conn = ConnectionToDB(); using (var command = new SQLiteCommand(conn)) { using (var transaction = conn.BeginTransaction()) { // 100,000 inserts for (var i = 0; i < rankingModels.Count; i++) { RankingModel rankingModel = rankingModels.ElementAt(i); command.CommandText = string.Format("insert into " + RankingModel.TableName + " (" + RankingModel.Column + ") values (" + RankingModel.Values + ")", CommonUtils.MakeArray(rankingModel)); command.ExecuteNonQuery(); } transaction.Commit(); } } DisconnectionToDB(conn); }