コード例 #1
0
        public IHttpActionResult Poststore_material(StoreMaterialRequestDto requestDto)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            store_material storeMaterial = new store_material();

            storeMaterial.store_id    = requestDto.storeId;
            storeMaterial.material_id = requestDto.materialId;
            storeMaterial.amount      = requestDto.amount;

            db.store_material.Add(storeMaterial);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (store_materialExists(requestDto))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            StoreMaterialDto storeMaterialDto = storeMaterialRepository.getStoreMaterial(requestDto);

            return(Ok(storeMaterialDto));
        }
コード例 #2
0
        public transaction convertTransaction(TransactionRequestDto dtos)
        {
            transaction transaction = new transaction();

            transaction.exchange_store_id = dtos.exchangeStoreId;
            transaction.store_id          = dtos.storeId;
            transaction.time                = stampConvert.convertTimeStamp(dtos.time);
            transaction.staff_id            = dtos.staffId;
            transaction.transaction_type_id = dtos.transactionTypeId;
            transaction.status_id           = dtos.statusId;

            foreach (var dto in dtos.detail)
            {
                transaction_detail detail = new transaction_detail();
                detail.trans_id    = dtos.id;
                detail.material_id = int.Parse(dto.material.id);
                detail.amount      = dto.materialAmount;
                db.transaction_detail.Add(detail);
                String[] list = new string[] { "EC", "EX01", "EX02", "IM02" };

                if (dtos.transactionTypeId == "EC")
                {
                    store_material storeMaterial = db.store_material.Where(s => s.store_id == dtos.storeId &&
                                                                           s.material_id == detail.material_id).FirstOrDefault();
                    storeMaterial.amount          = storeMaterial.amount - detail.amount;
                    db.Entry(storeMaterial).State = EntityState.Modified;
                    db.SaveChanges();
                }
            }
            return(transaction);
        }
コード例 #3
0
        public StoreMaterialDto getStoreMaterial(StoreMaterialRequestDto dto)
        {
            store_material storeMaterial = db.store_material.Where(s => s.store_id == dto.storeId &&
                                                                   s.material_id == dto.materialId).FirstOrDefault();
            StoreMaterialDto storeMaterialDto = new StoreMaterialDto(storeRepository.getSimpleStoreDto(storeMaterial.store_id),
                                                                     materialRepository.getSimpleMaterial(storeMaterial.material_id), storeMaterial.amount);

            return(storeMaterialDto);
        }
コード例 #4
0
        public IHttpActionResult Getstore_material(string storeId)
        {
            store_material storeMaterial = db.store_material.Where(s => s.store_id == storeId).FirstOrDefault();

            if (storeMaterial == null)
            {
                return(NotFound());
            }
            List <StoreMaterialDto> storeMaterialDtos = storeMaterialRepository.getStoreMaterials(storeMaterial.store_id);

            return(Ok(storeMaterialDtos));
        }
コード例 #5
0
        public IHttpActionResult Deletestore_material(string id)
        {
            store_material store_material = db.store_material.Find(id);

            if (store_material == null)
            {
                return(NotFound());
            }

            db.store_material.Remove(store_material);
            db.SaveChanges();

            return(Ok(store_material));
        }
コード例 #6
0
        public IHttpActionResult Putstore_material(string StoreId, StoreMaterialRequestDto requestDto)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (StoreId != requestDto.storeId)
            {
                return(BadRequest());
            }

            store_material storeMaterial = new store_material();

            storeMaterial.store_id    = requestDto.storeId;
            storeMaterial.material_id = requestDto.materialId;
            storeMaterial.amount      = requestDto.amount;

            db.Entry(storeMaterial).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!store_materialExists(requestDto))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }