Esempio n. 1
0
        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
                });
            }
        }
Esempio n. 2
0
 public Task <APIResult> SaveEmployeeInfo([FromBody] ParamEmpInfoDto param)
 {
     return(_usersService.SaveEmployeeInfo(param));
 }