public void AddNewsToBase(string userToken, Dictionary <string, object> news) { if (!IsAdmin(userToken)) { return; } var post = new NewsFull(); post.NewsFromJs(news); post.SendToBase(); }
public void LoadLists() { using (var _connection = new SqlConnection(Global.WaifString)) { _connection.Open(); var sCmd = "SELECT TOP 10 Id, Name, Image, Popularity FROM {0} {1} ORDER BY Popularity DESC "; using (var cmd = new SqlCommand(String.Format(sCmd, "Waifu", " WHERE Confirmed = N'1'"), _connection)) { using (var rd = cmd.ExecuteReader()) { while (rd.Read()) { TopWaifu.Add(new WaifuLight(rd)); } } } using (var cmd = new SqlCommand(String.Format(sCmd, "Anime", ""), _connection)) { using (var rd = cmd.ExecuteReader()) { while (rd.Read()) { TopAnime.Add(new AnimeLight(rd)); } } } using (var cmd = new SqlCommand("SELECT TOP 6 Id, Name, Image, Popularity FROM Waifu WHERE Confirmed=N'1' ORDER BY Newid()", _connection)) { using (var rd = cmd.ExecuteReader()) { while (rd.Read()) { RandomWaifu.Add(new WaifuLight(rd)); } } } using (var cmd = new SqlCommand("SELECT TOP 10 Id, Title, Date FROM News ORDER BY Id DESC", _connection)) { using (var rd = cmd.ExecuteReader()) { while (rd.Read()) { var temp = new NewsFull(rd); temp.Date = temp.Date.Remove(temp.Date.LastIndexOf('.')); TopNews.Add(temp); } } } } }
public void DeleteNews(string userToken, int id) { if (!IsAdmin(userToken)) { return; } try { NewsFull.DeleteFromBase(id); } catch (Exception) { } }
public string GetNews(int count, int offset) { using (var _connection = new SqlConnection(Global.WaifString)) { _connection.Open(); var Result = new List <NewsFull>(); using (var cmd = new SqlCommand("SELECT * FROM News ORDER BY Id DESC " + "OFFSET @Of ROWS FETCH NEXT @Co ROWS ONLY", _connection)) { cmd.Parameters.AddWithValue("Of", offset); cmd.Parameters.AddWithValue("Co", count); var rd = cmd.ExecuteReader(); while (rd.Read()) { var temp = new NewsFull(); temp.NewsFromReader(rd); Result.Add(temp); } return(new JavaScriptSerializer().Serialize(Result)); } } }