public async Task <APIResult> SaveEmployeeInfo(ParamEmpInfoDto empInfo) { try { string spName = @"up_RMMT_BAS_InsertEmployeeInfo_S"; DynamicParameters dp = new DynamicParameters(); dp.Add("@EmpId", empInfo.EmpId); dp.Add("@DisId", empInfo.DisId); dp.Add("@DepartId", empInfo.DepartId); dp.Add("@UserType", empInfo.UserType, DbType.String); dp.Add("@UserName", empInfo.UserName, DbType.String); dp.Add("@LoginId", empInfo.LoginId, DbType.String); dp.Add("@Password", empInfo.Password, DbType.String); dp.Add("@CellNo", empInfo.CellNo, DbType.String); dp.Add("@PhoneNo", empInfo.PhoneNo, DbType.String); dp.Add("@Email", empInfo.Email, DbType.String); dp.Add("@UseYN", empInfo.UseYN, DbType.Boolean); 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> SaveEmployeeInfo([FromBody] ParamEmpInfoDto param) { return(_usersService.SaveEmployeeInfo(param)); }