public async Task<BasicResponse> CreateOrUpdateYachtAttribute(YachtAttributeCreateModel model)
{
try
{
var entity = _dbYachtContext.YachtAttributes.FirstOrDefault(x => x.Id == model.Id);
if (entity != null)
{
entity = _mapper.Map<YachtAttributeCreateModel, YachtAttributes>(model, entity);
entity.IsDefault = model.IsDefault;
entity.LastModifiedBy = GetCurrentUserId();
entity.LastModifiedDate = DateTime.Now;
_dbYachtContext.YachtAttributes.Update(entity);
}
else
{
var newEntity = new YachtAttributes();
newEntity = _mapper.Map<YachtAttributeCreateModel, YachtAttributes>(model, newEntity);
newEntity.UniqueId = UniqueIDHelper.GenerateRandomString(12, false);
newEntity.IsDefault = model.IsDefault;
newEntity.CreatedBy = GetCurrentUserId();
newEntity.CreatedDate = DateTime.Now;
newEntity.LastModifiedBy = GetCurrentUserId();
newEntity.LastModifiedDate = DateTime.Now;
_dbYachtContext.YachtAttributes.Add(newEntity);
}
await _dbYachtContext.SaveChangesAsync();
return BasicResponse.Succeed("Success");
}
catch
{
throw;
}
}
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 bool CreateYachtMerchant(YachtMerchantCreateModel model)
{
using (var trans = _dbYachtContext.Database.BeginTransaction())
{
try
{
var userGuid = _workContext.UserGuid;
var userRoleId = _workContext.UserRoleId;
var entity = _mapper.Map <YachtMerchants>(model);
entity.UniqueId = UniqueIDHelper.GenerateRandomString(12, false);
entity.CreatedBy = userGuid;
entity.CreatedDate = DateTime.Now;
entity.LastModifiedBy = userGuid;
entity.LastModifiedDate = DateTime.Now;
_dbYachtContext.YachtMerchants.Add(entity);
_dbYachtContext.SaveChanges();
if (userRoleId == (int)UserRoleEnum.YachtMerchantManager)
{
var merchantAccountMgt = new YachtMerchantAqmgts
{
AqadminUserFid = userGuid,
MerchantFid = entity.Id,
MerchantName = entity.MerchantName,
CreatedBy = userGuid,
CreatedDate = DateTime.Now,
EffectiveStartDate = DateTime.Now,
EffectiveEndDate = DateTime.Now.AddYears(1),
Deleted = false,
LastModifiedBy = userGuid,
LastModifiedDate = DateTime.Now
};
_dbYachtContext.YachtMerchantAqmgts.AddAsync(merchantAccountMgt);
_dbYachtContext.SaveChanges();
}
trans.Commit();
trans.Dispose();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
trans.Dispose();
throw ex;
}
}
}
public ApiActionResult Create(CommonLanguaguesCreateModel model)
{
try
{
CommonLanguages obj = new CommonLanguages();
obj = _mapper.Map <CommonLanguages>(model);
obj.UniqueId = UniqueIDHelper.GenerateRandomString(12);
_dbConfigContext.CommonLanguages.Add(obj);
_dbConfigContext.SaveChanges();
return(ApiActionResult.Success());
}
catch (Exception ex)
{
return(ApiActionResult.Failed(ex.Message));
}
}
public ApiActionResult CreateNewPost(PostCreateModel model)
{
try
{
model.UniqueId = UniqueIDHelper.GenerateRandomString(12);
Posts obj = new Posts();
obj = _mapper.Map <Posts>(model);
obj.LastModifiedDate = model.LastModifiedDate;
obj.Deleted = false;
var res = _dbCMSContext.Posts.Add(obj);
_dbCMSContext.SaveChanges();
if (res.Entity.Id > 0)
{
model.postFileStream.ForEach(x => x.PostFid = res.Entity.Id);
var objFileStream = model.postFileStream.Select(k => new PostFileStreams
{
FileCategoryFid = k.FileCategoryFid,
FileCategoryResKey = k.FileCategoryResKey,
PostFid = res.Entity.Id,
FileStreamFid = k.FileStreamFid,
FileTypeFid = k.FileTypeFid,
FileTypeResKey = k.FileTypeResKey,
ActivatedDate = k.ActivatedDate,
LastModifiedDate = model.LastModifiedDate.Value,
LastModifiedBy = k.LastModifiedBy,
Deleted = false
});
_dbCMSContext.PostFileStreams.AddRange(objFileStream);
_dbCMSContext.SaveChanges();
PostDetails objDetail = new PostDetails();
objDetail = _mapper.Map <PostDetails>(model.postDetail);
objDetail.LastModifiedDate = model.postDetail.LastModifiedDate;
objDetail.Deleted = false;
objDetail.PostFid = res.Entity.Id;
var resDetail = _dbCMSContext.PostDetails.Add(objDetail);
_dbCMSContext.SaveChanges();
}
return(ApiActionResult.Success());
}
catch (Exception ex)
{
return(ApiActionResult.Failed(ex.Message));
throw ex;
}
}
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 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 ApiActionResult CreateNewCommonValues(CommonValueCreateModel model)
{
try
{
CommonValues obj = new CommonValues();
obj = _mapper.Map <CommonValueCreateModel, CommonValues>(model);
obj.UniqueId = UniqueIDHelper.GenerateRandomString(12);
_dbConfigContext.CommonValues.Add(obj);
var flag = _dbConfigContext.SaveChanges();
if (flag != 0)
{
return(ApiActionResult.Success());
}
return(ApiActionResult.Failed("Created Failed"));
}
catch (Exception ex)
{
return(ApiActionResult.Failed(ex.Message));
}
}
public bool CreateHotelMerchant(HotelMerchantCreateUpdateModel model)
{
var result = false;
var entity = new HotelMerchants();
entity = _mapper.Map <HotelMerchantCreateUpdateModel, HotelMerchants>(model, entity);
entity.UniqueId = UniqueIDHelper.GenerateRandomString(12);
entity.CreatedBy = _workContext.UserGuid;
entity.CreatedDate = DateTime.Now;
entity.LastModifiedBy = _workContext.UserGuid;
entity.LastModifiedDate = DateTime.Now;
var status = _dbHotelContext.HotelMerchants.Add(entity);
_dbHotelContext.SaveChanges();
if (status.State == EntityState.Unchanged)
{
result = true;
}
return(result);
}
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);
}
}