public async Task <IActionResult> Edit(int id, [Bind("NewsCategoryID,Name")] NewsCategory newsCategory) { if (id != newsCategory.NewsCategoryID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(newsCategory); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!NewsCategoryExists(newsCategory.NewsCategoryID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(newsCategory)); }
public NewsCategory GetNewsCategoryDetail(string id) { string sql = "SELECT * FROM NewsCategory WHERE CategoryId = '{0}'"; sql = string.Format(sql, id); SqlDataReader reader = SQLHelper.GetReader(sql); NewsCategory category = null; if (reader.Read()) { category = new NewsCategory() { CategoryId = reader["CategoryId"].ToString(), CategoryName = reader["CategoryName"].ToString(), Description = reader["Description"].ToString(), CreateTime = Convert.ToDateTime(reader["CreateTime"]), ModifyTime = Convert.ToDateTime(reader["ModifyTime"]), Enable = Convert.ToInt16(reader["Enable"]) }; } return(category); }
public static bool addNewsCategory(NewsCategory newsCategory, string connString) { #region code bool rs = false; using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sony_sp_add_news_category"; cmd.Parameters.AddWithValue("@name", newsCategory.Name); cmd.Parameters.AddWithValue("@seoUrl", newsCategory.SeoUrl); cmd.Parameters.AddWithValue("@imageUrl", newsCategory.ImageUrl); cmd.Parameters.AddWithValue("@parentId", newsCategory.ParentId); SqlParameter returnVal = new SqlParameter("@returnVal", SqlDbType.Int); returnVal.Direction = ParameterDirection.Output; cmd.Parameters.Add(returnVal); cmd.ExecuteNonQuery(); rs = ((int)cmd.Parameters["@returnVal"].Value != 0); } } catch (Exception ex) { return false; } } return rs; #endregion }
private void LoadContents() { if (ModuleConfigs.Count > 0) { int.TryParse(GetModuleConfigValue("CategoryId"), out iCategoryId); int.TryParse(GetModuleConfigValue("CaptionPage"), out iCaptionPageId); int.TryParse(GetModuleConfigValue("DetailPage"), out iDetailPageId); ModuleConfiguration configImgTopic = GetModuleConfig("TopicImage"); if (configImgTopic != null) { sTopicImage = configImgTopic.Value; } imgTopic.ImageUrl = sTopicImage; int.TryParse(GetModuleConfig("NumOfNewsShowOnModule").Value, out iNumOfNewsShowOnModule); NewsCategory cate = db.NewsCategories.SingleOrDefault <NewsCategory>(nc => nc.Id == iCategoryId); if (cate != null) { hplCaption.Text = cate.CategoryName; hplCaption.NavigateUrl = KHCNCT.Globals.Common.GenerateUrl(iCaptionPageId, "cid=" + cate.Id.ToString()); hplImageTopic.NavigateUrl = hplCaption.NavigateUrl; List <NewsContent> lstNews = (from nc in db.NewsContents where nc.ApprovementStatus == (short)EnumNewsApprovementStatus.DaXuatBan && nc.Hidden == false && (nc.CategoryId == iCategoryId || nc.NewsCategory.ParentId == iCategoryId) orderby nc.PublishFrom.Value descending, nc.CreatedTime.Value descending select nc).Take(iNumOfNewsShowOnModule).ToList <NewsContent>(); rptNews.DataSource = lstNews; rptNews.DataBind(); } } }
public News(string name, NewsCategory category, string title) { Name = name; Category = category; Title = title; ImageFile = string.Format("/Assets/Images/{0}/{1}.jpg", category, name); }
public ActionResult NewsManager() { IList <News> list = NewsBLL.GetAll(); List <News> newslist = new List <News>(); foreach (var temp in list) { News news = new News(); news.NewsId = temp.NewsId; news.NewsTitle = temp.NewsTitle; news.NewsCategory = temp.NewsCategory; news.PublishTime = temp.PublishTime; news.CategoryId = temp.CategoryId; newslist.Add(news); } IList <NewsCategory> lists = NewsCategoryBLL.GetAll(); List <NewsCategory> newscategorylist = new List <NewsCategory>(); foreach (var temp in lists) { NewsCategory newscategory = new NewsCategory(); newscategory.CategoryId = temp.CategoryId; newscategory.CategoryName = temp.CategoryName; newscategorylist.Add(newscategory); } ViewBag.NewsCategory = newscategorylist; return(View(newslist)); }
// public virtual void ParseHtml(HtmlNode documentNode, Pages page) public virtual void ParseHtml(string URL, NewsCategory page) { switch (page) { case NewsCategory.Official: // TODO delete not needed nodes from document node //var i = documentNode.SelectSingleNode(".//div[@id='riotbar-bar']"); //documentNode.SelectSingleNode("//div[@class='panel-pane pane-lolbar-navigation']").Remove(); // documentNode.SelectSingleNode("//div[@class='panel-pane pane-panels-mini pane-breadcrumb-title']").Remove(); // documentNode.SelectSingleNode("./div[@id='riotbar-subbar']").Remove(); break; case NewsCategory.SurrenderHome: case NewsCategory.ESports: case NewsCategory.PBE: case NewsCategory.RedPosts: case NewsCategory.Rotations: case NewsCategory.Releases: // TODO delete not needed nodes from document node break; } }
/// <summary> /// Форматирует данные для получения итогового списка категорий и новостей /// </summary> /// <param name="rssList"></param> /// <returns></returns> private static async Task <ObservableCollection <NewsCategory> > GetCategoriesAsync(List <Rss> rssList) { var categories = new ObservableCollection <NewsCategory>(); foreach (var rss in rssList) { var category = new NewsCategory { CategoryName = rss.Channel.Title.Substring(12), CategoryImagePath = await GetCategoryImgAsync(rss), Items = new ObservableCollection <NewsCategory.NewsItem>() }; foreach (var item in rss.Channel.Items) { DateTime date; DateTime.TryParse(item.PubDate, out date); category.Items.Add(new NewsCategory.NewsItem { NewsTitle = item.Title, NewsPubDate = date, NewsDescription = item.Description, NewsLink = item.Link, RelatedNewsItems = new ObservableCollection <NewsCategory.NewsItem>() }); } categories.Add(category); } return(categories); }
public Article(string title, string description, NewsCategory category) { this.title = title; this.description = description; Category = category; ImageFile = String.Format("/Assets/Images/{0}/{1}.jpg", category, title); }
public IList <NewsCategoryView> GetCategoryViewList(MobileParam mobileParams, int cver, out int sver) { #region instance var category = new NewsCategory() { Id = 1, Name = "热点", Status = 1, CreateDateTime = DateTime.Now }; var category2 = new NewsCategory() { Id = 2, Name = "财经", Status = 1, CreateDateTime = DateTime.Now }; #endregion var categorylist = new List <NewsCategory>() { category, category2 }; sver = 1; var result = categorylist.To <IList <NewsCategoryView> >(); return(result); }
public ActionResult Create([Bind(Include = "NewsCategoryId,Name")] NewsCategory newsCategory) { var loggedinuser = Session["bhuinfologgedinuser"] as AppUser; if (ModelState.IsValid) { if (loggedinuser != null) { newsCategory.DateCreated = DateTime.Now; newsCategory.DateLastModified = DateTime.Now; newsCategory.CreatedById = loggedinuser.AppUserId; newsCategory.LastModifiedById = loggedinuser.AppUserId; _db.NewsCategories.Add(newsCategory); _db.SaveChanges(); TempData["category"] = "This category has been created successfully!"; TempData["notificationtype"] = NotificationType.Success.ToString(); } else { TempData["login"] = "******"; TempData["notificationtype"] = NotificationType.Danger.ToString(); RedirectToAction("Create"); } return(RedirectToAction("Index")); } return(View(newsCategory)); }
public async Task <bool> Edit(string id, NewsServiceModel newsServiceModel) { NewsCategory newsCategoryFromDb = await this.context.NewsCategories .SingleOrDefaultAsync(newsCategory => newsCategory.Name == newsServiceModel.NewsCategory.Name); if (newsCategoryFromDb == null) { throw new ArgumentNullException(nameof(newsCategoryFromDb)); } News newsFromDb = await this.context.News.SingleOrDefaultAsync(news => news.Id == id); if (newsFromDb == null) { throw new ArgumentNullException(nameof(newsFromDb)); } newsFromDb.Title = newsServiceModel.Title; newsFromDb.Content = newsServiceModel.Content; newsFromDb.Picture = newsServiceModel.Picture; newsFromDb.NewsCategory = newsCategoryFromDb; this.context.Update(newsFromDb); int result = await this.context.SaveChangesAsync(); return(result > 0); }
public JsonResult Edit(NewsCategory model) { try { if (model.NewsCategoryId > 0) { var entity = _newsCategoryService.GetById(model.NewsCategoryId); //修改 entity.UTime = DateTime.Now; entity.Title = model.Title; entity.Sort = model.Sort; _newsCategoryService.Update(entity); } else { if (_newsCategoryService.IsExistName(model.Title)) { return(Json(new { Status = Successed.Repeat }, JsonRequestBehavior.AllowGet)); } //添加 model.CTime = DateTime.Now; model.UTime = DateTime.Now; _newsCategoryService.Insert(model); } return(Json(new { Status = Successed.Ok }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { Status = Successed.Error }, JsonRequestBehavior.AllowGet)); } }
protected void btnSave_Click(object sender, EventArgs e) { NewsCategory objContinents = new NewsCategory(); objContinents.Data = this.SetData(); int nResult = 0; string sLink = ""; string sAction = Request.QueryString[Constants.ACTION]; switch (sAction) { case Constants.ACTION_ADD: nResult = objContinents.Insert(); if (nResult > 0) { sLink = Constants.ROOT + Pages.BackEnds.ADMIN + "?" + Constants.PAGE + "=" + Pages.BackEnds.STR_NEWSCAT + "&" + Constants.MESS_ID + "=" + Constants.MESSAGE_INSERT; Response.Redirect(sLink); } else MessageBoxss.Show(MessagesAlert.INSERT_UNSUCCESSFUL); break; case Constants.ACTION_EDIT: int nID = ConvertData.ConvertToInt(Request.QueryString[Constants.ACTION_ID]); nResult = objContinents.Update(nID); if (nResult > 0) { MessageBoxss.Show(MessagesAlert.UPDATE_SUCCESSFUL); } else MessageBoxss.Show(MessagesAlert.UPDATE_UNSUCCESSFUL); break; } }
public IActionResult Put([FromBody] NewsCategoryViewModel model) { if (ModelState.IsValid && Validate(model)) { NewsCategory entity = Activator.CreateInstance <NewsCategory>(); entity = Service.AsObjectQuery().AsNoTracking().FirstOrDefault(f => EqualityComparer <int> .Default.Equals(f.Id, model.Id)); try { model.GetKeys(entity); Mapper.Map <NewsCategoryViewModel, NewsCategory>(model, entity); if (Service.TryUpdate(ref entity)) { model.AfterUpdateEntity(entity); } return(Ok(entity)); } catch (Exception ex) { ModelState.AddModelError("exception", ex.Message); return(BadRequest(ModelState)); } } return(BadRequest(ModelState)); }
public async Task <IList <Newsfeed> > LoadNewsfeedsAsync(NewsCategory page) { string URL = _settingsService[page].CategoryURL; _officialBaseURL = "https://" + new Uri(URL).Host; HtmlDocument doc = await _cookieWebClientService.GetPage(URL, page); if (doc == null) { return(new List <Newsfeed>()); } switch (page) { case NewsCategory.SurrenderHome: case NewsCategory.ESports: case NewsCategory.PBE: case NewsCategory.RedPosts: case NewsCategory.Rotations: case NewsCategory.Releases: _newsfeeds = await LoadSurrender(doc, page); break; case NewsCategory.Official: _newsfeeds = await LoadOfficial(doc, page); break; } return(_newsfeeds); }
public HttpResponseMessage Update(HttpRequestMessage request, NewsCategory newsCategory) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; if (!ModelState.IsValid) { response = request.CreateResponse(HttpStatusCode.BadRequest, ModelState); } else { var dbNewsCategory = this.newsCategoryService.GetById(newsCategory.Id); dbNewsCategory.Name = newsCategory.Name; dbNewsCategory.Alias = newsCategory.Alias; dbNewsCategory.Image = newsCategory.Image; dbNewsCategory.Description = newsCategory.Description; dbNewsCategory.ParentId = newsCategory.ParentId; dbNewsCategory.UpdatedDate = DateTime.Now; dbNewsCategory.Status = newsCategory.Status; dbNewsCategory.UpdatedBy = User.Identity.Name; this.newsCategoryService.Update(dbNewsCategory); this.newsCategoryService.Save(); response = request.CreateResponse(HttpStatusCode.Created, dbNewsCategory); } return response; })); }
public async Task Delete(NewsCategory category) { category.IsDeleted = true; await _entityService.Remove(category.Id, NewsCategoryEntityTypeId); _categoryRepository.SaveChanges(); }
public ActionResult UpdateCate(NewsCategory model) { if (ModelState.IsValid) { var obj = ServiceFactory.NewsCategoryManager.Get(new NewsCategory { NewsCategoryId = model.NewsCategoryId }); if (obj != null) { try { model.NewsCategoryShortName = model.NewsCategoryTitle.ToUrlSegment(250).ToLower(); ServiceFactory.NewsCategoryManager.Update(model, obj); return(RedirectToAction("SearchCate", "News")); } catch (Exception) { //throw; } } } var categories = ServiceFactory.NewsCategoryManager.GetAllActive(Culture); ViewBag.Categories = new SelectList(categories, "NewsCategoryId", "HlevelTitle"); ViewBag.IsEdit = true; return(View(model)); }
public NewsCategory AddCategory(NewsCategory toAdd) { this.categories.Add(toAdd); this.categories.SaveChanges(); return toAdd; }
public ActionResult GetModify(Int32?Id) { var newsCategoryFacade = NewsComponent.Instance.NewsCategoryFacade; var newsCategories = newsCategoryFacade.GetAll(); if (newsCategories.Count == 0) { var newsCategory = new NewsCategory { Title = "گروه پیش فرض", Enabled = true, CurrentUICultureName = SessionParameters.Culture }; if (!newsCategoryFacade.Insert(newsCategory)) { ShowMessage(Resources.Common.ErrorInInsert, Resources.Common.MessaageTitle, messageIcon: MessageIcon.Error); } } ViewBag.NewsCategory = new SelectList(newsCategoryFacade.GetAll(), "Id", "Title"); var news = Id.HasValue ? NewsComponent.Instance.NewsFacade.Get(Id) : new Radyn.News.DataStructure.News { PublishTime = DateTime.Now.ToShortTimeString(), PublishDate = DateTime.Now.ShamsiDate(), Enabled = true }; return(PartialView("PVModify", news)); }
public void SaveLastPostTitle(NewsCategory page, string lastPostTitle) { ISharedPreferencesEditor editor = PreferenceManager.GetDefaultSharedPreferences(Application.Context).Edit(); editor.PutString(PageToKey(page), lastPostTitle); editor.Apply(); }
/// <summary> /// Load chi tiet mot danh muc de cap nhat /// </summary> /// <param name="id"></param> private void LoadCategory(long id) { NewsCategory sc = db.NewsCategories.SingleOrDefault <NewsCategory>(s => s.Id == id); if (sc != null) { txtCategoryName.Text = sc.CategoryName; if (sc.ParentId.HasValue) { RadComboBoxItem item = rcbParentCategory.Items.FindItemByValue(sc.ParentId.ToString()); if (item != null) { item.Selected = true; } } if (!String.IsNullOrEmpty(sc.Icon)) { divIcon.Visible = true; imgIcon.ImageUrl = sc.Icon; } else { divIcon.Visible = false; } } }
public ActionResult Edit([Bind(Include = "NewsCategoryId,Name,DateCreated,DateLastModified,CreatedById,LastModifiedById")] NewsCategory newsCategory, FormCollection collectedValues) { var loggedinuser = Session["bhuinfologgedinuser"] as AppUser; if (ModelState.IsValid) { if (loggedinuser != null) { newsCategory.DateLastModified = DateTime.Now; newsCategory.LastModifiedById = loggedinuser.AppUserId; newsCategory.CreatedById = long.Parse(collectedValues["createdby"]); newsCategory.DateCreated = Convert.ToDateTime(collectedValues["date"]); _db.Entry(newsCategory).State = EntityState.Modified; _db.SaveChanges(); TempData["category"] = "This category has been modified successfully!"; TempData["notificationtype"] = NotificationType.Success.ToString(); } else { TempData["category"] = "Your session has expired,Login and try again!"; TempData["notificationtype"] = NotificationType.Danger.ToString(); RedirectToAction("Edit"); } return(RedirectToAction("Index")); } return(View(newsCategory)); }
public async Task <List <Newsfeed> > LoadOfficial(HtmlDocument Document, NewsCategory page) { List <Newsfeed> newsfeeds = new List <Newsfeed>(); _nextPageUrls[page] = _officialBaseURL + Document.DocumentNode.SelectSingleNode("//a[@class='next']").Attributes["href"].Value; HtmlNodeCollection nodes = Document.DocumentNode.SelectNodes("//div[@class='gs-container']"); foreach (HtmlNode node in nodes) { Newsfeed newsfeed = new Newsfeed(); try { newsfeed.Title = HttpUtility.HtmlDecode(node.SelectSingleNode(".//div[@class='default-2-3']").SelectSingleNode(".//a").InnerText); newsfeed.Date = HttpUtility.HtmlDecode(node.SelectSingleNode(".//div[@class='horizontal-group']").InnerText); newsfeed.UrlToNewsfeed = _officialBaseURL + node.SelectSingleNode(".//div[@class='default-2-3']").SelectSingleNode(".//a").Attributes["href"].Value; newsfeed.Image = await _cookieWebClientService.GetImage(_officialBaseURL + node.SelectSingleNode(".//img").Attributes["src"].Value.ToString()); newsfeed.ShortDescription = HttpUtility.HtmlDecode(node.SelectSingleNode(".//div[@class='teaser-content']").InnerText) .RemoveSpaceFromString(); newsfeed.Page = page; } catch { continue; } newsfeeds.Add(newsfeed); if (newsfeed.Title == null || newsfeed.UrlToNewsfeed == null || newsfeed.Image == null || newsfeed.ShortDescription == null) { throw new Exception(); } } return(newsfeeds); }
public ActionResult Show(int ID, string sortBy) { ViewBag.isAdmin = User.IsInRole("Administrator"); ViewBag.isEditor = User.IsInRole("Editor"); ViewBag.isUser = User.IsInRole("User"); ViewBag.userID = User.Identity.GetUserId(); if (TempData.ContainsKey("redirectMessage")) { ViewBag.notification = TempData["redirectMessage"].ToString(); if (TempData.ContainsKey("redirectMessageClass")) { ViewBag.notificationClass = TempData["redirectMessageClass"].ToString(); } else { ViewBag.notificationClass = "info"; } } try { NewsCategory category = db.NewsCategories.Find(ID); ViewBag.news = GetNewsArticlesByCategory(ID, sortBy); return(View("Show", category)); } catch (Exception e) { ViewBag.errorMessage = "Couldn't find news category #" + ID.ToString(); return(View("Error")); } }
public ActionResult Save(NewsCategory newsCategory) { if (!ModelState.IsValid) { var newsCategoryForm = new NewsCategoryForm { Name = newsCategory.Name }; return(View("Edit", newsCategoryForm)); } var categoryInDb = _repository.FindById(newsCategory.Id); if (categoryInDb == null) { // New Category CreateNewCategoryContext(newsCategory); // await _repository.Add(newsCategory); } else { // Update Category categoryInDb.Name = newsCategory.Name; _repository.SaveChanges(); } return(RedirectToAction("Index", "Categories")); }
public NewsCategory Add(NewsCategory NewsCategory) { var newsCategory = this.newsCategoryRepositories.Add(NewsCategory); this.unitOfWork.Save(); return(newsCategory); }
private async Task CheckNewPosts(NewsCategory page) { List <Newsfeed> list = new List <Newsfeed>(await _newsfeedService.LoadNewsfeedsAsync(page)); List <Newsfeed> newPosts = new List <Newsfeed>(); string lastPostTitle = _settingsService[page].LastPostTitle; if (lastPostTitle != null) { foreach (Newsfeed newsfeed in list) { if (newsfeed.Title == lastPostTitle) { break; } else { newPosts.Add(newsfeed); } } } _settingsService.SaveLastPostTitle(page, list[0].Title); if (newPosts.Count > 0) { _notificationService.ShowNewPostNotification(newPosts[0], page); //TODO Show all new post not only one } }
public JsonResult GetCategoryInfo(int id) { NewsCategory category = _uow.NewsCategoryRepo.FindNewsCategoryByID(id); string result = "Name:" + category.CategoryName + ",Order:" + category.CategoryOrder + ",MainCategory:" + category.MainCategory.ID; return(Json(result, JsonRequestBehavior.AllowGet)); }
public int GetDisplayOrder(int parentId, int display, string cal) { int res = 0; if (cal == "none") { res = (int)db.NewsCategories.Where(x => x.ParentID == parentId).Max(x => x.DisplayOrder) + 1; } if (cal == "minus") { for (int i = display - 1; i > 0; i--) { NewsCategory entity = db.NewsCategories.SingleOrDefault(x => x.ParentID == parentId && x.DisplayOrder == i); if (entity == null) { return(i); } } return(0); } if (cal == "plus") { while (true) { display++; NewsCategory entity = db.NewsCategories.SingleOrDefault(x => x.ParentID == parentId && x.DisplayOrder == display); if (entity == null) { return(display); } } } return(res); }
public void UpdateNewsCategory(NewsCategory newsCategory) { // ensure no other category exists with this title var similarCategory = _newsDbContext.NewsCategories .FirstOrDefault(x => x.Id != newsCategory.Id && x.Title == newsCategory.Title && x.UserId == newsCategory.UserId ); if (similarCategory != null) { throw new Exception($"Cannot update News category. A category named {newsCategory.Title} already exists."); } // locate and update the existing category var existingCategory = _newsDbContext.NewsCategories.FirstOrDefault(x => x.Id == newsCategory.Id); if (existingCategory == null) { throw new Exception($"Cannot update News category. Could not locate category {newsCategory.Id}"); } existingCategory.Title = newsCategory.Title; _newsDbContext.SaveChanges(); }
public async Task <IList <Newsfeed> > LoadMoreNewsfeeds(NewsCategory page) { List <Newsfeed> newsfeeds = new List <Newsfeed>(); HtmlDocument doc; if (_nextPageUrls.TryGetValue(page, out string url)) { doc = await _cookieWebClientService.GetPage(url, page); } else { throw new Exception("Filed to load next page url"); } switch (page) { case NewsCategory.SurrenderHome: case NewsCategory.ESports: case NewsCategory.PBE: case NewsCategory.RedPosts: case NewsCategory.Rotations: case NewsCategory.Releases: newsfeeds = await LoadSurrender(doc, page); break; case NewsCategory.Official: newsfeeds = await LoadOfficial(doc, page); break; } return(newsfeeds); }
private void BindDataToGrid(int CurrentPageIndex) { NewsCategory objCountry = new NewsCategory(); DataTable dtbContinents = new DataTable(); dtbContinents = objCountry.SearchAll(); RpNewsCategory.DataSource = dtbContinents; RpNewsCategory.DataBind(); }
public ActionResult NewsCategories_Destroy([DataSourceRequest]DataSourceRequest request, NewsCategoriesViewModel newsCategory) { if (ModelState.IsValid) { var entity = new NewsCategory { CategoryName = newsCategory.CategoryName }; this.newsCategries.Delete(entity.Id); } return Json(new[] { newsCategory }.ToDataSourceResult(request, ModelState)); }
protected void Page_Load(object sender, EventArgs e) { RpNewsCategoryDataBind(); if (int.TryParse(Request.QueryString["id"], out id)) { nc = NewsOperation.GetNewsCategoryById(id); if (!IsPostBack) { tbCategoryUpdate.Visible = true; tbxName.Text = nc.Name; tbxNote.Text = nc.Remark; } } else { tbCategoryUpdate.Visible = false; } }
protected void RpNewsCategory_ItemCommand(object source, RepeaterCommandEventArgs e) { string strCommand = e.CommandName; int nID = ConvertData.ConvertToInt(e.CommandArgument); NewsCategory objContinents = new NewsCategory(); switch (strCommand) { case "Delete": int nDelete = objContinents.DeleteById(nID); BindDataToGrid(1); break; case "Edit": string sEdit = Constants.ROOT + Pages.BackEnds.ADMIN + "?" + Constants.PAGE + "=" + Pages.BackEnds.STR_NEWSCAT_ADD + "&" + Constants.ACTION + "=" + Constants.ACTION_EDIT + "&" + Constants.ACTION_ID + "=" + nID; Response.Redirect(sEdit); break; } }
public ActionResult AddCategory(NewsCategory category) { if (Session["UserId"] == null) { return Redirect("/admin/login"); } if (category != null) { if (!string.IsNullOrEmpty(category.Id) && !string.IsNullOrEmpty(category.Name) && category.Sort > 0) { category.IsActive = true; NewsService newsService = new NewsService(); newsService.AddNewsCategory(category); Cache.UpdateNewsCategories();//更新缓存 } } return Redirect(Request.UrlReferrer.AbsoluteUri); }
private void BindDataWhenEdit() { string sAction = ConvertData.ConvertToString(Request.QueryString[Constants.ACTION]); try { if (sAction == Constants.ACTION_EDIT) { int nID = ConvertData.ConvertToInt(Request.QueryString[Constants.ACTION_ID]); if (nID > 0) { NewsCategory objContinents = new NewsCategory(); objContinents.LoadById(nID); txtDescript.Text = ConvertData.ConvertToString(objContinents.Data.Description); } } } catch { string sLink = Constants.ROOT + Pages.BackEnds.ADMIN + "?" + Constants.PAGE + "=" + Pages.BackEnds.STR_NEWSCAT + "&" + Constants.MESS_ID + "=" + Constants.ITEM_NOTEXIST; ; Response.Redirect(sLink); } }
private eNewsCategory SetData() { NewsCategory objCountry = new NewsCategory(); eNewsCategory eCountry = this.ContinentsEntity(); objCountry.Data.Description = ConvertData.ConvertToString(txtDescript.Text.Trim()); return objCountry.Data; }
/// <summary> /// 添加分类(成功返回success) /// </summary> public string AddNewsCategory(NewsCategory category) { string result = "添加失败"; var conn = DBRepository.GetSqlConnection(); try { conn.Open(); if (category != null) { if (!string.IsNullOrEmpty(category.Id) && !string.IsNullOrEmpty(category.Name) && category.Sort > 0) { NewsCategory temp = DBRepository.SelectOne<NewsCategory>("Id", category.Id, conn); conn.Close(); conn.Open(); if (temp == null) { category.IsActive = true; if (DBRepository.Insert<NewsCategory>(category, conn)) { result = "success"; } } } } else { result = "category对象为空"; LogService.Log("NewsService.AddNewsCategory", "category对象为空"); } } catch (Exception e) { result = "程序出现异常,详情见日志"; LogService.Log("添加分类", e.ToString()); } finally { conn.Close(); } return result; }
/// <summary> /// 更新分类 /// </summary> public string EditNewsCategory(NewsCategory category) { string result = "更新失败"; var conn = DBRepository.GetSqlConnection(); try { conn.Open(); if (category != null) { if (!string.IsNullOrEmpty(category.Id) && !string.IsNullOrEmpty(category.Name) && category.Sort > 0) { if (DBRepository.Update<NewsCategory>(category, "Id", conn)) { result = "success"; } } } else { result = "category对象为空"; LogService.Log("NewsService.AddNewsCategory", "category对象为空"); } } catch (Exception e) { result = "程序出现异常,详情见日志"; LogService.Log("更新分类", e.ToString()); } finally { conn.Close(); } return result; }
public static NewsCategory getNewsCategoryById(int categoryId, string connString) { #region code NewsCategory newsCategory = new NewsCategory(); using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sony_sp_get_news_category_by_id"; cmd.Parameters.AddWithValue("@id", categoryId); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { newsCategory.Id = (int)reader["id"]; newsCategory.Name = reader["name"].ToString(); newsCategory.SeoUrl = reader["seoUrl"].ToString(); newsCategory.ImageUrl = reader["imageUrl"].ToString(); newsCategory.Created = (DateTime)reader["created"]; newsCategory.Updated = (DateTime)reader["updated"]; } } } } catch (Exception ex) { return new NewsCategory(); } } return newsCategory; #endregion }
public static List<NewsCategory> getListNewSameParent(int p, string connString) { #region code List<NewsCategory> lists = new List<NewsCategory>(); using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sony_sp_get_all_category_same_parent"; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { NewsCategory newsCategory = new NewsCategory(); newsCategory.Id = (int)reader["id"]; newsCategory.Name = reader["name"].ToString(); newsCategory.SeoUrl = reader["seoUrl"].ToString(); newsCategory.ImageUrl = reader["imageUrl"].ToString(); newsCategory.ParentId = (int)reader["parentId"]; newsCategory.Created = (DateTime)reader["created"]; newsCategory.Updated = (DateTime)reader["updated"]; lists.Add(newsCategory); } } } } catch (Exception ex) { return new List<NewsCategory>(); } } return lists; #endregion }
private void BindDataToCategoryDropdown() { DataTable dtbCategory = new DataTable(); NewsCategory objCategory = new NewsCategory(); dtbCategory = objCategory.SearchAll(); ddlCategory.DataSource = dtbCategory; ddlCategory.DataValueField = "NewsCategoryID"; ddlCategory.DataTextField = "Description"; ddlCategory.DataBind(); //Utl1.SetNonSelectToControl(ddlCategory, "Tất cả", "0"); }
public void Update(NewsCategory toUpdate) { this.categories.Update(toUpdate); this.categories.SaveChanges(); }
private void BindDataToCategoryDropdown() { DataTable dtbCategory = new DataTable(); NewsCategory objCategory = new NewsCategory(); dtbCategory = objCategory.SearchAll(); ddlCategory.DataSource = dtbCategory; ddlCategory.DataValueField = "NewsCategoryID"; ddlCategory.DataTextField = "Description"; ddlCategory.DataBind(); Utl1.SetNonSelectToControl(ddlCategory, MultipleLanguage.DDL_SELECTVALUE, "0"); }
private string GetCategoryNameByID(int nCatID) { string sCategoryName = ""; NewsCategory objNewsCategory = new NewsCategory(); objNewsCategory.LoadById(nCatID); sCategoryName = ConvertData.ConvertToString(objNewsCategory.Data.Description); return sCategoryName; }
private eNewsCategory ContinentsEntity() { eNewsCategory entityContinents = new eNewsCategory(); int nItemID = ConvertData.ConvertToInt(Request.QueryString[Constants.ACTION_ID]); string sQueery = ConvertData.ConvertToString(Request.QueryString[Constants.ACTION]); if (nItemID > 0 && sQueery == Constants.ACTION_EDIT) { NewsCategory objContinents = new NewsCategory(); objContinents.LoadById(nItemID); entityContinents = objContinents.Data; } return entityContinents; }