public void UpdateStatus(int newsID, NewsStatus status) { DataCommand dc = DataCommandManager.GetDataCommand("News_UpdateStatus"); dc.SetParameterValue("@SysNo", newsID); dc.SetParameterValue("@Status", status); dc.SetParameterValueAsCurrentUserSysNo("@LastEditUserSysNo"); dc.ExecuteNonQuery(); }
/// <summary> /// Returns news for the specified type id /// </summary> /// <param name="typeId">New Type Name</param> /// <returns>NewsDetailView</returns> public IQueryable <NewsDetailView> GetNewsList(string typeName, NewsStatus status) { var q = from n in NewsData.NewsDetailViews where n.TypeUniqueName == typeName && n.Status == (int)status select n; return(q); }
/// <summary> /// Returns news for the specified type id /// </summary> /// <param name="typeId">New Type Id</param> /// <returns>NewsDetailView</returns> public IQueryable <NewsDetailView> GetNewsList(int typeId, NewsStatus status) { var q = from n in NewsData.NewsDetailViews where n.NewsType == typeId && n.Status == (int)status select n; return(q); }
public async Task <ActionResult <UpdateNewsResponse> > ChangeNewsStatus(int id, string status) { if (!NewsStatus.IsNewsStatus(status)) { return(BadRequest("News status is not valid")); } //Call Service return(await _newsServices.ChangeNewsStatus(id, status)); }
internal void PopulateData() { using (var context = new AppDbContext(options, null)) { if (context.NewsStatus.Count() < 1) { var p1 = new NewsStatus { NewsStatusID = 1, NewsStatusValue = 1, NewsStatusDescription = "NewsStatus 1", }; var p2 = new NewsStatus { NewsStatusID = 2, NewsStatusValue = 2, NewsStatusDescription = "NewsStatus 2", }; context.NewsStatus.Add(p1); context.NewsStatus.Add(p2); } if (context.LanguageType.Count() < 1) { var p1 = new LanguageType { LanguageTypeID = 1, LanguageTypeName = "LanguageType 1" }; var p2 = new LanguageType { LanguageTypeID = 2, LanguageTypeName = "LanguageType 2" }; context.LanguageType.Add(p1); context.LanguageType.Add(p2); } context.SaveChanges(); } using (var newscontext = new NEWSDBContext(newsoptions, null)) using (var context = new AppDbContext(options, null)) { if (newscontext.Feeder_Watches.Count() < 1) { var p1 = new Feeder_watches { pkWatchID = 1, Caption = "Feeder_watches 1", fkLanguageID = 1 }; var p2 = new Feeder_watches { pkWatchID = 2, Caption = "Feeder_watches 2", fkLanguageID = 2 }; newscontext.Feeder_Watches.Add(p1); newscontext.Feeder_Watches.Add(p2); } newscontext.SaveChanges(); } }
public void Update(NewsStatus obj, out OperationResult operationResult) { lock (Lock) { if (obj == null) { operationResult = new OperationResult { Type = OperationResult.ResultType.Warning }; return; } Common.Instance.Update (obj, objs => objs.NewsStatusId == obj.NewsStatusId, out operationResult); } }
public void Insert(NewsStatus obj, out OperationResult operationResult) { lock (Lock) { if (obj == null) { operationResult = new OperationResult { Type = OperationResult.ResultType.Warning }; } else { Common.Instance.Insert(obj, out operationResult); } } }
public bool SetAllNewsRead(int pid) { //取所有未读新闻标记 前1000条,超出无法标记后续 var news = GetNewsByProjectIDAndStatus(pid, 1, 1000, NewsConsts.NewsStatusUnread); foreach (var n in news) { NewsStatus status = new NewsStatus(); status.ProjectID = n.ProjectID; status.Status = NewsConsts.NewsStatusRead; status.Username = UserInfo.UserName; status.RecordID = n.ID; m_db.Insert("User_news_status", status); } return(true); }
public async Task <ActionResult <UpdateNewsResponse> > UpdateNews(UpdateNewsRequest request) { //Check Model State if (!ModelState.IsValid) { return(BadRequest(ModelState)); } //Check News Status if (!NewsStatus.IsNewsStatus(request.Status)) { return(BadRequest("News status is not valid, must be: " + string.Join(", ", NewsStatus.NewsStatusList))); } //Call Service return(await _newsServices.UpdateNews(request)); }
public bool SetNewsStatusRead(Int64 nid, int pid) { var ns = m_db.FirstOrDefault <NewsStatus>("SELECT * FROM User_news_status where record_id=@0 and username=@1", nid, UserInfo.UserName); if (ns == null) { NewsStatus status = new NewsStatus(); status.RecordID = nid; status.Status = 1; status.Username = UserInfo.UserName; status.ProjectID = pid; m_db.Insert("User_news_status", status); return(true); } m_db.Execute("update User_news_status set status=@0 where record_id=@1 and username=@2", NewsConsts.NewsStatusRead, nid, UserInfo.UserName); return(true); }
public IActionResult Create([FromBody] NewsStatus newmodel) { if (ModelState.IsValid) { _context.NewsStatus.Add(newmodel); ReturnData ret; ret = _context.SaveData(); if (ret.Message == "Success") { return(CreatedAtRoute("GetNewsStatus", new { id = newmodel.NewsStatusValue }, newmodel)); } return(NotFound(ret)); } else { return(BadRequest()); } }
public IActionResult UpdateEntry([FromBody] NewsStatus objupd) { var targetObject = _context.NewsStatus.FirstOrDefault(t => t.NewsStatusValue == objupd.NewsStatusValue); if (targetObject == null) { return(NotFound()); } _context.Entry(targetObject).CurrentValues.SetValues(objupd); ReturnData ret; ret = _context.SaveData(); if (ret.Message == "Success") { return(Ok()); } return(NotFound(ret)); }
public void NewsStatus() { IQueryable <NewsStatus> NewsStatusNewsStatus = Enumerable.Empty <NewsStatus>().AsQueryable(); NewsStatus ct = new NewsStatus { NewsStatusID = 1, NewsStatusDescription = "Test NewsStatus" }; Mock <INewsStatusRepository> NewsStatusService = new Mock <INewsStatusRepository>(); object obj = new object(); try { NewsStatusService.Setup(x => x.GetAll()).Returns(NewsStatusNewsStatus); NewsStatusService.Setup(x => x.Get(It.IsAny <int>())).Returns(ct); NewsStatusService.Setup(x => x.Add(It.IsAny <NewsStatus>())).Returns(ct); NewsStatusService.Setup(x => x.Delete(It.IsAny <NewsStatus>())).Verifiable(); NewsStatusService.Setup(x => x.Update(It.IsAny <NewsStatus>(), It.IsAny <object>())).Returns(ct); var NewsStatusObject = NewsStatusService.Object; var p1 = NewsStatusObject.GetAll(); var p2 = NewsStatusObject.Get(1); var p3 = NewsStatusObject.Update(ct, obj); var p4 = NewsStatusObject.Add(ct); NewsStatusObject.Delete(ct); Assert.IsAssignableFrom <IQueryable <NewsStatus> >(p1); Assert.IsAssignableFrom <NewsStatus>(p2); Assert.Equal("Test NewsStatus", p2.NewsStatusDescription); Assert.Equal("Test NewsStatus", p3.NewsStatusDescription); NewsStatusService.VerifyAll(); NewsStatusObject.Dispose(); } finally { NewsStatusService = null; } }
public ActionResult LikeOrDislikeANews(long Id, string actionType) { NewsStatus status = new NewsStatus(); if (ModelState.IsValid) { var loggedinuser = Session["bhuinfologgedinuser"] as AppUser; var newsModel = new NewsDataFactory().GetNewsById(Id); var news = _db.News.Find(Id); if (actionType == NewsActionType.Like.ToString()) { news.Likes = news.Likes + 1; status.NewsId = news.NewsId; if (loggedinuser != null) { status.LoggedInUserId = loggedinuser.AppUserId; } status.Status = NewsActionType.Like.ToString(); } else if (actionType == NewsActionType.Dislike.ToString()) { news.Dislikes = news.Dislikes + 1; status.NewsId = news.NewsId; if (loggedinuser != null) { status.LoggedInUserId = loggedinuser.AppUserId; } status.Status = NewsActionType.Dislike.ToString(); } _db.Entry(news).State = EntityState.Modified; _db.SaveChanges(); _dbe.NewsStatuses.Add(status); _dbe.SaveChanges(); return(PartialView("_LikeOrDislikePartial", newsModel)); } var newsToRedirect = _db.News.Find(Id); return(View("ViewNewsDetails", newsToRedirect)); }
public void NewsStatus() { using (var context = new AppDbContext(options, null)) { var controller = new NewsStatusController(context, null); // Get all var result = controller.Get(); // Assert var okResult = Assert.IsAssignableFrom <IEnumerable <NewsStatus> >(result); var pgcount = okResult.ToList().Count; Assert.Equal(2, pgcount); // Get by ID var result1 = controller.Get(1); var okResult1 = Assert.IsAssignableFrom <NewsStatus>(result1); Assert.Equal("NewsStatus 1", result1.NewsStatusDescription); // test update var pg1 = new NewsStatus { NewsStatusID = 1, NewsStatusValue = 1, NewsStatusDescription = "NewsStatus 1 upd" }; controller.UpdateEntry(pg1); var result3 = controller.Get(1); Assert.NotEqual("NewsStatus 1", result3.NewsStatusDescription); Assert.Equal("NewsStatus 1 upd", result3.NewsStatusDescription); // test delete var result4 = controller.Get(2); Assert.Equal("NewsStatus 2", result4.NewsStatusDescription); IActionResult result5 = controller.Delete(2); var viewResult = Assert.IsType <OkResult>(result5); var result6 = controller.Get(2); Assert.Null(result6); } }
///// <summary> ///// Возвращает датасет редакторов всех новостей. ///// </summary> ///// <returns>Датасет редакторов всех новостей.</returns> //public static DataSet GetNewsEditors() //{ // String query = "select distinct u.* from "; // query += ObjectMapper.GetDBTableName(typeof(Person)) + " u, "; // query += ObjectMapper.GetDBTableName(typeof(GroupMembership)) + " pg, "; // query += ObjectMapper.GetDBTableName(typeof(Group)) + " g "; // query += " where u.ID = pg.PersonID"; // query += " and pg.GroupID = g.ID"; // query += " and (g.GroupID = '" + Group.GroupsEnum.OfficeNewsEditor + "' or g.GroupID='" + Group.GroupsEnum.GeneralNewsEditor + "')"; // Query q = new Query(query); // DataSet ds = q.ExecDataSet(); // return ds; //} /// <summary> /// Возвращает датасет с результатами поиска новостей. /// </summary> /// <param name="SearchTerms">Искомые слова в тексте и заголовках.</param> /// <param name="SearchAuthor">Искомый автор.</param> public static DataSet SearchNews(PagingArgs args, out int total_count, string searchTerms, int searchAuthorID, NewsStatus newsStatus, int officeID, string[] offices, SearchPeriod period ) { if (searchTerms == null) searchTerms = String.Empty; // Period DateTime searchDateTime = new DateTime(1754, 1, 1); switch (period) { case SearchPeriod.Day: searchDateTime = DateTime.Now.AddDays(-1); break; case SearchPeriod.ThreeDays: searchDateTime = DateTime.Now.AddDays(-3); break; case SearchPeriod.Week: searchDateTime = DateTime.Now.AddDays(-7); break; case SearchPeriod.Month: searchDateTime = DateTime.Now.AddDays(-30); break; case SearchPeriod.HalfYear: searchDateTime = DateTime.Now.AddMonths(-6); break; case SearchPeriod.Year: searchDateTime = DateTime.Now.AddYears(-1); break; } // Author String[] aTerms; // aTerms = strSearchAuthor.Split(new char[] { ' ' }); String searchQuery = "SELECT t1.ID,Caption,Text,AuthorID,CreateTime,ExpireTime,OfficeID, PostID, t2.LastName FROM [Portal].[dbo].[News] t1 inner join (select ID,LastName from [Portal].[dbo].[Users]"; if (searchAuthorID != 0) { searchQuery += " where ("; /*searchQuery += " FirstName LIKE '%" + String.Join("%' OR FirstName LIKE '%", aTerms) + "%'"; searchQuery += " OR MiddleName LIKE '%" + String.Join("%' OR MiddleName LIKE '%", aTerms) + "%'"; searchQuery += " OR LastName LIKE '%" + String.Join("%' OR LastName LIKE '%", aTerms) + "%'";*/ searchQuery += "ID = " + searchAuthorID; searchQuery += " )"; } searchQuery += ") as t2 on t1.AuthorID = t2.ID "; searchQuery += " WHERE ( CreateTime >= CONVERT(datetime, '" + searchDateTime.ToString(CultureInfo.InvariantCulture.DateTimeFormat) + "', 101)"; // Terms aTerms = searchTerms.Split(new char[] { ' ' }); searchQuery += " AND (( Caption LIKE '%" + String.Join("%' AND Caption LIKE '%", aTerms) + "%' )"; searchQuery += " OR ( Text LIKE '%" + String.Join("%' AND Text LIKE '%", aTerms) + "%' ))"; switch (newsStatus) { case NewsStatus.ActualNews: searchQuery += " AND (ExpireTime > GetDate())"; break; case NewsStatus.ArchiveNews: searchQuery += " AND (ExpireTime <= GetDate())"; break; } if (officeID == -1) { searchQuery += " AND (OfficeID=" + String.Join(" OR OfficeID=", offices) + ")"; } else searchQuery += " AND OfficeID=" + officeID; searchQuery += ")"; Procedure procedure = new Procedure("uiGetObjectsPage"); procedure.Add("@PageIndex", args.PageIndex); procedure.Add("@PageSize", args.PageSize); procedure.Add("@OrderField", args.SortExpression); procedure.Add("@IsOrderASC", args.SortOrderASC); procedure.Add("@Query", searchQuery); procedure.AddReturnValueParameter(); DataSet ds = procedure.ExecDataSet(); total_count = Convert.ToInt32(procedure.GetReturnValue()); return ds; }
public IActionResult Update([FromBody] NewsStatus editentry) { var result = _repository.Update(editentry, editentry.NewsStatusID); return(Helper.CheckResult(result)); }
public IActionResult Create([FromBody] NewsStatus newentry) { var result = _repository.Add(newentry); return(Helper.CheckResult(result)); }
public ActionResult LikeOrDislikeANews(long Id, string actionType) { var loggedinuser = Session["bhuinfologgedinuser"] as AppUser; bool checkLike = false; bool checkDislike = false; NewsStatus status = new NewsStatus(); if (ModelState.IsValid) { var allNewsStatus = _dbe.NewsStatuses.ToList(); if (loggedinuser != null) { var checkLikeNewsStatus = allNewsStatus.SingleOrDefault( n => n.LoggedInUserId == loggedinuser.AppUserId && n.Status == NewsActionType.Like.ToString() && n.NewsId == Id); var checkDisLikeNewsStatus = allNewsStatus.SingleOrDefault( n => n.LoggedInUserId == loggedinuser.AppUserId && n.Status == NewsActionType.Dislike.ToString() && n.NewsId == Id); var newsModel = new NewsDataFactory().GetNewsById(Id); var news = _db.News.Find(Id); //compare for like status if (actionType == NewsActionType.Like.ToString() && checkLikeNewsStatus != null) { } if (actionType == NewsActionType.Like.ToString() && (checkLikeNewsStatus == null && checkDisLikeNewsStatus == null)) { news.Likes = news.Likes + 1; status.NewsId = news.NewsId; status.LoggedInUserId = loggedinuser.AppUserId; status.Status = NewsActionType.Like.ToString(); } if (actionType == NewsActionType.Dislike.ToString() && checkLikeNewsStatus != null) { news.Dislikes = news.Dislikes + 1; news.Likes = news.Likes - 1; status.NewsId = news.NewsId; status.LoggedInUserId = loggedinuser.AppUserId; status.Status = NewsActionType.Dislike.ToString(); checkDislike = true; } if (actionType == NewsActionType.Dislike.ToString() && (checkLikeNewsStatus == null && checkDisLikeNewsStatus == null)) { news.Dislikes = news.Dislikes + 1; status.NewsId = news.NewsId; status.LoggedInUserId = loggedinuser.AppUserId; status.Status = NewsActionType.Dislike.ToString(); } //compare for dislike status if (actionType == NewsActionType.Like.ToString() && checkDisLikeNewsStatus != null) { news.Dislikes = news.Dislikes - 1; news.Likes = news.Likes + 1; status.NewsId = news.NewsId; status.LoggedInUserId = loggedinuser.AppUserId; status.Status = NewsActionType.Like.ToString(); checkLike = true; } if (actionType == NewsActionType.Dislike.ToString() && checkDisLikeNewsStatus != null) { } if (checkDislike) { _dbe.NewsStatuses.Remove(checkLikeNewsStatus); _dbe.SaveChanges(); } if (checkLike) { _dbe.NewsStatuses.Remove(checkDisLikeNewsStatus); _dbe.SaveChanges(); } _db.Entry(news).State = EntityState.Modified; _db.SaveChanges(); _dbe.NewsStatuses.Add(status); _dbe.SaveChanges(); return(PartialView("_LikeOrDislikePartial", newsModel)); } } var newsToRedirect = _db.News.Find(Id); return(View("ViewNewsDetails", newsToRedirect)); }
public IList <News> GetAllNewsByStatus(NewsStatus newsStatus) { return(_newsRepository.Table.Where(a => a.NewsStatusId == (int)newsStatus).ToList()); }
/// <summary> /// درج مقادیر اولیه در دیتابیس به هنگام ساخت دیتابیس /// </summary> /// <param name="context">شی دیتابیس اصلی برنامه</param> protected override void Seed(AsefianContext context) { foreach (var item in Language.GetList()) { context.Language.Add(item); } #region Account foreach (var item in UserType.GetList()) { context.UserType.Add(item); } foreach (var item in BalanceType.GetList()) { context.BalanceType.Add(item); } foreach (var item in Browser.GetList()) { context.Browser.Add(item); } foreach (var item in DeviceType.GetList()) { context.DeviceType.Add(item); } foreach (var item in GroupStatus.GetList()) { context.GroupStatus.Add(item); } foreach (var item in NotificationStatus.GetList()) { context.NotificationStatus.Add(item); } foreach (var item in NotificationType.GetList()) { context.NotificationType.Add(item); } foreach (var item in Account.Enum.OperatingSystem.GetList()) { context.OperatingSystem.Add(item); } foreach (var item in Sex.GetList()) { context.Sex.Add(item); } foreach (var item in TokenType.GetList()) { context.TokenType.Add(item); } foreach (var item in UserAddressStatus.GetList()) { context.UserAddressStatus.Add(item); } foreach (var item in UserFavoriteFolderStatus.GetList()) { context.UserFavoriteFolderStatus.Add(item); } foreach (var item in UserFavoriteStatus.GetList()) { context.UserFavoriteStatus.Add(item); } foreach (var item in UserStatus.GetList()) { context.UserStatus.Add(item); } #endregion #region Blog foreach (var item in ArticleFileStatus.GetList()) { context.ArticleFileStatus.Add(item); } foreach (var item in ArticleStatus.GetList()) { context.ArticleStatus.Add(item); } foreach (var item in NewsStatus.GetList()) { context.NewsStatus.Add(item); } #endregion #region Core foreach (var item in BranchStatus.GetList()) { context.BranchStatus.Add(item); } foreach (var item in LocationType.GetList()) { context.LocationType.Add(item); } foreach (var item in SliderContentStatus.GetList()) { context.SliderContentStatus.Add(item); } foreach (var item in SliderStatus.GetList()) { context.SliderStatus.Add(item); } foreach (var item in SliderType.GetList()) { context.SliderType.Add(item); } #endregion #region Data foreach (var item in ExportStatus.GetList()) { context.ExportStatus.Add(item); } foreach (var item in ContactUsStatus.GetList()) { context.ContactUsStatus.Add(item); } foreach (var item in SpecialProjectStatus.GetList()) { context.SpecialProjectStatus.Add(item); } foreach (var item in SpecialProjectFileStatus.GetList()) { context.SpecialProjectFileStatus.Add(item); } foreach (var item in BrandStatus.GetList()) { context.BrandStatus.Add(item); } foreach (var item in CategoryFeatureStatus.GetList()) { context.CategoryFeatureStatus.Add(item); } foreach (var item in CategoryFeatureType.GetList()) { context.CategoryFeatureType.Add(item); } foreach (var item in CategoryStatus.GetList()) { context.CategoryStatus.Add(item); } foreach (var item in CategoryType.GetList()) { context.CategoryType.Add(item); } foreach (var item in DownloadCenterStatus.GetList()) { context.DownloadCenterStatus.Add(item); } foreach (var item in ProductFileStatus.GetList()) { context.ProductFileStatus.Add(item); } foreach (var item in ProductFileType.GetList()) { context.ProductFileType.Add(item); } foreach (var item in ProductFilterStatus.GetList()) { context.ProductFilterStatus.Add(item); } foreach (var item in ProductFilterType.GetList()) { context.ProductFilterType.Add(item); } foreach (var item in ProductFilterValueStatus.GetList()) { context.ProductFilterValueStatus.Add(item); } foreach (var item in ProductStatus.GetList()) { context.ProductStatus.Add(item); } foreach (var item in ServiceStatus.GetList()) { context.ServiceStatus.Add(item); } #endregion #region Financial foreach (var item in CouponStatus.GetList()) { context.CouponStatus.Add(item); } foreach (var item in CouponType.GetList()) { context.CouponType.Add(item); } foreach (var item in DeliveryType.GetList()) { context.DeliveryType.Add(item); } foreach (var item in InquiryStatus.GetList()) { context.InquiryStatus.Add(item); } foreach (var item in InvoiceDetailStatus.GetList()) { context.InvoiceDetailStatus.Add(item); } foreach (var item in InvoiceStatus.GetList()) { context.InvoiceStatus.Add(item); } foreach (var item in PaymentType.GetList()) { context.PaymentType.Add(item); } #endregion #region Support foreach (var item in FaqCategoryStatus.GetList()) { context.FaqCategoryStatus.Add(item); } foreach (var item in FaqStatus.GetList()) { context.FaqStatus.Add(item); } foreach (var item in MessageBoxStatus.GetList()) { context.MessageBoxStatus.Add(item); } foreach (var item in NewsLetterStatus.GetList()) { context.NewsLetterStatus.Add(item); } foreach (var item in TicketMessageType.GetList()) { context.TicketMessageType.Add(item); } foreach (var item in TicketPriority.GetList()) { context.TicketPriority.Add(item); } foreach (var item in TicketStatus.GetList()) { context.TicketStatus.Add(item); } foreach (var item in MessageType.GetList()) { context.MessageType.Add(item); } #endregion var admin = new User() { FirstName = "مدیر", LastName = "سیستم", MobileNumber = "09122424519", MobileNumberValid = true, Email = "*****@*****.**", EmailValid = true, SexId = Sex.Male.Id, TypeId = UserType.Insider.Id, Password = PasswordUtility.Encrypt("alialiali"), StatusId = UserStatus.Active.Id, Permission = 1, CreateDate = DateTime.Now, ModifyDate = DateTime.Now, CreateIp = "::1", ModifyIp = "::1" }; context.User.Add(admin); }