public void AddAnimeToBase(string userToken, Dictionary <string, object> anime) { if (!IsAdmin(userToken)) { return; } //Анти дудос, в продакшене раскоменть /*var cookie = Context.Request.Cookies["WL"]; * if(cookie != null) * { * return; * }*/ AnimeLight anim = new AnimeLight(); anim.AnimeFromJs(anime); if (anim.Id == -1) { anim.SendToBase(); } else { anim.UpdateBase(); } anim.ClearCache(); /*var nCookie = new HttpCookie("WL", "VioletEvergraden"); * nCookie.Expires = DateTime.Now.AddMinutes(1); * Context.Response.Cookies.Add(nCookie);*/ }
public void LoadTops(int count) { string command = "SELECT TOP {0} a.Id, a.Name, a.Image, a.Popularity, COUNT(w.Id) as waifCount " + "FROM Anime a LEFT JOIN Waifu w ON (w.AnimeId LIKE a.Id) GROUP BY " + "a.Id, a.Name, a.Image, a.Popularity, a.Description ORDER BY {1} DESC"; using (var cmd = new SqlCommand(String.Format(command, count, "a.Popularity"), _connection)) { var rd = cmd.ExecuteReader(); while (rd.Read()) { AnimeLight temp = new AnimeLight(rd); TopViewed.Add(temp); } rd.Close(); } using (var cmd = new SqlCommand(String.Format(command, count, "waifCount"), _connection)) { var rd = cmd.ExecuteReader(); while (rd.Read()) { AnimeLight temp = new AnimeLight(rd); temp.Popularity = Convert.ToInt32(rd["waifCount"]); TopPers.Add(temp); } rd.Close(); } }
public bool LoadAnime(int id) { if (_connection == null) { return(false); } var res = false; using (var cmd = new SqlCommand("SELECT * FROM Anime WHERE Id=@Id", _connection)) { cmd.Parameters.AddWithValue("Id", id); var rd = cmd.ExecuteReader(); if (rd.Read()) { PageAnim = new AnimeLight(rd); res = true; } rd.Close(); } return(res); }