/// <summary> /// Delete itemn /// </summary> /// <param name="Id"></param> public void Delete(int Id) { var model = new NewsModels(); var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString); if (_conn.State == ConnectionState.Closed) { _conn.Open(); } //Create command store procedure var command = new SqlCommand("DeleteNewsById"); command.Connection = _conn; command.CommandType = CommandType.StoredProcedure; try { var IdParam = new SqlParameter("@Id", Id); IdParam.Direction = ParameterDirection.Input; command.Parameters.Add(IdParam); command.ExecuteScalar(); } finally { command.Connection.Close(); command.Connection.Dispose(); } }
public async Task <ActionResult> NewsAsyncAsync() { DateTime dt1 = DateTime.Now; var rss = new string[] { "http://articles.csdn.net/api/rss.php?tid=1008", "http://aspnet.codeplex.com/project/feeds/rss", "http://solidot.org.feedsportal.com/c/33236/f/556826/index.rss", "http://www.codeguru.com/icom_includes/feeds/codeguru/rss-csharp.xml", "http://feed.google.org.cn/" }; List <List <NewsItem> > list = new List <List <NewsItem> >(); foreach (var item in rss) { List <NewsItem> news = await(NewsModels.GetNews(item)); list.Add(news); } var model = list.SelectMany(x => x) .ToList() .OrderByDescending(x => x.PostDate) .Take(100); DateTime dt2 = DateTime.Now; ViewBag.TimeCost = new TimeSpan(dt2.Ticks - dt1.Ticks).ToString(); return(View("News", model)); }
public ActionResult Edit(int id) { var newsItem = NewsService.Find(id); if (newsItem == null) { SetFlashMessage("Tin tức cần sửa không tồn tại trên hệ thống."); return(RedirectToAction("Index")); } var newsEdit = new NewsModels { Id = newsItem.ID, Title = newsItem.Title, CategoryId = newsItem.TypeID ?? 0, ImageUrl = newsItem.Image, Summary = newsItem.Summary, Detail = newsItem.Detail, Keyword = newsItem.Keyword, Description = newsItem.Description, Order = newsItem.Order ?? 0, IsHot = newsItem.Hot ?? false, IsFast = newsItem.Fast ?? false, IsFeatured = newsItem.Featured ?? false, Status = newsItem.Status ?? false, Site = newsItem.Site }; ViewBag.ListCategory = BuildListCategory(); ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>(); return(View("Edit", newsEdit)); }
public ActionResult Create(NewsModels model) { try { if (ModelState.IsValid) { var user = User.Identity.Name; NewsModels news = new NewsModels(); news.Title = model.Title; news.Text = model.Text; news.Publisher = User.Identity.Name; db.News.Add(news); db.SaveChanges(); } // If we got this far, something failed, redisplay form return(RedirectToAction("Index", "News")); } catch { return(View()); } }
public ActionResult DetailPost(int Id = 1, int menuId = 1) { var newsDb = new NewsDb(); var newsModel = new NewsModels(); newsModel = newsDb.GetDetailNews(Id); return(View(newsModel)); }
// GET: MyAdminNews/Create public ActionResult Create() { var n = new NewsModels(); n.admin_id_Member = 1; n.topic_idTopic = 1; return(View(n)); }
public ActionResult Details(Guid id) { NewsService service = new NewsService(); var info = service.GetbyNews(id); var model = new NewsModels().ToModel(info); return(View(model)); }
// // GET: /News/ public PartialViewResult Index() { NewsService service = new NewsService(); NewsModels model = new NewsModels(); ViewBag.Newslist = service.GetNewslist(); return(PartialView()); }
public ActionResult NewsList(NewsModels model) { ServiceResult <List <NewsListOM> > result = new ServiceResult <List <NewsListOM> > { Data = _component.GetNewsList(model.NewsSetionId, model.PageSize.Value, model.PageIndex.Value) }; return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Update new item and return success of fail /// </summary> /// <returns></returns> public void Update(NewsModels model) { var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString); if (_conn.State == ConnectionState.Closed) { _conn.Open(); } //Create command store procedure var command = new SqlCommand("Update_tblNews"); command.Connection = _conn; command.CommandType = CommandType.StoredProcedure; try { var TitleParam = new SqlParameter("@Title", model.Title); TitleParam.Direction = ParameterDirection.Input; var TinhThanhIdParam = new SqlParameter("@TinhThanhId", model.TinhThanhId); TinhThanhIdParam.Direction = ParameterDirection.Input; var QuanHuyenIdParam = new SqlParameter("@QuanHuyenId", model.QuanHuyenId); QuanHuyenIdParam.Direction = ParameterDirection.Input; var AddressParam = new SqlParameter("@Address", model.Address); AddressParam.Direction = ParameterDirection.Input; var MenuIdParam = new SqlParameter("@MenuId", model.MenuId); MenuIdParam.Direction = ParameterDirection.Input; var DientichParam = new SqlParameter("@Dientich", model.Dientich); DientichParam.Direction = ParameterDirection.Input; var PriceParam = new SqlParameter("@Price", model.Price); PriceParam.Direction = ParameterDirection.Input; var PhoneNumberParam = new SqlParameter("@PhoneNumber", model.PhoneNumber); PhoneNumberParam.Direction = ParameterDirection.Input; var NewsContentParam = new SqlParameter("@NewsContent", model.NewsContent); NewsContentParam.Direction = ParameterDirection.Input; var UserIdParam = new SqlParameter("@UserId", model.UserId); UserIdParam.Direction = ParameterDirection.Input; var IdParam = new SqlParameter("@Id", model.Id); IdParam.Direction = ParameterDirection.Input; command.Parameters.Add(TitleParam); command.Parameters.Add(TinhThanhIdParam); command.Parameters.Add(QuanHuyenIdParam); command.Parameters.Add(AddressParam); command.Parameters.Add(MenuIdParam); command.Parameters.Add(DientichParam); command.Parameters.Add(PriceParam); command.Parameters.Add(PhoneNumberParam); command.Parameters.Add(NewsContentParam); command.Parameters.Add(UserIdParam); command.Parameters.Add(IdParam); command.ExecuteScalar(); } finally { command.Connection.Close(); command.Connection.Dispose(); } }
public ActionResult OnCreate(NewsModels news) { if (ModelState.IsValid) { news.ImageUrl = news.Image != null? news.Image.Upload() : news.ImageUrl; var newsItem = new News { Title = news.Title, TypeID = news.CategoryId, Image = news.ImageUrl, Summary = news.Summary, Detail = news.Detail, Keyword = news.Keyword, Description = news.Description, Order = news.Order, Hot = news.IsFast, Fast = news.IsFast, Featured = news.IsFeatured, Status = news.Status, Date = news.CreatedAt, Site = news.Site }; var result = NewsService.Insert(newsItem); if (result == Result.Exists) { ModelState.AddModelError("", string.Format("Tin tức '{0}' đã tồn tại trên hệ thống.", news.Title)); ViewBag.ListCategory = BuildListCategory(); ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>(); return(View("Create", news)); } SetFlashMessage(string.Format("Thêm tin tức '{0}' thành công.", news.Title)); if (news.SaveList) { return(RedirectToAction("Index")); } ModelState.Clear(); ViewBag.ListCategory = BuildListCategory(); ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>(); return(View("Create", news.ResetValue())); } ViewBag.ListCategory = NewsGroupService.GetAll().Select ( cate => new MutilCategoryItem { Name = cate.Name, Id = cate.ID, ParentId = cate.Parent } ).ToList(); return(View("Create", news)); }
// GET: MyAdminNews/Details/5 public ActionResult Details(int id) { var detailsNews = ns.getNewsById(id); NewsModels item = new NewsModels(); item.idNews = detailsNews.idNews; item.title = detailsNews.title; item.description = detailsNews.description; item.topic = detailsNews.topic; return(View(item)); }
/// <summary> /// Get News by Id /// </summary> /// <param name="Id"></param> /// <returns></returns> public NewsModels GetDetailNews(int Id) { var model = new NewsModels(); var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString); if (_conn.State == ConnectionState.Closed) { _conn.Open(); } //Create command store procedure var command = new SqlCommand("GetDetailNews"); command.Connection = _conn; command.CommandType = CommandType.StoredProcedure; try { var IdParam = new SqlParameter("@Id", Id); IdParam.Direction = ParameterDirection.Input; command.Parameters.Add(IdParam); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { model.Id = reader.GetInt32(0); model.Title = reader.GetString(1); model.TinhThanhId = reader.GetInt32(2); model.QuanHuyenId = reader.GetInt32(3); model.Address = reader.GetString(4); model.MenuId = reader.GetInt32(5); model.MenuIdHidden = reader.GetInt32(5); model.Dientich = reader.GetString(6); model.Price = reader.GetString(7); model.PhoneNumber = reader.GetString(8); model.NewsContent = reader.GetString(9); model.UserId = reader.GetInt32(10); model.MenuName = reader.GetString(11); model.Datetime = reader.GetDateTime(12); break; } reader.Close(); } } finally { command.Connection.Close(); command.Connection.Dispose(); } return(model); }
// GET: MyAdminNews/Edit/5 public ActionResult Edit(int id) { var detailsNews = ns.getNewsById(id); NewsModels item = new NewsModels(); item.idNews = detailsNews.idNews; item.title = detailsNews.title; item.description = detailsNews.description; item.picture = detailsNews.picture; item.admin_id_Member = detailsNews.admin_id_Member; item.topic_idTopic = detailsNews.topic_idTopic; return(View(item)); }
public ActionResult EditPost(NewsModels model, string CaptchaText) { var areaDb = new AreaDb(); var listArea = areaDb.GetAll(); ViewBag.listArea = listArea; var listAreaChild = areaDb.GetListAreaById(1); ViewBag.listAreaChild = listAreaChild; if (model.MenuId == 0) { ModelState.AddModelError("MenuId", "Vui lòng chọn chuyên mục."); } if (model.QuanHuyenId == 0) { ModelState.AddModelError("QuanHuyenId", "Vui lòng chọn quận huyện."); } if (model.TinhThanhId == 0) { ModelState.AddModelError("TinhThanhId", "Vui lòng chọn tỉnh thành."); } if (this.Session["CaptchaImageText"].ToString() != CaptchaText) { ModelState.AddModelError("CaptchaText", "Mã xác nhận không đúng"); } if (!ModelState.IsValid) { return(View(model)); } var newsDb = new NewsDb(); var userId = new UserDb().GetUserInfo(User.Identity.Name).Id; if (model.UserId == userId) { newsDb.Update(model); Session["AddNewsSuccessMessage"] = "Sửa bài viết thành công!"; return(RedirectToAction("EditPost", "News", new { @Id = model.Id })); } else { return(RedirectToAction("MyPost", "News")); } }
public ActionResult OnEdit(NewsModels news) { if (ModelState.IsValid) { news.ImageUrl = news.Image != null? news.Image.Upload() : news.ImageUrl.ToImageOriginalPath(); var newsItem = new News { ID = news.Id, Title = news.Title, TypeID = news.CategoryId, Image = news.ImageUrl, Summary = news.Summary, Detail = news.Detail, Keyword = news.Keyword, Description = news.Description, Order = news.Order, Hot = news.IsFast, Fast = news.IsFast, Featured = news.IsFeatured, Status = news.Status, Date = news.CreatedAt, Site = news.Site }; var result = NewsService.Update(newsItem); if (result == Result.NotExists) { ModelState.AddModelError("", "Tin tức không tồn tại trên hệ thống."); ViewBag.ListCategory = BuildListCategory(); ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>(); return(View("Edit", news)); } SetFlashMessage(string.Format("Sửa tin tức '{0}' thành công.", news.Title)); if (news.SaveList) { return(RedirectToAction("Index")); } ViewBag.ListCategory = BuildListCategory(); ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>(); return(View("Edit", news)); } ViewBag.ListCategory = BuildListCategory(); ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>(); return(View("Edit")); }
///查看更多 切换显示Ajax public JsonResult SeeAjaxIndex(string NewsType, int pagings = 0) { NewsModels model = new NewsModels(); NewsService service = new NewsService(); model.Condition.PageSize = 3; model.Condition.NewsType = new Guid(NewsType); Paging paging = new Paging(model.Condition); var ser = service.SearchNews(model.Condition, ref paging); NewsModelsListModel models = new NewsModelsListModel(ser); models.Paging = paging; models.Total = paging.Total.ToString(); models.Index = paging.PageIndex.ToString(); models.Size = paging.PageSize.ToString(); return(Json(models, JsonRequestBehavior.AllowGet)); }
public JsonResult FenyeSeeMoreNew(string type = "", int pagings = 0) { NewsModels model = new NewsModels(); NewsService service = new NewsService(); model.Condition.PageSize = 3; model.Condition.NewsType = new Guid(type); Paging paging = new Paging(model.Condition); paging.PageIndex = pagings; var news = service.SearchNews(model.Condition, ref paging); NewsModelsListModel models = new NewsModelsListModel(news); models.Paging = paging; models.Total = paging.Total.ToString(); models.Index = paging.PageIndex.ToString(); models.Size = paging.PageSize.ToString(); return(Json(models, JsonRequestBehavior.AllowGet)); }
// GET: MyAdminNews/Delete/5 /* public ActionResult Delete(int id) * { * var detailsNews = ns.getNewsById(id); * NewsModels item = new NewsModels(); * * item.idNews = detailsNews.idNews; * item.title = detailsNews.title; * item.description = detailsNews.description; * item.picture = detailsNews.picture; * item.admin_id_Member = detailsNews.admin_id_Member; * item.topic_idTopic = detailsNews.topic_idTopic; * * return View(item); * } */ // POST: MyAdminNews/Delete/5 /* [HttpPost] * public ActionResult Delete(NewsModels nm) * { * // news x = null; * Console.WriteLine("hani l fou9"); * * if (ModelState.IsValid) * { * * var n = ns.getNewsById(nm.idNews); * * //news item = new news(); * * * //n.idNews = nm.idNews; * /*n.idNews = nm.idNews; * n.title = nm.title; * n.description = nm.description; * n.picture = nm.picture; * n.admin_id_Member = nm.admin_id_Member; * n.topic_idTopic = nm.topic_idTopic; * * * * // ns.deleteNewsById(n.idNews); * * ns.Delete(n); * ns.Commit(); * } * * return RedirectToAction("Index"); * } */ ////////////////////// // GET: AdminSeaAward/Delete/5 public ActionResult Delete(int id) { news n = ns.getNewsById(id); NewsModels model = new NewsModels { idNews = n.idNews, title = n.title, description = n.description, picture = n.picture, video = n.video, like = n.like, comment = n.comment, admin_id_Member = 1, topic_idTopic = 1 }; return(View(model)); }
public ActionResult Edit(NewsModels nm) { if (ModelState.IsValid) { var n = ns.getNewsById(nm.idNews); n.idNews = nm.idNews; n.title = nm.title; n.description = nm.description; n.picture = nm.picture; n.admin_id_Member = nm.admin_id_Member; n.topic_idTopic = nm.topic_idTopic; ns.Update(n); ns.Commit(); } return(RedirectToAction("Index")); }
// CommentNewsByMember // POST // GET: MemberNews/Details/5 public ActionResult Details(int id) { var detailsNews = ns.getNewsById(id); NewsModels item = new NewsModels(); item.idNews = detailsNews.idNews; item.title = detailsNews.title; item.description = detailsNews.description; item.picture = detailsNews.picture; item.comment = detailsNews.comment; item.like = detailsNews.like; item.topic = detailsNews.topic; // CommentNewsByMember(item); return(View(item)); }
public ActionResult SeeMore(int pagings = 0) { NewsModels model = new NewsModels(); NewsService service = new NewsService(); model.Condition.PageSize = 3; model.Condition.NewsType = service.GetActivityTypeList("新闻类型").Where(n => n.Name == "要点新闻").FirstOrDefault().Id; Paging paging = new Paging(model.Condition); paging.PageIndex = pagings; var news = service.SearchNews(model.Condition, ref paging); NewsModelsListModel models = new NewsModelsListModel(news); models.Paging = paging; models.Total = paging.Total.ToString(); models.Index = paging.PageIndex.ToString(); models.Size = paging.PageSize.ToString(); models.DataDictionary = service.GetActivityTypeList("新闻类型"); return(View(models)); }
public ActionResult NewsSync() { DateTime dt1 = DateTime.Now; var rss = new string[] { "http://articles.csdn.net/api/rss.php?tid=1008", "http://aspnet.codeplex.com/project/feeds/rss", "http://solidot.org.feedsportal.com/c/33236/f/556826/index.rss", "http://www.codeguru.com/icom_includes/feeds/codeguru/rss-csharp.xml", "http://feed.google.org.cn/" }; var model = rss.SelectMany(x => NewsModels.GetNews(x).Result) .ToList() .OrderByDescending(x => x.PostDate) .Take(100); DateTime dt2 = DateTime.Now; ViewBag.TimeCost = new TimeSpan(dt2.Ticks - dt1.Ticks).ToString(); return(View("News", model)); }
public ActionResult Create(NewsModels nm) { if (ModelState.IsValid) { //UploadImage(); news n = new news { title = nm.title, description = nm.description, picture = nm.picture, admin_id_Member = nm.admin_id_Member, topic_idTopic = nm.topic_idTopic }; UploadImage(); ns.Add(n); ns.Commit(); } return(RedirectToAction("Index")); }
public IActionResult listnew() { NewsModels nm = new NewsModels(); News nw = new News(); var query = "SELECT * FROM tb_nilecon"; SqlConnection con = new SqlConnection(Startup.ConnectionString); SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { nw = new News(); if (reader["id"] != DBNull.Value) { nw.id = int.Parse(reader["id"].ToString()); } if (reader["title"] != DBNull.Value) { nw.titel = reader["title"].ToString(); } if (reader["sup_content"] != DBNull.Value) { nw.sup_content = reader["sup_content"].ToString(); } if (reader["main_content"] != DBNull.Value) { nw.main_content = reader["main_content"].ToString(); } if (reader["image"] != DBNull.Value) { nw.image = reader["image"].ToString(); } nm.LNews.Add(nw); } return(PartialView("Listnews", nm)); }
public ActionResult Delete(int id, NewsModels news) { try { if (User.IsInRole("Admin") || news.Publisher == User.Identity.Name) { db.Entry(news).State = EntityState.Deleted; db.SaveChanges(); } else { ViewBag.Error = "You cannot delete this News item, either because you are not the publisher or you are not Admin."; } return(RedirectToAction("Index", "News")); } catch { ViewBag.Error = "An error occurred while trying to delete the News item."; return(RedirectToAction("Index", "News")); } }
public ActionResult Edit(int id, NewsModels model) { try { if (ModelState.IsValid) { if (User.IsInRole("Admin") || model.Publisher == User.Identity.Name) { var user = User.Identity.Name; NewsModels news = new NewsModels { Id = model.Id, Title = model.Title, Text = model.Text, Publisher = User.Identity.Name }; db.Entry(news).State = EntityState.Modified; db.SaveChanges(); } else { ViewBag.Error = "You cannot edit the News item because, either you are not the publisher or you are not Admin."; return(RedirectToAction("Index", "News")); } } return(RedirectToAction("Details", "News", new { id = model.Id })); } catch { ViewBag.Error = "An error occurred while trying to edit the News item."; return(RedirectToAction("Index", "News")); } }
public ActionResult IndexNegative(NewsModels news) { return(PartialView("_NegativeVote", news)); }
public ActionResult Delete(int id, NewsModels model) { ns.DeleteNewsById(id); return(RedirectToAction("Index")); }
/// <summary> /// Tim kiem tin tuc /// </summary> /// <param name="Count">Tong so ban ghi</param> /// <param name="TinhThanhId">Tinh Thanh</param> /// <param name="QuanHuyenId">Quan Huyen</param> /// <param name="TitleSearch">Tu khoa tim kiem</param> /// <param name="Price">Gia tien</param> /// <param name="PageNumber">Trang thu bao nhieu</param> /// <param name="RowsPage">So luong dong tren 1 trang</param> /// <param name="UserId">Menu</param> /// <returns></returns> public List <NewsModels> SearchMyPost( out int Count, int TinhThanhId = 0, int QuanHuyenId = 0, String TitleSearch = "", String Price = "", int PageNumber = 0, int RowsPage = 0, int UserId = 0) { var listSearch = new List <NewsModels>(); var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString); if (_conn.State == ConnectionState.Closed) { _conn.Open(); } //Create command store procedure var command = new SqlCommand("Search_MyPost"); command.Connection = _conn; command.CommandType = CommandType.StoredProcedure; var CountTitleParam = new SqlParameter("@CountTitle", SqlDbType.Int); CountTitleParam.Direction = ParameterDirection.Output; var TinhThanhIdParam = new SqlParameter("@TinhThanhId", TinhThanhId); TinhThanhIdParam.Direction = ParameterDirection.Input; var QuanHuyenIdParam = new SqlParameter("@QuanHuyenId", QuanHuyenId); QuanHuyenIdParam.Direction = ParameterDirection.Input; var TitleSearchParam = new SqlParameter("@TitleSearch", TitleSearch); TitleSearchParam.Direction = ParameterDirection.Input; var PriceParam = new SqlParameter("@Price", Price); PriceParam.Direction = ParameterDirection.Input; var PageNumberParam = new SqlParameter("@PageNumber", PageNumber); PageNumberParam.Direction = ParameterDirection.Input; var RowspPageParam = new SqlParameter("@RowspPage", RowsPage); RowspPageParam.Direction = ParameterDirection.Input; var MenuIdParam = new SqlParameter("@UserId", UserId); MenuIdParam.Direction = ParameterDirection.Input; command.Parameters.Add(TinhThanhIdParam); command.Parameters.Add(QuanHuyenIdParam); command.Parameters.Add(TitleSearchParam); command.Parameters.Add(PriceParam); command.Parameters.Add(PageNumberParam); command.Parameters.Add(RowspPageParam); command.Parameters.Add(MenuIdParam); command.Parameters.Add(CountTitleParam); try { Count = 0; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var model = new NewsModels(); model.Number = (int)reader.GetInt64(0); model.Id = reader.GetInt32(1); model.Title = reader.GetString(2); model.NewsContent = reader.GetString(3); model.Price = reader.GetString(4); model.MenuName = reader.GetString(5); model.Datetime = reader.GetDateTime(6); listSearch.Add(model); } reader.Close(); } } finally { command.Connection.Close(); command.Connection.Dispose(); } Count = CountTitleParam.Value as int? ?? default(int); return(listSearch); }