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