public async Task <IActionResult> PutGoodBrandCode([FromRoute] int id, [FromBody] GoodBrandCode goodBrandCode) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != goodBrandCode.Id) { return(BadRequest()); } var getBrand = await _context.GetTransactionInv .Where(w => w.GoodBrandCode == goodBrandCode.GoodBrandcode) .GroupBy(g => new { g.GoodBrandName }) .Select(s => new { s.Key.GoodBrandName }) .ToListAsync(); var getSubCodePro = await _context.CodePromotion .Where(w => w.SubId == goodBrandCode.SubId) .GroupBy(g => new { g.SubCodePro }) .Select(s => new { s.Key.SubCodePro }) .ToListAsync(); goodBrandCode.GoodBrandName = getBrand[0].GoodBrandName; goodBrandCode.SubCodePro = getSubCodePro[0].SubCodePro; _context.Entry(goodBrandCode).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!GoodBrandCodeExists(id.ToString())) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostGoodBrandCode([FromBody] GoodBrandCode goodBrandCode) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var getBrand = await _context.GetTransactionInv .Where(w => w.GoodBrandCode == goodBrandCode.GoodBrandcode) .GroupBy(g => new { g.GoodBrandName }) .Select(s => new { s.Key.GoodBrandName }) .ToListAsync(); var getSubCodePro = await _context.CodePromotion .Where(w => w.SubId == goodBrandCode.SubId) .GroupBy(g => new { g.SubCodePro }) .Select(s => new { s.Key.SubCodePro }) .ToListAsync(); goodBrandCode.GoodBrandName = getBrand[0].GoodBrandName; goodBrandCode.SubCodePro = getSubCodePro[0].SubCodePro; _context.GoodBrandCode.Add(goodBrandCode); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (GoodBrandCodeExists(goodBrandCode.GoodBrandcode)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtAction("GetGoodBrandCode", new { id = goodBrandCode.GoodBrandcode }, goodBrandCode)); }