public List <NewsData> GetNewses(int userId, int subjectId)
{
var newses = Context.CourseProjectNews.Where(x => x.SubjectId == subjectId)
.OrderByDescending(x => x.EditDate);
var list = new List <NewsData>();
foreach (var cp in newses)
{
var n = new NewsData
{
Id = cp.Id,
Title = cp.Title,
Body = cp.Body,
SubjectId = cp.SubjectId,
DateCreate = cp.EditDate.ToShortDateString(),
Disabled = cp.Disabled,
PathFile = cp.Attachments,
Attachments = FilesManagementService.GetAttachments(cp.Attachments)
};
list.Add(n);
}
return(list);
}
public bool ProcessNewsData(string jstr)
{
JObject jnlst = JObject.Parse(jstr);
Console.WriteLine("//////////////////////////////////////////");
Console.WriteLine(jnlst["results"].GetType());
Console.WriteLine("//////////////////////////////////////////");
bool res = false;
foreach (var news in jnlst["results"])
{
System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1));
// 当地时区
double time = (double)news["pubDate"];
DateTime dt = startTime.AddMilliseconds(time);
//Console.WriteLine(dt.ToString("yyyy/MM/dd"));
string date = dt.ToString("yyyy/MM/dd");
string url = (string)news["sourceUrl"];
string title = (string)news["title"];
Console.WriteLine(date + " " + url + " " + title);
Console.ReadLine();
NewsData nd = new NewsData(date, url, title);//date,url,title
INewsDataBLL ndb = new NewsDataBLL();
res = ndb.insert(nd);
}
//Console.WriteLine(jnlst["results"]);
//Console.ReadLine();
return(res);
}
public void DataRefresh()
{
string jsonText = File.ReadAllText("NewsData.json");
newsData = JsonConvert.DeserializeObject <NewsData>(jsonText);
dgvReset();
}
public void AddNews_WhenNewsItemIsValid_ShouldAddtoDB()
{
//Arrange
var context = new NewsDbContext();
var data = new NewsData(context);
var news = new NewsItem
{
Title = "Title1",
Content = "News content",
PublishDate = new DateTime(2000, 12, 1, 14, 01, 55)
};
//Act
data.News.Add(news);
data.SaveChanges();
//Assert
var newsFromDb = data.News.Find(news.Id);
Assert.IsNotNull(newsFromDb, "News is not added to database");
Assert.AreNotEqual(newsFromDb.Id, 0, "News has 0 for Id");
Assert.AreEqual(news.Title, newsFromDb.Title, "Title is not corect");
Assert.AreEqual(news.Content, newsFromDb.Content, "Content is not corect");
Assert.AreEqual(news.PublishDate.ToString(), newsFromDb.PublishDate.ToString(), "Date is not corect");
}
public List <NewsData> getLimitSystemNews(int numrows)
{
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From News Where NEWS_TYPE='02' AND ROWNUM <= " + numrows + " Order By NEWS_ID DESC";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
List <NewsData> news_Data = new List <NewsData>();
foreach (DataRowView rowData in allData)
{
NewsData news_data = new NewsData();
news_data.news_id = rowData["NEWS_ID"].ToString();
news_data.news_topic = rowData["NEWS_TOPIC"].ToString();
news_data.news_detail = rowData["NEWS_DETAIL"].ToString();
news_data.news_type = rowData["NEWS_TYPE"].ToString();
news_data.news_datetime = rowData["NEWS_DATETIME"].ToString();
news_data.news_postby = rowData["NEWS_POSTBY"].ToString();
news_data.news_read = Convert.ToInt32(rowData["NEWS_READ"].ToString());
news_Data.Add(news_data);
}
return(news_Data);
}
public void CreateNewsFromDatas(NewsData data)
{
//ニュースの生成
this.CreateNews(data.GetNewsTitle(), data.GetBodyText(), data.GetNewskKind());
//ニュースイベントの実行
data.GetNewsEvect().Invoke();
}
public void GetBugsShouldReturnAllBugs()
{
DbContext = new NewsDbContext();
this.data = new NewsData(DbContext);
// Arrange -> prapare the objects
this.data.News.Add(new NewsItem
{
Title = "Test",
Content = "Test",
PublishDate = DateTime.Now
});
this.data.News.Add(new NewsItem
{
Title = ";sdka;skladfh;aklsj kljoidflkjal",
Content = "Test;Test;Test;Test",
PublishDate = DateTime.Now.AddDays(-1)
});
this.data.SaveChanges();
// Act -> perform some logic
var news = this.data.News.All().Count();
// Assert -> validate the results
Assert.AreEqual(2, news);
}
public async Task <IActionResult> NewsList(string redditAfterID, string apiServicePage)
{
NewsService newsService = new NewsService();
NewsData newsData = await newsService.GetNewsListAsync(redditAfterID, apiServicePage);
return(PartialView("_NewsListPartial", newsData));
}
public async Task <IActionResult> Index()
{
NewsService newsService = new NewsService();
NewsData newsData = await newsService.GetNewsListAsync();
return(View(newsData));
}
public void ListAllNews_WhenAddedTwoNews_ShouldTwoNewsInDB()
{
//Arrange
var context = new NewsDbContext();
var data = new NewsData(context);
var news1 = new NewsItem
{
Title = "news 1",
Content = "News content",
PublishDate = new DateTime(2000, 12, 1, 14, 01, 55)
};
var news2 = new NewsItem
{
Title = "news 2",
Content = "News content2",
PublishDate = new DateTime(2000, 12, 1, 14, 01, 55)
};
data.News.Add(news1);
data.News.Add(news2);
data.SaveChanges();
//Act
var newsItems = data.News.All().ToList();
Assert.AreEqual(2, newsItems.Count);
Assert.AreEqual(news1.Title, newsItems[0].Title, "Title is not corect");
Assert.AreEqual(news1.Content, newsItems[0].Content, "Content is not corect");
Assert.AreEqual(news1.PublishDate.ToString(), newsItems[0].PublishDate.ToString(), "Date is not corect");
}
public bool AddVideo(NewsDataViewModels video, string videoPath)
{
bool RetVal = false;
if (video == null)
{ return RetVal; }
NewsData newsData = new NewsData
{
church = video.church,
country = video.country,
description = video.description,
fName = video.fName,
lName = video.lName,
person = video.person,
province = video.province,
status = video.status,
user_id = video.User_Id,
Path = videoPath
};
try
{
context.Entry(newsData).State = Microsoft.EntityFrameworkCore.EntityState.Added;
context.SaveChanges();
RetVal = true;
}
catch (Exception ex)
{
int i = 9;
}
return RetVal;
}
void SetNewsData(string jsonText)
{
var jsonData = Json.Deserialize(jsonText) as Dictionary <string, object>;
Dictionary <string, object> data = null;
if (NetworkConfig.IsUsingEncryption)
{
var enc = jsonData [TAG_DATA] as string;
data = Json.Deserialize(AES.Decrypt(enc)) as Dictionary <string, object>;
}
else
{
data = jsonData[TAG_DATA] as Dictionary <string, object>;
}
//Load news data
listNews.Clear();
var news = data[TAG_NEWS] as List <object>;
for (int i = 0; i < news.Count; i++)
{
var rawData = news[i] as Dictionary <string, object>;
NewsData newsData = new NewsData(rawData);
listNews.Add(newsData);
}
}
public async Task <NewsData> GetNewsListAsync(
string redditAfterID = "",
string apiServicePage = "1")
{
//TODO: Create enum for news vebservices
var redditNewsTask = GetRedditNewsAsync(redditAfterID);
var googleNewsTask = GetApiServiceNewsAsync("google-news", apiServicePage);
var bbcNewsTask = GetApiServiceNewsAsync("bbc-news", apiServicePage);
await Task.WhenAll(redditNewsTask, googleNewsTask, bbcNewsTask);
List <News> newsList = redditNewsTask.Result.Children.ToList().ConvertAll(
x => new News(
x.Data.Author,
x.Data.Title,
"reddit.com" + x.Data.Permalink,
x.Data.Preview != null ? x.Data.Preview.Images.First().Source.Url : null,
//x.ReleaseDate,
DateTime.Now,
x.Data.ID,
String.Empty,
String.Empty,
String.Empty,
String.Empty,
x.Data.SubredditName
)
).Union(googleNewsTask.Result.ToList().ConvertAll(
y => new News(
y.Author,
y.Title,
y.Permalink,
y.ImageURL,
y.ReleaseDate,
String.Empty,
y.Content,
y.Description,
String.Empty,
String.Empty,
String.Empty
)
)).Union(bbcNewsTask.Result.ToList().ConvertAll(
r => new News(
r.Author,
r.Title,
r.Permalink,
r.ImageURL,
r.ReleaseDate,
String.Empty,
r.Content,
r.Description,
String.Empty,
String.Empty,
String.Empty
))
).ToList();
NewsData newsData = new NewsData(newsList, redditNewsTask.Result.After, apiServicePage);
return(newsData);
}
public void displayNewsDetails(NewsData news)
{
window.Dispatcher.BeginInvoke((Action)(() =>
{
NewsDetailsPage page = new NewsDetailsPage(news);
window.NavigationService.Navigate(page);
window.isInHelpPage = false;
}));
}
public void TestInit()
{
var context = new NewsDbContext();
data = new NewsData(context);
this.controller = new NewsController();
// Start a new temporary transaction
tran = new TransactionScope();
}
public News(ISettings settings)
{
_settings = settings;
_newsData = new NewsData(_settings);
SetTimer();
HideForm();
InitializeComponent();
}
private IEnumerator GetNews()
{
var request = UnityWebRequest.Get(Application.streamingAssetsPath + "/mmmau-news.json");
request.SendWebRequest();
while (!request.isDone)
{
yield return(null);
}
var data = request.downloadHandler.text;
var newsData = JSON.Parse(data);
_newsData = new Dictionary <string, List <NewsData> >();
foreach (var newData in newsData["News"].AsArray)
{
foreach (var key in newData.Value.Keys)
{
string albumKey = key;
var items = newData.Value[albumKey].AsArray;
_newsData[albumKey] = new List <NewsData>();
foreach (var item in items)
{
var testValues = item.Value;
var counter = 0;
foreach (var keyThing in testValues.Keys)
{
string check = keyThing;
var newInfo = new NewsData()
{
Type = (NewsType)Enum.Parse(typeof(NewsType), check),
NewsItems = new List <News>()
};
foreach (var listItem in testValues[check].AsArray)
{
var someValue = listItem.Value;
var info = new News()
{
Title = someValue["Header"],
Link = someValue["Link"],
Body = someValue["Body"],
Subtitle = someValue["Type"]
};
yield return(GetImage(someValue["Photo-URL"], sprite => info.Thumbnail = sprite));
newInfo.NewsItems.Add(info);
}
_newsData[albumKey].Add(newInfo);
counter++;
}
}
}
}
}
public long GenerateAffair(ClaimsPrincipal user, NewsData data)
{
var news = _context.Artikel.SingleOrDefault(n => n.Id == data.NewsId);
if (news == null)
{
throw new NewsNotFoundException(data.NewsId.ToString());
}
if (news.VorfallId.HasValue)
{
throw new AffairAlreadyAttachedToNewsException(data.NewsId.ToString());
}
var userId = _accountService.GetIdOfUser(user);
news.Vorfall = new db.Affair.Vorfall()
{
UserId = userId,
Beschreibung = news.Description,
ErstelltAm = DateTime.Now,
PolitikerId = data.PolitikerId,
ReputationType = _mapper.Map <db.Affair.ReputationType>(data.ReputationType),
Titel = news.Title,
Legitimitaet = new db.Affair.Vote()
{
UserId = userId,
VoteType = db.Affair.VoteType.Up
}.AsList(),
Quellen = new db.Affair.Quelle()
{
Url = news.Link,
Zusatz = "Generiert"
}.AsList(),
Threads = new db.Board.Thread()
{
Generated = true,
Title = news.Title,
UserId = userId,
InitialPost = new Post()
{
UserId = userId,
Content = data.Beschreibung,
Likes = new Like()
{
UserId = userId, LikeType = LikeType.Like
}.AsList()
}
}.AsList()
};
_context.SaveChanges();
return(news.VorfallId.GetValueOrDefault());
}
public IActionResult GenerateVorfall([FromBody] NewsData data)
{
if (ModelState.IsValid)
{
return(Ok(_newsService.GenerateAffair(User, _mapper.Map <Core.BusinessObjects.News.NewsData>(data))));
}
else
{
return(BadRequest(ModelState));
}
}
public void Update(dynamic data)
{
AppManager.mainWindow.News_DataGrid.Items.Clear();
foreach (var _news in data.news)
{
string message = _news.message;
string link = _news.link;
NewsData newsData = new NewsData(message, link);
AppManager.mainWindow.News_DataGrid.Items.Insert(0, newsData);
}
}
public int insert(NewsData nd)
{
int line = 0;
string sql = "insert into NewsData values (@date,@url,@title)";
List <MySqlParameter> plst = new List <MySqlParameter>();
plst.Add(new MySqlParameter("@date", nd.date));
plst.Add(new MySqlParameter("@url", nd.url));
plst.Add(new MySqlParameter("@title", nd.title));
line = MySQLHelper.ExecuteSql(sql, plst.ToArray());
return(line);
}
public void DataRefresh()
{
dgv.Visible = true;
btnBack.Visible = false;
lblContent.Visible = false;
string jsonText = File.ReadAllText("NewsData.json");
newsData = JsonConvert.DeserializeObject <NewsData>(jsonText);
dgv.DataSource = newsData.NewsList.Select(x => new { x.Title, x.Author, x.PublishedDate }).ToList();
dgv.Columns[0].FillWeight = 300;
}
public void CreateNewsItemWithoutContentDataShouldThrowException()
{
DbContext = new NewsDbContext();
this.data = new NewsData(DbContext);
this.data.News.Add(new NewsItem
{
Title = "Test",
PublishDate = DateTime.Now
});
this.data.SaveChanges();
}
public ActionResult <string> Post([FromBody] NewsData data)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
NewsPrediction predictedValue = ConsumeModel.Predict(data);
string news = predictedValue.Prediction;
return(Ok(news));
}
internal string GetRequestUrl(ServiceType type, NewsData data)
{
string url = "";
switch (type)
{
case ServiceType.Hot:
url = string.Format("http://wcf.open.cnblogs.com/news/hot/{0}", data.PageSize);
break;
case ServiceType.Recent:
url = string.Format("http://wcf.open.cnblogs.com/news/recent/paged/{0}/{1}", data.PageIndex, data.PageSize);
break;
case ServiceType.Recommend:
url = string.Format("http://wcf.open.cnblogs.com/news/recommend/paged/{0}/{1}", data.PageIndex, data.PageSize);
break;
case ServiceType.PostComment:
url = string.Format("http://wcf.open.cnblogs.com/blog/post/{0}/comments/{1}/{2}", data.Id, data.PageIndex, data.PageSize);
break;
case ServiceType.NewsComment:
url = string.Format("http://wcf.open.cnblogs.com/news/item/{0}/comments/{1}/{2}", data.Id, data.PageIndex, data.PageSize);
break;
case ServiceType.Content:
url = string.Format("http://wcf.open.cnblogs.com/news/item/{0}", data.Id);
break;
case ServiceType.Search:
url = string.Format("http://wcf.open.cnblogs.com/blog/bloggers/search?t={0}", data.Key);
break;
case ServiceType.Blogger:
url = string.Format("http://wcf.open.cnblogs.com/blog/u/{0}/posts/{1}/{2}", data.Key, data.PageIndex, data.PageSize);
break;
case ServiceType.Home:
url = string.Format("http://wcf.open.cnblogs.com/blog/sitehome/paged/{0}/{1}", data.PageIndex, data.PageSize);
break;
case ServiceType.PostContent:
url = string.Format("http://wcf.open.cnblogs.com/blog/post/body/{0}", data.Id);
break;
default:
break;
}
return(url);
}
private NewsLanguageItemDTO Convert(NewsData newsData)
{
if (newsData == null)
{
return(null);
}
return(new NewsLanguageItemDTO()
{
Annotation = newsData.Annotation,
Body = newsData.Body,
Title = newsData.Title
});
}
// GET: NewsData/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NewsData newsData = await db.NewsDatas.FindAsync(id);
if (newsData == null)
{
return(HttpNotFound());
}
return(View(newsData));
}
public bool Create(ViewModels.NewsViewModel newsViewModel)
{
bool ret = false;
try
{
NewsData newsdata = new NewsData();
newsdata.NewsID = db.NewsData.AsEnumerable().Select(x => x.NewsID).DefaultIfEmpty(0).Max(x => x) + 1;
newsdata.OrderSeq = db.NewsData.AsEnumerable().Select(x => x.OrderSeq).DefaultIfEmpty(100000).Max(x => x) + 100;
newsdata.Topic = newsViewModel.Topic;
newsdata.Content = newsViewModel.Content;
newsdata.StartDT = newsViewModel.StartDT.Value;
newsdata.EndDT = newsViewModel.EndDT.Value;
if (newsViewModel.Priority == 0)
newsdata.Priority = 1;
else
newsdata.Priority = newsViewModel.Priority;
//if (newsViewModel.Class == 0)
// newsdata.Class = 1;
//else
// newsdata.Class = newsViewModel.Class;
newsdata.Class = 4;
newsdata.ClassStr = newsViewModel.ClassStr;
if (newsViewModel.isTop == null)
newsdata.isTop = "F";
else
newsdata.isTop = newsViewModel.isTop;
newsdata.CreateUserID = newsViewModel.CreateUserID;
newsdata.CreateDT = DateTime.Now;
//newsdata.UpdUserID = "AAA";
//newsdata.LastUpdDT = DateTime.Now;
db.NewsData.Add(newsdata);
db.SaveChanges();
//bulletinViewModel.SeqNo = bulletin.SeqNo;
ret = true;
}
catch
{
}
return ret;
}
public int update(NewsData nd)
{
int line = 0;
string sql = "update NewsData set title=@title where newsdate=@date and url=@url";
List <MySqlParameter> plst = new List <MySqlParameter>();
plst.Add(new MySqlParameter("@date", nd.date));
plst.Add(new MySqlParameter("@url", nd.url));
plst.Add(new MySqlParameter("@title", nd.title));
line = MySQLHelper.ExecuteSql(sql, plst.ToArray());
return(line);
}
public List <NewsData> selectALL()
{
List <NewsData> ndlst = new List <NewsData>();
string sql = "select newsdate ,url,title from NewsData";
MySqlDataReader reader = MySQLHelper.ExecuteReader(sql);
while (reader.Read())
{
NewsData nd = new NewsData(reader.GetString("newsdate"), reader.GetString("url"), reader.GetString("title"));
ndlst.Add(nd);
}
reader.Close();
return(ndlst);
}
public void AddNews_WhenTitleIsNull_ShouldThrowExeption()
{
//Arrange
var context = new NewsDbContext();
var data = new NewsData(context);
var news = new NewsItem
{
Content = "News content",
PublishDate = new DateTime(2000, 12, 1, 14, 01, 55)
};
//Act
data.News.Add(news);
data.SaveChanges();
}
public JsonResult News(string MyChecked)
{
News n = new News();
NewsData nd = new NewsData();
var array = MyChecked.Split(',');
if (MyChecked != "" && MyChecked != null)
{
for (var i = 0; i < array.Length; i++)
{
var Original = nd.Get().ToList().Where(a => a.num.ToString() == array[i]).SingleOrDefault();
var DelPath = System.IO.Path.Combine(Server.MapPath("~/upload/News/"), Original.pic1);
System.IO.File.Delete(DelPath);
//if (Original.jsonimg != "no_img.jpg")
//{
// var jsonstr = JsonConvert.DeserializeObject<List<jsonSer>>(Original.jsonimg);
// var DelJsonPath = Server.MapPath("~/upload/photograhy/");
// foreach (var j in jsonstr)
// {
// var DelJsonPathing = System.IO.Path.Combine(DelJsonPath, j.content);
// System.IO.File.Delete(DelJsonPathing);
// }
//}
n.num = Convert.ToInt32(array[i]);
nd.Delete(n);
}
}
return Json("");
}
