public ActionResult Update(int id)
{
//need information about a particular pet
News selectednews = db.News.SqlQuery("select * from news where newsid = @id", new SqlParameter("@id", id)).FirstOrDefault();
List <Category> categories = db.Categories.SqlQuery("select * from categories").ToList();
UpdateNews UpdateNewsViewModel = new UpdateNews();
UpdateNewsViewModel.News = selectednews;
UpdateNewsViewModel.category = categories;
return(View(UpdateNewsViewModel));
}
public ActionResult Update(int id)
{
//need information about a particular news
News selectednews = db.News.SqlQuery("select * from news where newsid = @id", new SqlParameter("@id", id)).FirstOrDefault();
List <Category> categories = db.Categories.SqlQuery("select * from categories").ToList();
UpdateNews UpdateNewsViewModel = new UpdateNews();
UpdateNewsViewModel.News = selectednews;
UpdateNewsViewModel.category = categories;
//using viewmodel to get the list of all the categories in order to perform updation of the news.
return(View(UpdateNewsViewModel));
}
public object Put(UpdateNews request)
{
WebNews result = null;
var context = TepWebContext.GetWebContext(PagePrivileges.AdminOnly);
try {
context.Open();
context.LogInfo(this, string.Format("/news PUT Id='{0}'", request.Id));
if (request.Type.Equals(EntityType.GetEntityType(typeof(TwitterNews)).Keyword))
{
TwitterNews tweet = null;
tweet = TwitterNews.FromId(context, request.Id);
tweet = (TwitterNews)request.ToEntity(context, tweet);
tweet.Store();
result = new WebNews(tweet);
}
else if (request.Type.Equals(EntityType.GetEntityType(typeof(RssNews)).Keyword))
{
RssNews rss = null;
rss = RssNews.FromId(context, request.Id);
rss = (RssNews)request.ToEntity(context, rss);
rss.Store();
result = new WebNews(rss);
//} else if (request.Type.Equals(EntityType.GetEntityType(typeof(TumblrNews)).Keyword)){
// TumblrNews tumblr = null;
// tumblr = TumblrNews.FromId(context, request.Id);
// tumblr = (TumblrNews)request.ToEntity(context, tumblr);
// tumblr.Store();
// result = new WebNews(tumblr);
}
else
{
Article article = null;
article = Article.FromId(context, request.Id);
article = (Article)request.ToEntity(context, article);
article.Store();
result = new WebNews(article);
}
context.Close();
} catch (Exception e) {
context.LogError(this, e.Message, e);
context.Close();
throw e;
}
return(result);
}
public async Task <ActionResult> UpdateNews(string NewsID)
{
return(await Task.Run(() =>
{
ViewBag.Message = "Update new news.";
UpdateNews newForUpdate = null;
var news = StateNewsBL.Instance.Select(NewsID);
if (news != null)
{
var imgList = ImageDetailBL.Instance.StateNewsImageList(NewsID);
IImageDetail image = null;
if (imgList != null && imgList.Count() > 0)
{
image = imgList.FirstOrDefault(v => v.IsActive == 1 && v.IsFirst == 1);
}
newForUpdate = new UpdateNews
{
NewsID = news.NewsID,
Heading = news.Heading,
StateCode = news.StateCode,
ShortDesc = news.ShortDescription,
Description = news.NewsDescription,
Image = null,
ImageUrl = " ",
Caption = " ",
CaptionLink = string.Empty,
IsActiveNews = news.IsActive == 1 ? true : false,
IsApprovedNews = news.IsApproved == 1 ? true : false,
IsTopTenNews = news.IsTopNews == 1 ? true : false
};
if (image != null)
{
newForUpdate.ImageUrl = string.IsNullOrEmpty(image.ImageUrl) ? " " : image.ImageUrl;
newForUpdate.Caption = news.ImageCaption;
newForUpdate.CaptionLink = news.ImageCaptionLink;
}
}
return View(newForUpdate);
}));
}
public Task <UpdateNewsResponse> UpdateNewsAsync(UpdateNews dto)
{
return(Task.Run(() =>
{
var newsEntity = _newsRepository.Table.Where(t => t.Id.Equals(dto.id)).SingleOrDefault();
if (newsEntity == null)
{
throw new RequestErrorException("该新闻不存在!");
}
newsEntity.Introduction = dto.introduction;
newsEntity.IsHot = dto.is_hot;
newsEntity.NewsUrl = dto.news_url;
newsEntity.Thumbnail = dto.thumbnail_url;
newsEntity.Title = dto.title;
newsEntity.OffLine = dto.off_line;
_newsRepository.Update(newsEntity);
return new Community.Contact.News.UpdateNewsResponse();
}));
}
public async Task <IActionResult> Edit(NewsViewModel vm,
[FromServices] CreateNews createNews,
[FromServices] UpdateNews updateNews)
{
if (vm.Id > 0)
{
//Update post if it exists
await updateNews.DoAsync(new UpdateNews.Request
{
Id = vm.Id,
Title = vm.Title,
Body = vm.Body,
Image = vm.Image,
Created = vm.Created,
Description = vm.Description,
Tags = vm.Tags,
Category = vm.Category
});
}
else
{
//Create new post if not exists
await createNews.DoAsync(new CreateNews.Request
{
Title = vm.Title,
Body = vm.Body,
Image = vm.Image,
Created = DateTime.Now,
Description = vm.Description,
Tags = vm.Tags,
Category = vm.Category
});
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> UpdateNews(UpdateNews newForUpdate)
{
var dbHelpre = DBHelper.Instance;
dbHelpre.BeginTransaction();
return(await Task.Run(() =>
{
try
{
bool IsNotValid = false;
ViewBag.Message = "Update new news.";
if (ModelState.IsValid)
{
var news = new StateNews
{
NewsID = newForUpdate.NewsID,
Heading = newForUpdate.Heading.Trim(),
StateCode = newForUpdate.StateCode,
ShortDescription = newForUpdate.ShortDesc.Trim(),
NewsDescription = string.IsNullOrEmpty(newForUpdate.Description) ? string.Empty : newForUpdate.Description.Trim(),
IsActive = newForUpdate.IsActiveNews ? 1 : 0,
IsApproved = newForUpdate.IsApprovedNews ? 1 : 0,
IsTopNews = newForUpdate.IsTopTenNews ? 1 : 0,
DisplayOrder = 0
};
var image = new ImageDetail
{
ImageType = 2,
ImageUrl = newForUpdate.ImageUrl,
Caption = newForUpdate.Caption,
CaptionLink = newForUpdate.CaptionLink,
IsActive = 1,
IsFirst = 1
};
var fileName = string.Empty;
if (newForUpdate.Image != null && newForUpdate.Image.ContentLength > 0)
{
fileName = new Random().Next(1000000000).ToString() + Path.GetFileName(newForUpdate.Image.FileName);
image.ImageUrl = ImagePath.StateNewsImage + "/" + fileName;
image.IsActive = 1;
image.IsFirst = 1;
}
var user = (IUsers)this.Session[Constants.UserSessionKey];
StateNewsBL.Instance.UpdateNews(ref dbHelpre, news, image, user);
if (!string.IsNullOrEmpty(fileName))
{
if (SaveImage(ImagePath.StateNewsImage, fileName, newForUpdate.Image))
{
if (DeleteImage(ImagePath.StateNewsImage, newForUpdate.ImageUrl))
{
ViewBag.Message = "Updated successfully.";
ModelState.Clear();
}
else
{
IsNotValid = true;
}
}
else
{
IsNotValid = true;
}
}
newForUpdate.ImageUrl = image.ImageUrl;
}
else
{
IsNotValid = true;
}
if (IsNotValid)
{
dbHelpre.RollbackTransaction();
ModelState.AddModelError("INSERT", "Oops ! There is some error.");
ViewBag.Message = "Oops ! There is some error.";
}
else
{
ViewBag.Message = "Updated successfully.";
ModelState.Clear();
}
dbHelpre.CommitTransaction();
}
catch (Exception ex)
{
dbHelpre.RollbackTransaction();
throw ex;
}
finally
{
dbHelpre.ClearAllParameters();
dbHelpre.CloseConnection();
dbHelpre.Dispose();
}
return View(newForUpdate);
}));
}
public async Task <IHttpActionResult> Put([FromBody] UpdateNews dto)
{
var resp = await _newsService.UpdateNewsAsync(dto);
return(Ok(resp));
}
