public async Task <ObjectResult> Create([FromBody] TaoTieuChiDPEntity model)
{
try
{
MyServiceResult objMyServiceResult = await this._ITieuChiService.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(TaoTieuChiDPEntity model)
{
try
{
if (model is null)
{
return(new MyServiceResult
{
Successed = false,
Content = "Lỗi tạo Tiêu chí"
});
}
IDbConnection dbConnection = _IMyDapper.GetConnection();
if (dbConnection.State == ConnectionState.Closed)
{
dbConnection.Open();
}
using (IDbTransaction dbTransaction = dbConnection.BeginTransaction())
{
try
{
int effectedRows = await dbConnection.ExecuteAsync("[TaoTieuChi]", new { @MaTieuChi = model.MaTieuChi, @TenTieuChi = model.TenTieuChi, @YeuCauCuaTieuChi = model.YeuCauCuaTieuChi, @MocChuanThamChieuDeDanhGiaTieuChiDatMucBon = model.MocChuanThamChieuDeDanhGiaTieuChiDatMucBon, @GoiYNguonMinhChung = model.GoiYNguonMinhChung, model.MaTieuChuan }, transaction : dbTransaction, commandType : CommandType.StoredProcedure);
dbTransaction.Commit();
if (effectedRows > 0)
{
return(new MyServiceResult
{
Successed = true,
Content = $"Tạo thành công Tiêu chí {model.TenTieuChi}"
});
}
else
{
return(new MyServiceResult
{
Successed = false,
Content = $"Tạo thất bại Tiêu chí {model.TenTieuChi}"
});
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
return(new MyServiceResult
{
Successed = false,
Content = ex.Message
});
}
}
}
catch (Exception ex)
{
return(new MyServiceResult
{
Successed = false,
Content = ex.Message
});
}
}
