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;
}
