public async Task <APIResult> SaveItemApproalYN(ItemApproalParams param)
{
try
{
string spName = @"up_RMMT_TOU_ItemApproalYN_C";
DynamicParameters dp = new DynamicParameters();
dp.Add("@TPId", param.TPId, DbType.Int64);
dp.Add("@TIId", param.TIId, DbType.Int64);
dp.Add("@Score", param.Score, DbType.Int64);
dp.Add("@PlanApproalYN", param.PlanApproalYN, DbType.Boolean);
dp.Add("@ResultApproalYN", param.ResultApproalYN, DbType.Boolean);
dp.Add("@UserId", param.UserId, DbType.Int64);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
using (var tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
await conn.ExecuteAsync(spName, dp, tran, null, CommandType.StoredProcedure);
tran.Commit();
}
}
return(new APIResult {
Body = "", ResultCode = ResultType.Success, Msg = ""
});
}
catch (Exception ex)
{
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
}
public Task <APIResult> SaveItemApproalYN([FromBody] ItemApproalParams param)
{
return(_tourService.SaveItemApproalYN(param));
}