public bool RestorePost(int postID)
{
try
{
var obj = _dbCMSContext.Posts.AsNoTracking().FirstOrDefault(x => x.Id == postID);
obj.Deleted = false;
_dbCMSContext.Posts.Update(obj);
_dbCMSContext.SaveChanges();
var objDetail = _dbCMSContext.PostDetails.AsNoTracking().Where(x => x.PostFid == postID).ToList();
objDetail.ForEach(x => x.Deleted = false);
_dbCMSContext.PostDetails.UpdateRange(objDetail);
_dbCMSContext.SaveChanges();
var objFileStream = _dbCMSContext.PostFileStreams.AsNoTracking().Where(x => x.PostFid == postID).ToList();
_dbCMSContext.PostFileStreams.UpdateRange(objFileStream);
objFileStream.ForEach(x => x.Deleted = false);
int res = _dbCMSContext.SaveChanges();
if (res > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
throw ex;
}
}
public long UpdatePostDetail(PostDetailCreateModel model)
{
try
{
var entity = _dbCMSContext.PostDetails.Find(model.Id);
if (entity == null || entity.Deleted)
{
throw new ArgumentNullException("Post detail");
}
int oldFileStreamId = entity.FileStreamFid;
entity = _mapper.Map(model, entity);
entity.UniqueId = entity.UniqueId ?? UniqueIDHelper.GenerateRandomString(UNIQUE_ID_LENGTH);
entity.LastModifiedDate = DateTime.Now;
entity.LastModifiedBy = _workContext.UserGuid;
_dbCMSContext.SaveChanges();
if (entity.Id > 0)
{
if (model.FileStreamFid > 0 && oldFileStreamId != model.FileStreamFid)
{
#region Insert new post file stream
entity.FileTypeFid = (int)FileTypeEnum.Image;
var fileStreamModel = PreparingPostFileStreamCreateModel(entity, PostFileCategoryEnum.Thumbnail);
_postFileStreamService.CreatePostFileStream(fileStreamModel);
_postFileStreamService.DeletePostFileStream(oldFileStreamId);
#endregion
}
if (model.FileDescriptionIds.Count > 0)
{
foreach (var id in model.FileDescriptionIds)
{
var item = PreparingPostFileStreamCreateModel(entity, PostFileCategoryEnum.Detail);
item.FileStreamFid = id;
_postFileStreamService.CreatePostFileStream(item);
}
}
var havePostDetailActive = _dbCMSContext.PostDetails.Count(x => x.PostFid == entity.PostFid && x.IsActivated) > 0;
var post = _dbCMSContext.Posts.Find(entity.PostFid);
post.IsActivated = havePostDetailActive;
post.LastModifiedBy = _workContext.UserGuid;
post.LastModifiedDate = DateTime.Now;
_dbCMSContext.SaveChanges();
}
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public long CreatePostDetail(PostDetailCreateModel model)
{
try
{
var existsPost = GetPostDetailByPostIdAndLanguageId(model.PostFid, model.LanguageFid);
if (existsPost != null)
{
throw new ArgumentNullException($"Post is existing with language={model.LanguageFid} and postId={model.PostFid}");
}
var entity = _mapper.Map <PostDetails>(model);
entity.UniqueId = UniqueIDHelper.GenerateRandomString(UNIQUE_ID_LENGTH);
entity.LastModifiedDate = DateTime.Now;
entity.LastModifiedBy = _workContext.UserGuid;
entity.Deleted = false;
_dbCMSContext.PostDetails.Add(entity);
_dbCMSContext.SaveChanges();
if (entity.Id > 0)
{
if (model.FileStreamFid > 0)
{
entity.FileTypeFid = (int)FileTypeEnum.Image;
var fileStreamModel = PreparingPostFileStreamCreateModel(entity, PostFileCategoryEnum.Thumbnail);
_postFileStreamService.CreatePostFileStream(fileStreamModel);
}
if (model.FileDescriptionIds.Count > 0)
{
foreach (var id in model.FileDescriptionIds)
{
var item = PreparingPostFileStreamCreateModel(entity, PostFileCategoryEnum.Detail);
item.FileStreamFid = id;
_postFileStreamService.CreatePostFileStream(item);
}
}
}
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public long CreatePostFileStream(PostFileStreamCreateModel model)
{
try
{
var entity = _mapper.Map <PostFileStreams>(model);
entity.LastModifiedDate = DateTime.Now;
entity.LastModifiedBy = _workContext.UserGuid;
entity.Deleted = false;
_dbCMSContext.PostFileStreams.Add(entity);
_dbCMSContext.SaveChanges();
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public long CreateNewPost(PostCreateModel model)
{
try
{
var entity = _mapper.Map <Posts>(model);
entity.Deleted = false;
entity.CreatedBy = _workContext.UserGuid;
entity.CreatedDate = DateTime.Now;
entity.UniqueId = UniqueIDHelper.GenerateRandomString(UNIQUE_ID_LENGTH);
var res = _dbCMSContext.Posts.Add(entity);
_dbCMSContext.SaveChanges();
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public bool DeletePostFileStream(int id)
{
try
{
var entity = _dbCMSContext.PostFileStreams.Find(id);
if (entity == null || entity.Deleted)
{
throw new ArgumentNullException("Post File Stream");
}
entity.Deleted = true;
entity.LastModifiedBy = _workContext.UserGuid;
entity.LastModifiedDate = DateTime.Now;
_dbCMSContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(false);
}
}
public long UpdatePostFileStream(PostFileStreamCreateModel model)
{
try
{
var entity = _dbCMSContext.PostFileStreams.Find(model.Id);
if (entity == null || entity.Deleted)
{
throw new ArgumentNullException("Post File Stream");
}
entity = _mapper.Map(model, entity);
entity.LastModifiedDate = DateTime.Now;
entity.LastModifiedBy = _workContext.UserGuid;
_dbCMSContext.SaveChanges();
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public int UpdatePostCategoryDetail(PostCategoryDetailCreateModel model)
{
try
{
var entity = _dbCMSContext.PostCategoryDetails.FirstOrDefault(x => x.PostCategoryFid == model.PostCategoryFid && x.Id == model.Id);
if (entity == null)
{
throw new ArgumentNullException("PostCategoryDetail");
}
_mapper.Map(model, entity);
entity.LastModifiedBy = _workContext.UserGuid;
entity.LastModifiedDate = DateTime.Now;
_dbCMSContext.SaveChanges();
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public int CreatePostCategoryDetail(PostCategoryDetailCreateModel model)
{
try
{
var entity = _mapper.Map <PostCategoryDetails>(model);
if (entity == null)
{
throw new ArgumentNullException("PostCategoryDetail");
}
entity.CreatedBy = _workContext.UserGuid;
entity.CreatedDate = DateTime.Now;
entity.Deleted = false;
_dbCMSContext.Add(entity);
_dbCMSContext.SaveChanges();
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public long UpdatePost(PostCreateModel model)
{
try
{
var entity = _dbCMSContext.Posts.Find(model.Id);
if (entity == null || entity.Deleted)
{
throw new ArgumentNullException("Post");
}
entity = _mapper.Map(model, entity);
entity.LastModifiedBy = _workContext.UserGuid;
entity.LastModifiedDate = DateTime.Now;
entity.UniqueId = entity.UniqueId ?? UniqueIDHelper.GenerateRandomString(UNIQUE_ID_LENGTH);
_dbCMSContext.SaveChanges();
return(entity.Id);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(0);
}
}
public bool DeletePostCategoryDetail(int id)
{
try
{
var entity = _dbCMSContext.PostCategoryDetails.FirstOrDefault(x =>
x.PostCategoryFid == id &&
!x.Deleted);
if (entity == null)
{
throw new ArgumentNullException("PostCategoryDetail");
}
entity.Deleted = true;
entity.LastModifiedBy = _workContext.UserGuid;
entity.LastModifiedDate = DateTime.Now;
_dbCMSContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
return(false);
}
}
public bool ChangeStatusPost(int postID, bool isActive)
{
try
{
var obj = _dbCMSContext.Posts.AsNoTracking().FirstOrDefault(x => x.Id == postID);
obj.IsActivated = isActive;
obj.LastModifiedBy = _workContext.UserGuid;
obj.LastModifiedDate = DateTime.Now;
_dbCMSContext.Posts.Update(obj);
var objDetail = _dbCMSContext.PostDetails.AsNoTracking().Where(x => x.PostFid == postID).ToList();
objDetail.ForEach(x => {
x.IsActivated = isActive;
if (isActive)
{
x.ActivatedBy = _workContext.UserGuid;
x.ActivatedDate = DateTime.Now;
}
else
{
x.ActivatedBy = null;
x.ActivatedDate = null;
}
});
int res = _dbCMSContext.SaveChanges();
if (res > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
AQException.ThrowException(ex);
throw ex;
}
}
