public async Task <APIResult> SaveImprovementItem(ImpApprovalParamDto paramDto)
{
string spName = @"up_RMMT_IMP_SaveImprovementItem_C";
string xmlAttachList = CommonHelper.Serializer(typeof(List <AttachDto>), paramDto.AttachList);
DynamicParameters dp = new DynamicParameters();
dp.Add("@ImprovementContent", paramDto.ImprovementContent, DbType.String);
dp.Add("@ExpectedTime", paramDto.ExpectedTime, DbType.String);
dp.Add("@ImprovementId", paramDto.ImprovementId, DbType.Int64);
dp.Add("@InUserId", paramDto.InUserId, DbType.Int64);
dp.Add("@XmlData", xmlAttachList, DbType.Xml);
dp.Add("@XmlRootName", "/ArrayOfAttachDto/AttachDto", DbType.String);
dp.Add("@SaveStatus", paramDto.SaveStatus, DbType.String);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
using (var tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
await conn.ExecuteAsync(spName, dp, tran, null, CommandType.StoredProcedure);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
finally
{
tran.Dispose();
}
}
return(new APIResult {
Body = "", ResultCode = ResultType.Success, Msg = ""
});
}
}
public async Task <IActionResult> SaveImprovementItem([FromBody] ImpApprovalParamDto paramDto)
{
var saveResult = await _improvementService.SaveImprovementItem(paramDto);
return(Ok(saveResult));
}
