public static string GetViewValueForTop(this User u, TopType type) { switch (type) { default: case TopType.Level: return($"{u.Level} **LVL** ({u.ExpCnt} **EXP**)"); case TopType.ScCnt: return($"{u.ScCnt} **SC**"); case TopType.TcCnt: return($"{u.TcCnt} **TC**"); case TopType.Posts: return($"{u.MessagesCnt}"); case TopType.PostsMonthly: return($"{u.MessagesCnt - u.MessagesCntAtDate}"); case TopType.PostsMonthlyCharacter: return($"{u.CharacterCntFromDate / (u.MessagesCnt - u.MessagesCntAtDate)} znaki"); case TopType.Commands: return($"{u.CommandsCnt}"); case TopType.Cards: return($"{u.GameDeck.Cards.Count}"); case TopType.CardsPower: return(u.GameDeck.GetCardCountStats()); } }
public static string Name(this TopType type) { switch (type) { default: case TopType.Level: return("doświadczenia"); case TopType.ScCnt: return("SC"); case TopType.TcCnt: return("TC"); case TopType.Posts: return("liczby wiadomości"); case TopType.PostsMonthly: return("liczby wiadomości w miesiącu"); case TopType.PostsMonthlyCharacter: return("liczby znaków w wiadomości"); case TopType.Commands: return("liczby użytych poleceń"); case TopType.Cards: return("liczby kart"); case TopType.CardsPower: return("mocy kart"); } }
/// <summary> /// Writing TOP N is not supported we need to wrap in an outer SELECT with /// ROWNUM as one of the fields on the inner SELECT so we can select ranges. /// </summary> /// <param name="count"></param> /// <param name="offset"></param> /// <param name="topType"></param> public override void WriteTop(double count, double offset, TopType topType) { StringBuilder sb = this.GetWritersInnerBuilder(); if (null == sb) { throw new InvalidOperationException(Errors.CannotUseTopAsInnerWriterNotSupportPosition); } string full = sb.ToString(); if (full.EndsWith("SELECT ", StringComparison.OrdinalIgnoreCase)) { _selectstart = full.Length - "SELECT ".Length; _assignReceivers = null; _assignValues = null; _hastop = true; _topcount = count; _toptype = topType; _offsetcount = offset; _hasorder = false; } else { throw new InvalidOperationException("Cannot use Top N outside of the start of a SELECT statement"); } }
public override void WriteTop(double count, double offset, TopType topType) { if (topType == TopType.Range) { this.IncrementStatementDepth(); StringBuilder builder = null; System.IO.TextWriter writer = this.Writer; if (writer is System.IO.StringWriter) { System.IO.StringWriter sw = writer as System.IO.StringWriter; builder = sw.GetStringBuilder(); } _range = new RangeOptions() { Count = (int)count - 1, //as we use between and we start from offset 1 - this works Offset = (int)offset, SelectInjectOffset = builder.Length, Builder = builder, CollectingFields = true }; } else { base.WriteTop(count, offset, topType); } }
private List <User> OrderUsersByTop(List <User> list, TopType type) { switch (type) { default: case TopType.Level: return(list.OrderByDescending(x => x.Level).ToList()); case TopType.ScCnt: return(list.OrderByDescending(x => x.ScCnt).ToList()); case TopType.TcCnt: return(list.OrderByDescending(x => x.TcCnt).ToList()); case TopType.Posts: return(list.OrderByDescending(x => x.MessagesCnt).ToList()); case TopType.PostsMonthly: return(list.Where(x => x.IsCharCounterActive()).OrderByDescending(x => x.MessagesCnt - x.MessagesCntAtDate).ToList()); case TopType.PostsMonthlyCharacter: return(list.Where(x => x.IsCharCounterActive()).OrderByDescending(x => x.CharacterCntFromDate / (x.MessagesCnt - x.MessagesCntAtDate)).ToList()); case TopType.Commands: return(list.OrderByDescending(x => x.CommandsCnt).ToList()); case TopType.Cards: return(list.OrderByDescending(x => x.GameDeck.Cards.Count).ToList()); case TopType.CardsPower: return(list.OrderByDescending(x => x.GameDeck.Cards.Sum(c => c.GetValue())).ToList()); } }
public async Task ShowTopAsync([Summary("rodzaj topki(poziom/sc/tc/posty(m/ms)/karty)")] TopType type = TopType.Level) { var session = new ListSession <string>(Context.User, Context.Client.CurrentUser); await _session.KillSessionIfExistAsync(session); using (var db = new Database.UserContext(Config)) { var users = await db.GetCachedAllUsersAsync(); session.ListItems = _profile.BuildListView(_profile.GetTopUsers(users, type), type, Context.Guild); } session.Event = ExecuteOn.ReactionAdded; session.Embed = new EmbedBuilder { Color = EMType.Info.Color(), Title = $"Topka {type.Name()}" }; var msg = await ReplyAsync("", embed : session.BuildPage(0)); await msg.AddReactionsAsync(new[] { new Emoji("⬅"), new Emoji("➡") }); session.Message = msg; await _session.TryAddSession(session); }
public ActionResult DeleteConfirmed(int id) { TopType topType = db.TopTypes.Find(id); db.TopTypes.Remove(topType); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Load(BinaryReader binaryReader) { Elevation = binaryReader.ReadByte(); baseTexture = (AtlasTexture)binaryReader.ReadByte(); topTexture = (AtlasTexture)binaryReader.ReadByte(); topType = (TopType)binaryReader.ReadByte(); topDirection = (Direction)binaryReader.ReadByte(); }
/// <summary> /// Creates a returns a new TOP (LIMITS) statment with the specified restrictions /// </summary> /// <param name="value"></param> /// <param name="type"></param> /// <returns></returns> public static DBTop Top(double value, TopType type) { DBTop top = new DBTopRef(); top.Type = type; top.TopValue = value; return(top); }
public async Task <ServerResponse <TopResponse> > GetTop(TopType type, int count) { var query = new FlexibleQuery() .AddToChain(OnlineQuery.Default) .AddToChain(GetIdentifier()) .AddProperty(new Property("type", type.GetAttributeOfSelected <OriginalNameAttribute>().OriginalName)) .AddProperty(new Property("count", count)); return(await Get <TopResponse>("/database/getGJScores20.php", query)); }
public ActionResult Edit([Bind(Include = "TopTypesID,TopTypeName")] TopType topType) { if (ModelState.IsValid) { db.Entry(topType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(topType)); }
public ActionResult Create([Bind(Include = "TopTypesID,TopTypeName")] TopType topType) { if (ModelState.IsValid) { db.TopTypes.Add(topType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(topType)); }
public override void WriteTop(double limit, double offset, TopType topType) { if (this.StatementDepth == 1) { if (topType == TopType.Percent) { throw new NotSupportedException("This provider does not support the top percent syntax"); } this._limits = (int)limit; this._offset = (int)offset; } }
protected override DBDatabaseProperties GetPropertiesFromDb(DBDatabase forDatabase) { string statement = "SELECT SERVERPROPERTY('productversion') AS [version], SERVERPROPERTY ('productlevel') AS [level], SERVERPROPERTY ('edition') AS [edition]"; DBDatabaseProperties props; System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(forDatabase.ConnectionString); string dbname = builder.InitialCatalog; if (string.IsNullOrEmpty(dbname)) { dbname = builder.DataSource; } TypedOperationCollection unsupported = new TypedOperationCollection(); this.FillNotSupported(unsupported); DBSchemaInformation info = DBSchemaInformation.CreateDefault(); TopType[] tops = new TopType[] { TopType.Count, TopType.Percent, TopType.Range }; bool caseSensitive = false; string level = "?"; string edition = "?"; Version version = new Version(1, 0); forDatabase.ExecuteRead(statement, reader => { if (reader.Read()) { level = reader["level"].ToString(); edition = reader["edition"].ToString(); version = new Version(reader["version"].ToString()); } }); props = new DBDatabaseProperties(dbname, "SQL Server", level, edition, "@{0}", version, SupportedSchemaOptions.All, caseSensitive, DBParameterLayout.Named, SUPPORTED_TYPES, tops, info, unsupported); props.TemporaryTableConstruct = ""; props.TemporaryTablePrefix = "#"; return(props); }
public HexGrid(int points, float size, TopType type) { mType = type; mSize = size; mEdgePoints = points; mDepthBoundaryLeft = -points * 3; mDepthBoundaryRight = -points; Width = points * 2 + 1; Height = points * 2 + 1; //Constants mSqrt3 = Mathf.Sqrt(3f); }
// GET: TopTypes/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TopType topType = db.TopTypes.Find(id); if (topType == null) { return(HttpNotFound()); } return(View(topType)); }
protected static string TopTypeToParam(TopType type) { switch (type) { case TopType.Overall: return("overall"); case TopType.ThreeMonth: return("3month"); case TopType.SixMonth: return("6month"); case TopType.TwelveMonth: return("12month"); } return(null); }
private List <User> OrderUsersByTop(List <User> list, TopType type) { switch (type) { default: case TopType.Level: return(list.OrderByDescending(x => x.Level).ToList()); case TopType.ScCnt: return(list.OrderByDescending(x => x.ScCnt).ToList()); case TopType.TcCnt: return(list.OrderByDescending(x => x.TcCnt).ToList()); case TopType.Posts: return(list.OrderByDescending(x => x.MessagesCnt).ToList()); case TopType.PostsMonthly: return(list.Where(x => x.IsCharCounterActive()).OrderByDescending(x => x.MessagesCnt - x.MessagesCntAtDate).ToList()); case TopType.PostsMonthlyCharacter: return(list.Where(x => x.IsCharCounterActive() && x.SendAnyMsgInMonth()).OrderByDescending(x => x.CharacterCntFromDate / (x.MessagesCnt - x.MessagesCntAtDate)).ToList()); case TopType.Commands: return(list.OrderByDescending(x => x.CommandsCnt).ToList()); case TopType.Card: return(list.OrderByDescending(x => x.GameDeck.GetStrongestCardPower()).ToList()); case TopType.Cards: return(list.OrderByDescending(x => x.GameDeck.Cards.Count).ToList()); case TopType.CardsPower: return(list.OrderByDescending(x => x.GameDeck.Cards.Sum(c => c.GetCardPower())).ToList()); case TopType.Karma: return(list.OrderByDescending(x => x.GameDeck.Karma).ToList()); case TopType.KarmaNegative: return(list.OrderBy(x => x.GameDeck.Karma).ToList()); case TopType.Pvp: return(list.Where(x => x.GameDeck.GlobalPVPRank > 0).OrderByDescending(x => x.GameDeck.GlobalPVPRank).ToList()); case TopType.PvpSeason: return(list.Where(x => x.IsPVPSeasonalRankActive() && x.GameDeck.SeasonalPVPRank > 0).OrderByDescending(x => x.GameDeck.SeasonalPVPRank).ToList()); } }
public static string Name(this TopType type) { switch (type) { default: case TopType.Level: return("doświadczenia"); case TopType.ScCnt: return("SC"); case TopType.TcCnt: return("TC"); case TopType.Posts: return("liczby wiadomości"); case TopType.PostsMonthly: return("liczby wiadomości w miesiącu"); case TopType.PostsMonthlyCharacter: return("liczby liczących się znaków na wiadomość"); case TopType.Commands: return("liczby użytych poleceń"); case TopType.Card: return("mocy karty"); case TopType.Cards: return("liczby kart"); case TopType.CardsPower: return("mocy kart"); case TopType.Karma: case TopType.KarmaNegative: return("karmy"); case TopType.Pvp: return("globalnego PVP"); case TopType.PvpSeason: return("miesięcznego PVP"); } }
public static string GetViewValueForTop(this User u, TopType type) { switch (type) { default: case TopType.Level: return($"{u.Level} **LVL** ({u.ExpCnt} **EXP**)"); case TopType.ScCnt: return($"{u.ScCnt} **SC**"); case TopType.TcCnt: return($"{u.TcCnt} **TC**"); case TopType.Posts: return($"{u.MessagesCnt}"); case TopType.PostsMonthly: return($"{u.MessagesCnt - u.MessagesCntAtDate}"); case TopType.PostsMonthlyCharacter: return($"{u.CharacterCntFromDate / (u.MessagesCnt - u.MessagesCntAtDate)}"); case TopType.Commands: return($"{u.CommandsCnt}"); case TopType.Card: return(u.GameDeck.Cards.OrderByDescending(x => x.GetCardPower())?.FirstOrDefault()?.GetString(false, false, true) ?? "---"); case TopType.Cards: return($"{u.GameDeck.Cards.Count}"); case TopType.CardsPower: return(u.GameDeck.GetCardCountStats()); case TopType.Karma: case TopType.KarmaNegative: return($"{u.GameDeck.Karma}"); case TopType.Pvp: return($"{u.GameDeck.GlobalPVPRank}"); case TopType.PvpSeason: return($"{u.GameDeck.SeasonalPVPRank}"); } }
public override void WriteTop(double count, double offset, TopType topType) { if (Array.IndexOf <TopType>(this.DatabaseProperties.SupportedTopTypes, topType) < 0) { throw new NotSupportedException("The top type '" + topType.ToString() + "' is not supported by this database"); } if (this.StatementDepth == 1) { this._limits = (int)count; if (topType == TopType.Range) { _offset = (int)offset; } } }
public List <string> BuildListView(List <User> list, TopType type, SocketGuild guild) { var view = new List <string>(); foreach (var user in list) { var bUsr = guild.GetUser(user.Id); if (bUsr == null) { continue; } view.Add($"{bUsr.Mention}: {user.GetViewValueForTop(type)}"); } return(view); }
public static IEnumerable <Point> GetNeighbors(this Point point, TopType topologyType = TopType.N8) { switch (topologyType) { case TopType.N4: case TopType.N4AndMe: yield return(new Point(point.X + 0, point.Y - 1)); yield return(new Point(point.X + 1, point.Y + 0)); yield return(new Point(point.X + 0, point.Y + 1)); yield return(new Point(point.X - 1, point.Y + 0)); if (topologyType == TopType.N8AndMe) { yield return(point); } break; case TopType.N8: case TopType.N8AndMe: yield return(new Point(point.X - 1, point.Y - 1)); yield return(new Point(point.X + 0, point.Y - 1)); yield return(new Point(point.X + 1, point.Y - 1)); yield return(new Point(point.X + 1, point.Y + 0)); yield return(new Point(point.X + 1, point.Y + 1)); yield return(new Point(point.X + 0, point.Y + 1)); yield return(new Point(point.X - 1, point.Y + 1)); yield return(new Point(point.X - 1, point.Y + 0)); if (topologyType == TopType.N8AndMe) { yield return(point); } break; } }
protected override DBDatabaseProperties GetPropertiesFromDb(DBDatabase forDatabase) { TypedOperationCollection unsupported = new TypedOperationCollection(); this.FillNotSupported(unsupported); DBSchemaInformation info = DBSchemaInformation.CreateDefault(); TopType[] tops = new TopType[] { TopType.Count, TopType.Percent, TopType.Range }; bool caseSensitive = false; string level = "?"; string edition = "?"; string database = "?"; Version version = new Version(1, 0); string statement = "SELECT SERVERPROPERTY('productversion') AS [version], SERVERPROPERTY ('productlevel') AS [level], SERVERPROPERTY ('edition') AS [edition], DB_NAME() As [currentdatabase]"; forDatabase.ExecuteRead(statement, reader => { if (reader.Read()) { level = reader["level"].ToString(); edition = reader["edition"].ToString(); version = new Version(reader["version"].ToString()); database = reader["currentdatabase"].ToString(); } }); DBDatabaseProperties props = new DBDatabaseProperties(database, "SQL Server", level, edition, "?", version, SupportedSchemaOptions.All, caseSensitive, DBParameterLayout.Positional, SUPPORTED_TYPES, tops, info, unsupported); props.TemporaryTableConstruct = ""; props.TemporaryTablePrefix = "#"; return(props); }
public static Vector2[] PointsAboutEllipse(int numIncrements, TopType topType, float verticalSquash = 1f) { var corners = new Vector2[numIncrements]; float aOffset = 0; if (topType == TopType.Flat) { aOffset = 0.5f; } for (int inc = 0; inc < numIncrements; inc++) { float theta = ((2f * Mathf.PI) * ((inc + aOffset) / (float)numIncrements)); corners[inc] = new Vector2(Mathf.Cos(theta), Mathf.Sin(theta) * verticalSquash); } return(corners); }
public virtual TQueryType Top(int count, TopType topType) { top.Count = count; top.TopType = topType; return((TQueryType)this); }
public List <User> GetTopUsers(List <User> list, TopType type) => GetRangeMax(OrderUsersByTop(list, type), 50);
/// <summary> /// Returns code with info of filled neighbors. Digit is 1 if cell is filled, 0 - not filled. Digit positions: /// /// 0 1 2 /// 7 X 3 /// 6 5 4 - for 8-connected topology /// /// 0 /// 3 X 1 /// 2 - for 4-connected topology /// /// <remark>For example: if you use 4-connected topology and top cell and bottom cell is filled, then method returns code 1010</remark>> /// </summary> public static int GetFilledNeighborsCode(this Point point, Func <Point, bool> isFilled = null, TopType topologyType = TopType.N8) { var res = 0; foreach (var p in point.GetNeighbors(topologyType)) { res *= 10; if ((isFilled ?? IsFilled)(p)) { res = res + 1; } } return(res); }
public static IEnumerable <Point> GetOutsideBorder(this IEnumerable <Point> cells, Func <Point, bool> isFilled = null, TopType topologyType = TopType.N8) { return(cells.Where(c => c.IsOutsideBorder(isFilled ?? IsFilled, topologyType))); }
public static bool IsOutsideBorder(this Point point, Func <Point, bool> isFilled = null, TopType topologyType = TopType.N8) { return(!(isFilled ?? IsFilled)(point) && point.GetNeighbors(topologyType).Count(isFilled ?? IsFilled) > 0); }