public NewsOM CheckNews(int id)
{
var news = new NewsDAC().GetById(id);
return(new NewsOM
{
Id = news.Id,
CNTitle = news.CNTitle,
ENTitle = news.ENTitle,
CNContent = news.CNContent,
ENContent = news.ENContent,
CNSource = news.CNSource,
ENSource = news.ENSource,
CNKeyword1 = news.CNKeyword1,
CNKeyword2 = news.CNKeyword2,
ENKeyword1 = news.ENKeyword1,
ENKeyword2 = news.ENKeyword2,
CNCoverPictureUrl = news.CNCoverPictureUrl,
ENCoverPictureUrl = news.ENCoverPictureUrl,
CreateTime = news.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Status = (int)news.Status,
CNPageView = news.CNPageView,
ENPageView = news.ENPageView,
CNPublisher = news.CNPublisher == null ? "" : news.CNPublisher,
ENPublisher = news.ENPublisher == null ? "" : news.ENPublisher,
CNIntro = news.CNIntro == null ? "" : news.CNIntro,
ENIntro = news.ENIntro == null ? "" : news.ENIntro
});
}
public List <NewsListOM> GetNewsList(int?newsSetionId, int pageSize, int pageIndex)
{
var list = new NewsDAC().GetNewsList(newsSetionId, pageSize, pageIndex);
return(list.Select(t => new NewsListOM
{
Id = t.Id,
CNTitle = t.CNTitle,
ENTitle = t.ENTitle,
CNContent = t.CNContent,
ENContent = t.ENContent,
CNSource = t.CNSource,
ENSource = t.ENSource,
CNKeyword1 = t.CNKeyword1,
CNKeyword2 = t.CNKeyword2,
ENKeyword1 = t.ENKeyword1,
ENKeyword2 = t.ENKeyword2,
CNCoverPictureUrl = t.CNCoverPictureUrl,
ENCoverPictureUrl = t.ENCoverPictureUrl,
CreateTime = t.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Status = (int)t.Status,
NewsSetionId = t.NewsSetionId,
CNPageView = t.CNPageView,
ENPageView = t.ENPageView,
CNPublisher = t.CNPublisher == null ? "" : t.CNPublisher,
ENPublisher = t.ENPublisher == null ? "" : t.ENPublisher,
CNIntro = t.CNIntro == null ? "" : t.CNIntro,
ENIntro = t.ENIntro == null ? "" : t.ENIntro
}).ToList());
}
public ActionResult Delete(int id)
{
INewsDAC dac = new NewsDAC();
dac.Delete(id);
return(RedirectToAction("Index"));
}
// GET: Admin/News
public ActionResult Index(int pageSize = 1000, int pageNo = 1)
{
INewsDAC dac = new NewsDAC();
int totalNoRecords;
int startIndex = pageSize * (pageNo - 1);
var news = dac.Get(null, "DateCreated DESC", startIndex, pageSize, out totalNoRecords);
return(View(news));
}
private void ClearNewsHistoryButton_Click(object sender, RoutedEventArgs e)
{
var result = MessageBox.Show("Clear News History?", Constants.APP_ID, MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
NewsDAC.Clear();
RefreshNewsHistoryButton_Click(null, null);
}
}
public ActionResult Edit(int id)
{
INewsDAC dac = new NewsDAC();
var news = dac.Get(id);
var model = new NewsEdit {
DateCreated = news.DateCreated, NewsID = news.NewsID, NewsText = news.NewsText, Subject = news.Subject
};
return(View(model));
}
public ActionResult Edit(NewsEdit news)
{
if (!ModelState.IsValid)
{
return(View(news));
}
INewsDAC dac = new NewsDAC();
dac.Update(news.NewsID, news.Subject, news.NewsText);
return(RedirectToAction("Index"));
}
public ActionResult Create(NewsCreate news)
{
if (!ModelState.IsValid)
{
return(View(news));
}
INewsDAC dac = new NewsDAC();
dac.Add(news.Subject, news.NewsText);
return(RedirectToAction("Index"));
}
public List <NewsSectionOM> GetAllSectionList(int pageSize, int pageIndex)
{
var list = new NewsDAC().GetAllSectionList(pageSize, pageIndex);
return(list.Select(t => new NewsSectionOM
{
Id = t.Id,
CNName = t.CNName,
ENName = t.ENName,
CreateTime = t.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Sort = t.Sort
}).ToList());
}
public SaveResult UpdateENVersion(News model)
{
if (CheckCNTitleExt(model))
{
return(new SaveResult(false, "This news already exists!"));
}
if (CheckENTitleExt(model))
{
return(new SaveResult(false, "This news already exists!"));
}
var result = new NewsDAC().UpdateENVersion(model);
return(new SaveResult(result));
}
public static void GetMatchingAndSendEmail(string[] keywords)
{
for (int index = 0; index < NewsList.Count; index++)
{
NewsEntry entry = NewsList[index];
if (ContainsAny(entry.Title, keywords) || ContainsAny(entry.Summary, keywords))
{
if (!NewsDAC.IsDuplicate(entry))
{
SendNewsAlertEmail(ref entry, keywords);
if (entry.EmailSent)
{
NewsDAC.Insert(entry);
}
}
}
}
}
private void RefreshNewsHistoryButton_Click(object sender, RoutedEventArgs e)
{
try
{
//create table
StringTable table = new StringTable();
table.ColumnNames.Add("Provider");
table.ColumnNames.Add("Title");
table.ColumnNames.Add("Url");
table.ColumnNames.Add("Email");
table.ColumnNames.Add("Email Sent");
//add rows
var allNews = NewsDAC.FetchAll();
foreach (var entry in allNews)
{
table.Add(table.Count, new StringRow()
{
{ "Provider", entry.Provider },
{ "Title", entry.Title },
{ "Url", entry.Url },
{ "Email", entry.EmailId },
{ "Email Sent", entry.EmailSent.ToString() }
});
}
DataGridHelper.Bind(ref NewsHistoryGrid, table);
//show summary
NewsSummaryTextBox.Text = string.Format("{0} Records", allNews.Count);
}
catch (Exception exception)
{
NewsSummaryTextBox.Text = "Unable to Load News-History: " + exception.Message;
}
}
public SaveResult Delete(int id)
{
var result = new NewsDAC().Delete(id);
return(new SaveResult(result));
}
public SaveResult UpdateNewsSection(NewsSetion model)
{
var result = new NewsDAC().UpdateNewsSection(model);
return(new SaveResult(result));
}
public bool CheckCNTitleExt(News model)
{
News ns = new NewsDAC().CheckByCNTitle(model);
return(ns != null);
}
public SaveResult Published(int id)
{
var result = new NewsDAC().Published(id);
return(new SaveResult(result));
}
public SaveResult DeleteNewsSection(int id)
{
var result = new NewsDAC().DeleteNewsSectionById(id);
return(new SaveResult(result));
}
