public async Task<IHttpActionResult> Puthd(short id, Hd hd) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != hd.Id) { return BadRequest(); } try { await _repository.Update(hd); } catch (DbUpdateConcurrencyException msgDbUpdateConcurrencyException) { return InternalServerError(msgDbUpdateConcurrencyException); } catch (KeyNotFoundException) { return NotFound(); } return StatusCode(HttpStatusCode.NoContent); }
public async Task<bool> Update(Hd item) { /*{ "Name":"??", "Code":"??", "HdIdUpline" : "??" }*/ //check IdExists var header = await IdExist(item.Id); //check Upline invalid if (item.HdIdUpline != null && item.HdIdUpline != 0) { var up = await IdExist(item.HdIdUpline.Value); } header.Name = item.Name; header.Code = item.Code; header.HdIdUpline = item.HdIdUpline; _db.Entry(header).State = EntityState.Modified; try { await _db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException exception) { throw new DbUpdateConcurrencyException(exception.Message); } return true; }
public async Task<Hd> Add(Hd item) { /*{ "Name":"??", "Code":"??", "HdIdUpline" : "??" }*/ if (item.HdIdUpline != null && item.HdIdUpline != 0) { var up = await IdExist(item.HdIdUpline.Value); } var randResult = await RandHd();//random hd.value 3 char before add var newHd = new Hd { Name = item.Name, Code = item.Code, HdIdUpline = item.HdIdUpline, Value = randResult, TableName = "_" + randResult//use hd.value to create tableName "_xxx" }; //create table backup in mysql *** //createBackUp(newHd.TableName); newHd = _db.Hds.Add(newHd); try { await _db.SaveChangesAsync(); return newHd; } catch (DbUpdateConcurrencyException exception) { throw new DbUpdateConcurrencyException(exception.Message); } }
public async Task<IHttpActionResult> Posthd(Hd hd) { if (!ModelState.IsValid) { return BadRequest(ModelState); } try { var header = await _repository.Add(hd); return CreatedAtRoute("DefaultApi", new { id = header.Id }, header); } catch (DbUpdateException msgDbUpdateException) { return InternalServerError(msgDbUpdateException); } }