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