public ActionResult add(NewsDetails news)
{
if (ModelState.IsValid)
{
int commitCount = 0;
NEWS n = new NEWS();
n.TIL = news.newsTitle;
n.CNTNT = news.newsContent;
n.AUTH_ID = Convert.ToInt32(this.Session["UserId"]);
n.CREATED_AT = System.DateTime.Now;
try
{
db.NEWS.Add(n);
commitCount = db.SaveChanges();
if (commitCount > 0)
{
//To Do... Implement Logic to send SMS to all students who has send SMS is enabled
//SMS_SETTING s = new SMS_SETTING();
}
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex;
}
return(RedirectToAction("view", "News", new { id = n.ID }));
}
else
{
ViewBag.ErrorMessage = "Model is not valid..";
return(RedirectToAction("add"));
}
}
public async Task <IActionResult> Edit(int id, NewsDetails newsDetails)
{
if (id != newsDetails.NewsDetailsID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(newsDetails);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NewsDetailsExists(newsDetails.NewsDetailsID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["NewsCategoryID"] = new SelectList(_context.NewsCategory, "NewsCategoryID", "NewsCategoryID", newsDetails.NewsCategoryID);
return(View(newsDetails));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
NewsDetails news = (sender as Button).DataContext as NewsDetails;
WebBrowserTask wbt = new WebBrowserTask();
wbt.URL = news.link;
wbt.Show();
}
public ActionResult Editor([Bind(Include = "NewID,ClassesName,Title,Author,Original,Content")] NewsDetails newsDetails)
{
if (ModelState.IsValid)
{
SQLHelper.SaveNewsDetails(newsDetails);
return(RedirectToAction("Manager"));
}
return(View(newsDetails));
}
public IActionResult PostDNEWS([FromBody] NewsDetails dnews)
{
if (dnews == null)
{
return(BadRequest());
}
_context.NewsDetails.Add(dnews);
_context.SaveChanges();
return(Ok(dnews));
}
public IActionResult GetNewsDetails(int id)
{
NewsDetails news = _context.NewsDetails
.FirstOrDefault(x => x.DnewsId == id);
if (news == null)
{
return(NotFound());
}
return(new ObjectResult(news));
}
public static void SaveNewsDetails(NewsDetails newsDetails)
{
News news = db.News.Find(newsDetails.NewID);
news.ClassesID = db.NewsClasses.FirstOrDefault(A => A.ClassesName.Equals("人文")).ClassesId;
news.Title = newsDetails.Title;
news.Author = newsDetails.Author;
news.Original = news.Original;
news.Content = newsDetails.Content;
db.Entry(news).State = EntityState.Modified;
db.SaveChanges();
}
public ActionResult view(int id)
{
var userdetails = this.Session["CurrentUser"] as UserDetails;
NewsDetails newsDetail = new NewsDetails();
int UserId = Convert.ToInt32(this.Session["UserId"]);
ViewBag.current_user = UserId;
newsDetail = GetNewsDetails(id);
ViewBag.isModerator = (userdetails.privilage.Select(p => p.Name == "ManageNews").FirstOrDefault()) ? true : false;
ViewBag.isAdminUser = (userdetails.ADMIN_IND == "Y") ? true : false;
return(View("view", newsDetail));
}
public IActionResult DeleteDNEWS(int id)
{
NewsDetails dnews = _context.NewsDetails
.FirstOrDefault(x => x.DnewsId == id);
if (dnews == null)
{
return(NotFound());
}
_context.NewsDetails.Remove(dnews);
_context.SaveChanges();
return(Ok(dnews));
}
public static void AddNews(NewsDetails newsDetails)
{
News news = new News
{
Author = newsDetails.Author,
ClassesID = db.NewsClasses.FirstOrDefault(A => A.ClassesName.Equals(newsDetails.ClassesName)).ClassesId,
Original = newsDetails.Original,
Title = newsDetails.Title,
Content = newsDetails.Content
};
db.News.Add(news);
db.SaveChanges();
}
public IActionResult PutDNEWS([FromBody] NewsDetails dnews)
{
if (dnews == null)
{
return(BadRequest());
}
if (!_context.NewsDetails.Any(x => x.DnewsId == dnews.DnewsId))
{
return(NotFound());
}
_context.Update(dnews);
_context.SaveChanges();
return(Ok(dnews));
}
public ActionResult edit(int newsId)
{
var news = db.NEWS.Find(newsId);
NewsDetails News = new NewsDetails();
//return RedirectToAction("view", "News", new { id = newsId });
News.newsId = news.ID;
News.newsTitle = news.TIL;
News.newsContent = news.CNTNT;
News.days = 3;
News.newsCreatedDate = news.CREATED_AT;
News.newsUpdatedDate = news.UPDATED_AT;
return(View("edit", News));
}
public static NewsDetails GetNewsDetails(int?id)
{
News news = db.News.Find(id);
NewsClasses newsClasses = db.NewsClasses.Find(news.ClassesID);
NewsDetails newsDetails = new NewsDetails
{
NewID = news.NewID,
ClassesName = newsClasses.ClassesName,
Title = news.Title,
Author = news.Author,
Original = news.Original,
Content = news.Content
};
return(newsDetails);
}
public ActionResult DetailsUser(int?id)
{
NewsDetails news = new NewsDetails();
news.RecentNews = db.NewsEvents.Include(m => m.Files);
if (id == null)
{
news.News = db.NewsEvents.Include(m => m.Files).FirstOrDefault();
return(View(news));
}
else
{
news.News = db.NewsEvents.Include(m => m.Files).FirstOrDefault(m => m.Id == id);
}
return(View(news));
}
private NewsDetails GetNewsDetails(int id)
{
int UserId = Convert.ToInt32(this.Session["UserId"]);
NewsDetails newsDetail = (from nw in db.NEWS
join us in db.USERS on nw.AUTH_ID equals us.ID into uj
from subus in uj.DefaultIfEmpty()
where nw.ID == id
orderby nw.UPDATED_AT
select new Models.NewsDetails
{
newsId = nw.ID,
CreatedByUserId = (nw.AUTH_ID == null) ? 0 : nw.AUTH_ID,
newsTitle = nw.TIL,
newsContent = nw.CNTNT,
newsCreatedBy = (nw.AUTH_ID == 0) ? "User Deleted" : string.Concat(subus.FIRST_NAME, " ", subus.LAST_NAME, " ", (subus.ADMIN_IND == "Y") ? " - Admin" : ""),
newsCreatedDate = nw.CREATED_AT,
newsUpdatedDate = nw.UPDATED_AT,
newsCommentCount = db.NEWS_COMMENTS.Where(X => X.NEWS_ID == nw.ID && X.IS_APPR == "Y").Distinct().Count(),
isUserAdmin = subus.ADMIN_IND,
isModerator = subus.ADMIN_IND,
}).FirstOrDefault();
newsDetail.commentList = (from com in db.NEWS_COMMENTS
join us in db.USERS on com.AUTH_ID equals us.ID into gj
from comus in gj.DefaultIfEmpty()
where com.NEWS_ID == id
orderby com.ID
select new Models.NewsComments
{
commentId = com.ID,
newsId = com.NEWS_ID,
commentContent = com.CNTNT,
commentAddedBy = (com.AUTH_ID == 0) ? "User Deleted" : string.Concat(comus.FIRST_NAME, " ", comus.LAST_NAME),
AddedByUserId = com.AUTH_ID,
//commentAddedBy = string.Concat(comus.FIRST_NAME, " ", comus.LAST_NAME),
commentAddedDate = com.CREATED_AT,
commentUpdatedDate = com.UPDATED_AT,
isApproved = com.IS_APPR,
EnableNewsCommentModeration = (from config in db.CONFIGURATIONs
where config.CONFIG_KEY == "EnableNewsCommentModeration"
select config).FirstOrDefault().CONFIG_VAL
}).ToList();
return(newsDetail);
}
public async Task <APIResponse> GetNewsDetail(int NewsID)
{
APIResponse objResponse = new APIResponse();
try
{
NewsDetails obj = new NewsDetails();
objResponse.Object = obj.GetNewsDetail(NewsID);
objResponse.StatusCode = APIStatusCode.Success;;
objResponse.StatusMessage = "API sucussfully processed";
}
catch (Exception ex)
{
objResponse.StatusMessage = ex.Message;
objResponse.StatusCode = APIStatusCode.SystemError;
}
return(objResponse);
}
public async Task <APIResponse> SearchNews(int PageNo, string Keyword)
{
APIResponse objResponse = new APIResponse();
try
{
NewsDetails obj = new NewsDetails();
objResponse.Collection = obj.SearchNews(PageNo, Keyword);
objResponse.StatusCode = APIStatusCode.Success;
objResponse.StatusMessage = "API sucussfully processed";
}
catch (Exception ex)
{
objResponse.StatusMessage = ex.Message;
objResponse.StatusCode = APIStatusCode.SystemError;
}
return(objResponse);
}
public ActionResult delete_comment(int commentId, int newsId)
{
NewsDetails newsDetail = new NewsDetails();
int userId = Convert.ToInt32(this.Session["UserId"]);
var userdetails = this.Session["CurrentUser"] as UserDetails;
var newsComment = db.NEWS_COMMENTS.Find(commentId);
ViewBag.current_user = userId;
ViewBag.isModerator = (userdetails.privilage.Select(p => p.Name == "ManageNews").FirstOrDefault()) ? true : false;
ViewBag.isAdminUser = (userdetails.ADMIN_IND == "Y") ? true : false;
db.NEWS_COMMENTS.Remove(newsComment);
db.SaveChanges();
newsDetail = GetNewsDetails(newsId);
//return RedirectToActionPermanent("view", newsId);
//return PartialView("_CommentSections", newsDetail);
//return View("view", newsDetail);
return(RedirectToAction("view", new { id = newsId }));
}
public async Task <APIResponse> LatestNews(int PageNo)
{
APIResponse objResponse = new APIResponse();
try
{
NewsDetails obj = new NewsDetails();
NewsParam objNewsParam = new NewsParam {
PageNo = PageNo
};
objResponse.Collection = obj.GetNewsHeadlines(objNewsParam);
objResponse.StatusCode = APIStatusCode.Success;;
objResponse.StatusMessage = "API sucussfully processed";
}
catch (Exception ex)
{
objResponse.StatusMessage = ex.Message;
objResponse.StatusCode = APIStatusCode.SystemError;
}
return(objResponse);
}
public static NewsDetails ParseCustomFormatting(this NewsDetails news)
{
if (!string.IsNullOrEmpty(news.Text))
{
using (var reader = new StringReader(news.Text))
using (var writer = new StringWriter())
{
int? raceResultId;
TrainingResult trainingResult;
while (reader.Peek() != -1)
{
var line = reader.ReadLine();
if (line.TryGetRaceResultId(out raceResultId))
{
news.RaceResultId = raceResultId;
}
else if (line.TryGetTrainingResult(out trainingResult))
{
news.TrainingResult = trainingResult;
}
else
{
var token = line.Length > 0 ? $"{line[0]}" : "";
if (TokenToParserMapping.ContainsKey(token))
{
line = TokenToParserMapping[token](line);
}
writer.WriteLine(line + "<br/>");
}
}
news.Text = writer.ToString();
}
return(news);
}
else
{
return(news);
}
}
//[HttpPost]
public ActionResult add_comment(int newsId, string news_Comment)
{
NewsDetails newsDetail = new NewsDetails();
try
{
//Configuration config = new Configuration();
int userId = Convert.ToInt32(this.Session["UserId"]);
var userdetails = this.Session["CurrentUser"] as UserDetails;
var priv = userdetails.privilage.Where(p => p.Name == "ManageNews").FirstOrDefault();
NEWS_COMMENTS newsComment = new NEWS_COMMENTS();
//newsComment.CNTNT = comments.commentContent;
newsComment.CNTNT = news_Comment;
newsComment.AUTH_ID = Convert.ToInt32(userdetails.Id);
newsComment.CREATED_AT = System.DateTime.Now;
newsComment.NEWS_ID = newsId;
newsComment.IS_APPR = (priv != null) ? "Y" :
(userdetails.ADMIN_IND == "Y") ? "Y" : "N";
//var config = db.CONFIGURATIONs.Find("EnableNewsCommentModeration");
//var _config = config.get_config_value("EnableNewsCommentModeration");
db.NEWS_COMMENTS.Add(newsComment);
db.SaveChanges();
newsDetail = GetNewsDetails(newsId);
ViewBag.current_user = userId;
//ViewBag.isModerator = (newsDetail.isUserAdmin == "Y") ? true : false;
//ViewBag.isAdminUser = (newsDetail.isUserAdmin == "Y") ? true : false;
ViewBag.isModerator = (userdetails.privilage.Select(p => p.Name == "ManageNews").FirstOrDefault()) ? true : false;
ViewBag.isAdminUser = (userdetails.ADMIN_IND == "Y") ? true : false;
}
catch (Exception ex)
{
throw ex;
//return View("view", newsDetail);
}
return(PartialView("_CommentSections", newsDetail));
//return RedirectToAction("view", "News", new { id = newsId });
}
public async Task <IActionResult> Create(NewsDetails newsDetails, IFormFile file)
{
if (ModelState.IsValid)
{
_context.Add(newsDetails);
await _context.SaveChangesAsync();
// Code to upload image if not null
if (file != null || file.Length != 0)
{
// Create a File Info
FileInfo fi = new FileInfo(file.FileName);
// This code creates a unique file name to prevent duplications
// stored at the file location
var newFilename = newsDetails.NewsDetailsID + "_" + String.Format("{0:d}",
(DateTime.Now.Ticks / 10) % 100000000) + fi.Extension;
var webPath = hostingEnvironment.WebRootPath;
var path = Path.Combine("", webPath + @"\ImageFiles\" + newFilename);
// IMPORTANT: The pathToSave variable will be save on the column in the database
var pathToSave = @"/ImageFiles/" + newFilename;
// This stream the physical file to the allocate wwwroot/ImageFiles folder
using (var stream = new FileStream(path, FileMode.Create))
{
await file.CopyToAsync(stream);
}
// This save the path to the record
newsDetails.Image = pathToSave;
_context.Update(newsDetails);
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(Index)));
}
return(View(newsDetails));
}
public ActionResult CreateEdit(long Id = 0)
{
News item = new News();
ViewBag.CategoryList = _categoryService.LoadAll(true);
if (Id > 0)
{
item = _newsService.Get(Id);
}
else
{
NewsDetails _itemDetails = new NewsDetails
{
Language = GlobalContext.WebSite.Language
};
item.Details.Add(_itemDetails);
}
if (GlobalContext.WebSite.IsMultiLangual)
{
foreach (var lang in SupportedCultures.Cultures)
{
var count = item.Details.Where(x => x.Language == lang.TwoLetterISOLanguageName).Count();
if (count <= 0)
{
NewsDetails _itemDetails = new NewsDetails
{
Language = lang.TwoLetterISOLanguageName
};
item.Details.Add(_itemDetails);
}
}
}
return(View(item));
}
public override void AfterCopyData(News entity, News oldEntity)
{
var currentDateTime = DateTime.Now;
foreach (var item in entity.Details)
{
var isNew = false;
var temp = oldEntity.Details.Where(x => x.Language == item.Language).FirstOrDefault();
if (temp == null)
{
isNew = true;
temp = new NewsDetails();
temp.Language = item.Language;
}
temp.Metadata = item.Metadata;
temp.Name = item.Name;
temp.Content = item.Content;
temp.Excerpt = item.Excerpt;
if (isNew)
{
oldEntity.Details.Add(temp);
}
}
}
// GET: News/add
public ActionResult add()
{
NewsDetails news = new NewsDetails();
return(View(news));
}
