public async Task <ObjectResult> Create([FromBody] TaoTieuChuanDPEntity model) { try { MyServiceResult objMyServiceResult = await this._ITieuChuanService.Tao(model); return(StatusCode(StatusCodes.Status200OK, JsonSerializer.Serialize <MyServiceResult>(objMyServiceResult))); } catch (Exception ex) { return(StatusCode(StatusCodes.Status400BadRequest, JsonSerializer.Serialize <MyServiceResult>(new MyServiceResult { Successed = false, Content = ex.Message }))); } }
public async Task <MyServiceResult> Tao(TaoTieuChuanDPEntity model) { try { if (model is null) { return(new MyServiceResult { Successed = false, Content = "Lỗi tạo Tiêu chuẩn" }); } IDbConnection dbConnection = this._IMyDapper.GetConnection(); if (dbConnection.State == ConnectionState.Closed) { dbConnection.Open(); } using (IDbTransaction dbTransaction = dbConnection.BeginTransaction()) { try { model.TenTieuChuan = model.TenTieuChuan.CapitalizeWord(); model.MoTa = model.MoTa.CapitalizeSentences(); int effectedRows = await dbConnection.ExecuteAsync("[TaoTieuChuan]", new { @MaTieuChuan = model.MaTieuChuan, @TenTieuChuan = model.TenTieuChuan, @MoTa = model.MoTa, @SoHopMinhChung = model.SoHopMinhChung }, transaction : dbTransaction, commandType : CommandType.StoredProcedure); dbTransaction.Commit(); if (effectedRows > 0) { return(new MyServiceResult { Successed = true, Content = $"Tạo thành công Tiêu chuẩn {model.TenTieuChuan}" }); } else { return(new MyServiceResult { Successed = false, Content = $"Tạo thất bại Tiêu chuẩn {model.TenTieuChuan}" }); } } catch (Exception ex) { dbTransaction.Rollback(); return(new MyServiceResult { Successed = false, Content = ex.Message }); } } } catch (Exception ex) { return(new MyServiceResult { Successed = false, Content = ex.Message }); } }