Exemplos de IDataBaseService.ExecuteNonQuery em C# (CSharp)

Exemplo n.º 1

Arquivo: UserService.cs Projeto: bhanu-singh/telemedicine-server-c-sharp

        public bool UpdateDeviceId(UserLogOnModel userModel)
        {
            List <Parameter> param = new List <Parameter>();

            param.Add(new Parameter("@UserId", userModel.Id));
            param.Add(new Parameter("@DeviceId", userModel.DeviceId));
            param.Add(new Parameter("@TenantId", userModel.TenantID));
            Parameter p_IsError  = new Parameter("@IsError", DBNull.Value, ParameterDirection.Output, DbType.Int16, 1);
            Parameter p_ErrorMsg = new Parameter("@ErrorMsg", DBNull.Value, ParameterDirection.Output, DbType.String, 16);

            param.Add(p_IsError);
            param.Add(p_ErrorMsg);
            var r = dataBaseService.ExecuteNonQuery(StoredProcedures.UpdateUserDeviceId, DBCommandType.Procedure, param.ToArray());

            if (r > 0)
            {
                return(true);
            }
            return(false);
        }