public async Task <APIResult> StaffInfoReg(StuffInfoParams param) { try { string StaffInfoXML = CommonHelper.Serializer(typeof(List <StaffInfo>), param.StaffInfoList); string spName = @"up_RMMT_PMN_StaffInfoReg_C"; DynamicParameters dp = new DynamicParameters(); dp.Add("@StaffInfoXML", StaffInfoXML, DbType.Xml); dp.Add("@UserId", param.UserId, DbType.Int32); 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 async Task <APIResult> UpdateStaffInfo([FromBody] StuffInfoParams param) { return(await _perMngService.UpdateStaffInfo(param)); }
public async Task <APIResult> StaffInfoReg([FromBody] StuffInfoParams param) { return(await _perMngService.StaffInfoReg(param)); }