public async Task <BasicResponse> DisablePortalLocation(int id)
        {
            using (var transaction = await _dbConfigContext.Database.BeginTransactionAsync())
            {
                try
                {
                    var entity = _dbConfigContext.PortalLocationControls.Where(x => x.Deleted == false && x.IsActive == true && x.Id == id).FirstOrDefault();
                    if (entity == null)
                    {
                        transaction.Dispose();
                        return(BasicResponse.Failed("Fail"));
                    }

                    entity.IsActive         = false;
                    entity.LastModifiedBy   = GetCurrentUserId();
                    entity.LastModifiedDate = DateTime.Now;
                    _dbConfigContext.PortalLocationControls.Update(entity);
                    await _dbConfigContext.SaveChangesAsync();

                    transaction.Commit();
                    transaction.Dispose();
                    return(BasicResponse.Succeed("Success"));
                }
                catch
                {
                    transaction.Rollback();
                    transaction.Dispose();
                    throw;
                }
            }
        }
Exemple #2
0
        public BasicResponse UpdateYachtMerchantCharterFee(YachtMerchantCharterFeeUpdateModel model)
        {
            try
            {
                var entity = _dbYachtContext.YachtMerchantCharterFeeOptions.AsNoTracking().Where(x => x.Deleted == false && x.Id == model.Id).FirstOrDefault();
                if (entity != null)
                {
                    var userId = _workContext.UserGuid;
                    entity = _mapper.Map <YachtMerchantCharterFeeUpdateModel, YachtMerchantCharterFeeOptions>(model, entity);
                    entity.LastModifiedBy   = userId;
                    entity.LastModifiedDate = DateTime.Now;

                    _dbYachtContext.YachtMerchantCharterFeeOptions.Update(entity);
                    _dbYachtContext.SaveChanges();

                    return(BasicResponse.Succeed("Update successfully!"));
                }

                return(BasicResponse.Failed("Update fail"));
            }
            catch
            {
                throw;
            }
        }
        public async Task <BasicResponse> UpdatePortalLocation(PortalLocationCreateModel model)
        {
            using (var transaction = _dbConfigContext.Database.BeginTransaction())
            {
                try
                {
                    var userId = _workContext.UserGuid;
                    var entity = _dbConfigContext.PortalLocationControls.Where(x => x.Deleted == false && x.IsActive == true && x.Id == model.Id).FirstOrDefault();
                    if (entity == null)
                    {
                        transaction.Dispose();
                        return(BasicResponse.Failed("Fail"));
                    }

                    entity = _mapper.Map <PortalLocationCreateModel, PortalLocationControls>(model, entity);
                    entity.LastModifiedBy   = userId;
                    entity.LastModifiedDate = DateTime.Now;
                    var result = _dbConfigContext.PortalLocationControls.Update(entity);
                    await _dbConfigContext.SaveChangesAsync();

                    transaction.Commit();
                    transaction.Dispose();
                    return(BasicResponse.Succeed("Success"));
                }
                catch
                {
                    transaction.Rollback();
                    transaction.Dispose();
                    throw;
                }
            }
        }
        public BasicResponse RemoveFile(int id)
        {
            using (var tran = _dataContext.Database.BeginTransaction())
            {
                try
                {
                    var fileInfo = _dataContext.FileStreamInfo.Where(x => x.FileId == id).FirstOrDefault();
                    if (fileInfo != null)
                    {
                        var fileData       = _dataContext.FileStreamData.Where(x => x.FileId == fileInfo.FileId).FirstOrDefault();
                        var deleteFileInfo = _dataContext.FileStreamInfo.Remove(fileInfo);
                        var deleteFileData = _dataContext.FileStreamData.Remove(fileData);
                        _dataContext.SaveChanges();

                        tran.Commit();
                        tran.Dispose();
                        return(BasicResponse.Succeed("Remove file successfully"));
                    }

                    tran.Dispose();
                    return(BasicResponse.Failed("Remove file fail"));
                }
                catch
                {
                    tran.Rollback();
                    tran.Dispose();
                    throw;
                }
            }
        }
Exemple #5
0
 public BasicResponse RemoveFile(int id)
 {
     try
     {
         var url = _baseFileStreamUrl + _apiUrlConfig.Value.FileManagementUrl.Index;
         var res = _aPIExcute.PostData <BasicResponse, int>($"{url}/{id}", APIHelpers.HttpMethodEnum.DELETE, null, _basicToken).Result;
         if (res.IsSuccessStatusCode)
         {
             return(res.ResponseData);
         }
         return(BasicResponse.Failed("Bad request"));
     }
     catch
     {
         throw;
     }
 }
 public async Task<BasicResponse> DeleteYachtAttribute(int id)
 {
     try
     {
         var entity = _dbYachtContext.YachtAttributes.FirstOrDefault(x => x.Id == id);
         if (entity != null)
         {
             entity.Deleted = true;
             _dbYachtContext.YachtAttributes.Update(entity);
             await _dbYachtContext.SaveChangesAsync();
             return BasicResponse.Succeed("Success");
         }
         else
             return BasicResponse.Failed("Not Found This Yacht Attribute");
     }
     catch
     {
         throw;
     }
 }
        public async Task <BasicResponse> CreateOrUpdateMembershipPrivileges(MembershipPrivilegesCreateModel model)
        {
            try
            {
                var check = CheckValidMembershipPrivileges(model);
                if (check)
                {
                    var entity = _dbConfigContext.AqmembershipDiscountPrivileges.FirstOrDefault(x => x.Id == model.ID);
                    if (entity != null)
                    {
                        entity.Name             = model.Name;
                        entity.Remark           = model.Remark;
                        entity.EffectiveDate    = model.EffectiveDate;
                        entity.EffectiveEndDate = model.EffectiveEndDate;
                        entity.LastModifiedBy   = GetCurrentUserId();
                        entity.LastModifiedDate = DateTime.Now;
                        entity.RoleFid          = model.RoleFID;
                        var details = _dbConfigContext.AqmembershipDiscountPrivilegeDetails.Where(x => x.PrivilegeFid == model.ID).ToList();
                        foreach (var i in details)
                        {
                            i.LastModifiedBy   = GetCurrentUserId();
                            i.LastModifiedDate = DateTime.Now;
                            i.DiscountPercent  = model.DataDetail.Find(x => x.ID == i.Id).DiscountPercent.GetValueOrDefault();
                        }
                        _dbConfigContext.AqmembershipDiscountPrivileges.Update(entity);
                        _dbConfigContext.AqmembershipDiscountPrivilegeDetails.UpdateRange(details);

                        UpdateOldMembershipPrivileges(entity);
                        _dbConfigContext.AqmembershipDiscountPrivileges.UpdateRange(entity);
                    }
                    else
                    {
                        var newMF = _mapper.Map <MembershipPrivilegesCreateModel, AqmembershipDiscountPrivileges>(model);
                        newMF.CreatedBy        = GetCurrentUserId();
                        newMF.CreatedDate      = DateTime.Now;
                        newMF.LastModifiedBy   = GetCurrentUserId();
                        newMF.LastModifiedDate = DateTime.Now;
                        _dbConfigContext.AqmembershipDiscountPrivileges.Add(newMF);
                        await _dbConfigContext.SaveChangesAsync();

                        var newDetails = _mapper.Map <List <MembershipPrivilegesDetailCreateModel>, List <AqmembershipDiscountPrivilegeDetails> >(model.DataDetail);
                        foreach (var i in newDetails)
                        {
                            i.PrivilegeFid     = newMF.Id;
                            i.LastModifiedBy   = GetCurrentUserId();
                            i.LastModifiedDate = DateTime.Now;
                        }
                        _dbConfigContext.AqmembershipDiscountPrivilegeDetails.AddRange(newDetails);
                        UpdateOldMembershipPrivileges(newMF);
                    }
                    await _dbConfigContext.SaveChangesAsync();

                    return(BasicResponse.Succeed("Success"));
                }
                else
                {
                    return(BasicResponse.Failed("Effective Date Invalid!"));
                }
            }
            catch
            {
                throw;
            }
        }